AZ-305 practice questions 111–120

1. Question 111 · 232 in bank

   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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Azure service or service tier "Azure SQL Managed Instance" Replication mechanis should be "Auto failover groups" Azure SQL Managed Instance is a fully managed, Azure-based version of SQL Server that can be used to host your on-premises SQL Server database in the cloud. It supports the deployment of multiple secondary, read-only replicas and can automatically replicate data between primary and secondary replicas. It also supports failover between primary and secondary replicas within a 15-minute RTO, which meets the requirement for the solution to have a recovery time objective of 15 minutes. Auto failover groups is a feature of Azure SQL Managed Instance that allows you to automatically failover between primary and secondary replicas in the event of an outage or failure. It supports the deployment of multiple secondary, read-only replicas and can automatically replicate data between primary and secondary replicas. It also supports failover between primary and secondary replicas within a 15-minute RTO, which meets the requirement for the solution to have a recovery time objective of 15 minutes.

   Source: Adapted from community discussion — RajFamily25

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • azure.microsoft.com documentation

   

   Next question

2. Question 112 · 232 in bank

   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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Please, stop voting this guy up, he's not thinking, he's just copy/pasting the explanation from another exam dump. In this case it is correct that option A is "Adding a secondary replica to AG1"... I know this because I researched it. But other questions that he posts (plagiarizes) in are WRONG responses.

   Source: Adapted from community discussion — betterthanlife

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

3. Question 113 · 232 in bank

   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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   1. GP service tier and Serverless compute tier 2. Always Encrypted https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#service-tiers The General Purpose service tier is designed for common workloads. It offers budget-oriented balanced compute and storage options. https://learn.microsoft.com/en-us/azure/azure-sql/database/sql-database-paas-overview?view=azuresql#compute-tiers Serverless compute tier: auto-scales compute resources based on workload activity and bills for the amount of compute used, per second. The serverless compute tier is generally available in the General Purpose service tier, and is currently in preview in the Hyperscale service tier.

   Source: Adapted from community discussion — zellck

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

4. Question 114 · 232 in bank

   HOTSPOT - You plan to deploy the backup policy shown in the following exhibit.

   

   Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic. NOTE: Each correct selection is worth one point. Hot Area:

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Answer is correct... But what's with "minimum RPO"? When the talk RPO, doesn't make sense working with 'minimum'... Yeah, we could talk in terms of 'maximum acceptable RPO', but not 'minimum'... That's there just to confuse us and throw us off.

   Source: Adapted from community discussion — FrancisFerreira

   References

   • Microsoft Learn
   • Microsoft Learn

   

   Next question

5. Question 115 · 232 in bank

   You plan to deploy an Azure Database for MySQL flexible server named Server1 to the East US Azure region. You need to implement a business continuity solution for Server1. The solution must minimize downtime in the event of a failover to a paired region. What should you do?

   • ACreate a read replica.
   • BStore the database files in Azure premium file shares.
   • CImplement Geo-redundant backup.
   • DConfigure native MySQL replication.

   Show answer

   Answer: C

   Explanation

   It tend to differ.. Answer A seems to be possible as well. It is faster then a restore. https://learn.microsoft.com/en-us/azure/mysql/flexible-server/concepts-read-replicas#cross-region-replication-in-geo-paired-region You can create a read replica in a different region from your source server. Cross-region replication can be helpful for scenarios like disaster recovery planning or bringing data closer to your users. Azure database for MySQL Flexible Server allows you to provision read-replica in the Azure supported [geo-paired region]

   Source: Adapted from community discussion — Dumber

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   Next question

6. Question 116 · 232 in bank

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

   

   You need to recommend a load balancing solution that will distribute incoming traffic for VMSS1 across NVA1 and NVA2. The solution must minimize administrative effort. What should you include in the recommendation?

   • AGateway Load Balancer
   • BAzure Front Door
   • CAzure Application Gateway
   • DAzure Traffic Manager

   Show answer

   Answer: A

   Explanation

   Gateway Load Balancer is a SKU of the Azure Load Balancer portfolio catered for high performance and high availability scenarios with third-party Network Virtual Appliances (NVAs). With the capabilities of Gateway Load Balancer, you can easily deploy, scale, and manage NVAs. Chaining a Gateway Load Balancer to your public endpoint only requires one selection.

   Source: Adapted from community discussion — daws08322

   References

   • Microsoft Learn
   • Microsoft Learn

   Next question

