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

Carolynn

3 months 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

2 months 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

2 months ago

D) Azure Data Factory

upvoted 0 times

...

Solange

2 months ago

C) Data Migration Assistant

upvoted 0 times

...

Lashanda

2 months ago

B) Azure Data Catalog

upvoted 0 times

...

Quentin

3 months ago

A) SQL Server Migration Assistant (SSMA)

upvoted 0 times

...

Barbra

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

2 months ago

True, Azure Data Factory can help with orchestrating and managing the SSIS packages in Azure.

upvoted 0 times

...

Golda

2 months 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

3 months ago

I agree, Data Migration Assistant will help with migrating the databases to Azure SQL Database.

upvoted 0 times

...

Xochitl

3 months ago

I think Data Migration Assistant is the best option for this scenario.

upvoted 0 times

...

Jina

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

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

3 months ago

I agree, Azure Data Factory can host and run the SSIS packages in Azure.

upvoted 0 times

...

Domonique

3 months ago

D) Azure Data Factory

upvoted 0 times

...

Vallie

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