Microsoft DP-300 Übungsprüfungen
Zuletzt aktualisiert am 31.05.2025- Prüfungscode: DP-300
- Prüfungsname: Administering Microsoft Azure SQL Solutions
- Zertifizierungsanbieter: Microsoft
- Zuletzt aktualisiert am: 31.05.2025
You plan to perform batch processing in Azure Databricks once daily.
Which type of Databricks cluster should you use?
- A . automated
- B . interactive
- C . High Concurrency
You have an Azure subscription that contain an Azure SQL managed instance named SQLMI1 and a Log Analytics workspace named Workspace1.
You need to collect performance metrics for SQLMI1 and stream the metrics to Workspace1.
- A . Create the private endpoint connection on SQLMI1.
- B . Configure Azure SQL Analytics to use Workspace1.
- C . Modify the Computer + storage settings for SQLMI1.
- D . Modify the diagnostic settings for SQLMI1.
You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.
What should you recommend?
- A . Configure virtual network service endpoints.
- B . Enable database firewall rules.
- C . Create database-scoped credentials.
- D . Configure connection strings that reference the read-write listener.
HOTSPOT
You have an Azure subscription.
You need to deploy a logical SQL server by using an Azure Resource Manager (ARM) template. The solution must ensure that the server will allow inbound connectivity from any Azure resource.
How should you complete the template? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are monitoring an Azure Stream Analytics job.
You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero.
You need to ensure that the job can handle all the events.
What should you do?
- A . Remove any named consumer groups from the connection and use $default.
- B . Change the compatibility level of the Stream Analytics job.
- C . Create an additional output stream for the existing input stream.
- D . Increase the number of streaming units (SUs).
HOTSPOT
You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.
You execute the Transact-SQL query shown in the following exhibit.
Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
DRAG DROP
You create all of the tables and views for ResearchDB1.
You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements.
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.
DRAG DROP
You create all of the tables and views for ResearchDB1.
You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements.
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.
You have four Azure subscriptions. Each subscription contains multiple Azure SQL databases.
You need to update the column and index statistics for the databases.
What should you use?
- A . an Azure Automation runbook
- B . a SQL Agent job
- C . Azure SQL Analytics
- D . automatic tuning in Azure SQL Database
What should you implement to meet the disaster recovery requirements for the PaaS solution?
- A . Availability Zones
- B . failover groups
- C . Always On availability groups
- D . geo-replication