- (Exam Topic 5)
You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.
What should you use?

Correct Answer:C

- (Exam Topic 5)
You have a SQL Server on Azure Virtual Machines instance named VM1 . You run the following query.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

Solution:


Does this meet the goal?

Correct Answer:A

- (Exam Topic 5)
You have an Azure Databricks workspace named workspace1 in the Standard pricing tier. Workspace1 contains an all-purpose cluster named cluster1.
You need to reduce the time it takes for cluster1 to start and scale up. The solution must minimize costs. What should you do first?

Correct Answer:C
You can use Databricks Pools to Speed up your Data Pipelines and Scale Clusters Quickly.
Databricks Pools, a managed cache of virtual machine instances that enables clusters to start and scale 4 times faster.
Reference:
https://databricks.com/blog/2019/11/11/databricks-pools-speed-up-data-pipelines.html

- (Exam Topic 5)
You have a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area.
NOTE:Each correct selection is worth one point.

Solution:
Table Description automatically generated with low confidence
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-ser

Does this meet the goal?

Correct Answer:A

- (Exam Topic 5)
You have an Azure SQL managed instance.
You need to restore a database named DB1 by using Transact-SQL.
Which command should you run? To answer, select the appropriate options in the answer area.
NOTE:Each correct selection is worth one point.

Solution:
Text Description automatically generated

Does this meet the goal?

Correct Answer:A

- (Exam Topic 5)
You have an Azure subscription.
You need to deploy an Azure SQL database. The solution must meet the following requirements:
• Dynamically scale CPU resources.
• Ensure that the database can be paused to reduce costs. What should you use?

Correct Answer:B