DP-200 Questions and Answers

  Printable PDF

Implementing an Azure Data Solution: DP-200

Rating: 4.6

Vendor: Microsoft

Certifications: Role-based

Exam Name: Implementing an Azure Data Solution

Exam Code: DP-200

Total Questions: 250 Q&As

Last Updated: Dec 12, 2021

Exam retired ,new exam code replace: DP-203

PDF Only: $45.99 VCE Only: $49.99 VCE + PDF: $59.99

Microsoft DP-200 PDF&VCE Dumps Download

  • 99.5% Pass Rate
  • 365 Days Free Update
  • Verified By Professional IT Experts
  • 24/7 Live Support
  • 378,380+ Satisfied Customers
  • 3 Days Preparation Before Test
  • 18 Years Experience
  • 6000+ IT Exam Dumps
  • 100% Safe Shopping Experience

Microsoft DP-200 Last Month Results

Successful Stories of Microsoft DP-200 Exam
High Score Rate in Actual Microsoft Exams
Same Questions from the Latest Real Exam

DP-200 Online Practice Questions and Answers

Questions 1

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while

others might not have a correct solution.

After you answer a question in this scenario, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You plan to create an Azure Databricks workspace that has a tiered structure. The workspace will contain the following three workloads:


A workload for data engineers who will use Python and SQL


A workload for jobs that will run notebooks that use Python, Spark, Scala, and SQL


A workload that data scientists will use to perform ad hoc analysis in Scala and R

The enterprise architecture team at your company identifies the following standards for Databricks environments:


The data engineers must share a cluster.


The job cluster will be managed by using a request process whereby data scientists and data engineers provide packaged notebooks for deployment to the cluster.


All the data scientists must be assigned their own cluster that terminates automatically after 120 minutes of inactivity. Currently, there are three data scientists.

You need to create the Databrick clusters for the workloads.

Solution: You create a Standard cluster for each data scientist, a Standard cluster for the data engineers, and a High Concurrency cluster for the jobs.

Does this meet the goal?

A. Yes

B. No

Show Answer
Questions 2

You have an Azure subscription the contains the resources shown in the following table:

All the resources have the default encryption settings.

You need to ensure that all the data stored in the resources is encrypted at rest.

What should you do?

A. Enable Azure Storage encryption for storageaccount1.

B. Enable Transparent Data Encryption (TDE) for synapsedb1.

C. Enable Azure Storage encryption for storageaccount2.

D. Enable encryption at rest for cosmosdb1.

Show Answer
Questions 3


You have an Azure data factory.

You need to ensure that pipeline-run data is retained for 120 days. The solution must ensure that you can query the data by using the Kusto query language.

Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

Select and Place:

Show Answer More Questions

Success Stories


  • United States
  • Nov 25, 2022
  • Rating: 4.7 / 5.0

Passed with an unexpected score. A big surprise. Thanks very much.

Download Free Microsoft DP-200 Demo

Experience Certbus exam material in PDF version.
Simply submit your e-mail address below to get started with our PDF real exam demo of your Microsoft DP-200 exam.

Instant download
Latest update demo according to real exam

*Email Address

* Our demo shows only a few questions from your selected exam for evaluating purposes