Azure tables are ideal to store and query huge set of structured, non-relational data.
Tables storage will scale as demand increases.
Common Scenarios are:
Used in Storing huge amount of structured data that serves` web applications
Storing datasets that doesn't need complex joins, foreign keys, and stored procedures and can be customized for faster access
Quickly querying data using a clustered index