Microsoft DP-900 Exam Practice Questions, practice question pack
MICROSOFT · DP-900

Microsoft DP-900 Exam Practice Questions

323 questionsInstant PDF downloadUpdated September 2026

US$39

Try 10 questions free

Card, Apple Pay or Google Pay. Your PDF is sent by email as soon as you check out.

Pass or your money backFail the exam after using this pack and we refund it. How the guarantee works
Category:
TRY BEFORE YOU BUY

Three of the 323 questions in this pack

Question 1

Which statement is an example of Data Manipulation Language (DML)?

  1. REVOKE
  2. DISABLE
  3. INSERT
  4. GRANT
Show answer and explanation

Correct answer: C. INSERT

INSERT is a Data Manipulation Language (DML) statement used to add new rows of data to a table. DML statements modify data within the database. REVOKE and GRANT are Data Control Language (DCL) statements for managing permissions, and DISABLE is not a standard SQL statement.

Why the other options are wrong

  • A. REVOKE is a Data Control Language (DCL) statement for revoking permissions, not DML.
  • B. DISABLE is not a standard SQL DML statement.
  • D. GRANT is a Data Control Language (DCL) statement for granting permissions, not DML.

Question 2

You have a SQL query that combines customer data and order data. The query includes calculated columns.

You need to create a database object that would allow other users to rerun the same SQL query.

What should you create?

  1. an index
  2. a view
  3. a scalar function
  4. a table
Show answer and explanation

Correct answer: B. a view

A view is a database object that stores a predefined SQL query, allowing other users to rerun the same query without needing to write it themselves. Views can include calculated columns and combine data from multiple tables. An index improves query performance but does not store queries, a scalar function returns a single value but is not designed for sharing complex queries, and a table stores data but not query logic.

Why the other options are wrong

  • A. An index optimizes query performance but does not store the query logic itself.
  • C. A scalar function returns a single value and is not the appropriate object for storing multi-row query results.
  • D. A table stores data but does not encapsulate the query logic needed to combine and calculate data.

Question 3

Your company recently reported sales from the third quarter.

You have the chart shown in the following exhibit.

Which type of analysis is shown in the fourth quarter?

Exhibit for question 3

  1. predictive
  2. prescriptive
  3. descriptive
  4. diagnostic
Show answer and explanation

Correct answer: A. predictive

The fourth quarter in the chart shows a shaded gray area extending beyond the solid blue line of actual Q3 sales, representing a range of possible future outcomes. This is characteristic of predictive analysis, which uses historical data and trends to forecast future values. The chart displays Q1-Q3 as actual reported sales (descriptive data) and Q4 as a projected range with uncertainty bounds, which is the hallmark of predictive modeling used to estimate future performance.

Why the other options are wrong

  • B. Prescriptive analysis would recommend specific actions or decisions to take, not simply project future sales ranges.
  • C. Descriptive analysis describes what has already happened; Q4 represents forecasted future data, not historical description.
  • D. Diagnostic analysis explains why something happened in the past; Q4 shows future projections rather than analysis of past causes.

See all 10 free questions Get the full pack, US$39

323 practice questions for Microsoft Azure Data Fundamentals (DP-900), with full explanations.

Every question comes with the correct answer, the reasoning behind it, and a note on why each wrong option is wrong. Work through it once with the answers, then again with the questions-only copy under exam conditions.

  • 323 questions mapped to the DP-900 exam objectives
  • Answers and explanations for every question, including the wrong options
  • A questions-only PDF for timed practice runs
  • Instant delivery by email the moment you check out
  • Free monthly updates for as long as the exam is live
  • Pass or your money back

A failed DP-900 attempt costs US$99 in the US, plus the weeks it takes to get ready again. This pack is US$39, paid once, and refunded if you fail.

Try 10 questions free before you buy.

Last updated September 2026 · 323 questions

What makes the DP-900 hard

Fundamentals does not mean easy, it means broad. The DP-900 covers the entire Azure data estate in 45 minutes, and the wrong answers are engineered to sound right.

The recurring trap is service selection at speed: Azure SQL Database versus Managed Instance versus SQL on a VM, Cosmos DB versus Table Storage, Synapse versus Databricks versus Fabric, and when a data lake beats a warehouse. Add a vocabulary layer, OLTP versus OLAP, structured versus semi-structured, batch versus streaming, where one word in the question decides the answer.

It is the standard entry ticket for every Azure data role, and the prerequisite knowledge for DP-300, DP-600 and DP-700.

About the exam

DP-900 certifies foundational knowledge of core data concepts and how they are implemented with Azure data services: relational, non-relational and analytics workloads. No prerequisites, and the certification never expires.

Exam domains

  • Core data concepts: 25 to 30%
  • Relational data on Azure: 20 to 25%
  • Non-relational data on Azure: 15 to 20%
  • Analytics workloads on Azure: 25 to 30%

Around 40 to 50 questions, 45 minutes, passing score 700 out of 1000, US$99 in the US, priced by local currency elsewhere, online proctored or test centre, never expires.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.

Questions before you buy

What do I get when I buy the Microsoft DP-900 pack?

323 practice questions as a PDF, each with the correct answer, a full explanation and a note on why the other options are wrong, plus a separate questions-only PDF for timed practice.

How quickly do I receive it?

Straight away. The full PDF and a questions-only copy are emailed to you the moment your payment goes through, and the same links are on your order page.

Is there a free sample?

Yes. Ten questions from this pack, with answers and explanations, are free on this page and as a PDF, so you can judge the quality before you pay.

Are updates included?

Yes. The pack is updated every month for as long as the exam is live, and updates are free for everyone who has bought it.

What if I fail the exam?

We refund the pack. Sit the exam 7 to 30 days after buying, then send your official score report within 7 days of the exam date, as set out in the refund policy.

Can I share it with colleagues?

Each purchase is licensed to one person. For a team, school or training organisation, email support@certstash.com for a licence that fits.

Related products