Microsoft Certified: Azure Data Fundamentals Questions and Answers
200 questions organized by topic with detailed explanations
Microsoft
DP-900
200 questions
4 topics
Updated May 2026Describe core data concepts
61 questions18 easy29 medium14 hard~28% of exam
If a transaction fails partway through in an OLTP system, what should happen to the work that already started?Why can heavily normalized transactional databases be difficult for business users to query directly for reporting?A manufacturer wants to analyze five years of sales to find seasonal trends and compare regional performance. Which work...
Identify considerations for relational data on Azure
48 questions11 easy28 medium9 hard~23% of exam
A developer needs to add a new sales row to a relational table. Which SQL statement should be used?A developer wants reusable database-side logic that can be executed repeatedly on demand. Which database object should b...A team wants to expose a saved query result to users without duplicating the underlying table data. Which database objec...
Describe considerations for working with non-relational data on Azure
37 questions10 easy18 medium9 hard~19% of exam
A globally distributed application needs low-latency access, elastic scale, and a fully managed NoSQL database. Which Az...Which blob type is optimized for append operations such as writing log data?A team is considering Azure Cosmos DB for interactive batch analytics over large historical datasets. Based on Microsoft...
Describe an analytics workload on Azure
54 questions13 easy25 medium16 hard~30% of exam
All Questions
| # | Question | Topic | Difficulty |
|---|---|---|---|
| 1 | A developer needs to add a new sales row to a relational table. Which SQL statement should be used? | Identify considerations for relational data on Azure | medium |
| 2 | If a transaction fails partway through in an OLTP system, what should happen to the work that alread... | Describe core data concepts | medium |
| 3 | A globally distributed application needs low-latency access, elastic scale, and a fully managed NoSQ... | Describe considerations for working with non-relational data on Azure | medium |
| 4 | Which statement correctly describes a Power BI dashboard compared to a report? | Describe an analytics workload on Azure | medium |
| 5 | Why can heavily normalized transactional databases be difficult for business users to query directly... | Describe core data concepts | hard |
Sign in to see all 200 questions
Create a free account to browse all questions — completely free during our launch phase.
Ready to test your knowledge?
Take a full Microsoft Certified: Azure Data Fundamentals practice test with timed exam simulation.
Start Practice Test