DP-200 exam

Topic 5, Misc Questions CORRECT TEXT 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 need to double the available processing resources available to an Azure SQL data warehouse named datawarehouse. To complete...

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. View AnswerAnswer: Explanation: Box 1: Azure Active Directory user Scenario: Access to polling data must...

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...

DRAG DROP You need to set up access to Azure SQL Database for Tier 7 and Tier 8 partners. Which three actions should you perform in sequence? To answer, move the appropriate three actions from the list of actions to the answer area and arrange them in the correct order....

HOTSPOT You need to mask tier 1 data. Which functions should you use? To answer, select the appropriate option in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: A: Default Full masking according to the data types of the designated fields. For string data...

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. View AnswerAnswer: Explanation: Box 1: Azure Active Directory user Scenario: Access to polling data must...

What should you implement to optimize SQL Database for Race Central to meet the technical requirements?A . the sp_update stored procedureB . automatic tuningC . Query StoreD . the dbcc checkdb commandView AnswerAnswer: A Explanation: Scenario: The query performance of Race Central must be stable, and the administrative time it...

What should you include in the Data Factory pipeline for Race Central?A . a copy activity that uses a stored procedure as a sourceB . a copy activity that contains schema mappingsC . a delete activity that has logging enabledD . a filter activity that has a conditionView AnswerAnswer: B...

CORRECT TEXT 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...

DRAG DROP You need to provision the polling data storage account. How should you configure the storage account? To answer, drag the appropriate Configuration Value to the correct Setting. Each Configuration Value may be used once, more than once, or not at all. You may need to drag the split...