Microsoft Certified Azure Data Fundamentals · Free Practice Question Easy
Question 29
Which of the following is NOT a feature of Azure Table Storage tables?
-
A
Timestamp column
-
B
Foreign keys
-
C
Denormalized data
-
D
Partitioning
Reveal correct answer
Correct answer: B
Explanation
Azure Table Storage tables are designed to store data in a denormalized format, without the complexity of relational database features such as foreign keys, relationships, stored procedures, or views. Each table is a collection of entities, and the relationships between these entities are managed at the application level rather than through database constraints.
Reference: https://learn.microsoft.com/en-us/azure/storage/tables/table-storage-overview
A. Timestamp columns are a feature of Azure Table Storage tables. They are automatically generated and maintained by the system to track the last modification time of a row in the table.
B. Foreign keys are not a feature of Azure Table Storage tables. Azure Table Storage is a NoSQL data store and does not support relationships or foreign keys between tables like traditional relational databases.
C. Denormalized data is a feature of Azure Table Storage tables. It is a common practice in NoSQL databases like Azure Table Storage to store data in a denormalized format to optimize read performance and simplify data retrieval.
D. Partitioning is a key feature of Azure Table Storage tables. It allows for efficient data distribution and scalability by dividing data into partitions based on a specified partition key.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
