Hotspot Question You have the following projects: - Project1: A rapidly iterating cloud-based solution that integrates multiple Azure software as a service (SaaS) solutions - Project2: The migration o

Question

Exhibits

Answer Area

• Project1Azure Cosmos DB
  Azure Cosmos DBAzure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure Virtual Machines
• Project2Azure SQL Managed Instance
  Azure Cosmos DBAzure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure Virtual Machines
• Project3Azure SQL Database
  Azure Cosmos DBAzure SQL DatabaseAzure SQL Managed InstanceSQL Server on Azure Virtual Machines

Explanation

Here's the rationale for each project's database solution:

• Project1: Azure Cosmos DB

  • Requirements: A rapidly iterating cloud-based solution that integrates multiple Azure SaaS solutions, minimize costs, and minimize administrative effort associated with operating system administration.
  • Rationale: Azure Cosmos DB is a fully managed, globally distributed NoSQL database service. It is ideal for cloud-native, rapidly evolving applications that integrate with other Azure SaaS solutions, as it offers high availability, low latency, and global scale without requiring extensive administrative effort for OS management (being a PaaS/serverless offering). Its flexible data model and various APIs suit rapidly iterating development.

• Project2: Azure SQL Managed Instance

  • Requirements: Migration of a 5-TB on-premises database to Azure, minimize how long it takes to migrate, and minimize administrative effort associated with operating system updates and backups.
  • Rationale: As explicitly stated in the provided explanation, "SQL Managed Instance supports database migration from on-premises with minimal to no database changes," which directly addresses the need to minimize migration time. It is a Platform-as-a-Service (PaaS) offering, meaning it handles operating system updates and backups, thus minimizing administrative effort. The 5-TB database size fits within its up to 16-TB limit.

• Project3: Azure SQL Database

  • Requirements: Migration of a 30-TB on-premises database to Azure, minimize how long it takes to migrate, and minimize administrative effort associated with operating system updates and backups.
  • Rationale: Azure SQL Database is a fully managed PaaS relational database service. Like Azure SQL Managed Instance, it minimizes administrative effort for OS management, updates, and backups. Crucially, for a 30-TB database, Azure SQL Database (especially with the Hyperscale service tier) can scale to handle much larger databases (up to 100 TB) compared to Azure SQL Managed Instance's 16-TB limit for a single instance. This makes it the appropriate PaaS choice for large-scale migrations while still meeting the requirements to minimize migration time and administrative overhead.

No community discussion yet for this question.