AZ-305 Practice Test 18 — 15 Questions

Question 1

A company is designing a hybrid storage solution to connect on-premises file shares to Azure. They need to cache frequently accessed files locally for low-latency access while storing all files in Azure. The solution must support SMB protocol and integrate with existing Windows file servers. Which Azure service should they use?

Accepted Answer

Azure File Sync. Azure File Sync is the correct choice because it enables caching of frequently accessed files on-premises via a sync agent installed on Windows Server, while all files are stored in Azure Files. This provides low-latency access for local users and supports SMB protocol, seamlessly integrating with existing Windows file servers through a cloud tiering feature that keeps only hot files locally.

Answer

Azure Blob Storage with NFS 3.0 support

Answer

Azure Files

Answer

Azure NetApp Files

Question 2

Which TWO Azure services can be used to host a MongoDB-compatible database with global distribution? (Select two.)

Accepted Answer

Azure Cosmos DB API for MongoDB. Azure Cosmos DB API for MongoDB is correct because it provides a MongoDB-compatible API layer over Cosmos DB's globally distributed, multi-model database engine. This allows you to use standard MongoDB drivers and tools while benefiting from Cosmos DB's turnkey global distribution, multi-region writes, and 99.999% availability SLA.

Answer

Azure SQL Database

Answer

Azure Database for PostgreSQL

Answer

Azure Cache for Redis

Question 3

Which TWO options are valid ways to enforce data residency in Azure Storage to ensure data does not leave a specific Azure region?

Accepted Answer

Use Azure Policy to deny storage accounts with geo-redundant storage (GRS) or read-access geo-redundant storage (RA-GRS).. Azure Policy can enforce data residency by denying the creation of storage accounts that use geo-redundant storage (GRS) or read-access geo-redundant storage (RA-GRS), as these replication options replicate data to a paired secondary region. By applying a policy that blocks these SKUs, you ensure that all storage account data remains within a single Azure region, meeting data residency requirements.

Answer

Use Azure Data Lake Storage Gen2 with hierarchical namespace.

Answer

Enable Azure Front Door with caching.

Answer

Use read-access geo-redundant storage (RA-GRS).

Question 4

Refer to the exhibit. You run a KQL query against Azure Cosmos DB diagnostics logs. The query shows increasing latency for Query operations over time. Which is the most likely root cause?

Accepted Answer

A query is consuming increasing RU over time, possibly due to a hot partition. The query latency increase over time, combined with the fact that the query is consuming more Request Units (RU) per execution, strongly indicates a hot partition. In Azure Cosmos DB, a hot partition occurs when a disproportionate amount of traffic hits a single physical partition, causing that partition's RU budget to be exhausted while others remain underutilized. This leads to increased latency for queries targeting that partition, as the partition's resources become saturated.

Answer

The Cosmos DB account has reached its storage limit

Answer

The Cosmos DB account is being throttled due to insufficient RUs

Answer

There is network latency between the client and the Cosmos DB endpoint

Question 5

Your company is migrating a critical on-premises database to Azure SQL Managed Instance. The database is 500 GB and requires minimal downtime during migration. You need to choose the best migration approach. What should you recommend?

Accepted Answer

Use Azure Database Migration Service with online migration.. Option D is correct because Azure Database Migration Service with online migration supports minimal downtime by continuously syncing changes. Option A is wrong because export/import requires downtime. Option B is wrong because transactional replication can be complex and is not the primary recommended method for minimal downtime. Option C is wrong because Azure Data Factory is for data integration, not minimal-downtime migration.

Answer

Use the export/import bacpac method.

Answer

Use Azure Data Factory to copy data.

Answer

Use transactional replication.

Question 6

You need to store semi-structured data from IoT devices in Azure. The data has varying schemas and high write throughput. Which Azure service should you use?

Accepted Answer

Azure Cosmos DB.. Option D is correct because Azure Cosmos DB supports semi-structured data with flexible schemas and high write throughput. Option A is wrong because Azure SQL Database is relational and less flexible for varying schemas. Option B is wrong because Azure Blob Storage is for unstructured data. Option C is wrong because Azure Table Storage has limited throughput and schema flexibility.

Answer

