- Home
- Microsoft
- Administering Relational Databases on Microsoft Azure
- Microsoft.DP-300.v2025-02-22.q138
- Question 64
Valid DP-300 Dumps shared by ExamDiscuss.com for Helping Passing DP-300 Exam! ExamDiscuss.com now offer the newest DP-300 exam dumps, the ExamDiscuss.com DP-300 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com DP-300 dumps with Test Engine here:
Access DP-300 Dumps Premium Version
(464 Q&As Dumps, 35%OFF Special Discount Code: freecram)
<< Prev Question Next Question >>
Question 64/138
You have an Azure subscription that contains three instances of SQL Server on Azure Virtual Machines.
You plan to implement a disaster recovery solution.
You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements:
* Minimize administrative effort for the recovery drills.
* Isolate the recovery environment from the production environment.
What should you use?
You plan to implement a disaster recovery solution.
You need to be able to perform disaster recovery drills regularly. The solution must meet the following requirements:
* Minimize administrative effort for the recovery drills.
* Isolate the recovery environment from the production environment.
What should you use?
Correct Answer: A
- Question List (138q)
- Question 1: You have an Azure SQL database. The database contains a tabl...
- Question 2: You need to use an Azure Resource Manager ARM) template to d...
- Question 3: You have an Azure subscription that contains an Azure SQL da...
- Question 4: You have an Azure SQL database named DB1 that contains a pri...
- Question 5: You have an Azure subscription that contains an instance of ...
- Question 6: You have an instance of SQL Server on Azure Virtual Machines...
- Question 7: You are building a database backup solution for a SQL Server...
- Question 8: You have an Azure SQL database. You discover that the plan c...
- Question 9: You need to recommend an authentication solution for App1 ac...
- Question 10: You have an Azure SQL database. You identify a long running ...
- Question 11: You have an Azure subscription that contains two instances o...
- Question 12: You have an Azure subscription that uses a domain named cont...
- Question 13: You have a burstable Azure virtual machine named VMI that ho...
- Question 14: You configure backup for an Azure SQL database as shown in t...
- Question 15: You need to recommend which service and target endpoint to u...
- Question 16: Task 10 You need to protect all the databases on sql37006S95...
- Question 17: You need to recommend the appropriate purchasing model and d...
- Question 18: You have an Azure SQL database. You run the following PowerS...
- Question 19: You have a SQL Server on Azure Virtual Machines instance tha...
- Question 20: Task 4 You need to enable change data capture (CDC) for db1....
- Question 21: You need to provide an implementation plan to configure data...
- Question 22: You have an Azure SQL database named DB1 that contains a tab...
- Question 23: Note: This question is part of a series of questions that pr...
- Question 24: You have an Azure SQL managed instance named SQLMI1 that hos...
- Question 25: You have a SQL Server on Azure Virtual Machines instance nam...
- Question 26: You have an Azure subscription. You plan to migrate 10 on-pr...
- Question 27: You need to implement the monitoring of SalesSQLDb1. The sol...
- Question 28: Note: This question is part of a series of questions that pr...
- Question 29: You have SQL Server on an Azure virtual machine that contain...
- Question 30: You have SQL Server on an Azure virtual machine. You need to...
- Question 31: A data engineer creates a table to store employee informatio...
- Question 32: You need to recommend a solution to ensure that the customer...
- Question 33: You need to trigger an Azure Data Factory pipeline when a fi...
- Question 34: You deploy a database to an Azure SQL Database managed insta...
- Question 35: You have an Azure subscription that contains a logical SQL s...
- Question 36: Note: This question is part of a series of questions that pr...
- Question 37: You have an Azure subscription that contains the following r...
- Question 38: You have an Azure SQL database named SOL1. You need to imple...
- Question 39: You have an instance of SQL Server on Azure Virtual Machines...
- Question 40: You are planning the migration of the SERVER1 databases. The...
- Question 41: You have an Azure Stream Analytics job. You need to ensure t...
- Question 42: You have an Azure SQL database that contains a table named E...
- Question 43: You have an Azure subscription that contains 50 instances of...
- Question 44: You are planning a solution that will use Azure SQL Database...
- Question 45: You have an Azure SQL managed instance. You need to enable S...
- Question 46: You have a version-8.0 Azure Database for MySQL database. Yo...
- Question 47: You have a single availability set that contains two SQL Ser...
- Question 48: Note: This question is part of a series of questions that pr...
- Question 49: You need to migrate an on-premises Microsoft SQL Server data...
- Question 50: You have an Azure SQL Database managed instance named SQLMI1...
- Question 51: You have an Azure Data Lake Storage Gen2 container. Data is ...
- Question 52: You have an Azure virtual machine named VM1 that runs Window...
- Question 53: Task 11 You have a legacy application written for Microsoft ...
- Question 54: You plan to move two 100-GB databases to Azure. You need to ...
- Question 55: You have an Azure key vault named Vault1 and a SQL Server on...
- Question 56: Note: This question is part of a series of questions that pr...
- Question 57: You have an Azure SQL managed instance. You need to restore ...
- Question 58: You have two instances of SQL Server on Azure virtual Machin...
- Question 59: You have an Azure subscription that contains an instance of ...
- Question 60: Task 12 You need to configure high availability for dbl. The...
- Question 61: You have two Azure virtual machines named VM1 and VM2 that r...
- Question 62: Note: This question is part of a series of questions that pr...
- Question 63: You have 10 Azure virtual machines that have SQL Server inst...
- Question 64: You have an Azure subscription that contains three instances...
- Question 65: You have an instance of SQL Server on Azure Virtual Machines...
- Question 66: You have an on-premises datacenter that contains a 2-TB Micr...
- Question 67: You need to implement statistics maintenance for SalesSQLDb1...
- Question 68: You have an Azure subscription that contains the resources s...
- Question 69: Note: This question is part of a series of questions that pr...
- Question 70: You have an Azure subscription that contains the resources s...
- Question 71: You have an Azure subscription. You plan to deploy an instan...
- Question 72: You have an Azure subscription that contains an Azure SQL ma...
- Question 73: You have a Microsoft SQL Server database named DB1 that cont...
- Question 74: You have the following Transact-SQL query. (Exhibit) Which c...
- Question 75: Your on-premises network contains a Microsoft SQL Server 201...
- Question 76: You have an Azure subscription that contains an Azure SQL ma...
- Question 77: You have an Azure SQL database named DB1. You need to ensure...
- Question 78: You have an Azure SQL database named DBI that contains a non...
- Question 79: You have an Azure Active Directory (Azure AD) tenant named c...
- Question 80: You have an Azure SQL database named db1 on a server named s...
- Question 81: You are building an Azure virtual machine. You allocate two ...
- Question 82: You need to recommend an availability strategy for an Azure ...
- Question 83: You need to recommend a backup solution to restore DB3. The ...
- Question 84: You have an Azure subscription that contains an Azure SQL da...
- Question 85: You have an on-premises app named App1 that stores data in a...
- Question 86: You are planning disaster recovery for the failover group of...
- Question 87: You have an Azure subscription that contains an instance of ...
- Question 88: Note: This question is part of a series of questions that pr...
- Question 89: You have an Azure SQL database named DB1 in the General Purp...
- Question 90: You have an instance of SQL Server on Azure Virtual Machines...
- Question 91: You have an Azure SQL database named db1 on a server named s...
- Question 92: Note: This question is part of a series of questions that pr...
- Question 93: You have an Azure AD tenant and a logical Microsoft SQL serv...
- Question 94: You need to implement the surrogate key for the retail store...
- Question 95: You need to apply 20 built-in Azure Policy definitions to al...
- Question 96: You have an Azure SQL database named DB1. A user named User ...
- Question 97: Note: This question is part of a series of questions that pr...
- Question 98: You plan to move two 100-GB databases to Azure. You need to ...
- Question 99: Based on the PaaS prototype, which Azure SQL Database comput...
- Question 100: You have an Azure SQL managed instance named SQLMI1 that has...
- Question 101: You have an Azure subscription that contains the resources s...
- Question 102: Note: This question is part of a series of questions that pr...
- Question 103: Task 2 You need to configure your user account as the Azure ...
- Question 104: You have an Azure SQL database. Users report that the execut...
- Question 105: Your on-premises network contains a server that hosts a 60-T...
- Question 106: Note: This question is part of a series of questions that pr...
- Question 107: You have an Azure SQL database named sqldb1. You need to min...
- Question 108: You are designing an anomaly detection solution for streamin...
- Question 109: You have an Azure SQL managed instance that hosts multiple d...
- Question 110: You have an Azure subscription. You need to deploy a logical...
- Question 111: You have an on-premises Microsoft SQL Server 2019 instance t...
- Question 112: You have four Azure subscriptions. Each subscription contain...
- Question 113: You have SQL Server 2019 on an Azure virtual machine that ru...
- Question 114: You have an Azure SQL managed instance. You need to gather t...
- Question 115: You need to design an analytical storage solution for the tr...
- Question 116: You have a Microsoft SQL Server 2019 instance in an on-premi...
- Question 117: You need to recommend a process to automate the management o...
- Question 118: You have an Azure subscription that contains a storage accou...
- Question 119: You have an Azure SQL Database instance named DatabaseA on a...
- Question 120: You have an Azure SQL database named DB1. The automatic tuni...
- Question 121: You have two Azure virtual machines named Server 1 and Serve...
- Question 122: You have an Azure subscription that contains a SQL Server on...
- Question 123: You plan to deploy an app that includes an Azure SQL databas...
- Question 124: You create a new Azure SQL managed instance named SQL1 and e...
- Question 125: You configure backups for an Azure SQL database as shown in ...
- Question 126: You have an Azure SQL logical server. You run the following ...
- Question 127: You have an Azure subscription that contains two Azure SQL m...
- Question 128: Note: This question is part of a series of questions that pr...
- Question 129: You configure version control for an Azure Data Factory inst...
- Question 130: You have an instance of SQL Server on Azure Virtual Machines...
- Question 131: You need to recommend a solution that will enable remote dev...
- Question 132: You have SQL Server 2019 on an Azure virtual machine that co...
- Question 133: You have an Azure subscription that contains an instance of ...
- Question 134: Task 9 You need to generate an email alert to admin@contoso....
- Question 135: You have an Azure subscription. You need to deploy an Azure ...
- Question 136: You have two on-premises Microsoft SQL Server 2019 instances...
- Question 137: You create a new Azure SQL managed instance named SQL1 and e...
- Question 138: You are designing an enterprise data warehouse in Azure Syna...
