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 (20)
✍️ 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.