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?
Suggested Answer:C🗳️
Incorrect Answers: D: Azure Database Migration Service is used to migrate on-premises SQL Server databases to the cloud. Reference: 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/
The member databases can be either databases in Azure SQL Database or in instances of SQL Server. See https://docs.microsoft.com/en-us/azure/azure-sql/database/sql-data-sync-data-sql-server-sql-database. So it's probably not Data Sync.
Here are my thoughts: we know that A and E are obviously incorrect, and since this is a single-selection question, we've got to select the most appropriate answer from the rest choices. SQL Data Sync can only be used to sync data between a Hub Database and a Member Database, and the Hub Database must be an Azure SQL Database. Azure Database Migration Service is mainly used to migrate data from on-prem RDMS to Azure Database or from MongoDB to Azure Cosmos DB (you can still do cloud-to-cloud migrations with it but there are strict network topology requirements applied). Considering that we have various types of databases in Azure and the consolidation requirements are not clear, Azure Data Factory is the most universal solution, so the answer is C.
The data is already hosted in cloud data stores, SQL data sync appeal to customers who are considering moving to the cloud and would like to put some of their application in Azure, So Azure Datafactory is appropriate here
I think you might be right. https://www.bdo.com/digital/insights/cloud/azure-sql-data-sync-is-now-generally-available
This article highlights the possibility
Though we can achieve this using data sync but it isn't recommended for this scenario. As data sync is mostly used for synchronizing but not transfer related activities.
upvoted 6 times
...
...
This section is not available anymore. Please use the main Exam Page.DP-201 Exam Questions
Log in to ExamTopics
Sign in:
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.
SidN
Highly Voted 4 years, 12 months agoIsrael2
4 years, 11 months agoIsrael2
4 years, 11 months agoD_Duke
Highly Voted 4 years, 7 months agosjain91
Most Recent 4 years, 1 month agoDeepu1987
4 years, 3 months agosyu31svc
4 years, 6 months agoAbhilvs
4 years, 11 months agoRuni
4 years, 12 months agodrdean
4 years, 12 months agoJzerpa_ccs
4 years, 7 months agoYaswant
4 years, 10 months ago