Free Microsoft DP-300 Exam Questions

You have an on-premises multi-tier application named App1 that includes a web tier, an application tier, and a Microsoft SQL Server tier. All the tiers run on Hyper-

V virtual machines.

Your new disaster recovery plan requires that all business-critical applications can be recovered to Azure.

You need to recommend a solution to fail over the database tier of App1 to Azure. The solution must provide the ability to test failover to Azure without affecting the current environment.

What should you include in the recommendation?

You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance namedSQLVM1. SQLVM1 has the following configurations:Automated patching is enabled.The SQL Server laaS Agent extension is installed.The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal.You need to automate the deployment of cumulative updates to SQLVM1 by using Azure UpdateManager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed byusing the Azure portal.What should you do first on SQLVM1?

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?

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?

You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information.

You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information.

What should you include in the recommendation?