Free AZ-305 Exam Braindumps
Designing Microsoft Azure Infrastructure Solutions Questions 25–29 (page: 29)

Updated On: 16-Nov-2026
View Related Case Study

You store web access logs data in Azure Blob Storage.
You plan to generate monthly reports from the access logs.
You need to recommend an automated process to upload the data to Azure SQL Database every month.
What should you include in the recommendation?

  1. Microsoft SQL Server Migration Assistant (SSMA)
  2. Data Migration Assistant (DMA)
  3. AzCopy
  4. Azure Data Factory

Answer(s): D

Explanation:

You can create Data Factory pipelines that copies data from Azure Blob Storage to Azure SQL Database. The configuration pattern applies to copying from a file-based data store to a relational data store.
Required steps:
Create a data factory.
Create Azure Storage and Azure SQL Database linked services.
Create Azure Blob and Azure SQL Database datasets.
Create a pipeline contains a Copy activity.
Start a pipeline run.
Monitor the pipeline and activity runs.


Reference:

https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-net



View Related Case Study

You have an Azure subscription.
You plan to deploy an Azure SQL database named DB1 that will store the maximum daily temperature.
You need to recommend a solution to query an external website, retrieve the maximum temperature from the previous 24 hours, and write the temperature to DB1. The solution should minimize costs, development effort, and administrative effort.
What should you include in the recommendation?

  1. an Azure Batch job
  2. an Azure event hub
  3. an Azure container instance
  4. an Azure function

Answer(s): D

Explanation:

You can connect Azure Functions to Azure SQL Database using Visual Studio Code.
Azure Functions lets you connect Azure services and other resources to functions without having to write your own integration code. These bindings, which represent both input and output, are declared within the function definition. Data from bindings is provided to the function as parameters. A trigger is a special type of input binding. Although a function has only one trigger, it can have multiple input and output bindings.


Reference:

https://learn.microsoft.com/en-us/azure/azure-functions/functions-add-output-binding-azure-sql-vs-code



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You plan to use Azure SQL as a database platform.
You need to recommend an Azure SQL product and service tier that meets the following requirements:
● Automatically scales compute resources based on the workload demand
● Provides per second billing
What should you recommend? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: A single Azure SQL Database
Azure SQL product
Serverless is a compute tier for single databases in Azure SQL Database that automatically scales compute based on workload demand and bills for the amount of compute used per second.
The serverless compute tier for single databases in Azure SQL Database is parameterized by a compute autoscaling range and an auto-pause delay.
Box 2: General Purpose
Service tier
The serverless compute tier is available in the General Purpose service tier and currently in preview in the Hyperscale service tier.


Reference:

https://learn.microsoft.com/en-us/azure/azure-sql/database/serverless-tier-overview



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You need to design a storage solution for an app that will store large amounts of frequently used data. The solution must meet the following requirements:
-Maximize data throughput.
-Prevent the modification of data for one year.
-Minimize latency for read and write operations.
Which Azure Storage account type and storage service should you recommend? To answer, select the appropriate options in the answer area.
Note: Each correct selection is worth one point.
Hot Area:

  1. See Explanation section for answer.

Answer(s): A

Explanation:



Box 1: BlockBlobStorage
Block Blob is a premium storage account type for block blobs and append blobs. Recommended for scenarios with high transactions rates, or scenarios that use smaller objects or require consistently low storage latency.
Box 2: Blob
Immutable storage for Azure Blob Storage enables users to store business-critical data in a WORM (Write Once, Read Many) state.
While in a WORM state, data cannot be modified or deleted for a user-specified interval. By configuring immutability policies for blob data, you can protect your data from overwrites and deletes.


Reference:

https://docs.microsoft.com/en-us/azure/storage/blobs/archive-blob https://docs.microsoft.com/en-us/azure/storage/blobs/immutable-storage-overview



View Related Case Study

You have 100 servers that run Windows Server and host Microsoft SQL Server 2014 instances. The instances host databases that have the following characteristics:
-Stored procedures are implemented by using CLR.
-The largest database is currently 3 TB. None of the databases will ever exceed 4 TB.
You plan to move all the data from SQL Server to Azure.
You need to recommend a service to host the databases. The solution must meet the following requirements:
-Whenever possible, minimize management overhead for the migrated databases.
-Ensure that users can authenticate by using Azure AD credentials.
-Minimize the number of database changes required to facilitate the migration.
What should you include in the recommendation?

  1. Azure SQL Database elastic pools
  2. Azure SQL Managed Instance
  3. Azure SQL Database single databases
  4. SQL Server 2016 on Azure virtual machines

Answer(s): B

Explanation:

SQL Managed Instance allows existing SQL Server customers to lift and shift their on-premises applications to the cloud with minimal application and database changes. At the same time, SQL Managed Instance preserves all PaaS capabilities (automatic patching and version updates, automated backups, high availability) that drastically reduce management overhead and TCO.


Reference:

https://docs.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance



Viewing page 29 of 78
Viewing questions 141 - 145 out of 382 questions


Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!