Microsoft Azure Data Fundamentals Exam (DP-900) - Microsoft

Exam Questions

94%

Students found the real exam almost the same

1,057

Students passed this exam after ExamsQA Prep

95.1%

Average score during Real Exams at the Testing Centre

Browse 316 Questions
💡

Browse at least 50% questions to maximize your chances of passing

Free Preview Questions

Sample DP-900 Exam Questions & Explanations

Practice with real question formats, multiple choice options, and detailed answer explanations for Microsoft DP-900.

Question #1 Verified Q&A
HOTSPOT To complete the sentence, select the appropriate option in the answer area.
Explanation:
<img src="https://examsqa.com/storage/question-images/microsoft-azure-data-fundamentals-exam-dp-900_page_1_Im3.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" /><br />
<br />
Disadvantages of non-relational databases include: Data Consistency — non-relational databases do not perform ACID transactions.<br />
<br />
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.<br />
<br />
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. https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77<br />
<br />
Reference:
Question #2 Verified Q&A
HOTSPOT To complete the sentence, select the appropriate option in the answer area.
Explanation:
<img src="https://examsqa.com/storage/question-images/microsoft-azure-data-fundamentals-exam-dp-900_page_2_Im5.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" />
Question #3 Verified Q&A
A bar chart showing year-to date sales by region is an example of which type of analytics?
A prescriptive
B descriptive
C predictive
D diagnostic
Correct Answer: diagnostic
Question #4 Verified Q&A
HOTSPOT To complete the sentence, select the appropriate option in the answer area.
Explanation:
<img src="https://examsqa.com/storage/question-images/microsoft-azure-data-fundamentals-exam-dp-900_page_2_Im6.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" /><br />
<br />
<img src="https://examsqa.com/storage/question-images/microsoft-azure-data-fundamentals-exam-dp-900_page_2_Im7.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" /><br />
<br />
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?<br />
<br />
Reference: https://azure.microsoft.com/en-us/blog/answering-whats-happening-whys-happening-and-what- will-happen-with-iot-analytics/
Question #5 Verified Q&A
Your company plans to load data from a customer relationship management (CRM) system to a data DRAG DROP warehouse by using an extract load, and transform (ELT) process.<br />
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate<br />
locations to the correct. Each location may be used once, or not at all, You may need to drag the split bar between panes or scroll to view content.<br />
<br />
NOTE: Each correct selection is worth one point.<br />
<br />
<img src="https://examsqa.com/storage/question-images/microsoft-azure-data-fundamentals-exam-dp-900_page_3_Im8.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" /><br />
<br />
<img src="https://examsqa.com/storage/question-images/microsoft-azure-data-fundamentals-exam-dp-900_page_3_Im9.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" />
Explanation:
Box 1: The CRM system Data is extracted from the CRM system. Box 2: The data warehouse Data is loaded to the data warehouse. Box 3: An in-memory data integration tool The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.<br />
<br />
<img src="https://examsqa.com/storage/question-images/microsoft-azure-data-fundamentals-exam-dp-900_page_4_Im10.jpg" alt="Exhibit" style="max-width: 100%; height: auto;" /><br />
<br />
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl

Want to practice all 316 questions?

Practice under real exam conditions with instant grading, timed simulations, and community insights.

Start Full DP-900 Practice Test

Frequently Asked Questions

Common questions about the Microsoft DP-900 certification practice test

How many questions are in the Microsoft DP-900 practice exam on ExamsQA?
Our DP-900 (Microsoft Azure Data Fundamentals Exam) practice question bank currently includes 316 verified questions with comprehensive explanations.
Are the DP-900 exam practice questions up to date for 2026?
Yes, all Microsoft DP-900 practice questions are regularly updated and verified against current exam objectives.
Will the DP-900 practice questions help me pass on my first attempt?
The DP-900 (Microsoft Azure Data Fundamentals Exam) question bank is built to mirror the real exam's format and topics, with detailed explanations for every answer so you understand the reasoning — not just memorize responses.
Is there a free demo available for DP-900 Microsoft Azure Data Fundamentals Exam?
Yes, ExamsQA offers free demo questions for the DP-900 exam so you can test the interface and question quality before purchasing full access.