A company stores web access logs for an application in Azure Blob storage. At the end of each month, the log data must be automatically sent to an Azure SQL database for report generation. Which of…

Question

Options

• AAzure Data Factory
• BData Migration Assistant
• CMicrosoft SQL Server Migration Assistant (SSMA)
• DAzCopy

• A
  71% (35)
• B
  14% (7)
• C
  4% (2)
• D
  10% (5)

Explanation

Azure Data Factory is managed cloud service for extract-transform-load (ETL), extract-load- transform (ELT), and data integration operations. With Azure Data Factory, you can create a data pipeline. A data pipeline is a logical group of activities (steps) that perform a unit of work. Each activity consists of tasks. You can implement the data pipeline to transfer data from Azure Blob storage to an Azure SQL database. It can also run based on a schedule. Option B is incorrect because Data Migration Assistant helps assess compatibility issues when upgrading your data store to a newer version of SQL Server or Azure SQL database. Option C is incorrect because Microsoft SQL Server Migration Assistant (SSMA) helps automate the database migration to SQL Server from Microsoft Access, DB2, MySQL, Oracle, and SAP Option D is incorrect because AzCopy helps to copy data between Azure storage accounts. https://docs.microsoft.com/en-us/azure/data-factory/introduction

No community discussion yet for this question.