azure, DP-900, Microsoft Certification

Practice Questions: Describe Azure Table storage (DP-900 Exam Prep)

Practice Questions

Question 1

What type of storage is Azure Table Storage?

A. Relational database
B. Object storage
C. NoSQL key-value store
D. Graph database

✅ Answer: C

Explanation:
Azure Table Storage is a NoSQL key-value store designed for structured, non-relational data.

Question 2

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

A. Primary Key and Foreign Key
B. Table Name and Column Name
C. Partition Key and Row Key
D. Index and Constraint

✅ Answer: C

Explanation:
Each entity is uniquely identified by a combination of Partition Key and Row Key.

Question 3

What is the purpose of the Partition Key?

A. To encrypt the data
B. To define relationships between tables
C. To group related data and improve scalability
D. To enforce schema rules

✅ Answer: C

Explanation:
The Partition Key determines how data is grouped and distributed for performance.

Question 4

Which statement best describes the schema in Azure Table Storage?

A. All entities must have identical columns
B. A fixed schema is required
C. Entities can have different properties
D. Only numeric data types are supported

✅ Answer: C

Explanation:
Azure Table Storage is schema-less, so entities can have different properties.

Question 5

Which scenario is BEST suited for Azure Table Storage?

A. Running complex SQL joins
B. Storing relational transactional data
C. Storing large volumes of user profile data
D. Hosting a data warehouse

✅ Answer: C

Explanation:
Table Storage is ideal for large-scale, simple, structured data with key-based access.

Question 6

Which operation is most efficient in Azure Table Storage?

A. Joining multiple tables
B. Querying by Partition Key and Row Key
C. Running aggregate functions
D. Performing full table scans

✅ Answer: B

Explanation:
Queries using Partition Key and Row Key are the most efficient.

Question 7

What is an entity in Azure Table Storage?

A. A database
B. A column
C. A row of data
D. A storage account

✅ Answer: C

Explanation:
An entity represents a single record (row) in a table.

Question 8

Which Azure service provides enhanced global distribution and performance compared to Table Storage?

A. Azure Blob Storage
B. Azure Files
C. Azure Cosmos DB (Table API)
D. Azure SQL Database

✅ Answer: C

Explanation:
Azure Cosmos DB offers global distribution, lower latency, and higher SLAs.

Question 9

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

A. Schema-less design
B. Key-based access
C. Support for complex joins
D. High scalability

✅ Answer: C

Explanation:
Table Storage does not support joins or complex relational queries.

Question 10

Which hierarchy correctly represents Azure Table Storage?

A. Storage Account → Table → Entity → Properties
B. Table → Entity → Storage Account → Properties
C. Entity → Table → Storage Account → Properties
D. Storage Account → Entity → Table → Properties

✅ Answer: A

Explanation:
The correct structure is Storage Account → Table → Entity → Properties.

✅ Quick Exam Takeaways

✔ Azure Table Storage = NoSQL key-value store
✔ Stores structured, non-relational data

✔ Key concepts:

  • Partition Key → grouping & scalability
  • Row Key → unique identifier

✔ Best for:

  • Large datasets
  • Fast key-based lookups
  • Simple access patterns

✔ Not suitable for:

  • Joins
  • Complex queries
  • Relational workloads

✔ Compare with:

  • Cosmos DB → more advanced, globally distributed

Go to the DP-900 Exam Prep Hub main page.

Leave a comment