Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Microsoft
  5. DP-900

Microsoft DP-900 Exam Questions
Microsoft Azure Data Fundamentals (Page 11 )

Updated On: 24-Feb-2026
Page 11 of 63
PDF with 314 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






Post your Comments and Discuss Microsoft DP-900 exam dumps with other Community members:

Join the DP-900 Discussion