DP-200

You have an Azure Cosmos DB database that uses the SQL API. You need to delete stale data from the database automatically. What should you use?A . soft deleteB . Low Latency Analytical Processing (LLAP)C . schema on readD . Time to Live (TTL)View AnswerAnswer: D Explanation: With Time to...

Topic 1, Proseware Inc Background Proseware, Inc, develops and manages a product named Poll Taker. The product is used for delivering public opinion polling and analysis. Polling data comes from a variety of sources, including online surveys, house-to-house interviews, and booths at public events. Polling data Polling data is stored...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: A 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...

DRAG DROP You need to implement the encryption for SALESDB. Which three 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. View AnswerAnswer: Explanation: Data in SALESDB must encrypted by using...

Validate configuration results and deploy the solution Does the solution meet the goal?A . YesB . NoView AnswerAnswer: B 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...

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

HOTSPOT You have an Azure SQL database that contains a table named Employee. Employee contains sensitive data in a decimal (10,2) column named Salary. You need to ensure that nonprivileged users can view the table data, but Salary must display a number from 0 to 100. What should you configure?...

Which windowing function should you use to perform the streaming aggregation of the sales data?A . TumblingB . HoppingC . SlidingD . SessionView AnswerAnswer: A Explanation: Scenario: The analytic process will perform aggregations that must be done continuously, without gaps, and without overlapping. The key differentiators of a Tumbling window...

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