Amazon
Avaya
Cisco
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL
Juniper
Microsoft
NVIDIA
Okta
Palo Alto Networks
Salesforce
SAP
ServiceNow
All Vendors

Microsoft Azure Data Fundamentals DP-900 Exam Questions in PDF

Free Microsoft DP-900 Dumps Questions (page: 10)

DP-900 PDF — 323 Questions

HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



A treemap chart divides the chart area into rectangles that represent the different levels and relative sizes of the data hierarchy.


Reference:

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/tree-map-and-sunburst-charts-in-reporting-services?view=sql-server-ver15



What is a characteristic of batch processing?

  1. The data ingested during batch processing must be processed as soon as the data is received.
  2. Large datasets must be split into batches of less than 1 GB before the data can be processed.
  3. There is a noticeable time delay between ingesting data and obtaining the data processing results.
  4. Batch processing can only process data that is structured.

Answer(s): C



HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



An aggregate function performs a calculation on a set of values, and returns a single value. The following are aggregate functions:
-APPROX_COUNT_DISTINCT
-AVG
-CHECKSUM_AGG
-COUNT
-COUNT_BIG

GROUPING
-GROUPING_ID
-MAX
-MIN
-STDEV
-STDEVP
-STRING_AGG
-SUM
-VAR
-VARP


Reference:

https://docs.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver15



HOTSPOT (Drag and Drop is not supported)
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:


Box 1: Yes
Batch processing refers to processing of high volume of data in batch within a specific time span. It processes large volume of data all at once. Batch processing is used when data size is known and finite. It takes little longer time to processes data.
Box 2: Yes
Stream processing refers to processing of continuous stream of data immediately as it is produced. It analyzes streaming data in real time. Stream processing is used when the data size is unknown and infinite and continuous.
Box 3: No


Reference:

https://www.geeksforgeeks.org/difference-between-batch-processing-and-stream-processing/



HOTSPOT (Drag and Drop is not supported)
Select the answer that correctly completes the sentence.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



The same set of columns.
In relational databases, a row is a data record within a table. Each row, which represents a complete record of specific item data, holds different data within the same structure. A row is occasionally referred to as a tuple.
Incorrect:
Not: a key value pair.
Unlike relational databases, key-value databases do not have a specified structure. Relational databases store data in tables where each column has an assigned data type. Key-value databases are a collection of key-value pairs that are stored as individual records and do not have a predefined data structure.


Reference:

https://www.techopedia.com/definition/4425/database-row
https://www.techtarget.com/searchdatamanagement/tip/NoSQL-database-types-explained-Key-value-store



Viewing page 10 of 63

Share your comments for Microsoft DP-900 exam with other users:

A
AI Tutor Explanation
5/16/2026 7:04:20 AM

Question 4:
Question 4 is about when to use batch processing.

  • Answer key: A (the option related to “When to use batch processing”).
  • Core idea: Batch processing is used when you can tolerate some delay and don’t need results instantly. Data is collected over a period, then processed together in a batch.

Why this is correct:
  • Latencies are expected with batch jobs. The system processes data in groups rather than as soon as data arrives.
  • The processes are often not mission-critical at the exact moment they run, so delays don’t impact operations.

Key concepts to know:
  • Batch processing vs real-time processing: Batch processes collect data and run at scheduled times or when resources are available, whereas real-time processing handles data immediately.
  • When to use batch processing:
- High-volume data where immediate results aren’t required - Tasks that can be scheduled (e.g., nightly ETL, end-of-day payroll, bulk reports) - When cost or resource utilization is optimized by processing in groups
Examples: nightly data aggregation, batch payroll processing, end-of-day reconciliations.
If you want, I can walk through how to identify the right scenario for batch vs real-time in practice.

Cape Town, South Africa
G
Gerrard
3/18/2026 6:58:37 AM

The DP-900 exam can be tricky if you aren't familiar with Microsoft’s specific cloud terminology. I used the practice questions from free-braindumps.com and found them incredibly helpful. The site breaks down core data concepts and Azure services in a way that actually mirrors the real test. As a resutl I passed my exam.

United States
AI Tutor 👋 I’m here to help!