7. Question 117 · 232 in bank

   HOTSPOT - You have the Azure subscriptions shown in the following table.

   

   Contoso.onmicrosft.com contains a user named User1. You need to deploy a solution to protect against ransomware attacks. The solution must meet the following requirements: • Ensure that all the resources in Sub1 are backed up by using Azure Backup. • Require that User1 first be assigned a role for Sub2 before the user can make major changes to the backup configuration. What should you create in each subscription? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   As I don't suggest asking ChatGPT for the exam answers, I went to the documentation and read it from the first hand. The provided answers look correct Source: https://learn.microsoft.com/en-us/azure/backup/multi-user-authorization

   Source: Adapted from community discussion — mykola_yakovliev

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

8. Question 118 · 232 in bank

   HOTSPOT - You have 10 on-premises servers that run Windows Server. You need to perform daily backups of the servers to a Recovery Services vault. The solution must meet the following requirements: • Back up all the files and folders on the servers. • Maintain three copies of the backups in Azure. • Minimize costs. What should you configure? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: The Microsoft Azure Recovery Services (MARS) agent The MARS agent is a free and easy-to-use agent that can be installed on Windows servers to back up files and folders to Azure. Volume Shadow Copy Service (VSS) is a Windows service that provides a snapshot of the server's file system, which is used to create consistent backups. The VSS service is already installed and enabled on Windows Server by default, so it is not necessary to select it as a configuration option. Box 2: Locally-redundant storage (LRS) LRS is the most cost-effective storage option for Azure Backup. It replicates data three times within a single data center in the primary region, which provides sufficient durability for most workloads.

   Source: Adapted from community discussion — OrangeSG

   

   Next question

9. Question 119 · 232 in bank

   HOTSPOT - You plan to deploy a containerized web-app that will be hosted in five Azure Kubernetes Service (AKS) clusters. Each cluster will be hosted in a different Azure region. You need to provide access to the app from the internet. The solution must meet the following requirements: • Incoming HTTPS requests must be routed to the cluster that has the lowest network latency. • HTTPS traffic to individual pods must be routed via an ingress controller. • In the event of an AKS cluster outage, failover time must be minimized. 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.

   

   This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

   Show the answer figure

   Answer: See figure below

   Explanation

   Box 1: Azure Front Door Both Azure Front Door and Traffic Manager are global load balancer. However, recommended traffic for Azure Front Door is HTTP(S), and recommended traffic for Traffic Manager is Non-HTTP(S). https://learn.microsoft.com/en-us/azure/architecture/guide/technology-choices/load-balancing-overview Box 2: Azure Application Gateway The Application Gateway Ingress Controller (AGIC) is a Kubernetes application, which makes it possible for Azure Kubernetes Service (AKS) customers to leverage Azure's native Application Gateway L7 load-balancer to expose cloud software to the Internet. AGIC helps eliminate the need to have another load balancer/public IP address in front of the AKS cluster and avoids multiple hops in your datapath before requests reach the AKS cluster. https://learn.microsoft.com/en-us/azure/application-gateway/ingress-controller-overview

   Source: Adapted from community discussion — OrangeSG

   References

   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn
   • Microsoft Learn

   

   Next question

10. Question 120 · 232 in bank

    HOTSPOT - You have an Azure subscription. You create a storage account that will store documents. You need to configure the storage account to meet the following requirements: • Ensure that retention policies are standardized across the subscription. • Ensure that data can be purged if the data is copied to an unauthorized location. Which two settings should you enable? To answer, select the appropriate settings in the answer area. NOTE: Each correct selection is worth one point.

    

    This is an interactive task on the real exam — a drag-and-drop, hotspot or ordering question. There is nothing to select here, so the answer is shown below for reference.

    Show the answer figure

    Answer: See figure below

    Explanation

    1, Enable operational backup with Azure Backup - can share same backup policy among multiple storage accounts 2, Enable permanent delete for soft deleted items - can delete blobs prematurely.

    Source: Adapted from community discussion — Joeylee

    References

    • Microsoft Learn
    • Microsoft Learn
    • Microsoft Learn

    

    Next question

Keyboard:J Kmove between questionsA–Dselect an answerRshow or hide the answer← →change page

AZ-305 practice, question 111. 232 questions available.