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

Question 1

You are designing a solution to store large binary files (videos) for a media company. The solution must support tiered storage to optimize costs based on access frequency. Which Azure storage option should you use?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Azure Blob Storage. Azure Blob Storage offers tiered storage (Hot, Cool, Archive) ideal for optimizing costs based on access frequency. Option A is incorrect because Azure Cosmos DB is a NoSQL database service, not designed for storing large binary files with tiered storage. Option B is incorrect because Azure Files provides fully managed file shares in the cloud, but does not support access tiers for cost optimization like Blob Storage does. Option D is incorrect because Azure Disk Storage provides block-level storage volumes for Azure VMs, not suitable for object storage with tiering.

Answer

Azure Cosmos DB

Answer

Azure Files

Answer

Azure Disk Storage

Question 2

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. Enabling the Azure Cosmos DB integrated cache caches frequently accessed data in memory, reducing the need to repeat queries against the backend and thus lowering RU consumption without changing application code. Option A is incorrect: switching to the Cassandra API does not inherently reduce RU consumption; it changes the data model and query interface. Option B is incorrect: while a composite index can improve query performance, it may increase RU consumption for writes and does not directly address read-heavy throttling. Option D is incorrect: increasing provisioned RU/s increases throughput capacity but does not reduce consumption; it may even encourage more usage and higher costs.

Answer

Switch to the Cassandra API

Answer

Create a composite index on frequently queried fields

Answer

Increase the provisioned RU/s

Question 3

You need to store event data from multiple sources in a schema-less format for later analysis. The data arrives as JSON and must be durable and highly available. Which Azure service should you use?

Accepted Answer

Azure Blob Storage. Azure Blob Storage provides durable, highly available storage for JSON blobs with schema-less format. Option B is wrong because Azure SQL Database requires a schema. Option C is wrong because Azure Event Hubs is for ingestion, not long-term storage. Option D is wrong because Azure Data Factory is an orchestration service.

Answer

Azure SQL Database

Answer

Azure Event Hubs

Answer

Azure Data Factory

Question 4

Your application uses Azure Table storage to store user preferences. You need to retrieve all preferences for a specific user quickly. Which key should you use as the partition key?

Accepted Answer

UserID. Using UserID as the partition key ensures that all preferences for a specific user are stored in the same partition, enabling fast and efficient point queries. Region, Random GUID, and Timestamp would scatter user data across multiple partitions, slowing down retrieval.

Answer

Region

Answer

Random GUID

Answer

Timestamp

Question 5

A company uses Azure Databricks to process data stored in Azure Data Lake Storage Gen2. They need to enforce fine-grained access control on files and folders based on user identity. Which security feature should they implement?

Accepted Answer

Access control lists (ACLs). Access control lists (ACLs) on Azure Data Lake Storage Gen2 provide POSIX-compliant, fine-grained permissions at the file and folder level. This allows you to grant read, write, or execute permissions to specific users or groups, which is exactly what is needed for enforcing identity-based access control on individual files and folders.

Answer

Storage account firewall rules

Answer

Shared access signatures (SAS)

Answer

Azure RBAC roles on the storage account

Question 6

You are storing log files from multiple applications in Azure Blob Storage. Each log file is a text file with timestamp data. You need to query logs for a specific date range using SQL. Which Azure service can query these files directly?

Accepted Answer

Azure Synapse Serverless SQL. Azure Synapse Serverless SQL can query text files in Azure Blob Storage using OPENROWSET with the CSV or text file format, allowing SQL queries over log files. Option A (Azure Stream Analytics) is for real-time streaming, not ad-hoc SQL batch queries. Option B (Azure Data Lake Storage) is a storage service, not a query engine. Option D (Azure Analysis Services) is for semantic models and OLAP, not direct file querying.

Answer

Azure Stream Analytics

Answer

Azure Data Lake Storage

Answer

Azure Analysis Services

Question 7

Which TWO of the following are characteristics of Azure Blob Storage?

Accepted Answer

Supports access tiers (Hot, Cool, Archive). Options B and C are correct. Azure Blob Storage supports access tiers (Hot, Cool, Archive) to optimize cost (B) and can store large binary objects like videos (C). Option A is incorrect because Blob Storage does not enforce a fixed schema; it stores unstructured data. Option D is incorrect because ACID transactions across multiple records are a feature of relational databases, not Blob Storage. Option E is incorrect because Blob Storage supports block blobs, append blobs, and page blobs.

Answer

Enforces a fixed schema for stored data

Answer

Provides ACID transactions across multiple records

Answer

Only supports block blobs

Question 8

Which THREE of the following are valid considerations when choosing between Azure Cosmos DB and Azure Table Storage?

Accepted Answer

Cosmos DB provides multiple consistency levels. Options B, C, and E are correct. Cosmos DB provides multiple consistency levels (B), supports multi-region writes (C), and automatically indexes all properties (E). Option A is incorrect because Table Storage does not support multi-region writes; that is a feature of Cosmos DB. Option D is incorrect because Cosmos DB does support JSON documents, both natively.

