Design data storage solutions
Domain 2 of AZ-305 accounts for 20-25% of the exam. EarnYourCert has 97 original questions for this domain, all with explanations: 63 multiple choice, 15 yes/no and 19 completion or ordering items, like the real exam.
Domain 2 sample questions
8 questions from our 97-question bank for this domain. Try to answer before revealing the solution.
1. A multitenant SaaS app must scale out across many databases by tenant. Which pattern and tooling does Azure SQL support?
- Azure Backup for each tenant database
- Azure Table Storage with one partition
- Sharding with elastic database tools and elastic pools
- A single large VM running SQL Server
Show answer
Correct answer: C. Elastic tools help manage many databases and shard maps.
2. Which Cosmos DB API should you choose to migrate an existing MongoDB application with minimal code changes?
- Azure Cosmos DB for Gremlin
- Azure SQL
- Table storage only
- Azure Cosmos DB for MongoDB
Show answer
Correct answer: D. Compatible APIs reduce migration effort.
3. A solution stores billions of simple key-value entities with low cost and does not need rich queries. Which service is the cheapest fit?
- Azure Table Storage
- Azure SQL Business Critical
- Cosmos DB with 50,000 RU/s
- Azure NetApp Files
Show answer
Correct answer: A. Table Storage is a low-cost NoSQL key-value store.
4. Which storage account setting helps ensure data is encrypted with keys you control in Azure Key Vault?
- Allowing anonymous blob access
- Sharing the account keys with the team
- Enabling public network access
- Customer-managed keys for storage encryption
Show answer
Correct answer: D. CMK lets organizations control the key lifecycle.
5. Data is accessed about once a quarter, must stay online and be kept at least 90 days per tier change, at lower cost than Cool. Which blob tier fits?
- Cold
- Archive, with rehydration when the data is needed
- Premium
- Hot
Show answer
Correct answer: A. The Cold tier is online with a 90-day minimum; Archive is offline and needs rehydration.
6. A multitenant Cosmos DB container would exceed the 20 GB logical partition limit for large tenants partitioned by TenantId. What should you design?
- A separate Cosmos DB account per user
- A single partition key value for all data
- Hierarchical partition keys such as TenantId then UserId
- Manual throughput raised to the maximum for the container
Show answer
Correct answer: C. Hierarchical partition keys subpartition data so large tenants can exceed 20 GB while queries stay targeted.
7. Which service runs real-time SQL-like queries over streaming data from Event Hubs or IoT Hub?
- Azure Event Hubs
- Azure Data Lake Storage
- Azure Stream Analytics
- Azure Data Factory
Show answer
Correct answer: C. Stream Analytics provides serverless stream processing.
8. A global app needs a relational database with multi-region writes and low latency. Which Azure service should you evaluate?
- Azure Database for MySQL single server
- Azure SQL Database with a read replica
- Azure Table Storage with GRS
- Azure Cosmos DB with multi-region writes
Show answer
Correct answer: D. Cosmos DB supports multi-region writes with configurable consistency levels. Azure SQL replicas are read-only.