Describe Common Data Workloads DP-900 Practice Questions (Page 4)

Questions 16–20

1. 16application · medium

   A marketing team wants to analyze customer purchase patterns over the past five years. They plan to run a report every night that processes millions of transactions to identify trends. Which type of workload does this represent?

   • ATransactional workload with ACID guarantees
   • BTransactional workload with real-time processing
   • CAnalytical workload with batch processing
   • DAnalytical workload with real-time streaming
   Reveal Solution Discussion Select an answer first
2. 17application · medium

   A retail company runs an online store. When a customer places an order, the system must deduct the item from inventory, charge the customer's credit card, and create a shipping record — all within a few seconds. If any of these steps fail, none of them should take effect. Which type of workload does this system represent, and what property is most critical to its success?

   • ATransactional workload; atomicity ensures all steps complete or none do
   • BAnalytical workload; durability ensures order data is never lost
   • CTransactional workload; isolation ensures the system can handle many orders at once
   • DAnalytical workload; the ability to run complex queries on order history
   Reveal Solution Discussion Select an answer first
4. 18application · medium

   A utility company stores smart-meter readings from millions of homes. Each month, a process runs to calculate each household's energy consumption and generate billing statements. The process reads all readings for the month, groups them by household, and computes totals. Which workload type is this, and why?

   • AReal-time workload, because the billing statements must be generated immediately
   • BAnalytical workload, because it processes large volumes of data to produce aggregated results
   • CComplex query workload, because the queries involve multiple joins
   • DTransactional workload, because each reading is a separate transaction
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A company runs an online payment system that must process transactions in real time with ACID guarantees. They also need to generate end-of-day reports that aggregate all transactions. The reports are not time-sensitive. Which approach best satisfies both requirements?

   • AUse a batch processing system for both transactions and reports
   • BUse a streaming analytics platform for both transactions and reports
   • CUse a single analytical database for both real-time transactions and batch reports
   • DUse a transactional database for real-time processing and a separate analytical store for batch reports
   Reveal Solution Discussion Select an answer first
6. 20expert · hard

   A ride-sharing company needs to match drivers with riders in real time. The matching system must process ride requests within seconds and update driver locations continuously. The company also needs to generate daily reports on ride volumes and driver earnings. The team is considering whether to use a single transactional database for both real-time matching and daily reporting. What is the primary risk of this approach?

   • AThe daily reporting queries will compete with real-time matching for resources, causing latency
   • BThe transactional database will not support ACID properties needed for matching
   • CThe daily reports will be inaccurate because the data changes in real time
   • DThe transactional database will not be able to handle the volume of ride requests
   Reveal Solution Discussion Select an answer first