Free Microsoft DP-300 Exam Questions

You have an Azure Data Factory pipeline that is triggered hourly.

The pipeline has had 100% success for the past seven days.

The pipeline execution fails, and two retries that occur 15 minutes apart also fail. The third failure returns the following error.

What is a possible cause of the error?

You are building a database backup solution for a SQL Server database hosted on an Azure virtual machine.

In the event of an Azure regional outage, you need to be able to restore the database backups. The solution must minimize costs.

Which type of storage accounts should you use for the backups?

You're attempting to authenticate users in your Azure SQL Database. Which two methods can you use to authenticate against Azure SQL using identities in Entra ID?

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 virtual machine based on a custom image named VM1.

VM1 hosts an instance of Microsoft SQL Server 2019 Standard.

You need to automate the maintenance of VM1 to meet the following requirements:

✑ Automate the patching of SQL Server and Windows Server.

✑ Automate full database backups and transaction log backups of the databases on VM1.

✑ Minimize administrative effort.

What should you do first?