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
HOTSPOT
You have an Azure data factory that has two pipelines named PipelineA and PipelineB.
PipelineA has four activities as shown in the following exhibit.
PipelineB has two activities as shown in the following exhibit.
You create an alert for the data factory that uses Failed pipeline runs metrics for both pipelines and all failure types.
The metric has the following settings:
✑ Operator: Greater than
✑ Aggregation type: Total
✑ Threshold value: 2
✑ Aggregation granularity (Period): 5 minutes
✑ Frequency of evaluation: Every 5 minutes
Data Factory monitoring records the failures shown in the following table.
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 deploy an instance of SQL Server on Azure Virtual Machines named SQL1 that hosts multiple databases.
You configure the full recovery model for all the databases.
You perform a full backup of the master database on SQL1.
You need to a perform an additional backup of the master database on SQL1. The solution must minimize how long it takes to perform the backup.
Which type of backup should you perform?
- A . tail-log
- B . differential
- C . full
- D . log
You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative effort.
What should you include in the recommendation?
- A . Azure SQL Managed instance
- B . Azure SQL Database single database
- C . Azure Database for PostgreSQL
- D . SQL Server on Azure virtual machines
You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative effort.
What should you include in the recommendation?
- A . Azure SQL Managed instance
- B . Azure SQL Database single database
- C . Azure Database for PostgreSQL
- D . SQL Server on Azure virtual machines
You need to recommend a solution to ensure that the customers can create the database objects.
The solution must meet the business goals.
What should you include in the recommendation?
- A . For each customer, grant the customer ddl_admin to the existing schema.
- B . For each customer, create an additional schema and grant the customer ddl_admin to the new schema.
- C . For each customer, create an additional schema and grant the customer db_writerto the new schema.
- D . For each customer, grant the customer db_writerto the existing schema.
You have an Azure subscription.
You need to deploy a new Azure SQL database by using Azure Command-Line Interface (CLI).
Which three parameters are required?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email.
You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of [email protected] instead.
What should you do?
- A . From the Azure portal, set a mask on the Email column.
- B . From the Azure portal, set a sensitivity classification of Confidential for the Email column.
- C . From Microsoft SQL Server Management Studio, set an email mask on the Email column.
- D . From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.
HOTSPOT
You have a SQL Server on Azure Virtual Machines instance that hosts a 10-TB SQL database named DB1.
You need to identify and repair any physical or logical corruption in DB1.
The solution must meet the following requirements:
• Minimize how long it takes to complete the procedure.
• Minimize data loss.
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 a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You have an Azure subscription.
You plan to deploy an instance of SQL Server on Azure Virtual Machines by using an Azure Marketplace image
You need to register the SQL Server laaS Agent extension (SqllaasExtension).
The solution must meet the following requirements:
• Install critical updates for SQL Server automatically.
• Minimize performance impact on the virtual machine.
Which management mode should you select?
- A . full
- B . lightweight
- C . NoAgent