Which three actions should you perform in sequence?

DRAG DROP You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements. 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...

March 9, 2022 No Comments READ MORE +

Topic 2, Contoso Ltd

Topic 2, Contoso Ltd 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...

March 9, 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 8, 2022 No Comments READ MORE +

What should you include in the migration plan?

HOTSPOT You are planning the migration of the SERVER1 databases. The solution must meet the business requirements. What should you include in the migration plan? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. View AnswerAnswer: Explanation: Azure Database Migration service...

March 8, 2022 No Comments READ MORE +

What should you do first?

You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. DF1 contains a linked service. You have an Azure Key vault named vault1 that contains an encryption kay named key1. You need to encrypt df1 by using key1. What should you do...

March 8, 2022 No Comments READ MORE +

Which two dynamic management views should you use?

You need to identify the cause of the performance issues on SalesSQLDb1. Which two dynamic management views should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.A . sys.dm_pdw_nodes_tran_locksB . sys.dm_exec_compute_node_errorsC . sys.dm_exec_requestsD . sys.dm_cdc_errorsE . sys.dm_pdw_nodes_os_wait_statsF . sys.dm_tran_locksView AnswerAnswer: A,E...

March 8, 2022 No Comments READ MORE +

Which counter should you monitor for real-time processing to meet the technical requirements?

Which counter should you monitor for real-time processing to meet the technical requirements?A . SU% UtilizationB . CPU% utilizationC . Concurrent usersD . Data Conversion ErrorsView AnswerAnswer: B Explanation: Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns. To monitor the...

March 8, 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 7, 2022 No Comments READ MORE +

Which three metrics should you use to size the elastic pool to meet the demands of your workload?

You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents...

March 7, 2022 No Comments READ MORE +

How should you configure the backup of DB1?

HOTSPOT You have an on-premises Microsoft SQL Server 2016 server named Server1 that contains a database named DB1. You need to perform an online migration of DB1 to an Azure SQL Database managed instance by using Azure Database Migration Service. How should you configure the backup of DB1? To answer,...

March 6, 2022 No Comments READ MORE +