Shop Categories

 [email protected]
Search
View Cart
Checkout

The following DP-200 questions are part of our Microsoft DP-200 real exam questions full version. There are 242 in our DP-200 full version. All of our DP-200 real exam questions can guarantee you success in the first attempt. If you fail DP-200 exam with our Microsoft DP-200 real exam questions, you will get full payment fee refund. Want to practice and study full verion of DP-200 real exam questions? Go now!

 Get DP-200 Full Version

Microsoft DP-200 Exam Actual Questions

The questions for DP-200 were last updated on Jul 27,2021 .

Viewing page 1 out of 2 pages.

Viewing questions 1 out of 10 questions

Question#1

Validate configuration results and deploy the solution
Does the solution meet the goal?

A. Yes
B. No

Explanation:
We use the Azure Key Vault, not the Windows Certificate Store, to store the master key.
Note: The Master Key Configuration page is where you set up your CMK (Column Master Key) and select the key store provider where the CMK will be stored. Currently, you can store a CMK in the Windows certificate store, Azure Key Vault, or a hardware security module (HSM).



References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-always-encrypted-azure-key-vault

Question#2

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 questions sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You need setup monitoring for tiers 6 through 8.
What should you configure?

A. extended events for average storage percentage that emails data engineers
B. an alert rule to monitor CPU percentage in databases that emails data engineers
C. an alert rule to monitor CPU percentage in elastic pools that emails data engineers
D. an alert rule to monitor storage percentage in databases that emails data engineers
E. an alert rule to monitor storage percentage in elastic pools that emails data engineers

Explanation:
Scenario:
Tiers 6 through 8 must have unexpected resource storage usage immediately reported to data engineers.
Tier 3 and Tier 6 through Tier 8 applications must use database density on the same server and Elastic pools in a cost-effective manner.

Question#3

You need to set up Azure Data Factory pipelines to meet data movement requirements.
Which integration runtime should you use?

A. self-hosted integration runtime
B. Azure-SSIS Integration Runtime
C. .NET Common Language Runtime (CLR)
D. Azure integration runtime

Explanation:
The following table describes the capabilities and network support for each of the integration runtime types:



Scenario: The solution must support migrating databases that support external and internal application to Azure SQL Database. The migrated databases will be supported by Azure Data Factory pipelines for the continued movement, migration and updating of data both in the cloud and from local core business systems and repositories.
References: https://docs.microsoft.com/en-us/azure/data-factory/concepts-integration-runtime

Question#4

Validate configuration results and deploy the solution
Does the solution meet the goal?

A. Yes
B. No

Explanation:
Use the Azure Key Vault, not the Windows Certificate Store, to store the master key.
Note: The Master Key Configuration page is where you set up your CMK (Column Master Key) and select the key store provider where the CMK will be stored. Currently, you can store a CMK in the Windows certificate store, Azure Key Vault, or a hardware security module (HSM).



References: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-always-encrypted-azure-key-vault

Question#5

HOTSPOT
You need to ensure polling data security requirements are met.
Which security technologies should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.


A. 

Explanation:
Box 1: Azure Active Directory user
Scenario:
Access to polling data must set on a per-active directory user basis
Box 2: DataBase Scoped Credential
SQL Server uses a database scoped credential to access non-public Azure blob storage or Kerberos-secured Hadoop clusters with PolyBase.
PolyBase cannot authenticate by using Azure AD authentication.
References: https://docs.microsoft.com/en-us/sql/t-sql/statements/create-database-scoped-credential-transact-sql

Exam Code: DP-200Q & A: 242 Q&AsUpdated:  Jul 27,2021

 Get DP-200 Full Version
 About DP-200 Questions

TOP Exams