Microsoft DP-900 Practice Exam Questions & Answers
6 Free Questions
· Last reviewed: September 28, 2026
· Prepared & Reviewed by the ValidExamDumps Editorial Team
Exam Facts
Microsoft DP-900 Exam Details
Key details for this exam, checked against the published exam outline
345
Practice Questions (Our Bank)
45 minutes
Exam Duration
700 out of 1000
Passing Score
USD 99
Official Exam Fee (United States)
- Exam Code
- DP-900
- Full Name
- Microsoft Azure Data Fundamentals
- Issuing Body
- Microsoft
- Question Format (Our Bank)
- Hotspot, Multiple Choice, Drag & Drop
- Delivery
- Online proctored exam through Pearson VUE or in-person at a testing center
- Eligibility
- No prerequisites or prior certification required
Practice Questions
Free DP-900 Practice Questions
Each question shows the correct answer and an explanation of why it is right
VA
ValidExamDumps Editorial Team
Every question and its answer is checked by our DP-900 exam
preparation team, who also write the explanation shown with each one.
How we research and review these pages
You need to gather real-time telemetry data from a mobile application.
Which type of workload describes this scenario?
Correct Answer:
D
Which Azure service provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition?
Correct Answer:
B
Explanation
Azure SQL Managed Instance provides the highest compatibility for databases migrated from Microsoft SQL Server 2019 Enterprise edition. It offers near-100% SQL Server compatibility, supports advanced features like Agent jobs and CLR integration, and minimizes application changes during migration, making it the optimal choice for enterprise SQL Server migrations.
What should you use to automatically delete blobs from Azure Blob Storage?
Correct Answer:
D
Explanation
To automatically delete blobs from Azure Blob Storage, you should use a Lifecycle management policy. Azure Blob Storage lifecycle management allows you to define rules that automatically delete, archive, or transition blobs between access tiers based on age or other criteria, enabling automated data retention and cost optimization.
You need to ensure that users use multi-factor authentication (MFA) when connecting to an Azure SQL
database.
Which type of authentication should you use?
Correct Answer:
B
Which type of Microsoft Power Bl visual can you use to examine trends over time for one or more series of values?
Correct Answer:
D
Explanation
A line chart in Microsoft Power BI is the visual type optimized for examining trends over time. It is ideal for displaying one or more series of values across a continuous time axis, making it easy to visualize patterns, changes, and comparisons in data over time periods.
Which two activities can be performed entirely by using the Microsoft Power BI service? Each correct answer presents a complete solution. (Choose two.)
NOTE: Each correct selection is worth one point.
Correct Answer:
A, D
Explanation
Two activities that can be performed entirely using the Microsoft Power BI service (without Power BI Desktop) are: Creating reports (using Power BI's web-based report editor) and Sharing dashboards (publishing and distributing dashboards to other users). While Power BI Desktop is used for more advanced data modeling and report creation, the service itself supports report creation and dashboard sharing through its web interface.
Full Access
Get the complete DP-900 question set
- 345 questions covering all exam domains
- Correct answers with explanations, like the free questions above
- PDF and online practice test
- 90 days of free updates
Domain 1: Describe core data concepts
25% - 30%
Covers the fundamentals of how data is represented and stored, including structured, semi-structured, and unstructured formats. Also covers common data storage options and the different types of workloads such as transactional and analytical processing, plus the roles and responsibilities of database administrators, data engineers, and data analysts in managing data systems.
Sample questions from this domain above:
Q4Q5Q6
Domain 2: Identify considerations for relational data on Azure
20% - 25%
Focuses on relational database concepts including normalization, schema design, and SQL fundamentals. Covers the Azure SQL product family including Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines, as well as open-source database options available on Azure.
Domain 3: Describe considerations for working with non-relational data on Azure
15% - 20%
Explores Azure storage services including Blob storage, Files, and Table storage, along with their specific use cases. Also covers Azure Cosmos DB, a multi-model database service, including its various APIs and scenarios where it is the right choice for applications.
Sample question from this domain above:
Q3
Domain 4: Describe an analytics workload
25% - 30%
Covers large-scale data analytics concepts including ingestion, processing, and storage of analytical data. Includes Microsoft cloud services like Azure Databricks and Microsoft Fabric, as well as real-time analytics solutions, and data visualization using Power BI including models and appropriate chart selection.
Sample questions from this domain above:
Q1Q2
FAQ
DP-900 Exam FAQ
Common questions about the exam itself
Is DP-900 a beginner exam or do I need prior data experience?
DP-900 is designed for candidates beginning to work with data in the cloud and assumes only foundational knowledge of core data concepts. You should have familiarity with basic IT tasks and simple data-related concepts like reading tables and charts, but no prior professional data experience is required.
How long should I study to prepare for DP-900?
Preparation time varies depending on your background, but most candidates spend between two to four weeks studying. Microsoft recommends combining self-paced learning modules on Microsoft Learn with hands-on practice in the Azure portal to reinforce the concepts.
What is the passing score for DP-900?
You need a score of 700 or greater out of 1000 to pass the DP-900 exam.
Can I take DP-900 as an online proctored exam or only at a test centre?
DP-900 is proctored and can be taken either online from your home or office or at a Pearson VUE test centre. Both options are available when you schedule your exam.
Is DP-900 a prerequisite for the Azure Data Engineer Associate or Azure Database Administrator Associate certifications?
No, DP-900 is not a prerequisite for either of these role-based certifications. However, passing DP-900 provides useful foundational knowledge that can help you prepare for them.
What is the hardest domain in DP-900 and how should I approach it?
Most candidates find the analytics workload domain challenging because it introduces multiple Azure services like Azure Databricks, Microsoft Fabric, and Power BI. Get hands-on experience in the Azure portal exploring these services and work through practical scenarios involving data ingestion and visualization.
How many questions are on the DP-900 exam and how much time do I have?
The exam contains multiple question types and formats. You have 45 minutes of testing time to complete the exam, which may include interactive components as part of the assessment.
How long is my DP-900 certification valid after I pass?
Microsoft certifications remain valid for a set period and have renewal requirements. Check your certification details in your Microsoft Learn profile for the specific validity period and renewal options for your DP-900 credential.
Can I retake DP-900 if I fail the first attempt?
Yes, you can retake the exam. Microsoft allows you to schedule retakes following their standard exam policies. There is typically a waiting period between attempts, so check the scheduling system for current retake requirements.
What job roles does DP-900 prepare me for?
DP-900 prepares you for foundational roles working with Azure data services, including entry-level positions in data engineering, data analysis, and database administration. It is designed to launch you toward role-based certifications in these specializations rather than a specific job itself.
