Microsoft AZ-305 Exam - 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

Alfreda

3 months ago

Definitely Azure Data Factory! It integrates well with SQL Database.

upvoted 0 times

...

Lorenza

3 months ago

I think SSMA is more suited for migrations, not hosting.

upvoted 0 times

...

Carin

3 months ago

Wait, can SSIS packages even run in Azure without a VM?

upvoted 0 times

...

Una

3 months ago

I disagree, Data Migration Assistant is not for hosting SSIS packages.

upvoted 0 times

...

Gearldine

4 months ago

Azure Data Factory is the way to go for SSIS in Azure!

upvoted 0 times

...

Tish

4 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

4 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

4 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

5 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

5 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

5 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

5 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

5 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

10 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

9 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

9 months ago

D) Azure Data Factory

upvoted 0 times

...

Solange

9 months ago

C) Data Migration Assistant

upvoted 0 times

...

Lashanda

10 months ago

B) Azure Data Catalog

upvoted 0 times

...

Quentin

10 months ago

A) SQL Server Migration Assistant (SSMA)

upvoted 0 times

...

Barbra

11 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

9 months ago

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

upvoted 0 times

...

Golda

9 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

10 months ago

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

upvoted 0 times

...

Xochitl

10 months ago

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

upvoted 0 times

...

Jina

11 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

11 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

10 months ago

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

upvoted 0 times

...

Domonique

11 months ago

D) Azure Data Factory

upvoted 0 times

...

Vallie

11 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