Relational Data in Azure (45–50%)DP-900 Study Guide

Azure SQL Services

Objective 2.1 · Relational Data

Azure SQL Managed Instance and SQL VM

Objective 2.2 · Relational Data

SQL Querying Basics

Objective 2.3 · Relational Data

Azure Cosmos DB

Objective 2.4 · Relational Data

Azure Table Storage and Blob Data

Objective 2.5 · Relational Data

Database Normalization (1NF, 2NF, 3NF)

Objective 2.1 · Relational Data

SQL Joins: INNER, LEFT, RIGHT, FULL

Objective 2.3 · Relational Data

Indexes, Views, and Stored Procedures

Objective 2.3 · Relational Data

Azure SQL Hyperscale and Serverless

Objective 2.1 · Relational Data

Azure SQL Elastic Pools

Objective 2.2 · Relational Data

Cosmos DB APIs: Core SQL, MongoDB, Cassandra, Gremlin

Objective 2.4 · Relational Data

Cosmos DB Consistency Levels

Objective 2.4 · Relational Data

ACID Properties in Relational Databases

Objective 2.1 · Relational Data

SQL DML and DDL: SELECT, INSERT, CREATE, ALTER

Objective 2.3 · Relational Data

SQL Data Types and Constraints

Objective 2.3 · Relational Data

Full-Text Search in Azure SQL

Objective 2.3 · Relational Data

Azure SQL Authentication: SQL vs Entra ID

Objective 2.1 · Relational Data

Transparent Data Encryption (TDE) in Azure SQL

Objective 2.1 · Relational Data

Azure SQL Active Geo-Replication

Objective 2.2 · Relational Data

Azure SQL Pricing: DTU vs vCore Models

Objective 2.1 · Relational Data

Azure Database for MySQL

Objective 2.1 · Relational Data

Azure Database for PostgreSQL

Objective 2.1 · Relational Data

Row-Level Security in Azure SQL

Objective 2.1 · Relational Data

Temporal Tables in Azure SQL

Objective 2.3 · Relational Data

Cosmos DB Partitioning Strategies

Objective 2.4 · Relational Data

Cosmos DB Request Units (RU/s)

Objective 2.4 · Relational Data

Cosmos DB Global Distribution and Failover

Objective 2.4 · Relational Data

Cosmos DB Change Feed for Streaming

Objective 2.4 · Relational Data

Data Security: Encryption, Masking, and Anonymisation

Objective 2.1 · Relational Data

Azure Cache for Redis for Low-Latency Data

Objective 2.5 · Relational Data

Azure SQL Managed Instance Deep Dive

Objective 2.2 · Relational Data

Azure SQL Elastic Pool Cost Optimisation

Objective 2.2 · Relational Data