DP-200 Exam Question 236

Use the following login credentials as needed:
Azure Username: xxxxx
Azure Password: xxxxx
The following information is for technical support purposes only:
Lab Instance: 10543936

You plan to enable Azure Multi-Factor Authentication (MFA).
You need to ensure that [email protected] can manage any databases hosted on an Azure SQL server named SQL10543936 by signing in using his Azure Active Directory (Azure AD) user account.
To complete this task, sign in to the Azure portal.

DP-200 Exam Question 237

You have an Azure data solution that contains an Azure SQL data warehouse named DW1.
Several users execute adhoc queries to DW1 concurrently.
You regularly perform automated data loads to DW1.
You need to ensure that the automated data loads have enough memory available to complete quickly and successfully when the adhoc queries run What should you do?
  • DP-200 Exam Question 238

    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 to configure data encryption for external applications.
    Solution:
    1. Access the Always Encrypted Wizard in SQL Server Management Studio
    2. Select the column to be encrypted
    3. Set the encryption type to Randomized
    4. Configure the master key to use the Windows Certificate Store
    5. Validate configuration results and deploy the solution
    Does the solution meet the goal?
  • DP-200 Exam Question 239

    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 have an Azure Storage account that contains 100 GB of files. The files contain text and numerical values. 75% of the rows contain description data that has an average length of 1.1 MB.
    You plan to copy the data from the storage account to an enterprise data warehouse in Azure Synapse Analytics.
    You need to prepare the files to ensure that the data copies quickly.
    Solution: You convert the files to compressed delimited text files.
    Does this meet the goal?
  • DP-200 Exam Question 240

    You develop data engineering solutions for a company. An application creates a database on Microsoft Azure.
    You have the following code:
    Which database and authorization types are used? To answer, select the appropriate option in the answer area.
    NOTE: Each correct selection is worth one point.