DP-201

You need to recommend a backup strategy for CONT_SQL1 and CONT_SQL2. What should you recommend?A . Use AzCopy and store the data in Azure.B . Configure Azure SQL Database long-term retention for all databases.C . Configure Accelerated Database Recovery.D . Use DWLoader.View AnswerAnswer: B Explanation: Scenario: The database backups have...

Topic 3, Case study 2 This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure...

HOTSPOT You need to design the Planning Assistance database. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: No Data used for Planning Assistance must be stored in a sharded...

HOTSPOT You need to ensure that security policies for the unauthorized detection system are met. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Blob storage Configure blob storage for audit logs....

HOTSPOT You need to design the SensorData collection. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: Eventual Traffic data insertion rate must be maximized. Sensor data must be stored in a...

Topic 2, Case study 1 This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure...

DRAG DROP You need to design the image processing solution to meet the optimization requirements for image tag data. What should you configure? To answer, drag the appropriate setting to the correct drop targets. Each source may be used once, more than once, or not at all. You may need...

You need to recommend an Azure SQL Database service tier. What should you recommend?A . Business CriticalB . General PurposeC . PremiumD . StandardE . BasicView AnswerAnswer: C Explanation: The data engineers must set the SQL Data Warehouse compute resources to consume 300 DWUs. Note: There are three architectural models...

Topic 1, Trey Research Case study This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to...

You need to optimize storage for CONT_SQL3. What should you recommend?A . AlwaysOnB . Transactional processingC . GeneralD . Data warehousingView AnswerAnswer: B Explanation: CONT_SQL3 with the SQL Server role, 100 GB database size, Hyper-VM to be migrated to Azure VM. The storage should be configured to optimized storage for...