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

Questions 21–25

1. 21expert · hard

   A retail chain wants to analyze sales data to identify which products sell best in each region. The data is stored in a transactional database that handles point-of-sale transactions. The analytics team needs to run complex queries that join sales, product, and store tables, but they are concerned that running these queries directly on the transactional database will slow down real-time sales processing. What should they do?

   • AUse the transactional database to process the analytical queries in real time
   • BDisable ACID properties on the transactional database to speed up analytical queries
   • CCopy the data to a separate analytical data store and run the queries there
   • DRun the analytical queries directly on the transactional database during off-peak hours
   Reveal Solution Discussion Select an answer first
2. 22foundation · easy

   Which of the following is a common requirement for an analytical workload?

   • AThe ability to provide immediate responses to individual transactions
   • BThe ability to support complex queries over large datasets
   • CThe ability to enforce strict ACID properties on every query
   • DThe ability to handle a large number of concurrent small writes
   Reveal Solution Discussion Select an answer first
4. 23application · medium

   An airline's online check-in system allows passengers to select seats. When a passenger selects a seat, the system must immediately mark that seat as occupied so no other passenger can select it. The system handles thousands of selections per minute. Which workload type does this represent, and which ACID property is most directly enforced?

   • ATransactional workload; durability ensures the seat selection is saved permanently
   • BReal-time workload; atomicity ensures the seat map is updated instantly
   • CTransactional workload; isolation prevents two passengers from selecting the same seat
   • DAnalytical workload; consistency ensures the seat map is accurate
   Reveal Solution Discussion Select an answer first
5. 24foundation · easy

   Which of the following is an example of a complex query used in an analytical workload?

   • AA query that deletes a record from a log table
   • BA query that inserts a new order into a sales table
   • CA query that updates a customer's address
   • DA query that joins multiple tables and aggregates millions of rows to calculate yearly sales by region
   Reveal Solution Discussion Select an answer first
6. 25application · medium

   A ride-hailing app matches drivers with riders. When a rider requests a ride, the system must find a nearby driver and send the driver's details to the rider within seconds. The system also records the ride details for later billing. Which workload characteristic is most critical for the ride-matching process?

   • AEventual consistency for all ride data
   • BReal-time processing with low latency
   • CBatch processing of historical ride data
   • DComplex queries over large datasets
   Reveal Solution Discussion Select an answer first