DP-300 Practice Questions & Answers

Loading your practice set…

In a scenario where you need to provision an Azure SQL Managed Instance in a specific region with a custom endpoint, which of the following steps should you take to ensure the instance is correctly configured and accessible from a virtual network in the same subscription?

Create the virtual network and then the managed instance.
Create the managed instance with the custom endpoint and then configure virtual network integration. (Correct)
Create the managed instance and then create the virtual network.
Configure virtual network integration after creating both the managed instance and the virtual network.

Explanation: The correct answer is B because you must first create the Azure SQL Managed Instance with the specified endpoint and then configure the virtual network integration to allow the managed instance to communicate with the virtual network. Option A is incorrect because it does not address the need for virtual network integration. Option C is incorrect as it suggests creating the virtual network before the managed instance, which is not necessary and could lead to misconfiguration. Option D is incorrect because it implies that the virtual network integration can be done after the managed instance is created without any prior steps.

When configuring storage for an Azure SQL Managed Instance, which of the following actions is necessary to ensure optimal performance and compliance with data governance policies?

Ensure the managed instance is in the same region as the storage account.
Configure the storage account with the appropriate access tier and performance level. (Correct)
Enable encryption on the managed instance.
Set the storage account to use geo-redundant storage (GRS).

Explanation: The correct answer is B because configuring the storage account with the appropriate access tier and performance level ensures optimal performance and helps comply with data governance policies. Option A is incorrect as it does not mention the importance of setting the access tier and performance level. Option C is incorrect because it focuses on the wrong aspect; the primary concern is the storage account configuration rather than the managed instance itself. Option D is incorrect as it suggests enabling encryption without mentioning the need for setting the access tier and performance level.

In a scenario where you need to configure database authentication using Microsoft Entra-only authentication for a SQL Server database, which of the following steps should you take to ensure that only users with valid Microsoft Entra identities can access the database without needing to create SQL Server logins?

Create SQL Server logins for all users.
Configure Microsoft Entra-only authentication for the database. (Correct)
Enable Windows authentication for the database.
Create contained database users for all users.

Explanation: The correct answer is B because configuring Microsoft Entra-only authentication ensures that only users with valid Microsoft Entra identities can access the database. Option A is incorrect because it involves creating SQL Server logins, which is not necessary when using Microsoft Entra-only authentication. Option C is incorrect because it suggests enabling Windows authentication, which is not relevant in this context. Option D is incorrect because it refers to contained database users, which are not suitable for Microsoft Entra-only authentication.

When setting up database authorization for a ledger table in SQL Server, which type of user should you use to ensure that the ledger table is protected and only accessible by specific roles or users within the database?

Use Microsoft Entra-only authentication.
Use contained database users. (Correct)
Use Windows authentication.
Use SQL Server logins.

Explanation: The correct answer is B because contained database users are appropriate for ledger tables as they do not require server-level logins and are scoped to the database. Option A is incorrect because Microsoft Entra-only authentication is used for authenticating users against Microsoft Entra ID, not for authorizing ledger table access. Option C is incorrect because Windows authentication is used for authenticating users against the Windows domain, not for authorizing ledger table access. Option D is incorrect because SQL Server logins are used for authenticating users at the server level, not for authorizing ledger table access.

In an Azure SQL Database environment, you notice that a specific query is running slowly and causing performance issues. You want to gather detailed information about the query execution plan and identify potential bottlenecks. Which tool or feature should you use to achieve this?

Intelligent Insights
Query Performance Insight (Correct)
Automatic Tuning
Extended Events

Explanation: The correct answer is B. Query Performance Insight provides detailed insights into query performance, including execution plans, wait statistics, and resource usage. It helps identify the root cause of performance issues. Intelligent Insights and Automatic Tuning are broader tools that provide monitoring and tuning recommendations across multiple resources, while Extended Events are used for more granular event tracking but not specifically for query performance analysis.

You are tasked with monitoring the performance of an Azure SQL Database instance over a period of time to ensure it meets the required service level agreements (SLAs). You need to set up a monitoring solution that can capture detailed performance metrics and alert you when certain thresholds are exceeded. Which feature would best suit this requirement?

Intelligent Insights
Query Performance Insight
Extended Events (Correct)
Automatic Tuning

Explanation: The correct answer is C. Extended Events can be configured to capture detailed performance metrics over extended periods, allowing for long-term monitoring and historical analysis. Intelligent Insights and Query Performance Insight are more focused on providing real-time insights and recommendations, while Automatic Tuning is designed to automatically optimize database performance based on observed workload patterns.

Your company operates a global application with a primary SQL Server database in the US East region and a secondary database in the Europe West region. The primary database is experiencing high read traffic, and you need to ensure that the secondary database can take over as the primary in case of a failure in the US East region. Which HADR strategy should you recommend to meet these requirements?

Active Geo-Replication
Failover Groups (Correct)
Automated Point-in-Time Restore
Long-term Retention

Explanation: Failover groups allow you to create a group of databases that can fail over to each other in case of a failure, ensuring high availability and disaster recovery. Active Geo-Replication provides a way to replicate data between regions but does not support automatic failover. Automated Point-in-Time Restore (PITR) allows you to restore a database to a specific point in time but does not provide a failover mechanism. Long-term Retention (LTR) is used for archiving data and does not support failover or replication.

Your organization has a SQL Server database in the Azure environment that needs to maintain data consistency across multiple regions to ensure business continuity. You want to implement a solution that can replicate data from the primary region to a secondary region and automatically recover the secondary region if the primary fails. Which HADR strategy would you recommend?

Failover Groups
Active Geo-Replication (Correct)
Automated Point-in-Time Restore
Long-term Retention

Explanation: Active Geo-Replication is designed to replicate data between Azure regions and supports automatic failover in case of a failure in the primary region. Failover groups are not suitable for cross-region replication, PITR is for restoring to a specific point in time, and LTR is for long-term data retention and does not support failover or replication.