Question 61

You have SQL Server on an Azure virtual machine that contains a database named DB1.
The database reports a CHECKSUM error.
You need to recover the database.
How should you complete the statements? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Question 62

You have the following Transact-SQL query.

Which column returned by the query represents the free space in each file?
  • Question 63

    Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
    After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
    You have SQL Server 2019 on an Azure virtual machine.
    You are troubleshooting performance issues for a query in a SQL Server instance.
    To gather more information, you query sys.dm_exec_requests and discover that the wait type is PAGELATCH_UP and the wait_resource is 2:3:905856.
    You need to improve system performance.
    Solution: You create additional tempdb files.
    Does this meet the goal?
  • Question 64

    You plan to perform batch processing in Azure Databricks once daily.
    Which type of Databricks cluster should you use?
  • Question 65

    You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1.
    You plan to migrate DB1 to an Azure SQL Database managed instance.
    What should you use to minimize downtime and data loss during the migration?