ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-304 All Questions

View all questions & answers for the AZ-304 exam
Go to Exam

Exam AZ-304 topic 3 question 35 discussion

Actual exam question from Microsoft's AZ-304
Question #: 35
Topic #: 3
[All AZ-304 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 SSIS 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. Data Migration Assistant
  • C. Azure Data Catalog
  • D. Azure Data Factory
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by express at July 1, 2021, 12:19 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
us3r
Highly Voted 3 years, 2 months ago
Selected Answer: D
i am a simple guy, I see "ADF" in aswers and I select it
upvoted 42 times
...
M4st3r0fN0n3
Highly Voted 3 years, 10 months ago
Incorrect. D is the answer based on this https://docs.microsoft.com/en-us/azure/data-factory/how-to-migrate-ssis-job-ssms
upvoted 34 times
...
Pabbinedi
Most Recent 2 years, 7 months ago
I believe the answer is correct. If we read the question carefully he is not asking to migrate the SSIS packages infact he is asking for "The solution must ensure that the packages can target the SQL Database instances as their destinations.". In order to find the fitment analysis we need to run DMA irrepspective of how you deploy the packages in Azure. please refer to below link https://learn.microsoft.com/en-us/sql/dma/dma-assess-ssis?view=sql-server-ver16
upvoted 1 times
...
Snownoodles
2 years, 9 months ago
Selected Answer: D
Check this link for SSIS vs ADF https://www.mssqltips.com/sqlservertip/7094/azure-data-factory-vs-ssis-similarities-differences/
upvoted 1 times
...
CakeBake
2 years, 10 months ago
The question is about hosting SSIS packages as is in Azure, Hence the answer here is Data Migration Assistant. ADF will be used if you are creating custom pipelines for your business requirements.
upvoted 3 times
...
hertino
3 years ago
In AZ-305 exam, 9 april 22
upvoted 4 times
...
plmmsg
3 years, 1 month ago
Selected Answer: D
DATA FACTORY
upvoted 1 times
...
shiju123
3 years, 2 months ago
Correct Answer is B https://docs.microsoft.com/en-us/azure/dms/how-to-migrate-ssis-packages-managed-instance
upvoted 4 times
TMM369
2 years, 11 months ago
Wrong - Azure Database Migration Service (DMS) currently does not support Azure SQL Database as a target migration destination. To redeploy SSIS projects/packages to Azure SQL Database, see the article Redeploy SQL Server Integration Services packages to Azure SQL Database. ..In this caso, SHOULD fo to Azure.
upvoted 1 times
...
...
xyz213
3 years, 3 months ago
Selected Answer: D
Correct one is D
upvoted 2 times
...
exam2022
3 years, 3 months ago
D Answer
upvoted 1 times
...
Fartfart
3 years, 4 months ago
Selected Answer: D
Data factory makes most sense based on this. https://docs.microsoft.com/en-us/azure/data-factory/how-to-migrate-ssis-job-ssms
upvoted 2 times
...
ScubaDiver123456
3 years, 4 months ago
Selected Answer: D
D Data Factory, seems right to me
upvoted 2 times
...
iwuehfkjj3
3 years, 4 months ago
Selected Answer: D
See https://docs.microsoft.com/en-us/azure/data-factory/how-to-migrate-ssis-job-ssms
upvoted 2 times
...
[Removed]
3 years, 4 months ago
Selected Answer: D
Consider #28 question, it's SSIS + ADF doing the migration targeting right package goes to it's respective SQL database.
upvoted 1 times
...
jj22222
3 years, 4 months ago
thanks i chose D too, so was confused to see it lists B
upvoted 1 times
...
mxcasarini
3 years, 5 months ago
Selected Answer: D
https://docs.microsoft.com/en-us/azure/data-factory/how-to-migrate-ssis-job-ssms
upvoted 4 times
...
syu31svc
3 years, 7 months ago
https://docs.microsoft.com/en-us/azure/data-factory/create-azure-ssis-integration-runtime Answer is D; Data Factory
upvoted 1 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago