Practice Free DP-300 Exam Online Questions
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?
- A . Yes
- B . No
You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases.
You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation.
You need to create the required Automation accounts.
Which two accounts should you create? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . From the Azure Active Directory admin center, create a service principal.
- B . From the Azure Active Directory admin center, create a user-assigned managed identity for SQL1.
- C . On SQL1. create a SQL user in the databases.
- D . On SQL1, create a SQL login.
- E . From the Azure Active Directory admin center, create an external identity.
HOTSPOT
You have an Azure subscription.
You plan to migrate 10 on-premises Microsoft SQL Server instances to Azure.
You need to ensure that the migrated environment can be managed by using multiserver administration and supports master/target (MSX/TSX) jobs. The solution must minimize administrative effort.
Which SQL deployment options should you select as the master server (MSX) and the target server (TSX)? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP
You have SQL Server 2019 on an Azure virtual machine that contains an SSISDB database.
A recent failure causes the master database to be lost.
You discover that all Microsoft SQL Server integration Services (SSIS) packages fail to run on the virtual machine.
Which four actions should you perform in sequence to resolve the issue? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct.
SIMULATION
Task 5
You need to generate an email alert for db1 if the average CPU percentage utilization is greater than 50 percent for five minutes sampled at one-minute intervals. The alert must be sent to [email protected].
You may need to use SQL Server Management Studio and the Azure portal.
HOTSPOT
You have an on-premises Microsoft SQL Server database named DB1.
You have an Azure subscription.
You need to migrate DB1 to an Azure SQL service that meets the following requirements:
• Protects the confidentiality of sensitive data from malware and high-privileged unauthorized database administrators
• Supports pattern matching for server-side database operations
• Uses a hardware-based encryption technology
Which Azure SQL service and attestation service should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure subscription that contains a server named Server1. Server1 hosts two Azure SQL databases named DB1 and DB2.
You plan to deploy a Windows app named App1 that will authenticate to DB2 by using SQL authentication.
You need to ensure that App1 can access DB2.
The solution must meet the following requirements:
✑ App1 must be able to view only DB2.
✑ Administrative effort must be minimized.
What should you create?
- A . a contained database user for App1 on DB2
- B . a login for App1 on Server1
- C . a contained database user from an external provider for App1 on DB2
- D . a contained database user from a Windows login for App1 on DB2
HOTSPOT
You have an Azure subscription that contains an instance of SQL Server on Azure Virtual Machines. The virtual machine hosts a database named DB1. You need to monitor DB1 by using Extended Events.
The solution must meet the following requirements:
• Capture raw event data and store the data in Azure Storage.
• Minimize the performance impact of capturing extended events.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT
You have an Azure SQL database named SQL1.
You need to monitor the resource usage of SQL1 by using a dynamic management view. The solution must return the average memory usage and the peak CPU usage.
How should you complete the query? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have a SQL Server on Azure Virtual Machines instance that contains a mission critical production database named DB1
You have a second SQL Server on Azure Virtual Machines instance located in a different availability zone Both instances are on the same virtual network.
You need to recommend a high-availability and disaster recovery (HADR) solution to protect DB1.
The solution must meet the following requirements:
• Provide the minimal recovery time objective (RTO) and recovery point objective (RPO).
• Minimize application configurations during failover.
What should you include in the recommendation?
- A . Always On availability group
- B . Azure Site Recovery
- C . log shipping
- D . Always On failover cluster instance (FCI)