Design data storage solutions Questions
Practice questions for Design data storage solutions topic in Microsoft Certified: Azure Solutions Architect Expert. 46 questions covering this domain.
A company wants protection against accidental blob deletion and overwrites for up to several months. Which statement about blob soft delete is correct...
A database workload needs broad SQL Server compatibility features such as SQL Agent, linked servers, and cross-database queries. Which Azure database ...
A data engineering team needs a managed cloud service for data integration, ETL, ELT, and orchestration using pipelines and activities. Which service ...
A security architect wants the strongest basic protection against accidental blob deletion and overwrites. Which Microsoft recommendation should guide...
Which storage account type does Microsoft recommend for most Azure storage scenarios?
A storage architect needs cross-region replication plus the ability to read from the secondary region if the primary becomes unavailable. Which redund...
Which Azure service is the fully managed globally distributed database service with turnkey global distribution?
An architect wants a database tier that is the default recommendation for most workloads, while reserving a different tier for very low latency local ...
Which Azure storage redundancy option replicates data synchronously across multiple availability zones in one region?
A recovery design for Azure SQL Database requires understanding the built-in automated backup cadence for point-in-time restore. Which statement is co...
An architect must choose between Azure Service Bus and Azure Event Hubs for a solution that requires queues, topics, subscriptions, sessions, and dead...
Which Azure Files authentication option lets domain users access SMB shares using on-prem AD identities?
A relational workload must scale read traffic across multiple regions while keeping a single primary writer. Which Azure SQL Database capability fits?
A team needs a partition key that maximizes write throughput in Cosmos DB while avoiding hot partitions for an order events workload. Which property i...
Which Azure Storage feature lets a storage account be reached only via a private IP from a VNet, blocking the public endpoint?
Which Azure Storage capability enforces WORM (write once, read many) retention so blobs cannot be modified or deleted for a configured period?
A regulatory framework requires customer-controlled encryption keys for storage at rest, including the ability to revoke key access. Which Azure capab...
A workload requires a globally distributed multi-region writable database with single-digit ms reads and writes. Which Azure service is the best fit?
An architect must move multi-TB on-prem data into Azure Blob Storage with bandwidth, throttling, and resume support. Which tool is recommended?
An architect must transition rarely-accessed blobs to a colder, lower-cost tier automatically and delete them after 7 years. Which feature implements ...
Sign in to see all 46 questions
Create a free account to browse all questions — completely free during our launch phase.