A logistics company collects GPS location data from thousands of delivery vehicles every minute. At the end of each day, a job runs to aggregate all of that day's data into a report showing average delivery times by region. The job processes about 50 million records and takes two hours to complete. Which type of workload is this, and what is its primary characteristic?

Transactional workload; each GPS reading is a separate transaction that must be committed immediately

Analytical workload; it processes large volumes of data in batches to produce insights

Transactional workload; it requires ACID properties to ensure the report is consistent

Analytical workload; it requires immediate processing of each GPS reading

A healthcare analytics team needs to find correlations between patient demographics, treatment types, and recovery rates across millions of patient records. They plan to run queries that join multiple tables, aggregate data over time periods, and compute statistical measures. Which type of workload is this, and what is its primary requirement?

Real-time workload; the queries must return results in milliseconds

Analytical workload; it requires complex queries to extract insights from large datasets

Batch workload; the queries must process data in a single transaction

Transactional workload; the queries must be ACID-compliant

A logistics company collects delivery status updates throughout the day. Each night, they load all of the day's updates into a data warehouse and run a series of reports to calculate on-time delivery rates. Which workload pattern is being used?

Real-time processing of each update

Transactional processing of each update

Batch processing of collected data

Streaming analytics on the updates

Which characteristic is most typical of a transactional workload?

Processing large volumes of historical data in batches

Performing read-only analysis on a data warehouse

Running complex queries that aggregate millions of rows

Executing a high volume of small, individual operations that must complete quickly

A financial analyst needs to generate a monthly report that aggregates millions of transactions from multiple sources. The report is not time-sensitive and can run overnight. Which workload approach is most appropriate?

Batch processing in an analytical workload

Real-time processing in a transactional workload

Streaming analytics on live data

Transactional processing with ACID guarantees

Microsoft Certified:Azure Data Fundamentals

Domain 1Objective 3

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

Part of the Describe core data concepts domain, which accounts for 25–30% of the DP-900 exam. Microsoft does not publish an official question count, but from its 45-minute exam (~20–30 total, ~5–9 in this domain), expect 1–2 from this objective — we provide 38 practice questions to prepare you well beyond it. (estimate)

38questions here

8free pages

6concepts

25–30%of the exam

Questions 11–15

11application · medium
A logistics company collects GPS location data from thousands of delivery vehicles every minute. At the end of each day, a job runs to aggregate all of that day's data into a report showing average delivery times by region. The job processes about 50 million records and takes two hours to complete. Which type of workload is this, and what is its primary characteristic?
Select an answer first
12application · medium
A healthcare analytics team needs to find correlations between patient demographics, treatment types, and recovery rates across millions of patient records. They plan to run queries that join multiple tables, aggregate data over time periods, and compute statistical measures. Which type of workload is this, and what is its primary requirement?
Select an answer first
13application · medium
A logistics company collects delivery status updates throughout the day. Each night, they load all of the day's updates into a data warehouse and run a series of reports to calculate on-time delivery rates. Which workload pattern is being used?
Select an answer first
14foundation · easy
Which characteristic is most typical of a transactional workload?
Select an answer first
15application · medium
A financial analyst needs to generate a monthly report that aggregates millions of transactions from multiple sources. The report is not time-sensitive and can run overnight. Which workload approach is most appropriate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DP-900

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Microsoft. “DP-900” is a trademark of its owner, used for identification only.

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

Questions 11–15

A logistics company collects delivery status updates throughout the day. Each night, they load all of the day's updates into a data warehouse and run a series of reports to calculate on-time delivery rates. Which workload pattern is being used?

Which characteristic is most typical of a transactional workload?

A financial analyst needs to generate a monthly report that aggregates millions of transactions from multiple sources. The report is not time-sensitive and can run overnight. Which workload approach is most appropriate?

Keep studying — Describe core data concepts