Administering Relational Databases on Microsoft Azure Exam (DP-300) - Microsoft Exam Questions

You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines HOTSPOT named SQLVM1 and a user named User1. SQLVM1 hosts a database named DB1.

You need to ensure that User1 can perform the following tasks on DB1:

• Modify, delete, and disable the jobs the user created.

• Create jobs.

• View all jobs.
The solution must use the principle of least privilege. Which built-in database role should you assign to User1, and where is the role defined? To answer,
select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

You have the following Azure Resource Manager template. HOTSPOT



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

NOTE: Each correct selection is worth one point.

You need to migrate an on-premises Microsoft SQL Server database to Azure SQL Database. The solution must minimize downtime.

What should you do?

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?

You have an Azure subscription that contains 20 Azure SQL databases. You create a Transact-SQL statement to perform index maintenance on a database. You need to schedule the statement to run once daily against each database by using Transact-SQL commands.

What should you use to schedule the statement?