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

Questions 26–30

1. 26application · medium

   A stock-trading platform must process buy and sell orders the moment they are placed. Each order updates the trader's portfolio balance and the stock's available quantity. The system must respond in milliseconds and cannot afford to wait for a nightly batch job. Which workload characteristic does this scenario primarily demonstrate?

   • ABatch processing, because orders are accumulated and processed at the end of the day
   • BComplex querying, because the system must analyze historical trading patterns
   • CAnalytical processing, because the system generates reports on trading volumes
   • DReal-time processing, because each order is handled immediately as it occurs
   Reveal Solution Discussion Select an answer first
2. 27foundation · easy

   Why do transactional workloads often require real-time processing?

   • ATo provide immediate feedback and maintain operational efficiency
   • BTo allow batch processing of historical data
   • CTo reduce the cost of storing large volumes of data
   • DTo ensure that data is available for complex analytical queries
   Reveal Solution Discussion Select an answer first
4. 28expert · hard

   A data team needs to run complex queries that join multiple large datasets to produce insights for executives. These queries are resource-intensive and can take hours. The team also needs to support a real-time dashboard that shows current metrics. Which approach best balances these needs?

   • AUse an analytical store for complex queries and a separate real-time store for the dashboard
   • BUse batch processing for both complex queries and the real-time dashboard
   • CUse a single analytical store for both complex queries and the real-time dashboard
   • DUse a transactional database for both complex queries and the real-time dashboard
   Reveal Solution Discussion Select an answer first
5. 29expert · hard

   A hospital's patient-admission system must record admissions and discharges. The system is used by multiple staff members simultaneously, and it must ensure that two staff members cannot discharge the same patient twice. The hospital also requires that once an admission is recorded, it is never lost, even if the server loses power. Which combination of ACID properties is most critical for this system?

   • AIsolation and durability
   • BAtomicity and isolation
   • CConsistency and durability
   • DAtomicity and consistency
   Reveal Solution Discussion Select an answer first
6. 30expert · hard

   A retail company wants to analyze sales trends and also process customer orders. The analysis requires complex queries over millions of historical records, while order processing requires immediate, ACID-compliant updates. The company has a limited budget and wants to minimize infrastructure costs. Which approach is most cost-effective while meeting both requirements?

   • AUse a single analytical database for both orders and analysis
   • BUse a batch processing system for both orders and analysis
   • CUse a transactional database for orders and a separate analytical store for analysis
   • DUse a streaming analytics platform for both orders and analysis
   Reveal Solution Discussion Select an answer first