Designing Microsoft Azure Infrastructure Solutions Exam (AZ-305) - Microsoft Exam Questions

You plan to deploy an app that will use an Azure Storage account.

You need to deploy the storage account. The solution must meet the following requirements:

• Store the data of multiple users.

• Encrypt each user's data by using a separate key.

• Encrypt all the data in the storage account by using Microsoft keys or customer-managed keys.

What should you deploy?

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

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 dat

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?

HOTSPOT You are planning an Azure Storage solution for sensitive dat