Microsoft DP-300 Exam Actual Questions

You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet.

You execute the following Transact-SQL statements.

You need to reduce the time it takes to perform analytic queries on the database.

Which configuration should you enable?

Show Answer Hide Answer

You have an instance of SQL Server on Azure Virtual Machines named VM1.

You need to implement a disaster recovery solution that meets the following requirements:

* Returns the solution to an operational state within 15 minutes of a failure

* Can perform disaster recovery testing in an isolated environment

* Minimizes administrative effort

What should you include in the solution?

Show Answer Hide Answer

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?

Show Answer Hide Answer

You have an Azure SQL database named SOL1.

You need to implement a disaster recovery solution for SQL1. The solution must minimize the following:

* The recovery point objective JRPO)

* The recovery time objective (RTO)

* Administrative effort

What should you include in the solution?

Show Answer Hide Answer

You have an Azure subscription that contains the resources shown in the following table.

You plan louse SQLDB11 as an elastic job database to run jobs on SQlDb11 andSOtDB22. What is the minimum number of database scoped credentials required tor the elastic jobs?

Show Answer Hide Answer