Instiq

2Design Data Storage Solutions

Practice questions →Glossary →
  • 2.1Designing Relational Databases

    Understand choosing relational data—Azure SQL Database/SQL Managed Instance/SQL on VM, service tiers, and Azure Database for PostgreSQL/MySQL. Pick the managed DB that fits requirements.

  • 2.2Designing Non-Relational and Storage

    Understand non-relational and object storage—Azure Cosmos DB (APIs/consistency), Blob Storage (access tiers), Azure Files, and queues/tables. Pick stores matching access patterns.

  • 2.3Designing Data Integration, Analytics, and Protection

    Understand using and protecting data—Data Lake Storage, Synapse Analytics, Data Factory, caching (Azure Cache for Redis), and encryption (at rest/in transit). Integrate/analyze data and keep it secure.