Microsoft AZ-305 Exam Actual Questions

You have 100 devices that write performance data to Azure Blob Storage.

You plan to store and analyze the performance data in an Azure SQL database.

You need to recommend a solution to continually copy the performance data to the Azure SQL database.

What should you include in the recommendation?

Show Answer Hide Answer

You need to recommend a data storage solution that meets the following requirements:

* Ensures that applications can access the data by using a REST connection

* Hosts 20 independent tables of varying sizes and usage patterns

* Automatically replicates the data to a second Azure region

* Minimizes costs

What should you recommend?

Show Answer Hide Answer

You are designing a solution that calculates 3D geometry from height-map dat

a. You need to recommend a solution that meets the following requirements:

* Performs calculations in Azure.

* Ensures that each node can communicate data to every other node.

* Maximizes the number of nodes to calculate multiple scenes as fast as possible.

* Minimizes the amount of effort to implement the solution.

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

NOTE: Each correct selection is worth one point.

Show Answer Hide Answer

You have 12 on-premises data sources that contain customer information and consist of Microsoft SQL Server, MySQL, and Oracle databases.

You have an Azure subscription.

You plan to create an Azure Data Lake Storage account that will consolidate the customer information for analysis and reporting.

You need to recommend a solution to automatically copy new information from the data sources to the Data Lake Storage account by using extract, transform and load (ETL). The solution must minimize administrative effort.

What should you include in the recommendation?

Show Answer Hide Answer

You plan to use an Azure Storage account to store data assets.

You need to recommend a solution that meets the following requirements:

* Supports immutable storage

* Disables anonymous access to the storage account

* Supports access control list (ACL)-based Azure AD permissions

What should you include in the recommendation?

Show Answer Hide Answer