Design data storage solutions for relational data
6 practice questions under this official exam objective (AZ-305) — each with the community-verified answer, a full option-by-option explanation and instant feedback.
Which Managed PostgreSQL Service Scales Transactional Writes with Row-Based Sharding?
This AZ-305 hotspot asks for a managed PostgreSQL solution that horizontally scales transactional writes through row-based sharding while minimizing a
Which Azure Database Fits the Cosmos, 5-TB, and 30-TB Projects?
This AZ-305 hotspot asks you to map three projects — a rapidly iterating app that integrates several Azure SaaS services, a 5-TB on-premises migration
Which VNets must link to privatelink.database.windows.net for VM1 and VM2?
This AZ-305 scenario tests private-endpoint DNS resolution in a hub-and-spoke topology: the privatelink.database.windows.net zone must be linked to th
Which Azure SQL Service Handles Cross-Database Queries with Least Effort?
Azure SQL Managed Instance is the recommended relational store when an app needs to query data across multiple databases because it supports native cr
Azure Cosmos DB Table API for Dedicated Throughput
This question evaluates the selection of Azure storage services for structured data requiring dedicated throughput and low latency. Azure Cosmos DB is
Migrating a 500-TB SQL Server DB and On-Prem VMs to Azure
Migrating a 500-TB on-premises SQL Server database offline and on-premises VMs to Azure calls for Azure Data Box for the database and Azure Migrate (w