Databases, DP-900, Microsoft Certification

Practice Questions: Describe Types of Databases (DP-900 Exam Prep)

Practice Questions

Question 1

You need to store customer orders in tables with fixed columns and enforce relationships between customers and orders.

Which type of database should you use?

A. Graph
B. Document
C. Relational
D. Key-value

✅ Answer: C

Explanation:
Relational databases store structured data in tables with defined schemas and support relationships via keys.

Question 2

Which characteristic best describes a relational database?

A. Schema-less storage
B. Data stored as JSON documents
C. Tables with rows and columns
D. Nodes and edges

✅ Answer: C

Explanation:
Relational databases organize data into tables (rows and columns) and use SQL for querying.

Question 3

An application must store user profiles in flexible JSON documents where each user may have different attributes.

Which database type is most appropriate?

A. Column-family
B. Document
C. Relational
D. Graph

✅ Answer: B

Explanation:
Document databases store data as JSON-like documents and allow flexible schemas — ideal for user profiles.

Question 4

Which Azure service supports multiple NoSQL data models such as Core (SQL) API, Table API, Cassandra API, and Gremlin API?

A. Azure SQL Database
B. Azure Table Storage
C. Azure Cosmos DB
D. Azure Database for PostgreSQL

✅ Answer: C

Explanation:
Azure Cosmos DB is a globally distributed, multi-model NoSQL database service.

Question 5

You are designing a recommendation engine that analyzes relationships between users and products.

Which database type is best suited?

A. Relational
B. Key-value
C. Graph
D. Column-family

✅ Answer: C

Explanation:
Graph databases specialize in relationship-heavy data using nodes and edges.

Question 6

Which statement about NoSQL databases is TRUE?

A. They always require fixed schemas
B. They primarily use SQL
C. They are optimized for horizontal scaling
D. They cannot store structured data

✅ Answer: C

Explanation:
NoSQL databases are designed for horizontal scaling and flexible schemas.

Question 7

You need extremely fast lookups using a unique identifier, and the data structure is simple.

Which NoSQL model should you choose?

A. Document
B. Graph
C. Column-family
D. Key-value

✅ Answer: D

Explanation:
Key-value databases store data as key/value pairs and provide very fast retrieval.

Question 8

Which Azure service is best suited for structured transactional workloads using SQL?

A. Azure Blob Storage
B. Azure Cosmos DB
C. Azure SQL Database
D. Azure Data Lake Storage

✅ Answer: C

Explanation:
Azure SQL Database is a managed relational database service optimized for structured transactional data.

Question 9

Which feature is typically associated with relational databases but not guaranteed in NoSQL systems?

A. Global distribution
B. Flexible schemas
C. ACID transactions
D. Horizontal scaling

✅ Answer: C

Explanation:
Relational databases traditionally provide full ACID transaction support.

Question 10

A company collects massive volumes of time-series telemetry data where columns may vary across rows.

Which database type fits this scenario best?

A. Relational
B. Document
C. Column-family
D. Graph

✅ Answer: C

Explanation:
Column-family (wide-column) databases are well suited for large, sparse datasets such as time-series data.

✅ Key Exam Reminders

For DP-900, make sure you can confidently:

  • Distinguish relational vs non-relational
  • Recognize NoSQL models (key-value, document, column-family, graph)
  • Match Azure services to database types (especially Azure SQL vs Azure Cosmos DB)
  • Choose the right database type for a scenario

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

Leave a comment