Understand Azure data solutions
- By Danilo Dominici, Francesco Milano, Daniel A. Seara
- 10/11/2021
- Data-storage concepts
- Data-processing concepts
- Use cases
- Summary
- Summary exercise
- Summary exercise answers
Summary exercise answers
This section contains the answers to the summary exercise questions in the previous section and explains why each answer is correct.
1. You should use Azure Cosmos DB with the MongoDB API to replace MongoDB, and Azure SQL Database to replace the current SQL Server implementation. Cosmos DB with MongoDB API is fully compatible with MongoDB, so you can reuse almost 100% of the application code. Azure SQL Database is a good replacement for SQL Server because, depending on the compatibility and service level required, you can choose among single, elastic pool, or managed instance flavors.
2. With Azure Cosmos DB with geo-replication, data is replicated across all the selected Azure regions, so applications can use the right database, nearest to the race location.
3. After MongoDB and SQL Server are migrated to cloud services, an Azure Data Factory pipeline can easily connect Cosmos DB and Azure SQL Database.