Introduction of Microsoft DP-900 Exam!

Microsoft DP-900 is a certification exam for the Microsoft Azure Data Fundamentals certification. It is designed to test a candidate's knowledge of the core data concepts and services in Azure. The exam covers topics such as data storage, data security, data analysis, and data integration.

What is the Duration of Microsoft DP-900 Exam?

The Microsoft DP-900 exam is a one-hour exam consisting of 40-60 questions.

What are the Number of Questions Asked in Microsoft DP-900 Exam?

There are 40-60 questions on the Microsoft DP-900 exam.

What is the Passing Score for Microsoft DP-900 Exam?

The passing score for the Microsoft DP-900 exam is 700 out of 1000.

What is the Competency Level required for Microsoft DP-900 Exam?

The Microsoft DP-900 exam requires a foundational level of knowledge and skills related to Microsoft Azure data fundamentals. Candidates should have a good understanding of the core Azure data services, data security, data management and data development in order to be successful on the exam.

What is the Question Format of Microsoft DP-900 Exam?

Microsoft DP-900 exam consists of multiple-choice, multiple-response, drag and drop, and build list questions.

How Can You Take Microsoft DP-900 Exam?

Microsoft DP-900 exam can be taken online or at a testing center. To take the exam online, you will need to register and pay for the exam through the Microsoft Learning website. To take the exam at a testing center, you will need to locate a testing center near you and register for the exam with the testing center. Once you have registered, you will be provided with instructions on how to take the exam.

What Language Microsoft DP-900 Exam is Offered?

Microsoft DP-900 Exam is offered in English.

What is the Cost of Microsoft DP-900 Exam?

The Microsoft DP-900 exam is offered for a cost of $165 USD.

What is the Target Audience of Microsoft DP-900 Exam?

The Microsoft DP-900 exam is designed for IT professionals who have experience implementing, managing, and monitoring an Azure data platform. This includes roles such as Database Administrators, Database Developers, Data Architects, and Business Intelligence professionals.

What is the Average Salary of Microsoft DP-900 Certified in the Market?

The average salary of Microsoft Azure Data Fundamentals certified professionals varies widely by role, region, and experience, because it depends on the job the certification is combined with. Check current listings in your market for an up-to-date figure.

Who are the Testing Providers of Microsoft DP-900 Exam?

The testing provider for the Microsoft DP-900 exam is Pearson VUE, both at test centers and through its online proctored service.

What is the Recommended Experience for Microsoft DP-900 Exam?

Microsoft recommends that candidates for the DP-900 exam have at least six months of hands-on experience with Microsoft Azure, including the following areas: • Developing applications and services that are hosted on Azure • Implementing security, identity, and storage solutions • Monitoring and optimizing Azure solutions • Configuring and troubleshooting virtual networking • Managing Azure Active Directory (AD) • Automating Azure tasks using scripting and automation tools

What are the Prerequisites of Microsoft DP-900 Exam?

The Microsoft DP-900 exam is designed to measure a candidate's ability to architect, deploy, secure, monitor, and optimize a Microsoft Azure data solution. The exam topics include security and governance, data storage, data processing, and data analysis. To prepare for the exam, Microsoft recommends hands-on experience with the Azure platform, a understanding of the Azure data services, and practical experience with designing and implementing Azure data solutions.

What is the Expected Retirement Date of Microsoft DP-900 Exam?

The Microsoft DP-900 exam is the current version of the Microsoft Azure Data Fundamentals exam, and Microsoft has not announced a retirement date for it. When Microsoft introduces a newer version, the retirement date for the older version is published on the Microsoft certification site.

What is the Difficulty Level of Microsoft DP-900 Exam?

The Microsoft DP-900 exam is classified as an intermediate-level exam. This means that it is designed for those who have some experience with Azure Data Fundamentals, but who may need to brush up on some of the more advanced concepts.

What is the Roadmap / Track of Microsoft DP-900 Exam?

The Microsoft DP-900 Exam is a certification track/roadmap for professionals who want to demonstrate their expertise in deploying and managing solutions on Microsoft Azure. The exam covers topics such as deploying and managing Azure resources, configuring Azure services, and developing solutions on Azure. The exam is designed to help professionals demonstrate their ability to use the Azure platform to create and manage cloud solutions.

