Free AZ-305 Dump

Topic 3 – Question Set 3

Question #1Topic 3

You have SQL Server on an Azure virtual machine. The databases are written to nightly as part of a batch process.

You need to recommend a disaster recovery solution for the data. The solution must meet the following requirements:

✑ Provide the ability to recover in the event of a regional outage.

✑ Support a recovery time objective (RTO) of 15 minutes.

✑ Support a recovery point objective (RPO) of 24 hours.

✑ Support automated recovery.

✑ Minimize costs.

What should you include in the recommendation?

• A. Azure virtual machine availability sets
• B. Azure Disk Backup
• C. an Always On availability group
• D. Azure Site Recovery

Correct Answer: D

Replication with Azure Site Recover:

✑ RTO is typically less than 15 minutes.

✑ RPO: One hour for application consistency and five minutes for crash consistency.

Incorrect Answers:

B: Too slow.

C: Always On availability group RPO: Because replication to the secondary replica is asynchronous, there’s some data loss.

Reference:

https://docs.microsoft.com/en-us/azure/site-recovery/site-recovery-sql

Community vote distribution

D (82%)

C (18%)

Question #2Topic 3

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:

Correct Answer: 

Question #3Topic 3

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 two Azure virtual machines to two Azure regions, and you create an Azure Traffic Manager profile.

Does this meet the goal?

• A. Yes
• B. No

Correct Answer: A

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.

Community vote distribution

A (100%)

Question #4Topic 3

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 two Azure virtual machines to two Azure regions, and you deploy an Azure Application Gateway.

Does this meet the goal?

• A. Yes
• B. No

Correct Answer: B

App Gateway will balance the traffic between VMs deployed in the same region. Create an Azure Traffic Manager profile instead.

Community vote distribution

B (100%)

Question #5Topic 3

HOTSPOT –

You plan to create an Azure Storage account that will host file shares. The shares will be accessed from on-premises applications that are transaction intensive.

You need to recommend a solution to minimize latency when accessing the file shares. The solution must provide the highest-level of resiliency for the selected storage tier.

What should you include in the recommendation? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Correct Answer: 

Box 1: Premium –

Premium: Premium file shares are backed by solid-state drives (SSDs) and provide consistent high performance and low latency, within single-digit milliseconds for most IO operations, for IO-intensive workloads.

Incorrect Answers:

✑ Hot: Hot file shares offer storage optimized for general purpose file sharing scenarios such as team shares. Hot file shares are offered on the standard storage hardware backed by HDDs.

✑ Transaction optimized: Transaction optimized file shares enable transaction heavy workloads that don’t need the latency offered by premium file shares.

Transaction optimized file shares are offered on the standard storage hardware backed by hard disk drives (HDDs). Transaction optimized has historically been called “standard”, however this refers to the storage media type rather than the tier itself (the hot and cool are also “standard” tiers, because they are on standard storage hardware).

Box 2: Zone-redundant storage (ZRS):

Premium Azure file shares only support LRS and ZRS.

Zone-redundant storage (ZRS): With ZRS, three copies of each file stored, however these copies are physically isolated in three distinct storage clusters in different Azure availability zones.

Reference:

https://docs.microsoft.com/en-us/azure/storage/files/storage-files-planning

Question #6Topic 3

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 an Azure virtual machine scale set that uses autoscaling.

Does this meet the goal?

• A. Yes
• B. No

Correct Answer: B

Instead, you should deploy two Azure virtual machines to two Azure regions, and you create a 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

Community vote distribution

B (100%)

Question #7Topic 3

HOTSPOT –

You need to recommend an Azure Storage account configuration for two applications named Application1 and Application2. The configuration must meet the following requirements:

✑ Storage for Application1 must provide the highest possible transaction rates and the lowest possible latency.

✑ Storage for Application2 must provide the lowest possible storage costs per GB.

