What should you recommend?

A company stores data in multiple types of cloud-based databases.

You need to design a solution to consolidate data into a single relational database. Ingestion of data will occur at set times each day.

What should you recommend?
A . SQL Server Migration Assistant
B . SQL Data Sync
C . Azure Data Factory
D . Azure Database Migration Service
E . Data Migration Assistant

View Answer

Answer: C

Explanation:

Incorrect Answers:

D: Azure Database Migration Service is used to migrate on-premises SQL Server databases to the cloud. References:

https://docs.microsoft.com/en-us/azure/data-factory/introduction https://azure.microsoft.com/en-us/blog/operationalize-azure-databricks-notebooks-using-data-factory/ https://azure.microsoft.com/en-us/blog/data-ingestion-into-azure-at-scale-made-easier-with-latest­

enhancements-to-adf-copy-data-tool/