What are the Topics Microsoft DP-900 Exam Covers?

The Microsoft DP-900 exam covers the following topics: 1. Implementing Microsoft Azure Data Fundamentals: This topic covers the fundamentals of Azure Data, including data storage and processing architectures, data security, and the Azure Data platform. 2. Implementing Data Storage and Processing Solutions: This topic covers the implementation of data storage and processing solutions using Azure Data services, such as Azure Storage, Azure SQL Database, and Azure Data Lake. 3. Implementing Data Security Solutions: This topic covers the implementation of data security solutions using Azure Data services, such as Azure Active Directory, Azure Key Vault, and Azure Data Encryption. 4. Implementing Data Platform Solutions: This topic covers the implementation of data platform solutions using Azure Data services, such as Azure Data Factory, Azure Data Catalog, and Azure Machine Learning. 5. Monitoring and Troubleshooting Data Solutions: This topic covers the monitoring and troubleshooting of data solutions using Azure Data services,

What are the Sample Questions of Microsoft DP-900 Exam?

1. What is Azure Data Factory and how is it used to move and transform data? 2. What are the components of an Azure Data Factory pipeline? 3. What are the benefits of using Azure Data Factory? 4. How can you create and deploy a pipeline in Azure Data Factory? 5. What are the best practices for managing and monitoring Azure Data Factory pipelines? 6. What are the security considerations when using Azure Data Factory? 7. How can you use Azure Data Factory to integrate data from multiple sources? 8. What are the differences between Azure Data Factory and Azure Data Lake? 9. How can you use Azure Data Factory to automate data processing tasks? 10. What are the different types of data stores that can be used with Azure Data Factory?

← Back to exam page

Free DP-900 – Microsoft Azure Data Fundamentals Practice Test Question

Free demo downloads

Loading demo links...

Showing 1–15 of 15 questions

Question 1 (Describe an analytics workload on Azure)

DRAG DROP

Match the types of activities to the appropriate Azure Data Factory activities.

To answer, drag the appropriate activity type from the column on the left to its Data Factory activity on the right. Each activity type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select and Place:

Answer is in the explanation below.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 2 (Describe an analytics workload on Azure)

DRAG DROP

Match the types of workloads to the appropriate scenarios.

To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.

NOTE: Each correct match is worth one point.

Select and Place:

Answer is in the explanation below.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 7 (Describe an analytics workload on Azure)

What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

○
denormalized data
○
heavy writes and moderate reads
○
light writes and heavy reads
○
schema on write
○
schema on read
○
normalized data

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 8 (New Update)

In Azure Table storage, each row in a table must be uniquely identified by which two components?

Each correct answer presents pan of the solution. NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

○
a timestamp
○
a range
○
a row key
○
a partition key

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 9 (Describe how to work with relational data on Azure)

You need to query a table named Products in an Azure SQL database.

Which three requirements must be met to query the table from the internet? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Select all that apply, then click Submit answer.

○
You must be assigned the Reader role for the resource group that contains the database.
○
You must have SELECT access to the Products table.
○
You must have a user in the database.
○
You must be assigned the Contributor role for the resource group that contains the database.
○
Your IP address must be allowed to connect to the database.

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 10 (New Update)

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.

Select all that apply, then click Submit answer.

○
report and dashboard creation
○
report sharing and distribution
○
data modeling
○
data acquisition and preparation

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 11 (New Update)

What is a primary characteristic of a relational database?

Select an option, then click Submit answer.

○
data is queried and manipulated by using a variant of the SQL language
○
a flexible data structure
○
a lack of dependencies between tables
○
a large amount of duplicate data

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 12 (Describe core data concepts)

Which storage solution supports access control lists (ACLs) at the file and folder level?

Select an option, then click Submit answer.

○
Azure Data Lake Storage
○
Azure Queue storage
○
Azure Blob storage
○
Azure Cosmos DB

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 13 (New Update)

You need to use Transact-SQL to query files in Azure Data Lake Storage from an Azure Synapse Analytics data warehouse.

What should you use to query the files?

Select an option, then click Submit answer.

