Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft AZ-305 Exam - Topic 3 Question 78 Discussion

You have 100 Microsoft SQL Server integration Services (SSIS) packages that are configured to use 10 on-premises SQL Server databases as their destinations.You plan to migrate the 10 on-premises databases to Azure SQL DatabaseYou need to recommend a solution to host the SSlS packages in Azure. The solution must ensure that the packages can target the SQL Database instances as their destinations.What should you include in the recommendation?
A) SQL Server Migration Assistant (SSMA)
B) Azure Data Catalog
C) Data Migration Assistant
D) Azure Data Factory

Microsoft AZ-305 Exam - Topic 3 Question 78 Discussion

Actual exam question for Microsoft's AZ-305 exam
Question #: 78
Topic #: 3
[All AZ-305 Questions]

You have 100 Microsoft SQL Server integration Services (SSIS) packages that are configured to use 10 on-premises SQL Server databases as their destinations.

You plan to migrate the 10 on-premises databases to Azure SQL Database

You need to recommend a solution to host the SSlS packages in Azure. The solution must ensure that the packages can target the SQL Database instances as their destinations.

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: A

by Cecil at Mar 21, 2025, 11:25 PM

Limited Time Offer

25%

Off

Get Premium AZ-305 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Alfreda
9 months ago
Definitely Azure Data Factory! It integrates well with SQL Database.
upvoted 0 times
...
Lorenza
10 months ago
I think SSMA is more suited for migrations, not hosting.
upvoted 0 times
...
Carin
10 months ago
Wait, can SSIS packages even run in Azure without a VM?
upvoted 0 times
...
Una
10 months ago
I disagree, Data Migration Assistant is not for hosting SSIS packages.
upvoted 0 times
...
Gearldine
10 months ago
Azure Data Factory is the way to go for SSIS in Azure!
upvoted 0 times
...
Tish
10 months ago
I thought Azure Data Catalog was more about data governance and not really for running SSIS packages, but I could be wrong.
upvoted 0 times
...
Louvenia
11 months ago
I feel like we had a similar practice question about migrating SSIS to the cloud, and Azure Data Factory was mentioned as a solution.
upvoted 0 times
...
Kattie
11 months ago
I'm not entirely sure, but I think SQL Server Migration Assistant is more for migrating databases rather than hosting SSIS packages.
upvoted 0 times
...
Loreen
11 months ago
I remember we discussed Azure Data Factory in class as a way to orchestrate data workflows, so I think that might be the right choice here.
upvoted 0 times
...
Emmanuel
11 months ago
I've worked with Azure Data Factory before, and I think that might be the best solution here. It can handle the migration of the databases and the integration with the SSIS packages.
upvoted 0 times
...
Nan
12 months ago
I'm a bit confused by the options. I'll need to review the differences between SSMA, Azure Data Catalog, Data Migration Assistant, and Azure Data Factory to decide which one is the most appropriate.
upvoted 0 times
...
Simona
12 months ago
Okay, I think I have a strategy here. I'll need to evaluate the different Azure services mentioned and determine which one best fits the requirements.
upvoted 0 times
...
Lorrine
12 months ago
Hmm, this looks like a tricky one. I'll need to think carefully about the best way to migrate the SSIS packages and databases to Azure.
upvoted 0 times
...
Carolynn
1 year ago
Azure Data Factory? More like Azure Data Bakery, amirite? *winks* Seriously though, it's the best option to keep those SSIS packages happy in the cloud.
upvoted 0 times
Albina
1 year ago
Azure Data Factory? More like Azure Data Bakery, amirite? *winks* Seriously though, it's the best option to keep those SSIS packages happy in the cloud.
upvoted 0 times
...
Wilford
1 year ago
D) Azure Data Factory
upvoted 0 times
...
Solange
1 year ago
C) Data Migration Assistant
upvoted 0 times
...
Lashanda
1 year ago
B) Azure Data Catalog
upvoted 0 times
...
Quentin
1 year ago
A) SQL Server Migration Assistant (SSMA)
upvoted 0 times
...
...
Barbra
1 year ago
Ah, the old 'migrate on-prem to Azure' conundrum. Data Factory is the way to go, my friend. Smooth sailing from here on out!
upvoted 0 times
Lenna
1 year ago
True, Azure Data Factory can help with orchestrating and managing the SSIS packages in Azure.
upvoted 0 times
...
Golda
1 year ago
But don't forget about Azure Data Factory, it can also be used to host the SSIS packages in Azure.
upvoted 0 times
...
Sylvia
1 year ago
I agree, Data Migration Assistant will help with migrating the databases to Azure SQL Database.
upvoted 0 times
...
Xochitl
1 year ago
I think Data Migration Assistant is the best option for this scenario.
upvoted 0 times
...
...
Jina
1 year ago
Whoa, 100 SSIS packages? That's a lot of work to migrate! I'd definitely go with Azure Data Factory. It's built for this kind of thing.
upvoted 0 times
...
Remona
1 year ago
I'm not sure SSMA or the Data Migration Assistant are the right tools for this scenario. We need something that can manage and run the SSIS packages, not just migrate the databases.
upvoted 0 times
Domonique
1 year ago
I agree, Azure Data Factory can host and run the SSIS packages in Azure.
upvoted 0 times
...
Domonique
1 year ago
D) Azure Data Factory
upvoted 0 times
...
...
Vallie
1 year ago
Azure Data Factory seems like the obvious choice here. It can seamlessly integrate with Azure SQL Database and handle the SSIS packages without any issues.
upvoted 0 times
Vashti
1 year ago
I don't think SSMA is the best choice here, Azure Data Factory is specifically designed for handling SSIS packages in Azure.
upvoted 0 times
...
Colton
1 year ago
Wouldn't SQL Server Migration Assistant (SSMA) also be a good option for this scenario?
upvoted 0 times
...
Fanny
1 year ago
Agreed, Azure Data Factory can easily handle the migration of the on-premises databases to Azure SQL Database.
upvoted 0 times
...
Carline
1 year ago
I think Azure Data Factory would be the best option for hosting the SSIS packages in Azure.
upvoted 0 times
...
Von
1 year ago
D) Azure Data Factory
upvoted 0 times
...
Natalie
1 year ago
C) Data Migration Assistant
upvoted 0 times
...
Jani
1 year ago
B) Azure Data Catalog
upvoted 0 times
...
Mireya
1 year ago
A) SQL Server Migration Assistant (SSMA)
upvoted 0 times
...
...
Luis
1 year ago
I also think Azure Data Factory is the best option. It can easily target the SQL Database instances as their destinations.
upvoted 0 times
...
Brynn
1 year ago
I agree with Eladia. Azure Data Factory can help us host the SSIS packages in Azure.
upvoted 0 times
...
Eladia
1 year ago
I think we should include Azure Data Factory in the recommendation.
upvoted 0 times
...

Save Cancel