Practice Questions

---

Question 1

What is the primary purpose of an analytical data store?

A. To process high-volume transactions
B. To store temporary application data
C. To support reporting and data analysis
D. To manage user authentication

✅ Answer: C

Explanation:
Analytical data stores are optimized for reporting, querying, and analysis, not transactions.

---

Question 2

Which type of data store is BEST suited for structured data and complex SQL queries?

A. Data lake
B. Data warehouse
C. File storage
D. Key-value store

✅ Answer: B

Explanation:
Data warehouses are designed for structured data and high-performance SQL queries.

---

Question 3

Which Azure service is commonly used as a data warehouse?

A. Azure Data Lake Storage
B. Azure Synapse Analytics
C. Azure Files
D. Azure Table Storage

✅ Answer: B

Explanation:
Azure Synapse Analytics provides data warehousing and large-scale analytics capabilities.

---

Question 4

What is a key characteristic of a data lake?

A. Requires predefined schema before loading data
B. Stores only structured data
C. Stores data in its raw format
D. Optimized for transactional workloads

✅ Answer: C

Explanation:
Data lakes store raw data in native formats, supporting schema-on-read.

---

Question 5

Which concept describes applying schema when data is read rather than when it is written?

A. Schema-on-write
B. Schema-on-read
C. Data normalization
D. Data partitioning

✅ Answer: B

Explanation:
Schema-on-read is used in data lakes, allowing flexible analysis.

---

Question 6

Which scenario is BEST suited for a data lake?

A. Financial reporting with strict schema
B. Running complex SQL joins on structured data
C. Storing raw IoT and log data for later analysis
D. Processing online transactions

✅ Answer: C

Explanation:
Data lakes are ideal for large volumes of raw, diverse data.

---

Question 7

Which analytical data store typically uses schema-on-write?

A. Data lake
B. Data warehouse
C. Object storage
D. Key-value store

✅ Answer: B

Explanation:
Data warehouses require a defined schema before data is loaded.

---

Question 8

Which of the following best describes a data lakehouse?

A. A transactional database system
B. A file storage system only
C. A hybrid of data lake and data warehouse
D. A key-value storage solution

✅ Answer: C

Explanation:
A lakehouse combines flexibility of data lakes with performance of warehouses.

---

Question 9

Which factor is MOST important when choosing between a data lake and a data warehouse?

A. Screen resolution
B. Data structure and query requirements
C. Programming language
D. User interface design

✅ Answer: B

Explanation:
The choice depends on data type (structured vs raw) and query needs.

---

Question 10

Which Azure service is BEST suited for storing large volumes of raw, unstructured data?

A. Azure SQL Database
B. Azure Data Lake Storage
C. Azure Synapse Analytics
D. Azure Table Storage

✅ Answer: B

Explanation:
Azure Data Lake Storage is optimized for large-scale raw data storage.

---

✅ Quick Exam Takeaways

✔ Analytical data stores support:

• Reporting
• Business intelligence
• Large-scale analytics

✔ Main types:

• Data Warehouse → structured, SQL, high performance
• Data Lake → raw, flexible, scalable
• Lakehouse → hybrid approach

✔ Key concepts:

• Schema-on-write → warehouse
• Schema-on-read → lake

✔ Azure services:

• Azure Synapse Analytics → data warehouse / analytics
• Azure Data Lake Storage → data lake

✔ Exam tip:
👉 Structured + SQL → Data Warehouse
👉 Raw + flexible → Data Lake

---

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