Sample Questions:-
Question : 1
D18912E1457D5D1DDCBD40AB3BF70D5D
You need to identify the cause of the performance issues on SalesSQLDb1.
Which two dynamic management views should you use? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A.sys.dm_pdw_nodes_tran_locks
B.sys.dm_exec_compute_node_errors
C.sys.dm_exec_requests
D.sys.dm_cdc_errors
E.sys.dm_pdw_nodes_os_wait_stats
F.sys.dm_tran_locks
Answer: A,E
Question : 2
D18912E1457D5D1DDCBD40AB3BF70D5D
You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.
What should you run as part of the implementation?
A.CREATE LOGIN and the FROM WINDOWS clause
B.CREATE USER and the FROM CERTIFICATE clause
C.CREATE USER and the FROM LOGIN clause
D.CREATE USER and the ASYMMETRIC KEY clause
E.CREATE USER and the FROM EXTERNAL PROVIDER clause
Answer: E
Question: 3
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 two Azure SQL Database servers named Server1 and Server2. Each server contains an Azure SQL database named Database1.
You need to restore Database1 from Server1 to Server2. The solution must replace the existing Database1 on Server2.
Solution: You run the Remove-AzSqlDatabase PowerShell cmdlet for Database1 on Server2. You run the
Restore-AzSqlDatabase PowerShell cmdlet for Database1 on Server2.
Does this meet the goal?
A.Yes
B.No
Answer: B
Question : 4
You have an Azure SQL Database managed instance named SQLMI1. A Microsoft SQL Server Agent job runs on SQLMI1.
You need to ensure that an automatic email notification is sent once the job completes.
What should you include in the solution?
A.From SQL Server Configuration Manager (SSMS), enable SQL Server Agent
B.From SQL Server Management Studio (SSMS), run sp_set_sqlagent_properties
C.From SQL Server Management Studio (SSMS), create a Database Mail profile
D.From the Azure portal, create an Azure Monitor action group that has an Email/SMS/Push/Voice action
Answer: C
Question : 5
You have an Azure virtual machine based on a custom image named VM1.
VM1 hosts an instance of Microsoft SQL Server 2019 Standard.
You need to automate the maintenance of VM1 to meet the following requirements:
Automate the patching of SQL Server and Windows Server.
Automate full database backups and transaction log backups of the databases on VM1.
Minimize administrative effort.
What should you do first?
A.Enable a system-assigned managed identity for VM1
B.Register VM1 to the Microsoft.Sql resource provider
C.Install an Azure virtual machine Desired State Configuration (DSC) extension on VM1 D18912E1457D5D1DDCBD40AB3BF70D5D
D.Register VM1 to the Microsoft.SqlVirtualMachine resource provider
Answer: B
For More Information:-
Visit Now:-
