Microsoft DP-900 Exam Practice Questions
US$39
Every question with the correct answer and why the other options are wrong.
Card, Apple Pay, Google Pay or PayPal. Download links are on your order page and in your email the moment you pay.
I passed the DP-900 exam with the help of Certstash Great Dumps. I scored almost 900 marks in the Microsoft Certified: Azure Data Fundamentals certification. All credits go to this website, you should give this certification dumps a try.
Three of the 323 questions in this pack
Question 1
You need to create an Azure Storage account. Data in the account must replicate outside the Azure region automatically. Which two types of replication can you use for the storage account? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Show answer and explanation
Correct answer: B, D. read-access geo-redundant storage (RA-GRS); geo-redundant storage (GRS)
Geo-redundant storage (GRS) and read-access geo-redundant storage (RA-GRS) both replicate data outside the Azure region automatically. GRS replicates to a secondary region asynchronously, while RA-GRS provides the same replication plus read access to the secondary region. Zone-redundant storage (ZRS) replicates only within a single region across availability zones, and locally-redundant storage (LRS) replicates only within a single datacenter, so neither meets the requirement of replicating outside the region.
Why the other options are wrong
- A. ZRS replicates across availability zones within a single region, not outside the region.
- C. LRS replicates only within a single datacenter and does not provide geo-replication.
Question 2
Which statement is an example of Data Manipulation Language (DML)?
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 3
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?
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.
10 reviews for Microsoft DP-900 Exam Practice Questions
Only logged in customers who have purchased this product may leave a review.
How much of the Microsoft DP-900 bank is free?
323 questions in the bankEach step includes the one before, so buying only adds new questions.
- You are here10questionsFree sampleThree on this page, all ten as a PDF.Download the sample
- 7323% of the bankPractice pageFree on the site, every answer explained.Go to the practice page
- 161the first half of the packHalf PackFree by email, as one PDF, every answer explained.Get the Half Pack
- 323100%, the whole bankFull pack, US$39Plus the questions-only PDF, monthly updates, refund if you fail.Get the full pack
What’s in the Microsoft DP-900 pack
- 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.
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 usual starting point for Azure data roles and good groundwork for DP-300, DP-600 and DP-700, though it is not a formal prerequisite for any of them.
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.
Questions before you buy
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.
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, or swap it for any other pack if you would rather keep studying. 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.
What is your pass rate?
99% of customers who prepare with a CertStash pack pass. If you do not, we refund the pack, or swap it for another pack.
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
-
Microsoft DP-700
161 questionsUpdated Nov 20265.0 (11) US$39 -
Microsoft DP-300
373 questionsUpdated Nov 20264.8 (21) US$39 -
Microsoft MB-310
425 questionsUpdated Nov 20265.0 (4) US$39 -
Microsoft AB-410
174 questionsUpdated Nov 2026 US$39
James Delreal –
I passed the DP-900 exam with the help of Certstash Great Dumps. I scored almost 900 marks in the Microsoft Certified: Azure Data Fundamentals certification. All credits go to this website, you should give this certification dumps a try.
Scott Martinez –
Certstash surely changed my perspective regarding the authenticity of the dumps. Your content within the dumps is so original and helped me so well. I am so grateful for you guys!
MILAN ISHIKAWA –
DP-900 passed on the first attempt.
Alejandro Morrison –
For anyone beginning their Azure certification journey these dumps are a priceless resource. Highly recommended for everyone
Jamie Sasser –
The structure and clarity of the dumps made learning so simple. Truly a 5-star service.
Ingrid –
Accurate and up to date for DP-900.
Kathy Smith –
WOW! These DP-900 exam dumps transformed my preparation entirely for the Azure Data Fundamentals exam. They covered the exam content perfectly, especially when it came to data architecture and storage solutions. I liked how they weren't just focused on questions but also provided clear, detailed explanations. It really helped me understand the major concepts and why each solution worked, which made a huge difference in the exam.
Finch –
I was kinda skeptical about purchasing dumps but the free demo for these DP-900 dumps really convinced me and I purchased the whole thing and was pleasantly surprised with the level of quality offered. The range of topics covered was huge; everything from data storage to database management. In fact, there were a lot of questions in the dumps that related to the analytics workload on Azure which is great because that exam area carries the most weightage in the exam. Overall, an incredibly effective practice resource!
Sandra Holmes –
Honestly, I wasn’t exactly sure what to expect with these DP-900 dumps, but woah, they really delivered!! For just $39, you get like close to 300 questions which is quite a decent deal if you ask me! Also, all types of difficulty levels were covered from very simple and easy questions to some very complex and tricky ones. This helped me get a better idea of the different varieties I could get in the exam and prepare to tackle them effectively. Certstash has done a pretty solid job on these! Appreciate it!
Bhatt –
The DP-900 content was concise but still comprehensive. I really appreciated how Cert Stash didn’t overload the pages with unnecessary theory. The pacing was quite manageable for short daily study sessions, making the whole experience less stressful and easy to fit into a busy schedule.