- (Exam Topic 5)
You have a burstable Azure virtual machine named VMI that hosts an instance of Microsoft SQL Server. You need to attach an Azure ultra disk to VMI. The solution must minimize downtime on VMI.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
You configure backup for an Azure SQL database as shown in the following exhibit.

Use the drop-down menus to select the answer choice the completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
You have an Azure subscription that contains a storage account named databasebackups. You have an Azure SQL managed instance named DB1.
You need to back up DB1 to databasebackups.
How should you complete the commands? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Solution:


Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A

- (Exam Topic 5)
You have an Azure SQL database named db1 on a server named server1.
The Intelligent Insights diagnostics log identifies queries that cause performance issues due to tempDB contention.
You need to resolve the performance issues. What should you do?

1. A. Implement memory-optimized tables.
2. B. Run thedbcc flushprocindBcommand.
3. C. Replace the sequential index keys with nonsequential keys.
4. D. Run thedbcc dbreindexcommand.

Correct Answer: A
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-performance#tempdb

- (Exam Topic 5)
You have an Azure SQL database.
You run the following PowerShell script.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE:Each correct selection is worth one point.

Solution:
Text Description automatically generated
Reference:
https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackupshorttermretentionpolicy?vi https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackuplongtermretentionpolicy?vie

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A