○
Azure Functions
○
Microsoft SQL Server Integration Services (SSIS)
○
PolyBase
○
Azure Data Factory

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 14 (Describe how to work with non-relational data on Azure)

Your company is designing a data store that will contain student data. The data has the following format.

Which type of data store should you use?

Select an option, then click Submit answer.

○
graph
○
key/value
○
object
○
columnar

Ask AI for More Explanation

— your own AI account, opens inside the app

Question 15 (New Update)

You have an inventory management database that contains the following table.

Which statement should you use in a SQL query to change the inventory quantity of Product1 to 270?

Select an option, then click Submit answer.

○
INSERT
○
MERGE
○
UPDATE
○
CREATE

Ask AI for More Explanation

— your own AI account, opens inside the app

About the DP-900 Free Practice Test

This free practice test covers the Microsoft Azure Data Fundamentals (DP-900) exam from Microsoft. The 15 questions are a free sample of the full Study4Pass practice set of 297 questions, so you can check your level before you commit to the real exam. The free sample includes 5 single-answer, 4 multiple-answer, 2 drag-and-drop, 2 interactive and 2 hands-on lab questions — the same mix of formats you will meet in the full set. Questions are spread across the areas that matter most on the real exam: Describe core data concepts, Identify considerations for relational data on Azure, Describe considerations for working with non-relational data on Azure and Describe an analytics workload on Azure. The real exam requires a score of 700 out of 1,000 to pass. Microsoft DP-900 is a certification exam for the Microsoft Azure Data Fundamentals certification.

The Microsoft DP-900 exam is designed for IT professionals who have experience implementing, managing, and monitoring an Azure data platform. The Microsoft DP-900 exam is designed to measure a candidate's ability to architect, deploy, secure, monitor, and optimize a Microsoft Azure data solution.

Certification: Microsoft Azure Data Fundamentals (DP-900)
Vendor: Microsoft
Free on this page: 15 practice questions with answers and explanations
Full practice set: 297 questions

Treat this sample as a diagnostic. Answer honestly, check the explanation after every question, and note which topics feel shaky. A short, focused review of those topics is worth more than re-reading everything — and the full set lets you drill them topic by topic.

A good way to use this page: take the whole sample in one sitting, then go back over every explanation with fresh eyes. Mark the topics that felt uncertain, not just the ones you got wrong — uncertain answers are unmarked risk on the real exam. One or two focused passes like this usually move a score more than days of passive reading.

Inside the full DP-900 practice set:

All 297 questions with answers and explanations
Timed Exam Simulation that mirrors the real exam pressure
Topic Training to drill one domain at a time
Ask AI for More Explanation on every question
Flag questions and review them before you finish

How to use this DP-900 free practice test

Answer a question, then check the result to see the correct answer and the explanation behind it. Work at your own pace — there is no timer and no signup. Stuck on a concept? This is an AI-Enabled practice test: use Ask AI on any question and get the underlying concept explained in plain words, so you learn the reasoning instead of memorizing answers. Ready for more? The full 297-question set adds a timed Exam Simulation mode, topic training for your weak areas, and a flagged-question review, so you can practise the way the real exam feels.

What to study for each DP-900 domain

Describe core data concepts (25–30%) — This is the largest section of the DP-900 exam at 25–30% — give it the most study time, and do not book the exam until these questions feel comfortable.
Identify considerations for relational data on Azure (20–25%) — Use the practice questions to find your gaps in Identify considerations for relational data on Azure first, then read the official Microsoft documentation for anything you missed.
Describe considerations for working with non-relational data on Azure (15–20%) — For Describe considerations for working with non-relational data on Azure, focus on understanding why each correct answer is right; the real exam rewards reasoning over recall.
Describe an analytics workload on Azure (25–30%) — This is the largest section of the DP-900 exam at 25–30% — give it the most study time, and do not book the exam until these questions feel comfortable.

DP-900 practice test — quick questions

Is this DP-900 practice test free?

Yes — the 15 questions on this page are completely free, with no signup and no payment details needed.

How many questions are in the full DP-900 set?

297 questions. The 15 free questions above are a sample of that full set, in the same style and topic balance.

Does the free test show the answers?

Yes — every question shows the correct answer with an explanation, and Ask AI can explain the concept behind a question in plain words if you want to go deeper.