A company plans to migrate an on-premises inventory management application to Microsoft Azure. The application requires a traditional relational database structure with strict schema enforcement, foreign key constraints, and complex SQL joins. The IT team is considering using Azure Cosmos DB for this database workload.
Why is Azure Cosmos DB unsuitable for this specific scenario?
- It is a multi-model NoSQL database designed for non-relational workloads rather than a traditional relational database engine.Cevap
- BIt is a Software as a Service (SaaS) database service, which prevents the customer from defining custom tables or schemas.
- CIt is an Infrastructure as a Service (IaaS) offering that requires the customer to manage and perform all operating system patching.
- DIt is a traditional relational database engine that does not support SQL-based query capabilities.
Cevap
It is a multi-model NoSQL database designed for non-relational workloads rather than a traditional relational database engine.
The correct option is correct because Azure Cosmos DB is a NoSQL (non-relational) database service, designed for high-velocity, semi-structured data, and lacks native support for traditional relational database features like foreign key constraints and ACID-compliant joins across multiple distinct tables.
Adım Adım Çözüm
Anahtar Kavram
Azure Cosmos DB is a fully managed, globally distributed NoSQL database service, whereas relational workloads requiring strict schemas, foreign keys, and traditional SQL joins are best suited for relational databases like Azure SQL Database.