Free Microsoft AZ-305 Exam Dumps Questions & Answers

You plan to migrate on-premises MySQL databases to Azure Database for MySQL Flexible Server.
You need to recommend a solution for the Azure Database for MySQL Flexible Server configuration. The solution must meet the following requirements:
* The databases must be accessible if a datacenter fails.
* Costs must be minimized.
Which compute tier should you recommend?

• A.  Memory Optimized
• B.  General Purpose
• C.  Burstable

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:
* The files must be available within 24 hours of being requested.
* 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 file share in the storage account and copy the files to the file share.
• B.  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.
• C.  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.
• D.  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.
• E.  Create a general-purpose v1 storage account. Create a blob container and copy the files to the blob container.

You plan to deploy an Azure SQL database that will store Personally Identifiable Information (Pll). You need to ensure that only privileged users can view the Pll.
What should you include in the solution?

• A.  Data Discovery & Classification
• B.  role-based access control (RBAC)
• C.  dynamic data masking
• D.  Transparent Data Encryption (TDE)

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.  Always On availability groups
• B.  Azure virtual machines that run Microsoft SQL Server servers
• C.  Azure SQL Database Managed instance
• D.  virtual network (VNET) service endpoint

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 stored access policy
• B.  Azure Service Bus queues with partitioning enabled
• C.  storage queues with a custom metadata setting
• D.  Azure Service Bus queues with sessions enabled