Which four actions should you perform in sequence?

DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four 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:...

March 17, 2022 No Comments READ MORE +

Which four actions should you perform in sequence?

DRAG DROP You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements. Which four 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:...

March 16, 2022 No Comments READ MORE +

Which service tier should you use during peak usage?

You are planning a solution that will use Azure SQL Database. Usage of the solution will peak from October 1 to January 1 each year. During peak usage, the database will require the following: ✑ 24 cores ✑ 500 GB of storage ✑ 124 GB of memory ✑ More than...

March 16, 2022 No Comments READ MORE +

What should you include in the plan?

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements. What should you include in the plan?A . Configure the Deleted databases settings for ResearchSrvOLB . Deploy and configure an Azure Backup server.C . Configure the Advanced Data...

March 16, 2022 No Comments READ MORE +

What should you recommend?

Topic 1, Litware Existing Environment Network Environment The manufacturing and research datacenters connect to the primary datacenter by using a VPN. The primary datacenter has an ExpressRoute connection that uses both Microsoft peering and private peering. The private peering connects to an Azure virtual network named HubVNet. Identity Environment Litware...

March 16, 2022 No Comments READ MORE +

How should you collect and stream metrics?

HOTSPOT You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements. How should you collect and stream metrics? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Box 1: The server, the elastic...

March 16, 2022 No Comments READ MORE +

What should you do?

You have an Azure SQL database named db1 on a server named server1. You need to modify the MAXDOP settings for db1. What should you do?A . Connect to db1 and run the sp_configure command.B . Connect to the master database of server1 and run the sp_configure command.C . Configure...

March 15, 2022 No Comments READ MORE +

Which windowing function should you use to perform the streaming aggregation of the sales data?

Topic 3, ADatum Corporation 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 that...

March 15, 2022 No Comments READ MORE +

Which Azure Storage functionality should you include in the solution?

Topic 4, Contoso Ltd Clothing Store You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements. Which Azure Storage functionality should you include in the solution?A . time-based retentionB . change feedC . lifecycle managementD . soft...

March 15, 2022 No Comments READ MORE +

What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?

You have an Azure SQL database. You identify a long running query. You need to identify which operation in the query is causing the performance issue. What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?A . Live Query StatisticsB . an estimated...

March 15, 2022 No Comments READ MORE +