EN简体繁體
Sign in
Home / Microsoft / DP-900
Microsoft · DP-900

DP-900 Exam Practice Questions

Azure Data Fundamentals

DP-900 English PDF practice questions: 323 questions in source order, with options supported by the source format, answers and available explanations. Access covers this exam only. One-time payment; no automatic renewal.

Exam overview

For beginners learning relational and nonrelational data concepts and Azure analytics workloads.

Exam code
DP-900
Official exam / credential
Azure Data Fundamentals
Exam format
Proctored assessment; interactive items may be included
Exam duration
45 minutes
Official exam languages
English, Japanese, Simplified Chinese, Korean, French, German, Spanish, Portuguese (Brazil), Russian, Indonesian, Arabic (Saudi Arabia), Traditional Chinese, Italian

Official exam languages and practice-question file languages are listed separately. Confirm the exam version and available languages when booking with the provider.

Official sources: Provider reference
Information checked: 2026-10-20

Supported languages

  • English
  • Simplified Chinese
  • Japanese
Try before you buy

First 20 practice questions

323 total questions

Questions follow the source order. Expand each answer to see its explanation.

Disclaimer: All questions on ExamPico are compiled from internet sources and are provided for study reference only.

Question 11

Question#11Topic1

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question illustration

Show answer and explanation

Answer

C

Explanation

Disadvantages of non-relational databases include: Data Consistency ג€' non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
Incorrect Answers:
Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.
Use Cloud storage (no relational database) for geographically distributed writes.
Reference:
https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77

Question 12

Question#12Topic1

HOTSPOT -
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:
Question illustration

Show answer and explanation

Answer

YYY

Explanation

Batch processing can have output to SQL Database, Hive, HBase, Spark SQL. Look at the link and the diagram there https://docs.microsoft.com/en-us/azure/architecture/data-guide/big-data/batch-processing

Question 13

Question#13Topic1

DRAG DROP -
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Question illustration

Show answer

Answer

BCC

Question 14

Question#14Topic1

HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Question illustration

Show answer and explanation

Answer

B

Explanation

Generally speaking, data analytics comes in four types (Figure 1):
Descriptive, to answer the question: What's happening?
Diagnostic, to answer the question: Why's happening?
Predictive, to answer the question: What will happen?
Prescriptive, to answer the question: What actions should we take?
Reference:
https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what-will-happen-with-iot-analytics/

Question 15

Question#15Topic1

DRAG DROP -
Match the types of visualizations to the appropriate descriptions.
To answer, drag the appropriate visualization type from the column on the left to its description on the right. Each visualization type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Question illustration

Show answer and explanation

Answer

CAB

Explanation

Box 1: Tree map -
Treemaps are charts of colored rectangles, with size representing value. They can be hierarchical, with rectangles nested within the main rectangles.
Question illustration

Box 2: Key influencer -
A key influencer chart displays the major contributors to a selected result or value.

Box 3: Scatter -
Scatter and Bubble charts display relationships between 2 (scatter) or 3 (bubble) quantitative measures -- whether or not, in which order, etc.

Downloads and personal use

  • Purchase this exam question set separately with 1, 3, 6 or 12 months of download access.
  • After payment confirmation, your library shows the download link and exact expiry time.
  • Download again during your term. Purchase a new term after expiry.
  • PDFs are licensed for personal study only and must not be resold or shared publicly.
  • Files already saved to your device are not remotely deleted when access expires.
How to choose your certification