Microsoft Certified: Azure Data Fundamentals (DP-900) Practice Test
Build your confidence for Microsoft Certified: Azure Data Fundamentals (DP-900). Practice the concepts, understand the answers, and strengthen your knowledge one question at a time.
Try a sample questionExam overview and details
Microsoft Azure Data Fundamentals (DP-900) assesses core data concepts, relational data on Azure, non-relational data, and analytics workloads. It is a foundational exam rather than a database-administrator or data-engineer qualification. This practice page helps you compare workload and storage requirements; consult the official study guide for the current scope and the Microsoft Learn material associated with each objective.
Sample Questions
Choose an answer and explore the explanation to see how practice works.
Fabrikam Health is migrating a large enterprise data warehouse and needs provisioned MPP compute for complex T-SQL reports over modeled tables. Which Azure service fits best?
Northwind Traders is building a new cloud-native order service with one relational database, automatic backups, and no need to manage Windows or SQL Server patching. Which service is the best fit?
Woodgrove Bank must run a vendor SQL Server product that requires OS-level access and custom third-party agents. Which Azure option best meets that constraint?
Proseware Logistics runs an on-premises SQL Server app that uses SQL Agent jobs and cross-database queries. The team wants a managed Azure service with minimal code changes. What should they choose?
Tailspin Toys is migrating a PostgreSQL application and wants Microsoft to manage patching, backups, and high availability for the database engine. Which service should be selected?
Career Opportunities & Salary
Exam insights and study advice
For each data scenario, identify its structure, query pattern, consistency needs and whether it is transactional or analytical. Compare the closest two storage choices using those requirements. After a missed question, write a small example of the data and the operation being performed; use it to explain why the alternative service is less suitable.
Your Path Forward
What this exam covers
Use the published domain weights to plan your study. Practice results do not predict your certification exam score.
01Describe an Analytics Workload on Azure
Data warehousing, real-time analytics, visualization
Topics
- Synapse Analytics
- Data Factory
- Databricks
- Power BI
02Describe Core Data Concepts
Data types, workloads, analytics concepts
Topics
- Relational data
- Non-relational data
- Analytics workloads
- Data processing
03Identify Considerations for Relational Data on Azure
Azure SQL services, relational concepts
Topics
- Azure SQL Database
- Azure SQL MI
- PostgreSQL
- MySQL
04Describe Considerations for Working with Non-Relational Data on Azure
Cosmos DB, Blob, Table, File storage
Topics
- Cosmos DB
- Blob Storage
- Table Storage
- Azure Files