Microsoft Microsoft Certifications AZ-305 Questions & Answers

• Question 151:

  You have a multi-tier app named Appl and an Azure SQL database named SQL l. The backend service Of Appl writes data to Users use the Appl client to read the data from SQL 1.

  During periods of high utilization the users experience delays retrieving the data.

  You need to minimize how long it takes for data requests.

  What should you include in the solution?

  A. Azure Synapse Analytics

  B. Azure Content Delivery Network (CON)

  C. Azure Data Factory

  D. Azure Cache for Redis

  Correct Answer: D

• Question 152:

  You have an Azure Active Directory (Azure AD) tenant that syncs with an on-premises Active Directory domain.

  Your company has a line-of-business (LOB) application that was developed internally.

  You need to implement. SAML single sign-on (SSO) and enforce multi-factor authentication (MFA) when users attempt to access the application from an unknown location.

  Which two features should you include in the solution? Each correct answer presents part of the solution.

  NOTE: Each correct selection is worth one point.

  A. Azure AD enterprise applications

  B. Azure AD Identity Protection

  C. Azure Application Gateway

  D. Conditional Access policies

  E. Azure AD Privileged Identity Management (PIM)

  Correct Answer: AD

• Question 153:

  You plan to deploy an application named App1 that will run in containers on Azure Kubernetes Service (AKS) clusters.

  The AKS clusters will be distributed across four Azure regions.

  You need to recommend a storage solution to ensure that updated container images are replicated automatically to all the Azure regions hosting the AKS clusters.

  Which storage solution should you recommend?

  A. Azure Cache for Redis

  B. Premium SKU Azure Container Registry

  C. Azure Content Delivery Network (CON)

  D. geo-redundant storage (GRS) accounts

  Correct Answer: B

• Question 154:

  Your company has the divisions shown m the following table.

  

  Sub1 contains an Azure App Service web app named App1. Appl uses Azure AD for single-tenant user authentication. Users from contoso.com can authenticate to App1.

  You need to recommend a solution to enable users in the fabrikam.com tenant to authenticate to App1.

  What should you recommend?

  A. Enable Azure AD pass-through authentication and update the sign-in endpoint

  B. Configure the Azure AD provisioning service.

  C. Configure assignments tor the fabnkam.com users by using Azure AD Privileged Identity Management (PIM).

  D. Use Azure AD entitlement management to govern external users.

  Correct Answer: D

• Question 155:

  You are designing an app that will include two components. The components will communicate by sending messages via a queue.

  You need to recommend a solution to process the messages by using a First in. First out (FIFO) pattern.

  What should you include in the recommendation?

  A. storage queues with a custom metadata setting

  B. Azure Service Bus queues with sessions enabled

  C. Azure Service Bus queues with partitioning enabled

  D. storage queues with a stored access policy

  Correct Answer: B

• Question 156:

  You use Azure virtual machines to run a custom application that uses an Azure SQL database on the back end.

  The IT apartment at your company recently enabled forced tunneling.

  Since the configuration change, developers have noticed degraded performance when they access the database

  You need to recommend a solution to minimize latency when accessing the database. The solution must minimize costs

  What should you include in the recommendation?

  A. Azure SQL Database Managed instance

  B. Azure virtual machines that run Microsoft SQL Server servers

  C. Always On availability groups

  D. virtual network (VNET) service endpoint

  Correct Answer: D

  https://docs.microsoft.com/en-us/azure/virtual-network/virtual-network-service-endpoints-overview

• Question 157:

  You have an on-premises Microsoft SQL server named SQLI that hosts 50 databases.

  You plan to migrate SQL 1 to Azure SQL Managed Instance.

  You need to perform an offline migration of SQL 1. The solution must minimize administrative effort.

  What should you include in the solution?

  A. SQL Server Migration Assistant (SSMA)

  B. Azure Migrate

  C. Data Migration Assistant (DMA)

  D. Azure Database Migration Service

  Correct Answer: D

  This Azure service supports migration in the offline mode for applications that can afford downtime during the migration process. Unlike the continuous migration in online mode, offline mode migration runs a one-time restore of a full database backup from the source to the target https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/managed-instance/sql- server-to- managed-instance-overview?view=azuresql#compare-migration-options

• Question 158:

  You plan to migrate data to Azure.

  The IT department at your company identifies the following requirements:

  1.

  The storage must support 1 PB of data.

  2.

  The data must be stored in blob storage.

  3.

  The storage must support three levels of subfolders.

  4.

  The storage must support access control lists (ACLs).

  You need to meet the requirements.

  What should you use?

  A. a premium storage account that is configured for block blobs

  B. a general purpose v2 storage account that has hierarchical namespace enabled

  C. a premium storage account that is configured for page blobs

  D. a premium storage account that is configured for files shares and supports large file shares

  Correct Answer: B

  Microsoft recommends that you use a GPv2 storage account for most scenarios. It supports up to 5 PB, and blob storage including Data Lake storage.

  Note: A key mechanism that allows Azure Data Lake Storage Gen2 to provide file system performance at object storage scale and prices is the addition of a hierarchical namespace. This allows the collection of objects/files within an account to be organized into a hierarchy of directories and nested subdirectories in the same way that the file system on your computer is organized. With a hierarchical namespace enabled, a storage account becomes capable of providing the scalability and cost-effectiveness of object storage, with file system semantics that are familiar to analytics engines and frameworks.

  References: https://docs.microsoft.com/en-us/azure/storage/common/storage-account-overview https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

• Question 159:

  You have an Azure subscription.

  Your on-premises network contains a file server named Server1. Server 1 stores 5 TB of company files that are accessed rarely.

  You plan to copy the files to Azure Storage.

  You need to implement a storage solution for the files that meets the following requirements:

  1.

  The files must be available within 24 hours of being requested.

  2.

  Storage costs must be minimized.

  Which two possible storage solutions achieve this goal?

  Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

  A. Create a general-purpose v1 storage account. Create a blob container and copy the files to the blob container.

  B. Create a general-purpose v2 storage account that is configured for the Hot default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.

  C. Create a general-purpose v1 storage account. Create a file share in the storage account and copy the files to the file share.

  D. Create a general-purpose v2 storage account that is configured for the Cool default access tier. Create a file share in the storage account and copy the files to the file share.

  E. Create an Azure Blob storage account that is configured for the Cool default access tier. Create a blob container, copy the files to the blob container, and set each file to the Archive access tier.

  Correct Answer: BE

  https://docs.microsoft.com/en-us/azure/storage/blobs/manage-access- tier?tabs=portal

• Question 160:

  You have an Azure Data Lake Storage account that contains 1,000 10-MB CSV files and an Azure Synapse Analytics dedicated SQL pool named sql1. You need to load the files to sql1. The solution must meet the following requirements:

  1.

  Maximize data load performance.

  2.

  Eliminate the need to define external tables before the data loads. What should you use?

  A. the copy statement

  B. PolyBase

  C. BCP

  D. the sqlBulkcopy object

  Correct Answer: B