Exam AZ-204 topic 1 question 9 discussion

Answer: B --mongorestore https://docs.microsoft.com/en-us/azure/cosmos-db/mongodb-pre-migration

mongorestore can be used to restore a MongoDB backup to the Azure Cosmos DB account using the MongoDB API.

The underlined text is incorrect. The Data Management Gateway tool is not typically used for migrating MongoDB to Azure Cosmos DB. The correct answer is B. mongorestore. To migrate MongoDB to Azure Cosmos DB, you can use MongoDB native tools like mongodump and mongorestore. These tools are designed to handle the export and import of MongoDB data efficiently.

Got this on the Microsoft documentation: "The MongoDB native tools are a set of binaries that facilitate data manipulation on an existing MongoDB instance. Since Azure Cosmos DB exposes an API for MongoDB, the MongoDB native tools are able to insert data into Azure Cosmos DB. The focus of this doc is on migrating data out of a MongoDB instance using mongoexport/mongoimport or mongodump/mongorestore. Since the native tools connect to MongoDB using connection strings, you can run the tools anywhere, however we recommend running these tools within the same network as the MongoDB instance to avoid firewall issues."

Data Management Gateway: This tool is used for connecting on-premises data sources (like SQL Server) to Azure Analysis Services or Power BI for data visualization and reporting. It's not designed for direct database migrations. Correct Answer: B. mongorestore The mongorestore command-line tool is specifically designed for restoring data backups created with mongodump into a MongoDB instance. This makes it a suitable option for migrating data from your on-premises MongoDB deployment to the Azure Cosmos DB account using the MongoDB API.

https://docs.microsoft.com/en-us/azure/cosmos-db/mongodb-migrate https://docs.mongodb.com/manual/reference/program/mongorestore/ The underlined text states that the Data Management Gateway tool is included in the migration strategy for migrating MongoDB to the Azure Cosmos DB account that uses the MongoDB API. This statement is incorrect. The Data Management Gateway tool is used to connect on-premises data sources to Azure services, including Power BI, PowerApps, and Microsoft Flow. It provides a secure and reliable connection between on-premises data sources and cloud-based services. However, in the context of migrating MongoDB to Azure Cosmos DB, the Data Management Gateway tool is not relevant. Instead, you should use one of the available migration tools such as the Azure Database Migration Service or the mongoimport/mongodump utilities to migrate your data. Therefore, the correct answer is B. mongorestore.

No change required => https://learn.microsoft.com/en-us/azure/data-factory/v1/data-factory-on-premises-mongodb-connector and https://learn.microsoft.com/en-us/azure/data-factory/v1/data-factory-move-data-between-onprem-and-cloud all the links supporting option with mongorestore do not mention data management gateway. For data management gateway you only need to specify schema and the rest is done by DMG and its pipeline with a copy activity.

Data Management Gateway is not supported for Azure Cosmos DB - Mongo API https://learn.microsoft.com/en-us/azure/data-factory/v1/data-factory-data-movement-activities#supported-data-stores-and-formats So you can use native tools to perform an offline (one-time) migration of databases from an on-premises or cloud instance of MongoDB to Azure Cosmos DB's API for MongoDB. https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/tutorial-mongotools-cosmos-db#overview-of-data-migration-using-mongodb-native-tools

When moving the whole DB, we are using mongorestore: https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/tutorial-mongotools-cosmos-db

A - No change required

To migrate MongoDB to an Azure Cosmos DB account that uses the MongoDB API, you can use mongodump and mongorestore tools that are included with MongoDB.

"include data management gateway" https://azure.microsoft.com/en-us/blog/data-management-gateway-high-availability-and-scalability-preview/

Answer: A In Data Management Gateway i.e., Data factory once source and sink are setup, there is no need for mongorestore to run, running the pipeline will transfer data.

i think is A the DMG do the job

mongorestore imports your BSON file dump into Azure Cosmos DB. Here, you can enhance the level of your knowledge about MongoDB migrations: https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/tutorial-mongotools-cosmos-db

For datastores with <10 GB monogoDB native tool is used for migration from on-premises data store to cloud data store. https://learn.microsoft.com/en-us/azure/cosmos-db/mongodb/pre-migration-steps#pre-migration-logistics-planning

I agree with Kozchris, the answer is B - mongorestore. DMG can not have Cosmos DB - Mongo as a supported sink (target). https://learn.microsoft.com/en-us/azure/data-factory/v1/data-factory-data-movement-activities#supported-data-stores-and-formats