✑ Storage for both applications must be available in an event of datacenter failure.

✑ Storage for both applications must be optimized for uploads and downloads.

What should you recommend? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Correct Answer: 

Box 1: BlobStorage with Premium Performance,ג€¦

Application1 requires high transaction rates and the lowest possible latency. We need to use Premium, not Standard.

Box 2: General purpose v2 with Standard Performance,..

General Purpose v2 provides access to the latest Azure storage features, including Cool and Archive storage, with pricing optimized for the lowest GB storage prices. These accounts provide access to Block Blobs, Page Blobs, Files, and Queues. Recommended for most scenarios using Azure Storage.

Reference:

https://docs.microsoft.com/en-us/azure/storage/common/storage-account-upgrade

Question #8Topic 3

HOTSPOT –

You plan to develop a new app that will store business critical data. The app must meet the following requirements:

✑ Prevent new data from being modified for one year.

✑ Maximize data resiliency.

✑ Minimize read latency.

What storage solution should you recommend for the app? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Correct Answer: 

Box 1: Standard general-purpose v2

Standard general-purpose v2 supports immutable storage.

In general Standard general-purpose v2 is the preferred Microsoft recommendation.

Box 2: Zone-redundant storage (ZRS)

ZRS is more resilient compared to LRS.

Note: RA-GRS is even more resilient, but it is not an option here.

Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-immutable-storage

Question #9Topic 3

You plan to deploy 10 applications to Azure. The applications will be deployed to two Azure Kubernetes Service (AKS) clusters. Each cluster will be deployed to a separate Azure region.

The application deployment must meet the following requirements:

✑ Ensure that the applications remain available if a single AKS cluster fails.

✑ Ensure that the connection traffic over the internet is encrypted by using SSL without having to configure SSL on each container.

Which service should you include in the recommendation?

• A. Azure Front Door
• B. Azure Traffic Manager
• C. AKS ingress controller
• D. Azure Load Balancer

Correct Answer: A

Azure Front Door supports SSL.

Azure Front Door, which focuses on global load-balancing and site acceleration, and Azure CDN Standard, which offers static content caching and acceleration.

The new Azure Front Door brings together security with CDN technology for a cloud-based CDN with threat protection and additional capabilities.

Reference:

https://docs.microsoft.com/en-us/azure/frontdoor/front-door-overview

Community vote distribution

A (91%)

7%

Question #10Topic 3

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:

Correct Answer: 

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 #11Topic 3

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:

Correct Answer: 

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 #12Topic 3

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:

Correct Answer: 

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 #13Topic 3

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?

• A. Azure SQL Managed Instance Business Critical
• B. Azure SQL Database Premium
• C. Azure SQL Database Basic
• D. Azure SQL Managed Instance General Purpose

Correct Answer: D

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

Community vote distribution

B (100%)

Question #14Topic 3

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?

• A. Azure SQL Managed Instance Business Critical
• B. Azure SQL Database Premium
• C. Azure SQL Database Basic
• D. Azure SQL Database Hyperscale

Correct Answer: B

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

Community vote distribution

B (100%)

Question #15Topic 3

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?

• A. Yes
• B. No

Correct Answer: B

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

Community vote distribution

B (100%)

Question #16Topic 3

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?

• A. Azure SQL Database Serverless
• B. Azure SQL Database Business Critical
• C. Azure SQL Database Basic
• D. Azure SQL Database Standard

Correct Answer: A

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/

Community vote distribution

B (55%)

A (45%)

Question #17Topic 3

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.

Correct Answer: 

Question #18Topic 3

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.

Correct Answer: 

Question #19Topic 3

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.

Correct Answer: 

Question #20Topic 3

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?

• A. Create a read replica.
• B. Store the database files in Azure premium file shares.
• C. Implement Geo-redundant backup.
• D. Configure native MySQL replication.

Correct Answer: C

Community vote distribution

C (77%)

A (23%)