Microsoft DP-300 Übungsprüfungen
Zuletzt aktualisiert am 27.04.2025- Prüfungscode: DP-300
- Prüfungsname: Administering Microsoft Azure SQL Solutions
- Zertifizierungsanbieter: Microsoft
- Zuletzt aktualisiert am: 27.04.2025
You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server
database.
The solution must meet the following requirements:
• Support real-time data replication to a different geographic region.
• Use Azure as a disaster recovery target.
• Minimize costs and administrative effort.
What should you include in the recommendation?
- A . database mirroring on an instance of SQL Server on Azure Virtual Machines
- B . availability groups for SQL Server on Azure Virtual Machines
- C . an Azure SQL Managed Instance link
- D . transactional replication to an Azure SQL Managed Instance
DRAG DROP
You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named Appl. Appl uses db1.
You need to enable Resource Governor for a App1. The solution must meet the following requirements:
App1 must be able to consume all available CPU resources.
App1 must have at least half of the available CPU resources always available.
Which three actions should you perform in sequence? To answer. move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You have an on-premises Microsoft SQL Server 2019 server that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL managed instance named SQLMI1 and a virtual network named VNET1. SQLMI1 resides on VNET1. The on-premises network connects to VNET1 by using an ExpressRoute connection.
You plan to migrate DB1 to SQLMI1 by using Azure Database Migration Service.
You need to configure VNET1 to support the migration.
What should you do?
- A . Configure service endpoints.
- B . Configure virtual network peering.
- C . Deploy an Azure firewall.
- D . Configure network security groups (NSGs).
You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.
You need to ensure that users from each company can view only the data of their respective company.
Which two objects should you include in the solution? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
- A . a column encryption key
- B . asymmetric keys
- C . a function
- D . a custom role-based access control (RBAC) role
- E . a security policy
You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements,
What should you use as the event_file target?
- A . an Azure SQL database
- B . an Azure Blob Storage container
- C . a SQL Server filegroup
- D . an Azure Files share
HOTSPOT
You have an Azure SQL database named D61.
You need to identify how much unused space in megabytes was allocated to DB1.
How should you complete the Transact-SQL query? To answer select the appropriate options m the answer area. NOTE: Each correct selection is worth one point.
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
HOTSPOT
You have an Azure subscription.
You need to deploy a logical SQL server by using PowerShell. The solution must ensure that the logical SQL server can create Azure AD users and provide Transparent Data Encryption (TDE} with a customer-managed key.
How should you complete the command? 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 DB 1 in the General Purpose service tier.
You need to monitor DB 1 by using SQL Insights.
What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
A company plans to use Apache Spark analytics to analyze intrusion detection data.
You need to recommend a solution to analyze network and system activity data for malicious activities and policy violations. The solution must minimize administrative efforts.
What should you recommend?
- A . Azure Data Lake Storage
- B . Azure Databricks
- C . Azure HDInsight
- D . Azure Data Factory