Azure Blob Storage.

Answer

Azure SQL Database.

Answer

Azure Table Storage.

Question 7

Which THREE considerations are important when designing a storage solution for Azure Virtual Desktop (AVD) user profiles using FSLogix? (Choose three.)

Accepted Answer

Use Azure Files as the storage solution.. Options B, C, and D are correct. FSLogix profiles require a share that supports SMB (Azure Files). Low latency is critical for user experience. High IOPS are needed for profile reads/writes. Option A is wrong because public endpoint is not required; private endpoint is recommended. Option E is wrong because geo-redundancy is not typically required for FSLogix; locally redundant or zone-redundant is sufficient.

Answer

Use a public endpoint for profile storage.

Answer

Enable geo-redundant storage (GRS) for disaster recovery.

Question 8

Your company, Contoso Ltd., is a global financial services firm with a primary data center in London and a disaster recovery site in Paris. They are migrating their on-premises SQL Server databases to Azure. The databases include: (1) a 2-TB customer database with high transaction throughput, requiring an RPO of 5 seconds and an RTO of 30 seconds; (2) a 500-GB reporting database that is read-only and can tolerate an RPO of 1 hour and an RTO of 2 hours; (3) a 100-GB archival database that is accessed once a month. The solution must minimize costs while meeting requirements. You need to recommend a storage and database strategy for each database. What should you recommend?

Accepted Answer

Use Azure SQL Database with active geo-replication for the customer database, geo-restore for the reporting database, and long-term retention for the archival database.. Option C is correct. For the customer database, Azure SQL Database with active geo-replication meets the low RPO/RTO. For the reporting database, Azure SQL Database geo-restore from geo-redundant backups meets the 1-hour RPO at lower cost. For the archival database, Azure SQL Database with long-term retention (LTR) and geo-restore is cost-effective. Option A is wrong because Azure SQL Managed Instance is more expensive and not necessary. Option B is wrong because using Cosmos DB for relational data is inappropriate. Option D is wrong because using Azure SQL Database for all with active geo-replication would be overkill and costly for the archival database.

Answer

Use Azure SQL Managed Instance for all databases with auto-failover groups.

Answer

Use Azure Cosmos DB for the customer database, Azure SQL Database for reporting, and Azure Blob Storage for archival.

Answer

Use Azure SQL Database with active geo-replication for all databases.

Question 9

A multinational corporation is designing a data storage solution for its global customer data. The data must be stored in the Azure region closest to each customer to minimize latency, but all data must be accessible from a central analytics platform for reporting. The solution must also comply with data residency regulations that require customer data to remain in the country of origin. Which Azure storage solution should the company recommend?

Accepted Answer

Azure Cosmos DB with multi-master writes and conflict resolution. Option C is correct because Azure Cosmos DB supports multi-region writes and data residency with a multi-master configuration, allowing data to be written in the region closest to the customer and read globally. Option A is wrong because Azure Blob Storage with geo-redundant storage (GRS) does not allow per-item residency control. Option B is wrong because Azure SQL Database with geo-replication replicates entire databases, not per-customer data. Option D is wrong because Azure Data Lake Storage Gen2 is a single-region service and does not natively support multi-region data placement per customer.

Answer

Azure Data Lake Storage Gen2 with geo-zone-redundant storage (GZRS)

Answer

Azure Blob Storage with geo-redundant storage (GRS)

Answer

Azure SQL Database with active geo-replication

Question 10

A company is designing a disaster recovery solution for its on-premises SQL Server databases that are critical for business operations. The databases are approximately 500 GB each. The solution must meet the following requirements: - Replicate data to Azure with minimal data loss (RPO of 15 minutes). - Automatically failover to Azure in case of an on-premises outage. - Use existing SQL Server licenses to minimize costs. Which Azure service should the company use?

Accepted Answer

Azure SQL Managed Instance with managed instance link. Option D is correct because Azure SQL Managed Instance supports managed instance link for near-real-time replication with RPO of 15 minutes and automatic failover using distributed availability groups. Option A is wrong because Azure Database Migration Service is for one-time migration, not ongoing replication. Option B is wrong because Azure Site Recovery replicates at the VM level, not database-level with SQL-specific consistency. Option C is wrong because Azure SQL Database Managed Instance does not support Azure Hybrid Benefit for SQL Server licenses in the same way as Azure SQL Managed Instance.

