Design data storage solutions for relational data
8 practice questions under this official exam objective (AZ-305), each with the answer key, an option-by-option explanation and instant feedback.
Questions under this objective
8 total · page 1 of 1Which 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 Azure databases meet zone redundancy for these App Service apps?
This AZ-305 drag-and-drop asks you to match each App Service web app's database engine and workload needs to a zone-redundant Azure PaaS database whil
How Should 100,000 Mobile App Instances Stream CPU Telemetry into Azure SQL?
This hotspot item asks you to design an ingestion and stream-aggregation path that accepts telemetry from 100,000 mobile app instances, computes each
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