DP-200 Practice Test

Question 21

A company runs Microsoft SQL Server in an on-premises virtual machine (VM). You must migrate the database to Azure SQL Database. You synchronize users from Active Directory to Azure Active Directory (Azure AD). You need to configure Azure SQL Database to use an Azure AD user as administrator. What should you configure?

1. For each Azure SQL Database, set the Access Control to administrator.
2. For each Azure SQL Database server, set the Active Directory to administrator.
3. For each Azure SQL Database, set the Active Directory administrator role.
4. For each Azure SQL Database server, set the Access Control to administrator.

Question 22

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22). You need to implement masking for the Customer_ID field to meet the following requirements: ✑ The first two prefix characters must be exposed. ✑ The last four suffix characters must be exposed. ✑ All other characters must be masked. Solution: You implement data masking and use a credit card function mask. Does this meet the goal?

1. Yes
2. No

Question 23

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22). You need to implement masking for the Customer_ID field to meet the following requirements: ✑ The first two prefix characters must be exposed. The last four suffix characters must be exposed. ✑ All other characters must be masked. Solution: You implement data masking and use an email function mask. Does this meet the goal?

1. Yes
2. No

Question 24

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 section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You have an Azure SQL database named DB1 that contains a table named Table1. Table1 has a field named Customer_ID that is varchar(22). You need to implement masking for the Customer_ID field to meet the following requirements: ✑ The first two prefix characters must be exposed. ✑ The last four suffix characters must be exposed. ✑ All other characters must be masked. Solution: You implement data masking and use a random number function mask. Does this meet the goal?

1. Yes
2. No

Question 25

You are responsible for providing access to an Azure Data Lake Storage Gen2 account. Your user account has contributor access to the storage account, and you have the application ID and access key. You plan to use PolyBase to load data into an enterprise data warehouse in Azure Synapse Analytics. You need to configure PolyBase to connect the data warehouse to the storage account. Which three components should you create in sequence? To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order. Select and Place: