DP-900 practice questions — Microsoft Azure Data Fundamentals

The exam

What DP-900 tests

DP-900 validates foundational knowledge of core data concepts and how they are implemented with Microsoft Azure data services. Covers ways to represent data, relational and non-relational data on Azure, and analytics workloads including Microsoft Fabric and Power BI.

Who it is for

Built for fundamentals-level candidates

Candidates beginning to work with data in the cloud. You should be familiar with the concepts of relational and non-relational data, and with different types of data workloads such as transactional and analytical. DP-900 can be used to prepare for role-based certifications such as Azure Database Administrator Associate or Azure Data Engineer Associate, but is not a prerequisite for them.

What it covers

The official domains, weighted as the exam weights them.

Your readiness map in the app is organised the same way, so what you see here is exactly what you study against.

Describe core data concepts
29%
Identify considerations for relational data on Azure
24%
Describe considerations for working with non-relational data on Azure
18%
Describe an analytics workload
29%

What Preppio gives you

Signal, not vibes.

851 questions

Across every domain above, in 5 formats: concept, scenario, ordering, multi-select, matching. Each one explains why the right answer is right and every distractor wrong.

A readiness map

Per domain, whether you are ready, weak, or not started — the same domains and weights as the exam itself.

Winston

Your study partner. He tracks where you are weak and drills exactly that, instead of serving you what you already know.

Try one

One of each format DP-900 uses, from the same bank.

Answer on the page. The explanation appears when you submit; use Next to move through the formats.

Sample 1 · Concept

You are reviewing a dataset for Contoso, Ltd. that consists of customer order records. Each record contains a fixed set of attributes: OrderID, CustomerID, OrderDate, and TotalAmount, and every record conforms to the same schema before it is loaded into a database. You need to identify the category of data represented by this dataset. Which category should you identify?

Pick one, then submit.

Sample 2 · Scenario

You are the data engineer for Tailwind Traders. You are building a solution that must ingest millions of streaming events per second from IoT devices and make them available for real-time processing with minimal latency before they are written to long-term storage. Which Azure service should you recommend for the ingestion layer?

Pick one, then submit.

Sample 3 · Ordering

You are normalizing a database for Contoso, Ltd. The initial design contains a single unnormalized table named OrderDetails that includes repeating groups of product columns for each order. You need to convert the design to third normal form (3NF) by applying the standard normalization progression. Which three actions should you perform in sequence?

Drag an item onto another to swap them, or use the arrows, then submit.

1Remove columns that depend on non-key columns rather than on the primary key, producing third normal form (3NF).
2Add redundant columns back into the table to improve read performance.
3Remove columns that depend on only part of a composite primary key, producing second normal form (2NF).
4Remove repeating groups of columns so that each field contains a single value, producing first normal form (1NF).

Sample 4 · Multi-select

Select all that apply: You are the Azure administrator for Adventure Works. You must select a storage service to host unstructured video files that will be accessed by a web application over HTTP and HTTPS. Which two statements about Azure Blob Storage are accurate?

Select all that apply, then submit.

Sample 5 · Matching

You are training new data analysts at Fabrikam, Inc. on data classification. Match each data format description to the data category it represents:

Pick up a response below, then click a prompt to place it.

Response pool — click to pick up

1 of 5

Study links

Official material

Microsoft Learn: Study guide for Exam DP-900learn.microsoft.com Free Practice Assessmentlearn.microsoft.com Exam Sandboxaka.ms

FAQ

The things people ask about DP-900

How many questions are on the DP-900 exam, and how long is it?

45 questions in 45 minutes.

What score do you need to pass DP-900?

70%, a scaled score of 700.

What does DP-900 cover?

4 domains, weighted as the exam weights them: Describe core data concepts (29%), Identify considerations for relational data on Azure (24%), Describe considerations for working with non-relational data on Azure (18%) and Describe an analytics workload (29%). Your readiness map in the app is organised by the same domains, so what you study against is what the exam tests.

What question formats does DP-900 use?

Five formats: concept, scenario, ordering, multi-select and matching. The practice questions use every one of them, and the sample on this page shows one of each.

Is DP-900 free on Preppio.ai?

DP-900 is on the Single, Dual and All Access plans. You start on the free tier and add it from the plan picker inside the app. Three fundamentals exams (AZ-900, CLF-C02 and CDL) are always free, and the sample on this page is free to try.

Where do the DP-900 practice questions come from?

Every question is generated from the exam's published objectives, then checked for accuracy, answer key and explanation before it is served. Nothing is copied from any exam, questions rotate by how often they have been seen, and they are retired when the objectives change.

DP-900Microsoft Azure Data Fundamentals