Answer

Table Storage supports multi-region writes

Answer

Cosmos DB does not support JSON documents

Question 9

Which TWO of the following Azure services are considered non-relational data stores?

Accepted Answer

Azure Cosmos DB. Options B and C are correct. Azure Cosmos DB (B) is a globally distributed, multi-model NoSQL database service, making it a non-relational data store. Azure Table Storage (C) is a key-value store that is also non-relational. Option A is wrong because Azure SQL Database is a relational database. Option D is wrong because Azure Synapse Analytics is a relational analytics system. Option E is wrong because Azure Database for PostgreSQL is a relational database.

Answer

Azure SQL Database

Answer

Azure Synapse Analytics

Answer

Azure Database for PostgreSQL

Question 10

Refer to the exhibit. You are storing product data in Azure Cosmos DB using the SQL API. The JSON shows a sample document. You need to query for all products in the 'Electronics' category with a price less than 200. Which query should you use?

Accepted Answer

SELECT * FROM c WHERE c.category = 'Electronics' AND c.price < 200. It uses the correct syntax: SELECT * FROM c WHERE c.category = 'Electronics' AND c.price < 200. It uses single quotes for the string value, appropriate alias 'c' from the FROM clause, and the AND operator to combine both conditions. Option A uses OR, which would return products that are either in Electronics or have price < 200, not both. Option B uses double quotes for the string, which is invalid in Cosmos DB SQL API. Option C uses alias 'p' but the FROM clause uses 'c', causing an error. Thus, D is the correct query.

Answer

SELECT * FROM c WHERE c.category = 'Electronics' OR c.price < 200

Answer

SELECT * FROM c WHERE c.category = "Electronics" AND c.price < 200

Answer

SELECT * FROM p WHERE p.category = 'Electronics' AND p.price < 200

Question 11

Refer to the exhibit. You have a CSV file stored in Azure Blob Storage. You want to query this file using Azure Synapse Serverless SQL. Which OPENROWSET option should you use?

Accepted Answer

FORMAT = 'CSV'. FORMAT = 'CSV'. In Azure Synapse Serverless SQL, the OPENROWSET function with BULK option allows querying files directly. When a CSV file is stored in Azure Blob Storage, you must specify FORMAT = 'CSV' to indicate the file format. Option A (FORMAT = 'JSON') is for JSON files, Option B (FORMAT = 'PARQUET') is for Parquet files, and Option D (FORMAT = 'DELTA') is for Delta Lake tables. Therefore, only FORMAT = 'CSV' correctly handles the CSV file.

Answer

FORMAT = 'JSON'

Answer

FORMAT = 'PARQUET'

Answer

FORMAT = 'DELTA'

Question 12

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 optimized for data that is infrequently accessed and stored for at least 30 days, with lower storage costs and higher access costs. Hot tier is for frequent access and would be more expensive. Archive tier has a 180-day minimum retention penalty. Premium tier is for high transaction volumes and is not cost-effective for this scenario.

Answer

Premium tier

Answer

Archive tier

Answer

Hot tier

Question 13

You are designing a solution to store JSON documents from a web application. Each document is about 10 KB and must be queried by a unique ID. Which Azure data store is most appropriate?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a NoSQL database that natively supports JSON documents and provides low-latency queries by ID. Azure Blob Storage stores blobs but is not optimized for querying by document ID. Azure SQL Database is relational and requires schema. Azure Table Storage is key-value but less feature-rich for JSON documents.

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Blob Storage

Question 14

A company uses Azure Blob Storage to store video files for a streaming service. The files are accessed frequently for the first 30 days after upload, then rarely after. The company wants to minimize storage costs while maintaining fast access for frequently accessed files. What should they implement?

Accepted Answer

Blob lifecycle management policies. Blob lifecycle management policies allow you to automatically transition blobs to cooler, cheaper access tiers (e.g., from Hot to Cool or Archive) based on age. This directly addresses the requirement: after 30 days of frequent access, the policy moves the video files to a lower-cost tier, reducing storage costs while keeping the Hot tier available for the initial high-access period.

Answer

Azure Content Delivery Network (CDN)

Answer

Azure Files shares

Answer

Geo-redundant storage (GRS)

Question 15

You need to store telemetry data from millions of devices. Each record includes a device ID, timestamp, and metric value. The data will be queried by device ID and time range. Which Azure data store is best suited for this scenario?

Accepted Answer

Azure Data Explorer. Azure Data Explorer (ADX) is optimized for time-series data and can ingest high volumes of telemetry, with fast queries on time ranges and device IDs. Azure Cosmos DB is good for real-time apps but less efficient for large-scale time-series analytics. Azure SQL Database is relational and may not scale as well. Azure Storage Queues are for messaging, not storage/query.

Answer

Azure SQL Database

Answer

Azure Storage Queues

Answer

Azure Cosmos DB