DP-900 Describe considerations for working with non-relational data on Azure Practice Test 2 — 15 Questions

Question 1

You need to upload a 500 GB file to Azure Blob Storage. The network connection is unreliable. Which feature should you use to ensure the upload completes successfully?

Accepted Answer

Use the Put Block and Put Block List operations with a block size that handles retries.. The Put Block and Put Block List operations allow you to upload a large file as a series of individual blocks. Each block can be retried independently if the network fails, and the final Put Block List assembles the blocks into a single blob. This block-level retry mechanism ensures the upload completes despite an unreliable connection.

Answer

Configure a lifecycle management policy to tier the file.

Answer

Use Azure File Sync to synchronize the file to the cloud.

Answer

Use AzCopy with the /Z parameter to resume the upload.

Question 2

A company uses Azure Data Lake Storage Gen2 to store analytics data. The security team requires that all data access be audited, including read, write, and delete operations. Which feature should you enable?

Accepted Answer

Enable Azure Monitor for the storage account.. Azure Monitor, specifically through its Diagnostic Settings feature for the storage account, allows you to collect resource logs (such as StorageRead, StorageWrite, and StorageDelete operations). These logs capture detailed information about data access operations on Azure Data Lake Storage Gen2, fulfilling the security team's auditing requirement. The logs can be sent to a Log Analytics workspace for analysis and long-term retention. Storage Analytics logging (Option C) is a legacy feature and is deprecated in favor of Azure Monitor.

Answer

Enable Microsoft Purview.

Answer

Enable Storage Analytics logging.

Answer

Enable Microsoft Defender for Cloud.

Question 3

You need to choose a non-relational data store for a key-value workload where each item is identified by a partition key and row key. Which Azure service should you use?

Accepted Answer

Azure Table Storage. Azure Table Storage is the correct choice because it is a non-relational key-value store in which every entity is uniquely identified by a composite of PartitionKey and RowKey, exactly matching the stated workload. It is schema-less, scales massively, and is designed for fast lookups by that key pair. Azure Blob Storage stores unstructured objects in containers and is addressed by blob name, not by a partition key/row key pair. Azure Files is a managed SMB/NFS file share, not a key-value store. Azure Cosmos DB can offer key-value access via its Table API, but the question asks for the service whose native model is partition key plus row key, which is Azure Table Storage.

Answer

Azure Blob Storage

Answer

Azure Files

Answer

Azure Cosmos DB

Question 4

Which THREE are benefits of using Azure Cosmos DB? (Choose three.)

Accepted Answer

Automatically indexes all data.. Option A is correct because Azure Cosmos DB automatically indexes every property of every document by default without requiring you to define or manage an indexing policy manually, which simplifies querying and improves performance. Option C is correct because Cosmos DB provides comprehensive SLAs that guarantee low latency — specifically, reads and writes are guaranteed to complete in under 10 ms at the 99th percentile for single-region accounts (and under 15 ms for multi-region reads). Option D is correct because Cosmos DB is designed to scale storage elastically and transparently, with no upper limit on the total amount of data a container or database can hold. Option B is not a benefit of Cosmos DB itself; while it offers an SQL-compatible query API, it is not a SQL Server integration product. Option E is incorrect because Cosmos DB is schema-agnostic — documents in the same container can have entirely different structures, which is one of its core advantages.

Answer

Supports SQL Server integration.

Answer

Requires a fixed schema for all documents.

Question 5

Which TWO are valid access tiers for Azure Blob Storage? (Choose two.)

Accepted Answer

Cool. Option C (Cool) is correct because Azure Blob Storage defines Cool as an online access tier optimized for infrequently accessed data stored for at least 30 days, offering lower storage costs than Hot but higher access costs. Option E (Hot) is correct because Hot is the default online access tier designed for frequently accessed data, with the highest storage cost and lowest access latency. The other options are not access tiers: Premium (A) refers to a performance-based storage account type (e.g., premium block blobs, page blobs, or file shares) rather than an access tier, and Cold (B) and Frozen (D) are not Azure Blob Storage access tiers — Azure offers Hot, Cool, Cold (in some contexts for other services), and Archive, but 'Frozen' does not exist.

Answer

Premium

Answer

Cold

Answer

Frozen

Question 6

Refer to the exhibit. You are analyzing the configuration of an Azure Storage account. Which of the following is true about this account?

Accepted Answer

It supports Azure Data Lake Storage Gen2.. The exhibit shows a storage account configured with a hierarchical namespace enabled, which is the defining characteristic of Azure Data Lake Storage Gen2. ADLS Gen2 is built on top of Blob Storage with hierarchical namespace support, so the account supports it.

Answer

It allows all network traffic by default.

Answer

Encryption uses Azure Key Vault.

Answer

It is a general-purpose v1 storage account.

Question 7

Refer to the exhibit. You are reviewing an Azure Cosmos DB account configuration. Which API is this account configured to use?

Accepted Answer

Cassandra API. The Cassandra API in Azure Cosmos DB exposes a CQL (Cassandra Query Language) endpoint and uses a schema model based on keyspaces, tables, and rows with partition keys and clustering columns. The exhibit shows these Cassandra-specific constructs, which uniquely identify the Cassandra API. Other Cosmos DB APIs use different terminology: SQL API uses containers and items, Table API uses tables and entities, and MongoDB API uses collections and documents.

Answer

Table API

Answer

SQL (Core) API

Answer

MongoDB API

Question 8

