Physical Address
304 North Cardinal St.
Dorchester Center, MA 02124
Plan and implement a high availability and disaster recovery environment Microsoft Quiz Answers
Get Plan and implement a high availability and disaster recovery environment Microsoft Quiz Answers
Data must be available when needed. Configure, test and manage a solution for high availability and disaster recovery using Azure tools and SQL Server tools.
This learning path helps prepare you for Exam DP-300: Administering Microsoft Azure SQL Solutions.
Prerequisites:
- Experience creating and configuring resources using the Azure portal
- Basic understanding of SQL Server file storage
- Familiarity with SQL Server database files for data and log
- Familiarity with purpose and management of SQL Server transaction log
Module 2: Explore IaaS and PaaS solutions for high availability and disaster recovery
Deploy Windows Server Failover Cluster and availability groups in Azure and hybrid environments. Configure temporal tables, geo-replication, and auto-failover groups.
Learning objectives:
After completing this module, you will be able to:
- Explore options for deploying a WSFC in Azure
- Explore options for deploying an AG in Azure
- Implement Temporal Tables
- Plan active geo-replication and auto-failover groups
Prerequisites:
- Experience creating and configuring resources using the Azure portal.
- Basic understanding of SQL Server file storage.
This module is part of these learning paths:
Quiz 1: Knowledge check
Q1. What component in Azure needs to be configured for the listener in an AG to work properly?
- The NIC
- The NSG
- A load balancer
Q2. What tool can be used to create a WSFC in Azure for AGs and FCIs?
- Wizard in Failover Cluster Manager
- PowerShell
- WMI
Q3. What Azure feature for testing disaster recovery without bringing the production system down?
- Azure Site Recovery
- Azure SQL Database
- Azure Load Balancer
Q4. What feature creates a replica of the database in another region that is asynchronously kept up to date?
- Failover group
- Secondary replica that is readable
- Active geo-replication
Q5. What setting for auto-failover groups must be changed to ensure a low RPO?
- RPOZero
- AlwaysBeInSync
- GracePeriodWithDataLossHours
Module 3: Back up and restore databases
Plan and implement policy for recovering data if user errors occur or the technology fails. Explore various options for how and where to back up and restore databases.
Learning objectives:
In this module, you will:
- Explore backup and restore options for IaaS
- Implement backup and restore for PaaS
Prerequisites:
- Experience creating and configuring resources using the Azure portal.
- Basic understanding of SQL Server file storage.
- Familiarity with SQL Server database files for data and log.
- Familiarity with purpose and management of SQL Server transaction log.
This module is part of these learning paths:
Quiz 1: Knowledge check
Q1. How does backup to URL in SQL Server or Azure Managed Instance store the backup file?
- As a URL
- As a blob
- As a pointer
Q2. What is the default redundancy option for Azure SQL databases?
- Locally-redundant backup storage (LRS)
- Zone-redundant backup storage (ZRS)
- Geo-redundant backup storage
Q3. Which option should you use to geographic failover instances of SQL Managed Instance?
- Auto-failover groups
- Active geo-replication
- Failover Cluster Instance
Conclusion:
I hope this Plan and implement a high availability and disaster recovery environment Microsoft Quiz Answers would be useful for you to learn something new from this problem. If it helped you then don’t forget to bookmark our site for more Coding Solutions.
This Problem is intended for audiences of all experiences who are interested in learning about Data Science in a business context; there are no prerequisites.
Keep Learning!
