Microsoft Azure Data FundamentalsDescribe core data conceptsMedium
A company is migrating its on-premises database of customer information to Azure. The existing database is highly structured, uses primary and foreign keys to enforce relationships, and requires strong transactional consistency (ACID properties). Which Azure database service is the MOST suitable choice for this migration?
- AAzure Cosmos DB
- BAzure Database for PostgreSQL
- CAzure Data Lake Storage Gen2
- DAzure Table Storage
Show answer & explanationAnswer & explanation
Correct answer: B. Azure Database for PostgreSQL
Azure Database for PostgreSQL is a fully managed relational database service that supports all the characteristics of a highly structured database, including primary/foreign keys and ACID properties, making it an ideal choice for migrating existing relational databases.
Why the other options are wrong
- A. Azure Cosmos DB is a NoSQL database, not designed for strict relational models with primary/foreign keys.
- C. Azure Data Lake Storage Gen2 is a hierarchical file system for big data analytics, not a transactional database service.
- D. Azure Table Storage is a NoSQL key-value store, lacking relational features and strong transactional consistency across multiple entities.
Azure Database for PostgreSQL
Azure Database for PostgreSQL is a managed relational database service in the cloud, based on the open-source PostgreSQL database engine.
- Supports structured data and relational models.
- Enforces primary and foreign key constraints.
- Provides ACID transactional consistency.
Memory trick: PostgreSQL is 'post'-perfect for structured data.