Practice Questions
Question 1
Which scenario best represents a transactional workload?
A. Generating monthly sales reports
B. Training a machine learning model
C. Recording a customer purchase in real time
D. Visualizing historical trends
✅ Answer: C
Explanation:
Transactional workloads capture operational business events as they occur.
Question 2
Which characteristic is most closely associated with transactional workloads?
A. Large batch queries
B. Complex aggregations
C. Frequent small read/write operations
D. Historical trend analysis
✅ Answer: C
Explanation:
Transactional systems perform many small, fast inserts, updates, and deletes.
Question 3
Which ACID property ensures that completed transactions are permanently saved?
A. Atomicity
B. Consistency
C. Isolation
D. Durability
✅ Answer: D
Explanation:
Durability guarantees that once a transaction commits, it remains stored even after failures.
Question 4
A banking system transfers money between accounts. If either debit or credit fails, both must roll back.
Which ACID property does this demonstrate?
A. Consistency
B. Isolation
C. Atomicity
D. Durability
✅ Answer: C
Explanation:
Atomicity ensures that a transaction is all-or-nothing.
Question 5
Transactional workloads typically use which type of schema design?
A. Denormalized
B. Star schema
C. Snowflake schema
D. Normalized
✅ Answer: D
Explanation:
Transactional systems usually use normalized schemas to reduce redundancy and enforce integrity.
Question 6
Which Azure service is MOST appropriate for a traditional OLTP application?
A. Azure Synapse Analytics
B. Azure SQL Database
C. Azure Data Lake Storage
D. Azure Blob Storage
✅ Answer: B
Explanation:
Azure SQL Database is optimized for transactional (OLTP) workloads with ACID support.
Question 7
Which requirement is most critical for transactional workloads?
A. High throughput for batch queries
B. Schema flexibility
C. Low latency and strong consistency
D. Historical data retention
✅ Answer: C
Explanation:
Transactional workloads prioritize fast response times and data consistency.
Question 8
Which workload is LEAST likely to be transactional?
A. Updating inventory levels
B. Processing credit card payments
C. Inserting new customer records
D. Running yearly financial summaries
✅ Answer: D
Explanation:
Yearly summaries are analytical, not transactional.
Question 9
Which statement about transactional workloads is TRUE?
A. They primarily analyze historical data
B. They usually involve complex joins across millions of rows
C. They support operational business processes
D. They are optimized for reporting
✅ Answer: C
Explanation:
Transactional workloads support daily operations such as orders, payments, and updates.
Question 10
An e-commerce application must confirm orders instantly and ensure inventory counts are always correct.
Which workload type does this describe?
A. Analytical
B. Batch
C. Streaming
D. Transactional
✅ Answer: D
Explanation:
Real-time order processing with consistency requirements is transactional.
✅ Exam Tips for Transactional Workloads
For DP-900, remember:
✔ Focus on real-time operational processing
✔ Think OLTP
✔ Many small reads/writes
✔ ACID compliance
✔ Low latency + strong consistency
✔ Typically normalized schemas
✔ Azure SQL Database is the classic example
Go to the DP-900 Exam Prep Hub main page.
The Data Community 