Free AZ-305 Exam Braindumps
Designing Microsoft Azure Infrastructure Solutions Questions 10–14 (page: 26)

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. Storage Mover
  2. Microsoft SQL Server Migration Assistant (SSMA)
  3. Azure Data Factory
  4. AzCopy

Answer(s): C

Explanation:

Correct:
* Azure Data Factory
Incorrect:
* AzCopy
* Data Migration Assistant (DMA
* Microsoft SQL Server Migration Assistant (SSMA)
* Storage Mover
Note:
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 that contains an Azure Blob Storage account named store1.
You have an on-premises file server named Server1 that runs Windows Server. Server1 stores 500 GB of company files.
You need to store a copy of the company files from Server1 in store1.
Which two possible Azure services achieve this goal? Each correct answer presents a complete solution.
Note: Each correct selection is worth one point.

  1. an Azure Logic Apps integration account
  2. an Azure Import/Export job
  3. Azure Data Factory
  4. an Azure Analysis services On-premises data gateway
  5. an Azure Batch account

Answer(s): B,C

Explanation:

B: You can use the Azure Import/Export service to securely export large amounts of data from Azure Blob storage. The service requires you to ship empty drives to the Azure datacenter. The service exports data from your storage account to the drives and then ships the drives back.
C: Big data requires a service that can orchestrate and operationalize processes to refine these enormous stores of raw data into actionable business insights. Azure Data Factory is a managed cloud service that's built for these complex hybrid extract-transform-load (ETL), extract-load-transform (ELT), and data integration projects.


Reference:

https://docs.microsoft.com/en-us/azure/storage/common/storage-import-export-data-from-blobs https://docs.microsoft.com/en-us/azure/data-factory/introduction



View Related Case Study

You have an Azure subscription that contains two applications named App1 and App2. App1 is a sales processing application.
When a transaction in App1 requires shipping, a message is added to an Azure Storage account queue, and then App2 listens to the queue for relevant transactions.
In the future, additional applications will be added that will process some of the shipping requests based on the specific details of the transactions.
You need to recommend a replacement for the storage account queue to ensure that each additional application will be able to read the relevant transactions.
What should you recommend?

  1. one Azure Data Factory pipeline
  2. multiple storage account queues
  3. one Azure Service Bus queue
  4. one Azure Service Bus topic

Answer(s): D

Explanation:

A queue allows processing of a message by a single consumer. In contrast to queues, topics and subscriptions provide a one-to-many form of communication in a publish and subscribe pattern. It's useful for scaling to large numbers of recipients. Each published message is made available to each subscription registered with the topic. Publisher sends a message to a topic and one or more subscribers receive a copy of the message, depending on filter rules set on these subscriptions.


Reference:

https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-queues-topics-subscriptions



View Related Case Study

HOTSPOT (Drag and Drop is not supported)
You have an on-premises Microsoft SQL Server database named DB1.
You have an Azure subscription.
You need to migrate DB1 to an Azure SQL managed instance. The solution must meet the following requirements:
-Support offloading read-only workloads to secondary replicas.
-Provide resiliency in the event of an Azure region outage.
-Support up to 16 TB of storage.
-Minimize costs.
Which service tier and feature should you include in the solution? 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:




To meet the requirements for migrating DB1 to an Azure SQL Managed Instance, the following service tier and feature should be selected:
Service Tier - Business Critical
The Business Critical tier allows for read scale-out, enabling offloading of read-only workloads to secondary replicas. It also provides high availability with replication across multiple zones and support for up to 16 TB of storage. This ensures resiliency in case of a region outage, as needed in the solution.
Feature - Failover group
A Failover group provides automatic failover of a managed instance between different regions, ensuring that the solution remains available in the event of an Azure region outage. It supports geo-replication and enhances disaster recovery capabilities, which aligns with the resiliency requirement.



View Related Case Study

You are designing an application that will be hosted in Azure.
The application will host video files that range from 50 MB to 12 GB. The application will use certificate-based authentication and will be available to users on the internet.
You need to recommend a storage option for the video files. The solution must provide the fastest read performance and must minimize storage costs.
What should you recommend?

  1. Azure Files
  2. Azure Data Lake Storage Gen2
  3. Azure Blob Storage
  4. Azure SQL Database

Answer(s): C

Explanation:

Blob Storage: Stores large amounts of unstructured data, such as text or binary data, that can be accessed from anywhere in the world via HTTP or HTTPS. You can use Blob storage to expose data publicly to the world, or to store application data privately.
Max file in Blob Storage. 4.77 TB.


Reference:

https://docs.microsoft.com/en-us/azure/architecture/solution-ideas/articles/digital-media-video



Viewing page 26 of 78
Viewing questions 126 - 130 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!