Practice Free AZ-305 Exam Online Questions

Your company has an app named App1 that uses data from the on-premises Microsoft SQL Server databases shown in the following table.

App1 and the data are used on the first day of the month only. The data is not expected to grow more than 3% each year.

The company is rewriting App1 as an Azure web app and plans to migrate all the data to Azure.

You need to migrate the data to Azure SQL Database. The solution must minimize costs.

Which service tier should you use?

Reveal Solution Hide Solution

You ate designing a SQL database solution. The solution will include 20 databases that will be 20 GB each and have varying usage patterns. You need to recommend a database platform to host the databases.

The solution must meet the following requirements:

• The compute resources allocated to the databases must scale dynamically.

• The solution must meet an SLA of 99.99% uptime.

• The solution must have reserved capacity.

• Compute charges must be minimized.

What should you include in the recommendation?

Reveal Solution Hide Solution

You have an Azure subscription that contains an Azure App Service app named App1 in a Standard App Service plan. App1 is accessed directly from the internet by using the following URL: https://app 1. contoso.com. The Azure region that hosts App1 supports availability zones for App Service apps.

You need to recommend a redundancy solution for App 1.

The solution must meet the following requirements:

• Ensure that App1 is available if two availability zones fail.

• Minimize administrative effort.

• Minimize costs.

What should you recommend?

Reveal Solution Hide Solution

You are designing a message application that will run on an on-premises Ubuntu virtual machine.

The application will use Azure Storage queues.

You need to recommend a processing solution for the application to interact with the storage queues.

The solution must meet the following requirements:

✑ Create and delete queues daily.

✑ Be scheduled by using a CRON job.

✑ Upload messages every five minutes.

What should developers use to interact with the queues?

Reveal Solution Hide Solution

HOTSPOT

You plan to deploy a custom database solution that will have multiple instances as shown in the following table.

Client applications will access database servers by using db.contoso.com.

You need to recommend load balancing services for the planned deployment.

The solution must meet the following requirements:

✑ Access to at least one database server must be maintained in the event of a regional outage.

✑ The virtual machines must not connect to the internet directly.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Azure Traffic Manager

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. Because Traffic Manager is a DNS-based load-balancing service, it load balances only at the domain level. For that reason, it can’t fail over as quickly as Front Door, because of common challenges around DNS caching and systems not honoring DNS TTLs.

Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/load-balancing-overview

You have an Azure subscription that contains a Basic Azure virtual WAN named Virtual/WAN1 and the virtual hubs shown in the following table.

You have an ExpressRoute circuit in the US East region.

You need to create an ExpressRoute association to VirtualWAN1.

What should you do first?

Reveal Solution Hide Solution

You have an app named App1 that uses two on-premises Microsoft SQL Server databases named DB1 and DB2.

You plan to migrate DB1 and DB2 to Azure.

You need to recommend an Azure solution to host DB1 and DB2.

The solution must meet the following requirements:

• Support server-side transactions across DB1 and DB2.

• Minimize administrative effort to update the solution.

What should you recommend?

Reveal Solution Hide Solution

You plan to archive 10 TB of on-premises data files to Azure.

You need to recommend a data archival solution. The solution must minimize the cost of storing the data files.

Which Azure Storage account type should you include in the recommendation?

Reveal Solution Hide Solution

DRAG DROP

You have an on-premises app named App1.

Customers use App1 to manage digital images.

You plan to migrate App1 to Azure.

You need to recommend a data storage solution for Appl.

The solution must meet the following image storage requirements:

• Encrypt images at rest.

• Allow files up to 50 MB.

• Manage access to the images by using Azure Web Application Firewall (WAF) on Azure Front Door.

The solution must meet the following customer account requirements:

• Support automatic scale out of the storage.

• Maintain the availability of App1 if a datacenter fails.

• Support reading and writing data from multiple Azure regions.

Which service should you include in the recommendation for each type of data? To answer, drag the appropriate services to the correct type of data. 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.

Reveal Solution Hide Solution

Correct Answer:

You have to design a Data Engineering solution for your company. The company currently has an Azure subscription. They also have application data hosted in a database on a Microsoft SQL Server hosted in their on-premises data center server. They want to implement the following requirements Transfer transactional data from the on-premises SQL server onto a data warehouse in Azure. Data needs to be transferred every day in the night as a scheduled job

A managed Spark cluster needs to be in place for data engineers to perform analysis on the data stored in the SQL data warehouse. Here the data engineers should have the ability to develop notebooks in Scale, R and Python.

They also need to have a data lake store in place for the ingestion of data from multiple data sources Which of the following would the use for hosting the data warehouse in Azure?

Reveal Solution Hide Solution