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!

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 service should you recommend to host SSIS packages in Azure while allowing them to target Azure SQL Database instances?

Azure Data Catalog
SQL Server Migration Assistant (SSMS)
Data Migration Assistant
Azure Data Factory

The correct answer is: 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.