2025/November Latest Braindump2go DP-300 Exam Dumps with PDF and VCE Free Updated Today! Following are some new Braindump2go DP-300 Real Exam Questions!
QUESTION 205
You are training a new administrator for your company’s Azure data services, which includes database deployed on Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure virtual machines (VMs).
You need to identify the fixed roles that are supported by Azure SQL Database only.
Which two fixed roles are available with Azure SQL Database only?
Each correct answer presents a complete solution.
A. db_securityadmin
B. sysadmin
C. dbmanager
D. dbcreator
E. loginmanager
Answer: CE
QUESTION 206
You provision an Azure SQL Managed Instance database named MyDevData. The database will be used by in-house development for application development projects.
DevSupport custom database role members will use dynamic management views (DMVs) to retrieve performance and health information about MyDevData.
You need to ensure that DevSupport members can view information through DMVs.
Which statement should you use?
Each correct answer presents part of the solution.
A. GRANT VIEW DATABASE STATE TO DevSupport
B. GRANT VIEW SERVER STATE TO DevSupport
C. GRANT VIEW DEFINITION TO DevSupport
D. GRANT VIEW REFERENCES TO DevSupport
Answer: A
QUESTION 207
MyDB1 is an Azure SQL on Azure virtual machine (VM) database.
You identify a long-running query.
You want to determine where the operation in the query is causing performance problems.
You need to use SQL Server Management Studio (SSMS) to view the execution plan based on runtime information so you can try query variations in real time.
What should you use?
A. Analyze an actual execution plan.
B. Display an actual execution plan.
C. Display an estimated execution plan.
D. Compare execution plans.
Answer: B
QUESTION 208
Your company has an Azure SQL database named lead2passdb. This is on an Azure SQL Server called whizlabserver1000. You have to create a contained database user in the database based on an Azure AD user.
Which of the following would you execute for this requirement? (Choose 3 answers)
A. Connect to the database by using the Active Directory account admin account
B. Create a user by using the FROM EXTERNAL PROVIDER clause
C. Connect to the database by using a server administrator account
D. Set the Active Directory Admin for the Azure SQL Server
E. From the Azure portal, assign the SQL DB Contributor role to the user
Answer: ABD
Explanation:
First, you need to set the Active Directory Admin for the Azure SQL Server.
The next step is to connect to the database with the Active Directory account admin account.
And then finally create the contained database user by using the FROM EXTERNAL PROVIDER clause
Option C is incorrect because you need to connect to the database using the Active Directory account admin account
Option E is incorrect because you don’t need to assign any RBAC role to the user
https://docs.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure?tabs=azure-powershell
QUESTION 209
Your company has an on-premises instance of Microsoft SQL Server. This instance contains a database that has a 5 TiB data file. The database requires 10,000 IOPS.
You have to port the database onto Azure. You create a virtual machine. You then allocate two 1 TiB, P30 Premium storage disks to the virtual machine. Each disk provides 5,000 IOPS. You have to ensure the storage is configured to support the migrated database.
Which of the following would you implement for this requirement? (Choose 3 answers)
A. Create a virtual disk that uses the stripe layout
B. Create a virtual disk that uses mirror layout
C. Create a volume
D. Create a storage pool
Answer: ACD
Explanation:
First, you need to create a storage pool.
This can be used to host multiple disks together. Now create a virtual disk based on the stripe layout.
Then create a volume from the virtual disk.
Option B is incorrect because it is normally used to mirror data from one disk onto another.
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices
QUESTION 210
Your company has an Azure SQL database named lead2passdb. Below are the configuration settings set for the database for automatic tuning.
Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You now have to scale up the virtual machine to 16 vCPUs and 64 GB of memory.
You have to provide the lowest latency for the tempdb database.
You decide to create 2 data files for tempdb
Would this fulfill the requirement?
A. Yes
B. No
Answer: B
Explanation:
As per the Microsoft documentation, you should have 1 file per vCore for TempDB with a limit of 8 files.
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices
QUESTION 211
Your company has a SQL Server 2019 instance hosted on an Azure virtual machine. The machine runs Windows Server 2019. The virtual machine has 4 vCPUs and 28 GB of memory. You now have to scale up the virtual machine to 16 vCPUs and 64 GB of memory.
You have to provide the lowest latency for the tempdb database.
You decide to create 4 data files for tempdb
Would this fulfill the requirement?
A. Yes
B. No
Answer: B
Explanation:
As per the Microsoft documentation, you should have 1 file per vCore for TempDB with a limit of 8 files.
https://docs.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/performance-guidelines-best-practices
QUESTION 212
You have an Azure Database for MySQL database. You have to identify which database queries are consuming the most resources.
Which of the following tool can be used for this requirement?
A. Query Store
B. Metrics
C. Query Performance Insight
D. Alerts
Answer: A
Explanation:
The Query Store feature in Azure Database for MySQL provides a way to track query performance over time. Query Store simplifies performance troubleshooting by helping you quickly find the longest running and most resource-intensive queries. Query Store automatically captures a history of queries and runtime statistics, and it retains them for your review. It separates data by time windows so that you can see database usage patterns. Data for all users, databases, and queries is stored in the mysql schema database in the Azure Database for MySQL instance.
Reference:
https://docs.microsoft.com/en-us/azure/mysql/concepts-query-store
QUESTION 213
You have an Azure SQL database.
You need to identify a long-running query. Here you need to identify which operation in the question is causing a performance issue.
Which of the following can be used to display the query execution plan in Microsoft SQL Server Management Studio?
A. Live Query Statistics
B. An estimated execution plan
C. An actual execution plan
D. Client Statistics
Answer: A
Explanation:
With Live Query statistics, you get real-time information and insights on the queries as they are running. This allows you to debugging query performance issues, such as long-running queries, and queries that run indefinitely and never finish.
Option B is incorrect since this will only give you what could be the plan that is going to be used
Option C is incorrect since this will not give live statistics that can show which query is causing an issue
Option D is incorrect since this will not give the server stats that will show the performance of the queries
https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-profiling-infrastructure?view=sql-server-ver15
QUESTION 214
Your company has an Azure SQL database named lead2passdb.
You have to implement disaster recovery for the database. Below are the key requirements:
– During normal operations, there should be at least two readable copies of the database
– The lead2passdb database needs to be available even if a datacenter fails
You decide to deploy an Azure SQL database that uses the Business-Critical service tier and availability zones.
Would this fulfil the requirement?
A. Yes
B. No
Answer: A
Explanation:
As shown below, you already get options for enabling read scale-out for read only database copies and zone redundancy. When it comes to the Business-Critical service tier.
https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla#general-purpose-service-tier-zone-redundant-availability-preview
QUESTION 215
Your company has an Azure SQL Database instance. This database is going to be added to a failover group. It has to be ensured that the database becomes available as quickly as possible if a major outage occurs. The Read/Write failover policy is set to Automatic.
Which of the following can occur as a result of this configuration? (Select TWO)
A. If a dataceter or Azure regional outage does occur , then the databases can fail over automatically.
B. If an outage does occur , then the databases in the primary instance can fail over immediately.
C. If an outage does occur, you can selectively failover databases
D. If an outage does occur, you can set a different grace period to fail over each database.
Answer: AD
Explanation:
If you set the Read/Write failover policy as Automatic, in the event of a datacenter or Azure regional outage, the databases will failover automatically.
For Automatic failover, you can also set the Read/Write grace period as shown below.
Option B is incorrect because this is based on a dataceter or Azure regional outage
Option C is incorrect since the policy is set as Automatic, so the databases can’t be failed over manually.
https://docs.microsoft.com/en-us/azure/azure-sql/database/auto-failover-group-overview?tabs=azure-powershell
QUESTION 216
Your company wants to create an Azure SQL Database. The database will contain a table that would have Employee information. There are columns which contain sensitive information. You have to enabled Always Encryption for the data stored in the Employee table.
Which of the following could be used to store the encryption keys required for enabling Always Encrypted for the table?
A. Windows certificate store
B. Private Encryption keys
C. Public Encryption keys
D. Azure Key vault
Answer: AD
Explanation:
The Encryption keys can only be stored in either Azure Key vault or the windows certificate store.
From the implementation shown below, you can see that these are the sources you can use for storing the encryption keys.
https://docs.microsoft.com/en-us/azure/azure-sql/database/always-encrypted-azure-key-vault-configure?tabs=azure-powershell
QUESTION 217
You have an instance of SQL Server on Azure Virtual Machine named SQL1.
You need to monitor SQL1 and query the metrics by using Kusto query language.
The solution must minimize administrative effort.
Where should you store the metrics?
A. a Log Analytics workspace
B. Azure Event Hubs
C. Azure SQL Database
D. an Azure Blob storage container
Answer: A
Explanation:
Kusto language is used in Log Analytics.
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-query-overview
QUESTION 218
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.
Answer: B
Explanation:
For Azure SQL Managed Instance, the supported option FORCE_LAST_GOOD_PLAN can only be configured through T-SQL. The Azure portal based configuration and automatic index tuning options described in this article do not apply to Azure SQL Managed Instance.
https://learn.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable?view=azuresql
QUESTION 219
You have an Azure subscription that contains a logical SQL server named Server1.
The master database of Server1 contains a user named User1.
You need to ensure that User1 can create databases on Server1.
Which database role should you assign to User1?
A. db_owner
B. dbmanager
C. dbo
D. db_ddladmin
Answer: B
Explanation:
dbmanager: Can create and delete databases. A member of the dbmanager role that creates a database, becomes the owner of that database, which allows that user to connect to that database as the dbo user. The dbo user has all database permissions in the database. Members of the dbmanager role don’t necessarily have permission to access databases that they don’t own.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles
QUESTION 220
You have a on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance.
The solution must minimize downtime and prevent data loss.
What should you use?
A. log shipping
B. Always On availability groups
C. Database Migration Assistant
D. Backup and Restore
Answer: D
Explanation:
DMA does not support database migrations to Azure SQL Managed Instance. Recommendation is to use the Azure SQL migration extension for Azure Data Studio, which supports both online and offline database migrations to Azure SQL Managed Instance, but here we don´t have the option “Azure SQL migration extension for Azure Data Studio”.
https://learn.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver16#capabilities
Regarding log shipping to Managed Instance is not possible; it only supports the restore of full backups.
https://dba.stackexchange.com/questions/232332/is-it-possible-to-log-ship-from-on-premise-sql-server-to-azure-sql-managed-insta
https://docs.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql-server-to-managed-instance-guide
QUESTION 221
You have an Azure subscription that contains the resources shown in the following table.
You need to configure a connection between VM1 and MI1. The solution must meet the following requirements:
– The connection must be encrypted.
– Network latency must be minimized.
What should you implement?
A. virtual network peering
B. private endpoints
C. service endpoints
D. a site-to-site VPN
Answer: B
Explanation:
https://learn.microsoft.com/en-us/azure/private-link/private-endpoint-overview
QUESTION 222
You have an Azure SQL database named DB1 that contains a private certificate named Sales. The private key for Sales is encrypted with a password.
You need to change the password for the private key.
Which Transact-SQL statement should you run?
A. ALTER CERTIFICATE Sales
WITH PRIVATE KEY (DECRYPTION BY PASSWORD = ‘ EWYx9Xk+$#’);
B. ALTER CERTIFICATE Sales
WITH PRIVATE KEY (ENCRYPTION BY PASSWORD = ‘ 6YY9YcD!pV’);
C. ALTER CERTIFICATE Sales
WITH PRIVATE KEY (DECRYPTION BY PASSWORD = ‘Mb^68K&*w%’),
ENCRYPTION BY PASSWORD = ‘ 6YY9YcD!pV’);
D. ALTER CERTIFICATE Sales
WITH PRIVATE KEY (FILE = ‘D:\importkeys\SalesNew,
(DECRYPTION BY PASSWORD = ‘ Mb^68K&*w%’);
Answer: C
Explanation:
Azure SQL database ALTER CERTIFICATE changes the password used to encrypt the private key of a certificate, removes the private key, or imports the private key if none is present.
Example, changing the password that is used to encrypt the private key:
ALTER CERTIFICATE Shipping11 –
WITH PRIVATE KEY (DECRYPTION BY PASSWORD = ’95hkjdskghFDGGG4%’,
ENCRYPTION BY PASSWORD = ‘34958tosdgfkh##38’);
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/statements/alter-certificate-transact-sql
QUESTION 223
Your on-premises network contains a Microsoft SQL Server 2016 server that hosts a database named db1.
You have an Azure subscription.
You plan to migrate db1 to an Azure SQL managed instance.
You need to create the SQL managed instance. The solution must minimize the disk latency of the instance.
Which service tier should you use?
A. Hyperscale
B. General Purpose
C. Premium
D. Business Critical
Answer: D
Explanation:
General purpose has disk latency, Business critical puts the logs on SSD, Premium is a DTU offering which is not supported on Azure SQL MI, Hyperscale is not on Managed Instance.
QUESTION 224
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 db1.
C. Decrease the auto-pause delay for db1.
D. Enable automatic tuning for db1.
Answer: B
Explanation:
https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview?view=azuresql#auto-pausing-and-auto-resuming
QUESTION 225
You have an Azure subscription that contains an Azure SQL database named SQL1.
SQL1 is in an Azure region that does not support availability zones.
You need to ensure that you have a secondary replica of SQLI in the same region.
What should you use?
A. log shipping
B. auto-failover groups
C. active geo-replication
D. Microsoft SQL Server failover clusters
Answer: C
Explanation:
Active geo-replication is a feature that lets you create a continuously synchronized readable secondary database for a primary database. The readable secondary database may be in the same Azure region as the primary, or, more commonly, in a different region. This kind of readable secondary database is also known as a geo-secondary or geo-replica.
https://learn.microsoft.com/en-us/azure/azure-sql/database/active-geo-replication-overview?source=recommendations&view=azuresql
QUESTION 226
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVM1. SQLVM1 has the following configurations:
– Automated patching is enabled.
– The SQL Server IaaS Agent extension is installed.
– The Microsoft SQL Server instance on SQLVM1 is managed by using the Azure portal.
You need to automate the deployment of cumulative updates to SQLVM1 by using Azure Update Manager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed by using the Azure portal.
What should you do first on SQLVM1?
A. Install the Azure Monitor Agent.
B. Uninstall the SQL Server IaaS Agent extension.
C. Install the Log Analytics agent.
D. Set Automated patching to Disable.
Answer: D
Explanation:
https://learn.microsoft.com/en-us/azure/azure-sql/virtual-machines/windows/automated-patching?view=azuresql
Choose only one option to automatically update your VM as overlapping tools may lead to failed updates.
QUESTION 227
Hotspot Question
You have a database on a SQL Server on Azure Virtual Machines instance. The current state of Query Store for the database is 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.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
The first answer is “none of the” because the Operation Mode (actual) is “Read only” so it is not retaining any query for evaluation due to the Query Store Available is 0.0 MB.
When the actual state is read-only, use the readonly_reason column to determine the root cause. Typically, you find that Query Store transitioned to read-only mode because the size quota was exceeded. In that case, the readonly_reason is set to 65536
Consider the following steps to switch Query Store to read-write mode and activate data collection:
* Increase the maximum storage size by using the MAX_STORAGE_SIZE_MB option of ALTER DATABASE
or
* Clean up Query Store data
https://learn.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-ver16#Verify
QUESTION 228
Hotspot Question
You have a SQL Server on Azure Virtual Machines instance named VM1 that hosts a database named DB1.
You run the following query.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Box 1: No
A copy-only log backup preserves the existing log archive point and, therefore, does not affect the sequencing of regular log backups.
Box 2: No
Box 3: Yes
If the database is online and you plan to perform a restore operation on the database, begin by backing up the tail of the log. To avoid an error for an online database, you must use the … WITH NORECOVERY option of the BACKUP Transact-SQL statement.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/tail-log-backups-sql-server
https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/copy-only-backups-sql-server
QUESTION 229
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVM1 hosts a database named DB1.
You need to retrieve query plans from the Query Store on DB1.
What should you do first?
A. On SQLVM1, install the SQL Server laaS Agent extension.
B. From Microsoft SQL Server Management Studio, modify the properties of the SQL Server instance.
C. From Microsoft SQL Server Management Studio, modify the properties of DB1.
D. On SQLVM1, install the Azure Monitor agent for Windows.
Answer: C
Explanation:
Enable the Query Store
Use the Query Store page in SQL Server Management Studio
1. In Object Explorer, right-click a database, and then select Properties.
2. In the Database Properties dialog box, select the Query Store page.
3. In the Operation Mode (Requested) box, select Read Write.
Reference:
https://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store
QUESTION 230
Drag and Drop Question
You have an Azure subscription.
You plan to deploy a new Azure virtual machine that will host a Microsoft SQL Server instance.
You need to configure the disks on the virtual machine. The solution must meet the following requirements:
– Minimize latency for transaction logs.
– Minimize the impact on IO Of the virtual machine.
Which type of disk should you use for each workload? To answer. drag the appropriate disk types to the correct workloads. Each disk type may be used once, at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Answer:
QUESTION 231
You have 25 Azure SQL databases.
You need to implement a centralized database management solution that uses Transact-SQL.
What should you include in the solution?
A. elastic jobs
B. an Azure Automation runbook
C. Azure Functions
D. Azure Logic Apps
Answer: A
Explanation:
Elastic jobs provide the ability to run one or more T-SQL scripts in parallel, across a large number of databases, on a schedule or on-demand. The target can be any tier of Azure SQL Database.
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/elastic-jobs-overview
QUESTION 232
Hotspot Question
You have an Azure SQL database named DB1 that contains a table named Table1.
You run a query to load data into Table1.
The performance metrics of Table1 during the load operation are 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.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
You are loading data into Table1, which means there is some inserts going on. Note that insert statements is also considered a query. It should be scale resource in order to reduce the time insert data into Table1.
QUESTION 233
Drag and Drop Question
You have an Azure subscription that contains an Azure SQL database named SQLDb1. SQLDb1 contains a table named Table1.
You plan to deploy an Azure web app named webapp1 that will export the rows in Table1 that have changed.
You need to ensure that webapp1 can identify the changes to Table1. The solution must meet the following requirements:
– Minimize compute times.
– Minimize storage.
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.
Answer:
Explanation:
https://learn.microsoft.com/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server?view=sql-server-ver16
To track changes, change tracking must first be enabled for the database and then enabled for the tables that you want to track within that database. The table definition does not have to be changed in any way, and no triggers are created.
QUESTION 234
Hotspot Question
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.
Answer:
Explanation:
Box 1: REPAIR_REBUILD
Performs repairs that have no possibility of data loss. This option may include quick repairs, such as repairing missing rows in nonclustered indexes, and more time-consuming repairs, such as rebuilding an index.
Box 2: PHYSICAL_ONLY
Limits the checking to the integrity of the physical structure of the page and record headers and the allocation consistency of the database. This check is designed to provide a small overhead check of the physical consistency of the database, but it can also detect torn pages, checksum failures, and common hardware failures that can compromise a user’s data.
Incorrect:
TABLOCK
Causes DBCC CHECKDB to obtain locks instead of using an internal database snapshot. This includes a short-term exclusive (X) lock on the database.
TABLOCK will cause DBCC CHECKDB to run faster on a database under heavy load, but will decrease the concurrency available on the database while DBCC
CHECKDB is running.
EXTENDED_LOGICAL_CHECKS
If the compatibility level is 100 ( SQL Server 2008) or higher, performs logical consistency checks on an indexed view, XML indexes, and spatial indexes, where present.
Reference:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql
QUESTION 235
Hotspot Question
You have an Azure SQL database named DB1.
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 in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Box 1: 128.0
— Connect to database
— Database data space allocated in MB and database data space allocated unused in MB
SELECT SUM(size/128.0) AS DatabaseDataSpaceAllocatedInMB,
SUM(size/128.0 – CAST(FILEPROPERTY(name, ‘SpaceUsed’) AS int)/128.0) AS DatabaseDataSpaceAllocatedUnusedInMB
FROM sys.database_files
GROUP BY type_desc
HAVING type_desc = ‘ROWS’
Box 2: sys.database_files
Reference:
https://techcommunity.microsoft.com/t5/azure-database-support-blog/how-to-get-azure-sql-database-size/ba-p/369189
QUESTION 236
Hotspot Question
You have an Azure SQL database.
You need to identify whether a delayed query execution is associated to a RESOURCE_SEMAPHORE wait.
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.
Answer:
Explanation:
Box 1: wait_type
Determine if a RESOURCE_SEMAHPORE wait is a top wait
Use the following query to determine if a RESOURCE_SEMAHPORE wait is a top wait
SELECT wait_type,
SUM(wait_time) AS total_wait_time_ms
FROM sys.dm_exec_requests AS req
JOIN sys.dm_exec_sessions AS sess
ON req.session_id = sess.session_id
WHERE is_user_process = 1
GROUP BY wait_type
ORDER BY SUM(wait_time) DESC;
Box 2: sys.dm_exec_requests
Use the sys.dm_exec_requests or sys.dm_os_waiting_tasks to see the wait_type and wait_time.
Azure SQL RESOURCE_SEMAPHORE wait “wait_time” is_user_process
QUESTION 237
You have an Azure subscription that contains 50 instances of SQL Server on Azure Virtual Machines. The instances host 500 Azure SQL databases.
You need to ensure that all the databases have the same configuration. The solution must meet the following requirements:
– Auditing must be enabled.
– Azure Defender must be enabled.
– Public network access must be disabled.
– Administrative effort must be minimized.
Which two resources should you create in the subscription? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. an Azure Automation runbook
B. an Azure Policy initiative
C. an Azure Policy assignment
D. an Azure Automation account
E. an Azure Policy definition
Answer: BE
Explanation:
https://techcommunity.microsoft.com/t5/itops-talk-blog/azure-policy-initiatives-vs-azure-policies-when-should-i-use-one/ba-p/1229167
QUESTION 238
Drag and Drop Question
You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named App1. App1 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.
Answer:
QUESTION 239
Drag and Drop Question
You have two instances of SQL Server on Azure Virtual Machines named VM1 and VM2. VM1 hosts a database named db1.
You plan to create a database availability group (DAG) for db1. The solution must use certificate authentication between VM1 and VM2.
You need to configure authentication for the outbound connections of VM1.
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.
Answer: 
QUESTION 240
You have an Azure SQL database named DB1 that contains a nonclustered index named index1.
End users report slow queries when they use index1.
You need to identify the operations that are being performed on the index.
Which dynamic management view should you use?
A. Sys.dm_exec_query_plan_stats
B. Sys.dm_db_index_physical_stats
C. Sys.dm_db_index_operational_stats
D. Sys.dm_db_index_useage_stats
Answer: D
Explanation:
Every individual seek, scan, lookup, or update on the specified index by one query execution is counted as a use of that index and increments the corresponding counter in this view. Information is reported both for operations caused by user-submitted queries, and for operations caused by internally generated queries, such as scans for gathering statistics.
https://learn.microsoft.com/en-us/sql/relational-databases/system-dynamic-management-views/sys-dm-db-index-usage-stats-transact-sql?view=sql-server-ver16#remarks
QUESTION 241
You have a Microsoft SQL Server 2017 server.
You need to migrate the server to Azure. The solution must meet the following requirements:
– Ensure that the latest version of SQL Server is used.
– Support the SQL Server Agent service.
Minimize administrative effort.
What should you use?
A. SQL Server on Azure Virtual Machines
B. Azure SQL Database
C. an Azure SQL Database elastic pool
D. Azure SQL Managed Instance
Answer: D
Explanation:
https://learn.microsoft.com/en-us/sql/ssms/agent/set-service-startup-account-sql-server-agent-sql-server-configuration-manager?view=sql-server-ver16
QUESTION 242
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.
You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:
– The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.
– Administrative effort must be minimized.
What should you use to host the databases?
A. a single Azure SQL database
B. an Azure SQL Database elastic pool
C. SQL Server on Azure Virtual Machines
D. Azure SQL Managed Instance
Answer: D
Explanation:
Linked servers are available in SQL Server Database Engine and Azure SQL Managed Instance. They are not enabled in Azure SQL Database singleton and elastic pools.
https://learn.microsoft.com/en-us/sql/relational-databases/linked-servers/linked-servers-database-engine?view=sql-server-2017
Resources From:
1.2025 Latest Braindump2go DP-300 Exam Dumps (PDF & VCE) Free Share:
https://www.braindump2go.com/dp-300.html
2.2025 Latest Braindump2go DP-300 PDF and DP-300 VCE Dumps Free Share:
https://drive.google.com/drive/folders/14Cw_HHhVKoEylZhFspXeGp6K_RZTOmBF?usp=sharing
3.2025 Free Braindump2go DP-300 Exam Questions Download:
https://www.braindump2go.com/free-online-pdf/DP-300-VCE-Dumps(205-242).pdf
Free Resources from Braindump2go,We Devoted to Helping You 100% Pass All Exams!