exam questions

Exam AZ-305 All Questions

View all questions & answers for the AZ-305 exam

Exam AZ-305 topic 4 question 30 discussion

Actual exam question from Microsoft's AZ-305
Question #: 30
Topic #: 4
[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 create Azure-SQL Server Integration Services (SSIS) packages. The solution must ensure that the packages can target the
SQL Database instances as their destinations.
What should you include in the recommendation?

  • A. Data Migration Assistant (DMA)
  • B. Azure Data Factory
  • C. Azure Data Catalog
  • D. SQL Server Migration Assistant (SSMA)
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
NotMeAnyWay
Highly Voted 1 year, 7 months ago
Selected Answer: B
Correct: B. Azure Data Factory You should include Azure Data Factory in the recommendation to create Azure-SQL Server Integration Services (SSIS) packages. Azure Data Factory supports running SSIS packages in the cloud using Azure-SSIS Integration Runtime, which allows you to target Azure SQL Database instances as the destinations for your SSIS packages. This enables you to continue using your existing SSIS packages while migrating your on-premises databases to Azure SQL Database.
upvoted 13 times
...
GarryK
Highly Voted 2 years, 2 months ago
Selected Answer: B
https://docs.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure
upvoted 7 times
...
SeMo0o0o0o
Most Recent 3 weeks ago
Selected Answer: B
B is correct
upvoted 1 times
...
Lazylinux
7 months, 2 weeks ago
Selected Answer: B
Given Answer B is correct, Once you understand the meaning of SSIS it becomes clear answer is Azure Data factory https://learn.microsoft.com/en-us/sql/integration-services/sql-server-integration-services?view=sql-server-ver16 https://learn.microsoft.com/en-us/azure/data-factory/tutorial-deploy-ssis-packages-azure
upvoted 1 times
...
VBK8579
1 year, 10 months ago
Selected Answer: B
Azure Data Factory provides a cloud-based platform for the orchestration and management of data transformation and movement. Azure Data Factory supports connecting to and migrating data from on-premises databases, including SQL Server, to Azure SQL Database. Azure Data Factory also supports integrating with SSIS packages, making it possible to continue using your existing SSIS packages while utilizing Azure SQL Database as the target database.
upvoted 5 times
...
OPT_001122
1 year, 10 months ago
Selected Answer: B
B. Azure Data Factory
upvoted 1 times
...
Snownoodles
2 years, 2 months ago
I wonder if there is a typo in this question: "You need to recommend a solution to CREATE Azure-SQL Server Integration Services (SSIS) packages" Should "CREATE" be "REPLACE"?
upvoted 2 times
sKaiNL
2 years, 2 months ago
Apparently yes
upvoted 2 times
...
...
kay000001
2 years, 2 months ago
Selected Answer: B
B. https://docs.microsoft.com/en-us/azure/data-factory/how-to-migrate-ssis-job-ssms
upvoted 4 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago