Table storage basics in Azure - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Azure Table Storage?

Azure Table Storage is a service that stores large amounts of structured, non-relational data in the cloud. It organizes data into tables, which contain rows called entities.

beginner

What is an entity in Azure Table Storage?

An entity is a single record in a table. It is similar to a row in a database table and contains properties with values.

intermediate

What are PartitionKey and RowKey in Azure Table Storage?

PartitionKey groups entities for scalability and performance. RowKey uniquely identifies an entity within a partition. Together, they form a unique key for each entity.

intermediate

How does Azure Table Storage differ from a traditional relational database?

Azure Table Storage is a NoSQL key-value store. It does not enforce a schema, supports flexible properties per entity, and is optimized for large-scale, fast access rather than complex queries.

intermediate

Why is PartitionKey important for performance in Azure Table Storage?

PartitionKey helps distribute data across servers. Queries within the same partition are faster because data is stored together, improving scalability and reducing latency.

What does an entity in Azure Table Storage represent?

A A single record or row in a table

B A whole table

C A database schema

D A storage account

An entity is a single record in a table, similar to a row in a database.

Which two keys uniquely identify an entity in Azure Table Storage?

A PartitionKey and RowKey

B PrimaryKey and ForeignKey

C TableKey and EntityKey

D StorageKey and AccessKey

PartitionKey and RowKey together uniquely identify an entity.

Azure Table Storage is best described as which type of database?

A Relational database

B In-memory database

C Graph database

D NoSQL key-value store

Azure Table Storage is a NoSQL key-value store optimized for large-scale structured data.

Why is PartitionKey important in Azure Table Storage?

A It controls user access

B It groups entities for better performance

C It encrypts data

D It stores metadata

PartitionKey groups entities to improve scalability and query speed.

Which of the following is NOT a feature of Azure Table Storage?

A Scalable storage for large datasets

B Flexible properties per entity

C Schema enforcement for all entities

D Fast access to entities within partitions

Azure Table Storage does not enforce a schema; entities can have different properties.

Explain the role of PartitionKey and RowKey in Azure Table Storage and why they matter.

Think about how data is organized and accessed quickly.

Describe the main differences between Azure Table Storage and a traditional relational database.

Focus on structure and query capabilities.