Microsoft Azure Architect Design (AZ-301) Practice Exam

Disable ads (and more) with a membership for a one time $2.99 payment

Prepare for the Microsoft Azure Architect Design (AZ-301) Exam with interactive quizzes featuring flashcards and multiple-choice questions, each packed with hints and explanations to ace your certification test!

Start Multiple Choice Practice Test
Start Flash Cards

Each practice test/flash card set has 50 randomly selected questions from a bank of over 500. You'll get a new set of questions each time!

Practice this question and more.

Which process is recommended for regularly uploading web access log data from Azure Blob storage to Azure SQL Database?

  1. Microsoft SQL Server Migration Assistant (SSMA)

  2. Azure Data Factory

  3. Data Migration Assistant

  4. AzCopy

The correct answer is: Data Migration Assistant

The recommended process for regularly uploading web access log data from Azure Blob storage to Azure SQL Database is Azure Data Factory. Azure Data Factory is a cloud-based data integration service that allows you to create data-driven workflows for orchestrating and automating data movement and data transformation. It is specifically designed for handling various data ingestion scenarios, including the seamless transfer of large volumes of data from Blob storage to an SQL Database. With its built-in scheduling capabilities, Azure Data Factory can facilitate regular uploads, ensuring that the data stays current without requiring manual intervention. In contrast, while the other options also serve important functions within Azure, they do not specifically cater to the regular uploading of data from Blob storage to SQL databases. The SQL Server Migration Assistant and Data Migration Assistant are primarily focused on migrating databases or assessing compatibility rather than providing ongoing data transfer solutions. Similarly, AzCopy is a command-line utility designed to copy data efficiently to and from Azure Storage but lacks the orchestration and scheduling features that Azure Data Factory offers, making it less suitable for regular uploads of web access log data.

More Questions Like This