Answer

Azure Site Recovery with SQL Server replication

Answer

Azure Database Migration Service (DMS)

Answer

Azure SQL Database Managed Instance with transaction replication

Question 11

A company is designing a solution for storing sensitive financial records that must be retained for 7 years. The solution must meet the following requirements: - Data must be immutable during the retention period. - After the retention period, data must be automatically deleted. - The solution must minimize storage costs. Which two Azure services should the company use? (Choose two.)

Accepted Answer

Azure Blob Storage lifecycle management. Option A is correct because Azure Blob Storage provides immutable storage with time-based retention policies. Option C is correct because Azure Blob Storage lifecycle management can automatically delete blobs after a specified period. Option B is wrong because Azure Files does not support immutable storage natively. Option D is wrong because Azure NetApp Files does not have built-in immutability or lifecycle management. Option E is wrong because Azure Purview is a data governance service, not for storage.

Answer

Microsoft Purview Data Map

Answer

Azure NetApp Files with replication

Answer

Azure Files with snapshots

Question 12

A company stores petabytes of sensor data in Azure Data Lake Storage Gen2. They need to run complex analytics queries that involve joining multiple datasets and aggregating time-series data. The queries must complete within seconds. Which Azure service should they use for querying?

Accepted Answer

Azure Synapse Analytics. Azure Synapse Analytics (formerly SQL Data Warehouse) provides massively parallel processing (MPP) for fast analytics on data lakes. Azure Stream Analytics is for real-time streaming. Azure Data Explorer is for time-series but not optimized for joining large datasets from Data Lake. Azure Databricks is good for big data but not as fast for interactive SQL queries.

Answer

Azure Stream Analytics

Answer

Azure Data Explorer

Answer

Azure Databricks

Question 13

You are the Azure architect for a healthcare organization that needs to store patient medical records (unstructured data) and provide secure access to doctors and nurses via a web application. The data must be encrypted at rest and in transit. Access must be authorized based on the requester's role (doctor, nurse, admin). The solution must be cost-effective and support high concurrency. You decide to use Azure Blob Storage. You need to design the access control mechanism. What should you recommend?

Accepted Answer

Use Azure RBAC with Microsoft Entra ID authentication.. Option A is correct. Using Azure RBAC with Microsoft Entra ID (formerly Azure AD) allows role-based access control natively integrated with Blob Storage. This meets the requirement of role-based authorization without managing additional keys. Option B is wrong because SAS tokens are not tied to user roles. Option C is wrong because using access keys provides full access, not role-based. Option D is wrong because storage service encryption is enabled by default and doesn't provide access control.

Answer

Enable storage service encryption and use HTTPS.

Answer

Use shared access signatures (SAS) with stored access policies.

Answer

Use storage account access keys and distribute them to users.

Question 14

A company uses Azure Redis Cache to improve the performance of a web application. They need to ensure that cached data survives a failover to a secondary region. Which Azure Redis Cache tier should they choose?

Accepted Answer

Premium tier. Azure Redis Cache Premium tier supports geo-replication for cross-region disaster recovery. Standard tier only replicates within a datacenter. Basic tier has no replication. Enterprise tier also supports geo-replication but is more expensive and complex.

Answer

Standard tier

Answer

Basic tier

Answer

Enterprise tier

Question 15

A company plans to store operational logs from Azure App Services in a scalable and cost-effective way. The logs must be retained for 90 days and then automatically deleted. Which Azure data storage solution should you recommend?

Accepted Answer

Azure Log Analytics Workspace. Option B is correct because Azure Log Analytics Workspace is designed for storing and analyzing logs with built-in retention policies. Option A is wrong because Blob Storage is for unstructured data but lacks native log querying. Option C is wrong because Azure SQL Database is for relational data and less cost-effective for logs. Option D is wrong because Cosmos DB is for NoSQL workloads and overpriced for logs.

Answer

Azure Blob Storage with lifecycle management

Answer

Azure SQL Database with retention policy

Answer

Azure Cosmos DB with TTL