Microsoft Exam AZ-305 Topic 3 Question 78 Discussion

Actual exam question for Microsoft's AZ-305 exam

Question #: 78
Topic #: 3

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?

ASQL Server Migration Assistant (SSMA)

BAzure Data Catalog

CData Migration Assistant

DAzure Data Factory

Show Suggested 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:

Submit Cancel

Barbra

4 days 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

...

Jina

7 days 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

12 days 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

...

Vallie

15 days 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