What is a key characteristic of batch processing in analytical workloads?

Processing data only when a user requests it

Processing data in small, real-time increments

Processing large volumes of data at scheduled intervals

Processing data continuously as it arrives

A healthcare system records patient vitals continuously. The system must update patient records immediately and ensure that each update is consistent with the previous state. However, the system also needs to run nightly analytical reports on historical vitals. Which design best balances these needs?

Use a batch processing system for both updates and reports

Use a single analytical database for both real-time updates and nightly reports

Use a transactional database for real-time updates and a separate analytical store for nightly reports

Use a streaming analytics platform for both updates and reports

Why is batch processing commonly used in analytical workloads?

To efficiently process large volumes of data that do not require immediate results

To provide immediate responses to individual transactions

To minimize the cost of storing data

To ensure that every transaction is immediately durable

A utility company collects smart meter readings every 15 minutes. At the end of each day, they load all readings into a data lake and run a job to calculate daily consumption summaries. Which workload pattern is this?

Streaming analytics on the readings

Real-time processing of each reading

Transactional processing of each reading

Batch processing of daily readings

In the context of ACID properties, what does 'Atomicity' guarantee?

That the database remains in a valid state before and after a transaction

That a transaction is either fully completed or fully rolled back

That once a transaction is committed, it is permanently saved

That concurrent transactions do not interfere with each other

Microsoft Certified:Azure Data Fundamentals

Domain 1Objective 3

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

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 6–10

6foundation · easy
What is a key characteristic of batch processing in analytical workloads?
Select an answer first
7expert · hard
A healthcare system records patient vitals continuously. The system must update patient records immediately and ensure that each update is consistent with the previous state. However, the system also needs to run nightly analytical reports on historical vitals. Which design best balances these needs?
Select an answer first
8foundation · easy
Why is batch processing commonly used in analytical workloads?
Select an answer first
9application · medium
A utility company collects smart meter readings every 15 minutes. At the end of each day, they load all readings into a data lake and run a job to calculate daily consumption summaries. Which workload pattern is this?
Select an answer first
10foundation · easy
In the context of ACID properties, what does 'Atomicity' guarantee?
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.