Microsoft DP-300 Übungsprüfungen
Zuletzt aktualisiert am 05.06.2025- Prüfungscode: DP-300
- Prüfungsname: Administering Microsoft Azure SQL Solutions
- Zertifizierungsanbieter: Microsoft
- Zuletzt aktualisiert am: 05.06.2025
HOTSPOT
Vou have an Azure SQL database named DB1.
You have 10 Azure virtual machines that connect to a virtual network subnet named Subnet 1.
You need to implement a database-level firewall that meets the following requirements:
• Ensures that only the 10 virtual machines can access DB1
• Follows the principle of least privilege
How should you configure the firewall rule, and how should you establish network connectivity from the virtual machines to DB1? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You plan to move two 100-GB databases to Azure.
You need to dynamically scale resources consumption based on workloads. The solution must minimize
downtime during scaling operations.
What should you use?
- A . An Azure SQL Database elastic pool
- B . SQL Server on Azure virtual machines
- C . an Azure SQL Database managed instance
- D . Azure SQL databases
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
You have an Azure Synapse Analytics workspace named WS1 that contains an Apache Spark pool named Pool1.
You plan to create a database named DB1 in Pool1.
You need to ensure that when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool.
Which format should you use for the tables in DB1?
- A . JSON
- B . CSV
- C . Parquet
- D . ORC
You have 50 Azure SQL databases.
You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure.
What should you do?
- A . Create a diagnostic setting for the activity log that has the Security log enabled.
- B . For the database, create a diagnostic setting that has the InstanceAndAppAdvanced metric enabled.
- C . Create an alert rule that uses a Metric signal type.
- D . Create an alert rule that uses an Activity Log signal type.
You have an Azure subscription that contains the resources shown in the following table.
App1 experiences transient connection errors and timeouts when it attempts to access db1 after extended periods of inactivity. You need to modify db1 to resolve the issues experienced by App1 as soon as possible, without considering immediate costs.
What should you do?
- A . Increase the number Of vCores allocated to db1.
- B . Disable auto-pause delay for dbl.
- C . Decrease the auto-pause delay for db1.
- D . Enable automatic tuning for db1.
You have an Azure SQL Database server named sqlsrv1 that hosts 10 Azure SQL databases.
The databases perform slower than expected.
You need to identify whether the performance issue relates to the use of tempdb on sqlsrv1.
What should you do?
- A . Run Query Store-based queries
- B . Review information provided by SQL Server Profiler-based traces
- C . Review information provided by Query Performance Insight
- D . Run dynamic management view-based queries
You Save an Azure SCX database named DB1.
You need to query the fragmentation information of data and indexes for the tables in D61.
Which command should you run?
A)
B)
C)
D)
- A . Option A
- B . Option B
- C . Option C
- D . Option D
SIMULATION
Task 8
You plan to perform performance testing of db1.
You need prevent db1 from reverting to the last known good query plan.
You have an Azure SQL managed instance named MI1.
You need to implement automatic tuning for the databases of MI1.
What should you do?
- A . Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property.
- B . Use Transact-SQL to enable the force_last_good_plan option.
- C . From the Azure portal, configure automatic tuning.