DP-200 Study Guide 2026
Everything you need to pass the DP-200 exam in one place: the exam format, every topic to study, real practice questions with explanations, flashcards, and full-length practice tests. Free, no sign-up needed.
📋 DP-200 Exam Format at a Glance
📚 DP-200 Topics to Study (18)
✍️ Sample DP-200 Questions & Answers
1. What is the purpose of a linked service in Azure Data Factory?
A linked service in ADF defines the connection string and credentials needed to connect to an external data store or compute target.
2. What is the purpose of result-set caching in Azure Synapse Analytics dedicated SQL pool?
Result-set caching stores the output of a query and serves the same result for subsequent identical queries, dramatically reducing latency for repeated BI queries.
3. Which Cosmos DB consistency level provides the strongest consistency guarantees?
Strong consistency guarantees that reads always return the most recent committed write, at the cost of higher latency.
4. In Azure SQL Database, what is the purpose of Query Store?
Query Store persists query execution plans, runtime statistics, and wait statistics over time, enabling analysis of query performance regressions.
5. What is the purpose of Streaming Units (SUs) in Azure Stream Analytics?
Streaming Units represent the combined CPU and memory resources allocated to a Stream Analytics job, and scaling SUs increases processing throughput.
6. Which output sink in Azure Stream Analytics is best suited for storing aggregated results in a relational format for BI reporting?
Azure SQL Database is the ideal relational output for Stream Analytics aggregations that will be consumed by BI tools like Power BI.
🎯 Free DP-200 Practice Tests
📖 DP-200 Guides & Articles
What Practice Test Geeks adds beyond an AI chat for DP-200
An AI chatbot can quiz you, but it can't reproduce the exam conditions or keep your record. Here you get:
- A timed, full-length DP-200 mock exam — 50 questions in 180 minutes with a 70% pass mark, modeled on the official exam's question count and time limit, followed by a score report broken down by exam domain.
- A fixed DP-200 question bank: the same test every attempt, so your score is comparable from one try to the next instead of changing with every regenerated quiz.
- Progress saved on your device: completed tests, scores and missed questions stay in My Progress, so you can retake only what you got wrong.
- A printable DP-200 cheat sheet you can print or save as a PDF.
- DP-200 flashcards built from the same question bank.
- Free DP-200 practice tests with the correct answer shown after each question.
How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com — Eligibility, renewal, score validity, retake policy, passing score, score release, exam information · verified Nov 2026
- pearsonvue.com — Test delivery · verified Nov 2026