HOTSPOT - You have an on-premises file server that stores 2 TB of data files. You plan to move the data files to Azure Blob Storage in the West Europe Azure region. You need to recommend a storage account type to store the data files and a replication solution for the storage account. The solution must meet the following requirements: - Be available if a single Azure datacenter fails. - Support storage tiers. - Minimize cost. What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: Standard general-purpose v2 Standard general-purpose v2 meets the requirements and minimizes the costs. Box 2: Zone-redundant storage (ZRS) ZRS protects against a Datacenter failure, while minimizing the costs. Reference: https://docs.microsoft.com/en-us/azure/storage/common/storage-redundancy
Question 112
HOTSPOT - You have an Azure web app named App1 and an Azure key vault named KV1. App1 stores database connection strings in KV1. App1 performs the following types of requests to KV1: - Get - List - Wrap - Delete Unwrap - - Backup - Decrypt - Encrypt You are evaluating the continuity of service for App1. You need to identify the following if the Azure region that hosts KV1 becomes unavailable: - To where will KV1 fail over? - During the failover, which request type will be unavailable? What should you identify? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Box 1: A server in the paired region The contents of your key vault are replicated within the region and to a secondary region at least 150 miles away, but within the same geography to maintain high durability of your keys and secrets. Regions are paired for cross-region replication based on proximity and other factors. Box 2: Delete - During failover, your key vault is in read-only mode. Requests that are supported in this mode are: List certificates - Get certificates - List secrets - Get secrets - List keys - Get (properties of) keys - Encrypt - Decrypt - Wrap - Unwrap - Verify - Sign - Backup - Reference: https://docs.microsoft.com/en-us/azure/key-vault/general/disaster-recovery-guidance
Question 113
DRAG DROP - Your company identifies the following business continuity and disaster recovery objectives for virtual machines that host sales, finance, and reporting applications in the company's on-premises data center: - The sales application must be able to fail over to a second on-premises data center. - The reporting application must be able to recover point-in-time data at a daily granularity. The RTO is eight hours. - The finance application requires that data be retained for seven years. In the event of a disaster, the application must be able to run from Azure. The recovery time objective (RTO) is 10 minutes. You need to recommend which services meet the business continuity and disaster recovery objectives. The solution must minimize costs. What should you recommend for each application? To answer, drag the appropriate services to the correct applications. Each service may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point. Select and Place:
Box 1: Azure Site Recovery - Azure Site Recovery - Coordinates virtual-machine and physical-server replication, failover, and fullback. DR solutions have low Recovery point objectives; DR copy can be behind by a few seconds/minutes. DR needs only operational recovery data, which can take hours to a day. Using DR data for long-term retention is not recommended because of the fine-grained data capture. Disaster recovery solutions have smaller Recovery time objectives because they are more in sync with the source. Remote monitor the health of machines and create customizable recovery plans. Box 2: Azure Site Recovery and Azure Backup Backup ensures that your data is safe and recoverable while Site Recovery keeps your workloads available when/if an outage occurs. Box 3: Azure Backup only - Azure Backup - Backs up data on-premises and in the cloud Have wide variability in their acceptable Recovery point objective. VM backups usually one day while database backups as low as 15 minutes. Backup data is typically retained for 30 days or less. From a compliance view, data may need to be saved for years. Backup data is ideal for archiving in such instances. Because of a larger Recovery point objective, the amount of data a backup solution needs to process is usually much higher, which leads to a longer Recovery time objective. Reference: https://lighthousemsp.com/whats-the-difference-between-azure-backup-and-azure-site-recovery/
Question 114
You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without any data loss. - The database must remain available in the event of a zone outage. - Costs must be minimized. Which deployment option should you use?
General Purpose service tier provides zone redundant availability. There are two high availability architectural models: * Standard availability model that is based on a separation of compute and storage. It relies on high availability and reliability of the remote storage tier. This architecture targets budget-oriented business applications that can tolerate some performance degradation during maintenance activities. * Premium availability model that is based on a cluster of database engine processes. It relies on the fact that there is always a quorum of available database engine nodes. This architecture targets mission-critical applications with high IO performance, high transaction rate and guarantees minimal performance impact to your workload during maintenance activities. Note: Zone-redundant configuration for the general purpose service tier is offered for both serverless and provisioned compute. This configuration utilizes Azure Availability Zones "‰to replicate databases across multiple physical locations within an Azure region."‰By selecting zone-redundancy, you can make your"‰new and existing serverless and provisioned general"‰purpose single databases and elastic pools resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic. Incorrect: Not A: Azure SQL Managed Instance Business Critical is more expensive. Not B: Premium is more expensive. Not C: Azure SQL Database Basic, and General purpose provide only locally redundant availability. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
Question 115
You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without any data loss. - The database must remain available in the event of a zone outage. - Costs must be minimized. Which deployment option should you use?
Azure SQL Database Premium meets the requirements and is the least expensive. Note: There are two high availability architectural models: * Standard availability model that is based on a separation of compute and storage. It relies on high availability and reliability of the remote storage tier. This architecture targets budget-oriented business applications that can tolerate some performance degradation during maintenance activities. * Premium availability model that is based on a cluster of database engine processes. It relies on the fact that there is always a quorum of available database engine nodes. This architecture targets mission-critical applications with high IO performance, high transaction rate and guarantees minimal performance impact to your workload during maintenance activities. Note: Zone-redundant configuration for the general purpose service tier is offered for both serverless and provisioned compute. This configuration utilizes Azure Availability Zones "‰to replicate databases across multiple physical locations within an Azure region."‰By selecting zone-redundancy, you can make your"‰new and existing serverless and provisioned general"‰purpose single databases and elastic pools resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic. Incorrect: Not A: Azure SQL Managed Instance Business Critical is more expensive. Not C: Azure SQL Database Basic, and General purpose provide only locally redundant availability. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/high-availability-sla
Question 116
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution. After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen. You need to deploy resources to host a stateless web app in an Azure subscription. The solution must meet the following requirements: - Provide access to the full .NET framework. - Provide redundancy if an Azure region fails. - Grant administrators access to the operating system to install custom application dependencies. Solution: You deploy a web app in an Isolated App Service plan. Does this meet the goal?
Instead: You deploy two Azure virtual machines to two Azure regions, and you create an Azure Traffic Manager profile. Note: Azure Traffic Manager is a DNS-based traffic load balancer that enables you to distribute traffic optimally to services across global Azure regions, while providing high availability and responsiveness. Reference: https://docs.microsoft.com/en-us/azure/traffic-manager/traffic-manager-overview
Question 117
You need to design a highly available Azure SQL database that meets the following requirements: - Failover between replicas of the database must occur without any data loss. - The database must remain available in the event of a zone outage. - Costs must be minimized. Which deployment option should you use?
Now your new and existing serverless Azure SQL Databases allow for zone redundant configuration. This feature utilizes Azure Availability Zones to replicate databases across multiple physical locations within an Azure region. By selecting zone redundancy, you can make your serverless databases resilient to a much larger set of failures, including catastrophic datacenter outages-without any changes of the application logic. The SQL Database serverless compute tier optimizes price-performance and simplifies performance management for single databases with intermittent, unpredictable usage by auto-scaling compute and billing for compute used per second. Incorrect: Not B: Azure SQL Database Business Critical is a more expensive solution. Not C: Azure SQL Database Basic does not provide zone redundancy. Not D: Azure SQL Database Standard is a more expensive solution. Reference: https://azure.microsoft.com/en-us/updates/public-preview-zone-redundant-configuration-for-azure-sql-database-serverless-compute-tier/
Question 118
HOTSPOT - You have an on-premises Microsoft SQL Server database named SQL1. You plan to migrate SQL1 to Azure. You need to recommend a hosting solution for SQL1. The solution must meet the following requirements: • Support the deployment of multiple secondary, read-only replicas. • Support automatic replication between primary and secondary replicas. • Support failover between primary and secondary replicas within a 15-minute recovery time objective (RTO). What should you include in the solution? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 119
HOTSPOT - You have two on-premises Microsoft SQL Server 2017 instances that host an Always On availability group named AG1. AG1 contains a single database named DB1. You have an Azure subscription that contains a virtual machine named VM1. VM1 runs Linux and contains a SQL Server 2019 instance. You need to migrate DB1 to VM1. The solution must minimize downtime on DB1. What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Question 120
HOTSPOT - You are building an Azure web app that will store the Personally Identifiable Information (PII) of employees. You need to recommend an Azure SQL. Database solution for the web app. The solution must meet the following requirements: • Maintain availability in the event of a single datacenter outage. • Support the encryption of specific columns that contain PII. • Automatically scale up during payroll operations. • Minimize costs. What should you include in the recommendations? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