Your organization stores IoT sensor data as JSON blobs in Azure Blob Storage. You need to query this data using SQL statements without moving the data. Which Azure service should you use?

Accepted Answer

Azure Synapse Serverless SQL. Azure Synapse serverless SQL pools let you query files in Azure Data Lake Storage Gen2 (including JSON) directly using T-SQL with OPENROWSET, without provisioning or loading data into a database. This is the canonical 'query data in place' service in Azure. It supports JSON, Parquet, CSV, and Delta formats over the data lake.

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Answer

Azure Data Lake Storage Gen2

Question 9

A retail company uses Azure Cosmos DB to store product catalog data. They experience high request unit (RU) consumption during peak hours, leading to throttling. Which action should they take to reduce RU consumption without changing the application code?

Accepted Answer

Enable the Azure Cosmos DB integrated cache. The Azure Cosmos DB integrated cache is a built-in, in-memory cache that stores frequently accessed data and point reads, reducing the number of request units (RUs) consumed by serving repeated queries from the cache instead of the backend. Enabling it requires no application code changes — you simply provision a dedicated gateway and configure the cache, and subsequent reads for cached items consume far fewer RUs. This directly addresses high RU consumption during peak hours.

Answer

Switch to the Cassandra API

Answer

Create a composite index on frequently queried fields

Answer

Increase the provisioned RU/s

Question 10

A company stores IoT sensor data in Azure Blob Storage. The data is written hourly and must be retained for 90 days. After 90 days, it must be automatically deleted. Which access tier should be used for cost optimization during the retention period?

Accepted Answer

Cool tier. The Cool tier is designed for data that is infrequently accessed and stored for at least 30 days. Since the data is written hourly and retained for 90 days, it is accessed rarely after initial write, making Cool tier cost-effective for storage during the retention period. It offers lower storage costs than Hot tier while still allowing immediate access if needed.

Answer

Premium tier

Answer

Archive tier

Answer

Hot tier

Question 11

You are designing a solution that requires storing large binary files (up to 5 TB each) that are updated frequently by multiple processes. Which Azure storage feature allows concurrent writes to the same file?

Accepted Answer

Azure Files. Azure Files supports concurrent writes to the same file through the SMB protocol, which allows multiple processes or clients to open and modify a file simultaneously. This is essential for scenarios requiring shared access to large binary files (up to 5 TB each) that are frequently updated by multiple processes. Azure Files is designed for shared file storage, making it the correct choice.

Answer

Azure Blob Storage with soft delete

Answer

Azure Disks

Answer

Azure NetApp Files

Question 12

Your company uses Azure Cosmos DB with the Core (SQL) API. A collection contains millions of documents, and queries often filter by a property that is not the partition key. What should you do to improve query performance?

Accepted Answer

Create a composite index on the filtered property. Creating a composite index on the filtered property can improve query performance by making the lookup more efficient within each partition. While queries filtering on a non-partition key property will still fan out across partitions, the index reduces the processing time within each partition, thereby improving overall query performance. Changing the partition key (D) would require data migration for an existing collection with millions of documents, making it a significant re-architecture rather than a direct performance improvement step for an existing setup. Increasing RU/s (B) improves throughput but does not directly address the query's efficiency. Enabling analytical store (C) is for analytical queries, not operational.

Answer

Increase the provisioned throughput (RU/s)

Answer

Enable analytical store

Answer

Change the partition key to the filtered property

Question 13

You have applied the lifecycle management policy shown in the exhibit to an Azure Storage account. A blob named 'logs/error.log' was last modified 200 days ago. In which tier is the blob currently stored?

Accepted Answer

Archive tier. The lifecycle management policy moves blobs to the Archive tier after 180 days of no modification, so a blob last modified 200 days ago has already been transitioned to Archive. Archive is the correct tier because 200 days exceeds the 180-day threshold defined in the policy. The blob is not deleted because the policy's delete threshold (if any) would be later than 180 days.

Answer

Hot tier

Answer

The blob has been deleted

Answer

Cool tier

Question 14

A media company stores video files in Azure Blob Storage. They want to use Azure Content Delivery Network (CDN) to serve these videos globally. However, they need to restrict access to only authorized users. What should you implement?

Accepted Answer

Implement shared access signatures (SAS) and token-based authentication on the CDN.. Azure CDN can be configured to honor shared access signatures (SAS) and token-based authentication, allowing the CDN edge to validate time-limited, scoped tokens before serving blobs. This restricts access to authorized users without exposing the storage account publicly. SAS tokens can be generated per user or session with expiration and permission constraints, and the CDN passes them through to the origin.

Answer

Set the blob container to public access.

Answer

Use Azure Active Directory (Microsoft Entra ID) authentication for the CDN endpoint.

Answer

Use a firewall on the storage account to allow only CDN IP addresses.

Question 15

You are designing a solution to store customer preferences as key-value pairs. The data will be accessed frequently and must support high availability across multiple Azure regions. The solution should minimize management overhead. Which Azure service should you use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it natively stores key-value data and offers turnkey multi-region replication with high availability and low latency, while requiring minimal management overhead. Its multi-master and single-digit-millisecond performance make it ideal for frequently accessed customer preference data distributed across regions. Azure SQL Database is a relational service that would require more schema and scaling management and does not provide the same effortless global distribution. Azure Cache for Redis is primarily an in-memory cache and not a durable globally distributed database, and Azure Queue Storage is a messaging service, not a key-value store.

Answer

Azure SQL Database

Answer

Azure Cache for Redis

Answer

Azure Queue Storage