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

Questions 1–5

1. 1application · medium

   A bank's fund-transfer system allows customers to move money between accounts. The system must ensure that a transfer either fully completes (money debited from one account and credited to another) or fully fails, even if the database crashes mid-operation. Which ACID property is the system relying on to guarantee this behavior?

   • ADurability
   • BIsolation
   • CAtomicity
   • DConsistency
   Reveal Solution Discussion Select an answer first
2. 2application · medium

   A bank is designing a funds transfer system. The system must ensure that a transfer either completes fully or not at all, and once the transfer is committed, it must survive a power failure. Which two ACID properties are most directly required?

   • AConsistency and Isolation
   • BConsistency and Durability
   • CAtomicity and Durability
   • DAtomicity and Isolation
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   Which of the following scenarios best illustrates a transactional workload that requires real-time processing?

   • ARunning a nightly job to update a data warehouse
   • BGenerating a monthly sales report from historical data
   • CProcessing a credit card payment at a point-of-sale terminal
   • DAnalyzing years of customer feedback to identify trends
   Reveal Solution Discussion Select an answer first
5. 4application · medium

   A research team needs to analyze decades of climate data to identify trends in temperature and precipitation. They will run queries that join weather station data with geographic data, aggregate readings by year and region, and compute moving averages. Which workload type does this represent?

   • ATransactional workload, because the queries update the climate data
   • BBatch workload, because the data is processed in a single transaction
   • CReal-time workload, because the team needs results immediately
   • DAnalytical workload, because it uses complex queries to extract insights from large datasets
   Reveal Solution Discussion Select an answer first
6. 5expert · hard

   A government agency maintains a database of citizen records. Analysts need to run complex queries to identify trends in service usage, but the database also supports real-time updates to citizen records by case workers. The agency has a strict budget and cannot afford a separate analytical system. What is the most practical way to minimize the impact of analytical queries on the real-time updates?

   • ADisable indexes on the database to speed up analytical queries
   • BLimit analytical queries to a single row at a time
   • CRun analytical queries only during business hours when case workers are active
   • DUse read replicas to offload analytical queries from the primary database
   Reveal Solution Discussion Select an answer first