ある企業では、アプリケーションのWebアクセスログをAzure Blobストレージに保存しています。毎月末に、ログデータをAzure SQLデータベースに自動的に送信し、レポートを生成する必要があります。
この要件を満たすために、次のどれを実装しますか?
正解:A
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 ASE.
Option D is incorrect because AzCopy helps to copy data between Azure storage accounts.
Reference:
https://docs.microsoft.com/en-us/azure/data-factory/introduction