Get 100% Real DP-300 Exam Questions, Accurate & Verified Answers As Seen in the Real Exam!
DP-300 Premium Files Updated Feb-2026 Practice Valid Exam Dumps Question
How to Register For Exam DP-300: Administering Relational Databases on Microsoft Azure?
Preparing for the DP-300 exam requires a significant investment of time and effort. You need to have hands-on experience with Microsoft Azure and its database services. You should also be familiar with database management concepts and tools, as well as best practices for security, performance, and disaster recovery. Fortunately, there are many resources available to help you prepare for DP-300 exam, including online courses, study guides, and practice exams.
NEW QUESTION # 199
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 rows in Table1 that have changed.
You need to ensure that webapp1 can identity the changes to Table'. 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:
Explanation
Graphical user interface, text, application Description automatically generated
NEW QUESTION # 200
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.
Answer:
Explanation:
Explanation:
NEW QUESTION # 201
You are evaluating the role assignments.
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:
Reference:
https://docs.microsoft.com/en-us/azure/role-based-access-control/built-in-roles
NEW QUESTION # 202
Hotspot Question
You have an Azure SQL database.
You are reviewing a slow performing query as 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:
Explanation:
Box 1: Live Query Statistics
Live Query Statistics as it a percentage of the execution.
Box 2: Key Lookup
The use of a Key Lookup operator in a query plan indicates that the query might benefit from performance tuning. For example, query performance might be improved by adding a covering index.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/live-query-statistics?view=sql-server-ver15
https://docs.microsoft.com/en-us/sql/relational-databases/showplan-logical-and-physical-operators-reference
NEW QUESTION # 203
You have an Azure SQL database.
You run the following PowerShell script.
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:
Explanation:
Reference:
https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackupshorttermretentionpolicy?
view=azps-7.2.0
https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackuplongtermretentionpolicy?
view=azps-7.2.0
NEW QUESTION # 204
You have an Azure SQL database named DBI 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. Option A
- B. Option C
- C. Option D
- D. Option B
Answer: C
NEW QUESTION # 205
You have an Azure SQL database.
You identify a long running query.
You need to identify which operation in the query is causing the performance issue.
What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
- A. an actual execution plan
- B. an estimated execution plan
- C. Client Statistics
- D. Live Query Statistics
Answer: D
Explanation:
https://www.mssqltips.com/sqlservertip/3685/live-query-statistics-in-sql-server-2016/
NEW QUESTION # 206
You have SQL Server on an Azure virtual machine that contains a database named DB1.
You view a plan summary that showsthe durationin milliseconds of each execution of query 1178902 as shown in the following exhibit:
What should you do to ensure that the query uses the execution plan which executes in the least amount of time?
- A. Run theDBCC FREEPROCCACHEcommand.
- B. Force the query execution plan for plan 1220917.
- C. Force the query execution plan for plan 1221065.
- D. Disable parameter sniffing.
Answer: B
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/performance/query-store-usage-scenarios
NEW QUESTION # 207
SIMULATION
You need to configure your user account as the Microsoft Entra admin for the server named sql12345678.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.
Answer:
Explanation:
Manage administrator accounts in Azure Active Directory B2C
You can assign a role when you create a user or invite a guest user. You can add a role, change the role, or remove a role for a user:
Solution 1:
Provision Microsoft Entra admin (SQL Managed Instance)
Your SQL Managed Instance needs permission to read Microsoft Entra ID to accomplish tasks such as authentication of users through security group membership or creation of new users. For this to work, you must grant the SQL Managed Instance permission to read Microsoft Entra ID.
You can do this using the Azure portal or PowerShell.
To grant your SQL Managed Instance read permissions to Microsoft Entra ID using the Azure portal, sign in as a Global Administrator and follow these steps:
Step 1: In the Azure portal, in the upper-right corner select your account, and then choose Switch directories to confirm which directory is your Current directory. Switch directories, if necessary.
Step 2: Choose the correct Microsoft Entra directory as the Current directory.
This step links the subscription associated with Microsoft Entra ID to the SQL Managed Instance, ensuring the Microsoft Entra tenant and SQL Managed Instance use the same subscription.
Step 3: Now, you can choose your Microsoft Entra admin for your SQL Managed Instance. For that, go to your managed instance resource in the Azure portal and select Microsoft Entra admin under Settings.
Step 4: Select the banner on top of the Microsoft Entra admin page and grant permission to the current user.
Step 5: After the operation succeeds, the following notification will show up in the top-right corner:
Step 6: On the Microsoft Entra admin page, select Set admin from the navigation bar to open the Microsoft Entra ID pane.
Step 7: On the Microsoft Entra ID pane, search for a user, check the box next to the user or group to be an administrator, and then press Select to close the pane and go back to the Microsoft Entra admin page for your managed instance. [Select yourself] Step 8: From the navigation bar of the Microsoft Entra admin page for your managed instance, select Save to confirm your Microsoft Entra administrator.
The process of changing the administrator might take several minutes. Then the new administrator appears in the Microsoft Entra admin box.
Solution 2:
Step 1: Sign in to the Azure portal with Global Administrator or Privileged Role Administrator permissions.
Step 2: (If you have access to multiple tenants, select the Settings icon in the top menu to switch to your Azure AD B2C tenant from the Directories + subscriptions menu.) Step 3: Under Azure services, select Azure AD B2C. Or use the search box to find and select Azure AD B2C.
Step 4: Under Manage, select Users.
Step 5: Select the user you want to change the roles for. [Select your user account]. Then select Assigned roles.
Step 6: Add a role assignment
Step 7: Select Add assignments, select the role to assign (for example, Application administrator),
[Select Microsoft Entra administrator] and then choose Add.
Reference:
https://learn.microsoft.com/en-us/azure/azure-sql/database/authentication-aad-configure
https://learn.microsoft.com/en-us/azure/active-directory-b2c/tenant-management-manage- administrator
NEW QUESTION # 208
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.
Answer:
Explanation:
Explanation:
NEW QUESTION # 209
You have an Azure SQL database.
You run the following PowerShell script.
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:
Reference:
https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackupshorttermretentionpolicy?view=azps-7.2.0
https://docs.microsoft.com/en-us/powershell/module/az.sql/set-azsqldatabasebackuplongtermretentionpolicy?view=azps-7.2.0
NEW QUESTION # 210
You are creating a managed data warehouse solution on Microsoft Azure.
You must use PolyBase to retrieve data from Azure Blob storage that resides in parquet format and load the data into a large table called FactSalesOrderDetails.
You need to configure Azure Synapse Analytics to receive the data.
Which four 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:
1 - Create a master key on database.
2 - Create an external data source for Azure Blob storage.
3 - Create an external file format to map the parquet files.
4 - Create an external table FactSalesOrderDetails.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-azure-blob-storage
NEW QUESTION # 211
You have an Azure Data Lake Storage Gen2 container.
Data is ingested into the container, and then transformed by a data integration application. The data is NOT modified after that. Users can read files in the container but cannot modify the files.
You need to design a data archiving solution that meets the following requirements:
New data is accessed frequently and must be available as quickly as possible.
Data that is older than five years is accessed infrequently but must be available within one second when requested.
Data that us older than seven years is NOT accessed. After seven years, the data must be persisted at the lowest cost possible.
Costs must be minimized while maintaining the required availability.
How should you manage the data? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-storage-tiers
NEW QUESTION # 212
You have a SQL Server on Azure Virtual Machines instance named VM1 . You run the following query.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
Answer:
Explanation:
Explanation
NEW QUESTION # 213
You need to apply 20 built-in Azure Policy definitions to all new and existing Azure SQL Database deployments in an Azure subscription. The solution must minimize administrative effort.
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:
Explanation:
Step 1: Create an Azure Policy Initiative
The first step in enforcing compliance with Azure Policy is to assign a policy definition. A policy definition defines under what condition a policy is enforced and what effect to take.
With an initiative definition, you can group several policy definitions to achieve one overarching goal. An initiative evaluates resources within scope of the assignment for compliance to the included policies.
Step 2: Create an Azure Policy Initiative assignment
Assign the initiative definition you created in the previous step.
Step 3: Run Azure Policy remediation tasks
To apply the Policy Initiative to the existing SQL databases.
Reference:
https://docs.microsoft.com/en-us/azure/governance/policy/tutorials/create-and-manage
NEW QUESTION # 214
You have a Microsoft SQL Server 2019 database named DB1 that uses the following database-level and instance-level features.
Clustered columnstore indexes
Automatic tuning
Change tracking
PolyBase
You plan to migrate DB1 to an Azure SQL database.
What feature should be removed or replaced before DB1 can be migrated?
- A. Clustered columnstore indexes
- B. Change tracking
- C. PolyBase
- D. Automatic tuning
Answer: C
Explanation:
This table lists the key features for PolyBase and the products in which they're available.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-versioned-feature-summary
NEW QUESTION # 215
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.
Answer: D
NEW QUESTION # 216
You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:\DB1.bak.
You plan to deploy an Always On availability group that will have the following configurations:
VM1 will host the primary replica of DB1.
VM2 will host a secondary replica of DB1.
You need to prepare the secondary database on VM2 for the availability group.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Reference:
https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/manually-prepare-a-secondary-database-for-an-availability-group-sql-server?view=sql-server-ver15
NEW QUESTION # 217
You have an Azure SQL Database managed instance named sqldbmi1 that contains a database name Sales.
You need to initiate a backup of Sales.
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:
Reference:
https://techcommunity.microsoft.com/t5/azure-sql-database/native-database-backup-in-azure-sql-managed-instance/ba-p/386154
NEW QUESTION # 218
You have a burstable Azure virtual machine named VMI that hosts an instance of Microsoft SQL Server.
You need to attach an Azure ultra disk to VMI. The solution must minimize downtime on VMI.
In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.
Answer:
Explanation:
Explanation
NEW QUESTION # 219
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. differential
- B. tail-log
- C. log
- D. full
Answer: D
Explanation:
Backups, only a full database backup can be performed on the master database.
https://learn.microsoft.com/en-us/sql/relational-databases/databases/master-database?view=sql-server-ver16
NEW QUESTION # 220
You have a database named db1.
The log for db1 contains the following entry.
You need to ensure That db1 can process transactions.
Answer:
Explanation:
NEW QUESTION # 221
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 by Azure SQL databases on
sqlsrv1.
What should you do?
- A. Run Query Store-based queries
- B. Review information provided by SQL Server Profiler-based traces
- C. Run dynamic management view-based queries
- D. Review information provided by Query Performance Insight
Answer: C
Explanation:
Section: [none]
Explanation:
The diagnostics log outputs tempDB contention details. You can use the information as the starting point for
troubleshooting.
You can use the Intelligent Insights performance diagnostics log of Azure SQL Database to troubleshoot
performance issues.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-troubleshoot-
performance#tempdb-contention
https://docs.microsoft.com/en-us/azure/azure-sql/database/intelligent-insights-use-diagnostics-log
NEW QUESTION # 222
You have an Azure subscription that contains an Azure SQL database named db1.
You need to implement SQL insights for db1.
Which two resources should you create first? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point
- A. an Azure logic app
- B. a Log Analytics workspace
- C. a storage account
- D. a virtual machine
- E. an Azure function
Answer: B,D
NEW QUESTION # 223
......
What is Microsoft DP-300 Exam
DP-300 Administering Relational Databases on the Microsoft Azure certification is the optimal target audience for the exam. You need to confirm whether the exam is an ideal option for your career goals or not. The perfect candidates for the DP-300 exam are Data Source Monitoring Specialists and Data Source Administrators. Certified Prospects work would primarily include on-premises and cloud-based relational database monitoring, based on Microsoft Azure and Microsoft SQL Web Server data solutions. The role of certified candidates for the DP-300 exam would certainly be to fulfill the responsibilities.
Application and monitoring of functional aspects of hybrid and cloud-based native information systems services based on Microsoft SQL Web Server and also on Microsoft Azure data solutions. Use of numerous tools and techniques to assist in daily database administration tasks, such as applying knowledge of using T-SQL for administrative administration purposes. Provides efficiency management, planning, protection, optimization, and monitoring for sophisticated relational data source options. Works collaboratively with Azure Data Engineers to monitor operational aspects of information platform solutions.
REAL DP-300 Exam Questions With 100% Refund Guarantee : https://www.dumpsactual.com/DP-300-actualtests-dumps.html
Practice with DP-300 Dumps for Microsoft Azure Certified Exam Questions & Answer: https://drive.google.com/open?id=1qcjZ5GZds5OCHYR3XLNX9z7hjRFXXS-e
