Microsoft Azure Architect Design (AZ-301) Practice Exam

Question: 1 / 400

Which service should you recommend to host SSIS packages in Azure while allowing them to target Azure SQL Database instances?

Azure Data Catalog

To host SQL Server Integration Services (SSIS) packages in Azure while enabling them to target Azure SQL Database instances, the best recommendation is to use Azure Data Factory.

Azure Data Factory provides an Integration Runtime that supports the execution of SSIS packages natively, allowing you to move and transform data in a scalable manner. It is specifically designed to orchestrate data workflows, manage data extraction, transformation, and loading (ETL) processes, and seamlessly integrates with both on-premises and Azure data services, including Azure SQL Database.

Additionally, Azure Data Factory facilitates the scheduling and monitoring of the SSIS packages and provides a more robust and efficient platform for handling data pipelines in a cloud environment compared to other services. Therefore, recommending Azure Data Factory is aligned with the need to execute SSIS packages effectively in Azure while targeting databases hosted on Azure.

Get further explanation with Examzify DeepDiveBeta

SQL Server Migration Assistant (SSMS)

Data Migration Assistant

Azure Data Factory

Next Question

Report this question

Download Microsoft Azure Architect Design (AZ-301) Practice Exam PDF Study Guide
Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy