Pass4Future also provide interactive practice exam software for preparing Microsoft Administering Microsoft Azure SQL Solutions (DP-300) Exam effectively. You are welcome to explore sample free Microsoft DP-300 Exam questions below and also try Microsoft DP-300 Exam practice test software.
Do you know that you can access more real Microsoft DP-300 exam questions via Premium Access? ()
You have an on-premises datacenter that contains a 14-TB Microsoft SQL Server database.
You plan to create an Azure SQL managed instance and migrate the on-premises database to the new instance.
Which three service tiers support the SQL managed instance? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Answer : A, C, D
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?
Answer : D
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?
Answer : A
https://learn.microsoft.com/en-us/azure/site-recovery/site-recovery-sql#combining-bcdr-technologies-with-site-recovery
You have an Azure subscription that contains an Azure SQL database named DB1.
You need to host elastic jobs by using DB1. DB1 will also be configured as a job target. The solution must support the use of location-based Conditional Access policies.
What should the elastic jobs use to access DB1?
Answer : A
You have an on-premises Microsoft SQL Server 2022 instance that hosts a 60-TB production database named DB1.
You plan to migrate DB1 to Azure.
You need to recommend a hosting solution for DB1.
Which Azure SQL Database service tier should you use to host DB1?
Answer : A
