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?
Answer(s): C
Correct:* Azure Data FactoryIncorrect:* AzCopy* Data Migration Assistant (DMA* Microsoft SQL Server Migration Assistant (SSMA)* Storage MoverNote: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.
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-dot-net
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.
Answer(s): B,C
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.
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
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?
Answer(s): D
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.
https://docs.microsoft.com/en-us/azure/service-bus-messaging/service-bus-queues-topics-subscriptions
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:
Answer(s): A
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 CriticalThe 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 groupA 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.
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?
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.
https://docs.microsoft.com/en-us/azure/architecture/solution-ideas/articles/digital-media-video
Post your Comments and Discuss Microsoft AZ-305 exam prep with other Community members:
Our website is free, but we have to fight against AI bots and content theft. We're sorry for the inconvenience caused by these security measures. You can access the rest of the AZ-305 content, but please register or login to continue.