Azure Solutions Architect Expert

A workload needs a globally distributed, low-latency operational database for JSON documents with multi-region writes and tunable consistency. Which store should the design specify?

A team is migrating a SQL Server database that uses SQL Agent jobs, cross-database queries, and CLR, and wants a managed PaaS with near-full instance compatibility. Which option fits best?

An analytics design must store massive volumes of raw files (Parquet/CSV) with a hierarchical namespace for big-data processing. Which storage should you specify?

A data-warehouse design must run complex analytical queries over terabytes with massively parallel processing (MPP). Which service should you choose?

A shared PaaS database must be reachable only from the application's virtual network, never over its public endpoint. Which design achieves private connectivity?

The design needs a message-durability store for orders that supports transactions and ordered processing, and a separate cache for hot reads. Which two services fit respectively?

An Azure SQL Database must recover to any point in the last 30 days after accidental data corruption. Which built-in capability provides this without custom backups?

A design must choose a storage redundancy that keeps three synchronous copies across availability zones in one region to survive a datacenter failure. Which option is correct?

For a relational database that should automatically pause during inactivity and scale compute based on demand to save cost for intermittent workloads, which option should you design?

The team needs a managed open-source relational database for a PostgreSQL application with high availability and automated maintenance. Which service should the design use?