- (Exam Topic 5)
You have an on-premises datacenter that contains a 2-TB Microsoft SQL Server 2019 database named DB1. You need to recommend a solution to migrate DB1 to an Azure SQL managed instance. The solution must minimize downtime and administrative effort.
What should you include in the recommendation?

1. A. Log Replay Service (LRS)
2. B. log shipping
3. C. transactional replication
4. D. SQL Data Sync

Correct Answer: B

- (Exam Topic 5)
You have an Azure SQL managed instance named SQLMI1 that hosts 10 databases.
You need to implement alerts by using Azure Monitor. The solution must meet the following requirements: Minimize costs.
Aggregate Intelligent Insights telemetry from each database. What should you do?

1. A. From the Diagnostic settings of each database, select Send to Log Analytics.
2. B. From the Diagnostic settings of each database, select Stream to an event hub.
3. C. From the Diagnostic settings of SQLMI1. select Send to Log Analytics.
4. D. From the Diagnostic settings of SQLMI1. select Stream to an event hub.

Correct Answer: A
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/metrics-diagnostic-telemetry-logging-streaming-expo

- (Exam Topic 5)
You need to use an Azure Resource Manager ARM) template to deploy an Azure virtual machine that will host a Microsoft SQL Server instance. The solution must maximize disk I/O performance for the SQL Server database and log files
How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:
Read onlyReadWrite

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
You have an Azure Data Factory pipeline that is triggered hourly. The pipeline has had 100% success for the past seven days.
The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error.

What is a possible cause of the error?

1. A. From 06:00 to 07:00 on January 10, 2021, there was no data in wwi/BIKES/CARBON.
2. B. The parameter used to generate year=2021/month=01/day=10/hour=06 was incorrect.
3. C. From 06:00 to 07:00 on January 10, 2021, the file format of data in wwi/BIKES/CARBON was incorrect.
4. D. The pipeline was triggered too early.

Correct Answer: B

- (Exam Topic 5)
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1. You need to configure SQL! to use mixed mode authentication. Which procedure should you run?

1. A. sp_addremoteIogin
2. B. xp_instance_regwrite
3. C. sp_cnarge_users_login
4. D. xp_grant_login

Correct Answer: B