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.

Modify the diagnostic settings for SQLMI1.

Create the private endpoint connection on SQLMI1.

Configure Azure SQL Analytics to use Workspace1.

Modify the Computer + storage settings for SQLMI1.

Modify the diagnostic settings for SQLMI1.

You have an Azure SQL database named DB1.A user named User 1 has an Azure AD account.You need to provide User1 with the ability to add and remove columns from the tables m DBV The solution must use the principle of least privilege.Which two actions should you perform? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point

Assign the database user the db.ddladmm role.

Create a login and an associated database user.

Assign the database user the db.ddladmm role.

Assign the database user the db.owner role.

Create a contained database user.

Create a login and an associated database user.

You have an on-premises Microsoft SQL Server 2019 instance named SQL1 that hosts a database named db1. You have an Azure subscription that contains an Azure SQL managed instance named MI1 and an Azure Storage account named storage1.You need to ensure that you can back up db1 to storage1. The solution must meet the following requirements:* Use block blob storage.* Maximize security.

Enable infrastructure encryption.

Generate a shared access signature (SAS)

Enable infrastructure encryption.

You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases. You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation. You need to create the required Automation accounts.Which two accounts should you create? Each correct answer presents part of the solution.NOTE: Each correct selection is worth one point.

From the Azure Active Directory admin center, create a service principal.

On SQL1. create a SQL user in the databases.

From the Azure Active Directory admin center, create a service principal.

From the Azure Active Directory admin center, create a user-assigned managed identity for SQL1.

On SQL1. create a SQL user in the databases.

From the Azure Active Directory admin center, create an external identity.

You have an Azure SQL database named DB1.You need to encrypt DB1. The solution must meet the following requirements;- Encrypt data in motion.- Support comparison operators.- Provide randomized encryption.What should you include in the solution?

Transparent Data Encryption (TDE)

Always Encrypted with secure enclaves

You have a SQL Server on Azure Virtual Machines instance named SQLVM1 that was deployed by using an Azure Marketplace SQL Server 2019 Enterprise image. You need to change the Microsoft SQL Server instance on SQLVM1 to the Standard edition. The solution must ensure licensing compliance. What should you do first?

From SQLVM1, uninstall the SQL Server instance.

From the SQL Server Installation Center on SQLVM1. run the Edition Upgrade wizard.

From SQLVM1, uninstall the SQL Server instance.

From the SQL Server Installation Center on SQLVM1. run the Repair wizard.

From the Azure portal, reconfigure SQLVM1.

You have a Microsoft SQL Server 2019 instance in an on-premises datacenter. The instance contains a 4-TB database named DB1. You plan to migrate DB1 to an Azure SQL Database managed instance.What should you use to minimize downtime and data loss during the migration?

Azure Database Migration Service

distributed availability groups

Azure Database Migration Service

You have an Azure subscription.You need to deploy an Azure SQL database. The solution must meet the following requirements:- Dynamically scale CPU resources.- Ensure that the database can be paused to reduce costs.What should you use?

the Business Critical service tier

the General Purpose service tier

You need to recommend a disaster recovery solution for an on-premises Microsoft SQL Server database. The solution must meet the following requirements:- Support real-time data replication to a different geographic region.- Use Azure as a disaster recovery target.- Minimize costs and administrative effort.What should you include in the recommendation?

transactional replication to an Azure SQL Managed Instance

database mirroring on an instance of SQL Server on Azure Virtual Machines

availability groups for SQL Server on Azure Virtual Machines

an Azure SQL Managed Instance link

transactional replication to an Azure SQL Managed Instance

You have a single availability set that contains two SQL Server on Azure Virtual Machines instances. The instances were deployed by using an Azure Marketplace SQL Server 2019 Enterprise image that has the latest cumulative updates applied. The instances are configured as the nodes of a failover cluster instance (FCI) named FCI1. You need to ensure that client applications can connect to FCI1. The solution must meet the following requirements:- Provide an availability SLA- Minimize costs.What should you create?

a distributed network name (DNN) resource

a virtual network name (VNN) resource

a distributed network name (DNN) resource

an Azure Standard Load Balancer

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. You need to recommend a deployment solution that meets the following requirements:- Provides a Service Level Agreement (SLA) of at least 99.95%- Replicates databases in the same group synchronously- Minimizes the latency of database writesWhat should you recommend?

Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group.

Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.

Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.

Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.

You have an Azure subscription.You need to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group. The solution must meet the following requirements:• Minimize how long it takes to fail over.• Maintain existing connections to the primary replica during a failover.What should you do?

Connect each virtual machine to a different subnet on a single virtual network.

Connect each virtual machine to a single subnet on a single virtual network.

Connect each virtual machine to a single subnet on a virtual network. Deploy a standard Azure load balancer.

Connect each virtual machine to a different subnet on a single virtual network.

Connect each virtual machine to a different subnet on a virtual network. Deploy a basic Azure load balancer.

Microsoft DP-300 Practice Test 7 - Free Online Exam Prep & Questions

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance named SQLVMI. SQLVMI hosts a database named OBI. You need to retrieve query plans from the Query Store on DBI.

What should you do first?

Become a Premium Member for full access

Unlock Premium Member

Microsoft DP-300 Practice Test 7

Question

Microsoft DP-300 Practice Tests

Practice Tests