A company is planning to deploy a web application and needs a database service. The application requires a non-relational (NoSQL) database to store unstructured user profile documents. A developer proposes using Azure SQL Database to meet this requirement. Why is this proposal incorrect?
- Azure SQL Database is a relational database service, not a non-relational (NoSQL) database service.Answer
- BAzure SQL Database is a Platform as a Service (PaaS) offering, which means the customer is responsible for operating system patching.
- CAzure SQL Database is a Software as a Service (SaaS) offering, and customers cannot host custom application databases on it.
- DAzure Cosmos DB is the only database in Azure that supports traditional relational SQL schemas, so Azure SQL Database cannot be used.
Answer
Azure SQL Database is a relational database service, not a non-relational (NoSQL) database service.
The correct option is correct because Azure SQL Database is a relational database service built on SQL Server. It is designed for structured tables and relations, not for storing non-relational (NoSQL) document data models. For NoSQL document workloads, Azure Cosmos DB is the appropriate service.
Step-by-Step Solution
Key Concept
Azure SQL Database is a relational database service (PaaS) designed for structured data with relationships, whereas Azure Cosmos DB is a non-relational (NoSQL) database service designed for unstructured and semi-structured data.