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

Questions 31–35

1. 31foundation · easy

   Which of the following is a common requirement for a transactional workload?

   • AThe ability to store petabytes of historical data
   • BThe ability to process data in near real-time with low latency
   • CThe ability to run complex aggregations across multiple data sources
   • DThe ability to run long-running queries that scan entire tables
   Reveal Solution Discussion Select an answer first
2. 32foundation · easy

   Which characteristic is most typical of an analytical workload?

   • AUpdating individual records frequently in real time
   • BRunning complex queries that aggregate large volumes of data
   • CProcessing a high volume of small, individual transactions
   • DRequiring low-latency responses for individual operations
   Reveal Solution Discussion Select an answer first
4. 33application · medium

   A retail company operates an online store. When a customer places an order, the system must deduct inventory, record the payment, and create a shipping label. If any of these steps fail, none of them should be applied. The company also needs the order confirmation to be returned to the customer immediately. Which type of workload best describes this requirement?

   • ATransactional workload with ACID guarantees and real-time processing
   • BAnalytical workload with real-time ingestion and simple lookups
   • CTransactional workload with eventual consistency and delayed response
   • DAnalytical workload with batch processing and complex queries
   Reveal Solution Discussion Select an answer first
5. 34application · medium

   A marketing firm collects clickstream data from its website. Every night at 2:00 AM, a scheduled job loads the entire day's clickstream data into a data warehouse and runs a series of queries to calculate daily unique visitors and popular pages. The job typically processes 10 terabytes of data. Which workload pattern is this?

   • ABatch processing, because a large volume of data is processed on a schedule
   • BReal-time processing, because the job runs on a fixed schedule
   • CTransactional processing, because each click is a separate transaction
   • DComplex querying, because the queries involve multiple joins
   Reveal Solution Discussion Select an answer first
6. 35expert · hard

   An e-commerce platform is designing a checkout process. The process must deduct inventory, process payment, and create an order record. The team is debating whether to use a single database transaction or to perform each step independently with compensating actions. The requirement is that the order must never be created without payment, and inventory must never be deducted without an order. Which approach best satisfies the requirement?

   • APerform each step independently and use compensating actions to undo partial steps
   • BUse a single database transaction that covers all three steps
   • CProcess payment first, then deduct inventory, and if inventory deduction fails, refund the payment
   • DCreate the order first, then process payment, and if payment fails, delete the order
   Reveal Solution Discussion Select an answer first