Practice Questions

---

Question 1

Which scenario best represents an analytical workload?

A. Recording a new customer order
B. Updating inventory quantities
C. Generating a yearly sales trends report
D. Processing a credit card payment

✅ Answer: C

Explanation:
Analytical workloads focus on reporting and historical analysis, not real-time operations.

---

Question 2

Analytical workloads primarily involve which type of queries?

A. Short insert and update statements
B. Point lookups by primary key
C. Complex queries with aggregations
D. Transactional batch commits

✅ Answer: C

Explanation:
Analytical workloads typically use complex SELECT queries with GROUP BY, SUM, AVG, etc.

---

Question 3

Which characteristic is MOST associated with analytical workloads?

A. Many small write operations
B. ACID transaction enforcement
C. Read-heavy access to large datasets
D. Millisecond response requirements

✅ Answer: C

Explanation:
Analytical systems mainly read and aggregate large volumes of data.

---

Question 4

Which schema design is commonly used for analytical workloads?

A. Fully normalized schema
B. Hierarchical schema
C. Denormalized star schema
D. Key-value schema

✅ Answer: C

Explanation:
Analytical systems often use denormalized schemas (such as star schemas) to improve query performance.

---

Question 5

Which Azure service is MOST appropriate for enterprise-scale analytical reporting?

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

✅ Answer: B

Explanation:
Azure Synapse Analytics is designed for large-scale analytical and data warehousing workloads.

---

Question 6

Which statement about analytical workloads is TRUE?

A. They prioritize low-latency updates
B. They mainly support operational business processes
C. They often analyze historical data
D. They require normalized schemas

✅ Answer: C

Explanation:
Analytical workloads typically analyze historical and aggregated data for insights.

---

Question 7

Which storage format is commonly used to optimize analytical queries?

A. Row-based text files
B. Columnar formats such as Parquet
C. Binary key-value files
D. XML documents

✅ Answer: B

Explanation:
Columnar formats like Parquet improve performance for analytical queries by minimizing I/O.

---

Question 8

Which workload characteristic differentiates analytical systems from transactional systems?

A. Use of indexes
B. Support for SQL
C. Focus on throughput over latency
D. Ability to store structured data

✅ Answer: C

Explanation:
Analytical systems prioritize processing large volumes of data efficiently rather than ultra-fast response times.

---

Question 9

A company combines data from sales, marketing, and customer systems to build dashboards in Power BI.

What type of workload is this?

A. Transactional
B. Streaming
C. Analytical
D. Operational

✅ Answer: C

Explanation:
Combining multiple sources for dashboards and insights is an analytical workload.

---

Question 10

Which activity is LEAST likely to be part of an analytical workload?

A. Running aggregate queries
B. Creating executive dashboards
C. Performing nightly ETL jobs
D. Updating individual customer records

✅ Answer: D

Explanation:
Updating individual records is transactional, not analytical.

---

✅ Exam Memory Anchors

For DP-900, remember analytical workloads as:

✔ OLAP
✔ Large datasets
✔ Complex read-heavy queries
✔ Aggregations & reporting
✔ Historical analysis
✔ Denormalized schemas
✔ Columnar storage
✔ Azure Synapse + Data Lake
✔ Power BI consumers

---

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