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

Question 1

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 2

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. Option B is correct because Azure Synapse Serverless SQL can query text files in Blob Storage using OPENROWSET. Option A is wrong because Azure Stream Analytics is for real-time streaming, not batch query. Option C is wrong because Azure Analysis Services is for semantic models. Option D is wrong because Azure Data Lake Storage is storage, not query.

Answer

Azure Stream Analytics

Answer

Azure Data Lake Storage

Answer

Azure Analysis Services

Question 3

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

Accepted Answer

Supports access tiers (Hot, Cool, Archive). Options A and C are correct. Blob Storage supports storing large unstructured data like videos (A) and provides access tiers (C). Option B is wrong because Blob Storage does not enforce a schema. Option D is wrong because Blob Storage is not a relational database. Option E is wrong because Blob Storage supports both block and append blobs.

Answer

Enforces a fixed schema for stored data

Answer

Provides ACID transactions across multiple records

Answer

Only supports block blobs

Question 4

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 A, B, and C are correct. Cosmos DB offers multi-region writes (A), multiple consistency models (B), and automatic indexing (C). Option D is wrong because both support serverless. Option E is wrong because both support JSON.

Answer

Table Storage supports multi-region writes

Answer

Cosmos DB does not support JSON documents

Question 5

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

Accepted Answer

Azure Cosmos DB. Options A and C are correct. Azure Cosmos DB is a NoSQL database (A), and Azure Table Storage is a key-value store (C). Option B is wrong because Azure SQL Database is relational. Option D is wrong because Azure Database for PostgreSQL is relational. Option E is wrong because Azure Synapse Analytics is a relational analytics system.

Answer

Azure SQL Database

Answer

Azure Synapse Analytics

Answer

Azure Database for PostgreSQL

Question 6

Refer to the exhibit. You are designing an Azure Table storage schema for user settings. The JSON shows a sample entity. Which query will retrieve all settings for user123 efficiently?

Accepted Answer

Filter by PartitionKey eq 'user123' and RowKey eq 'settings'. Option B is correct because using PartitionKey and RowKey together is a point query, which is the most efficient in Table storage. Option A is wrong because filtering only by PartitionKey scans the entire partition. Option C is wrong because filtering by RowKey without PartitionKey performs a full table scan. Option D is wrong because filtering by both properties with OR is inefficient.

Answer

Filter by RowKey eq 'settings'

Answer

Filter by PartitionKey eq 'user123'

Answer

Filter by PartitionKey eq 'user123' or RowKey eq 'settings'

Question 7

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. Option A is correct because the SQL API uses SELECT * FROM c WHERE c.category = 'Electronics' AND c.price < 200. Option B is wrong because using double quotes is invalid. Option C is wrong because the FROM clause is incorrect. Option D is wrong because the WHERE clause uses OR instead of AND.

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 8

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'. Option D is correct because FORMAT = 'CSV' specifies the file format for CSV files. Option A is wrong because FORMAT = 'JSON' is for JSON files. Option B is wrong because FORMAT = 'PARQUET' is for Parquet files. Option C is wrong because FORMAT = 'DELTA' is for Delta Lake.

Answer

FORMAT = 'JSON'

Answer

FORMAT = 'PARQUET'

Answer

FORMAT = 'DELTA'

Question 9

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 10

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 11

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 12

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

Question 13

A company is migrating on-premises Hadoop HDFS data to Azure. They want to keep the same file system semantics for compatibility with existing analytics jobs. Which Azure storage solution should they use?

Accepted Answer

Azure Data Lake Storage Gen2. Azure Data Lake Storage Gen2 (ADLS Gen2) provides Hadoop-compatible file system semantics (hierarchical namespace) and is built on Blob Storage. Azure Blob Storage does not have a hierarchical namespace by default. Azure Cosmos DB and Azure SQL are not file systems.

Answer

Azure Blob Storage

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Question 14

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 SMB protocol with leasing and oplocks, allowing multiple clients to read/write the same file with proper coordination. Blob Storage does not support concurrent writes to the same blob without custom logic. Azure Disks are for VM disks, not shared access. Azure NetApp Files provides shared file access but is more expensive and complex.

Answer

Azure Blob Storage with soft delete

Answer

Azure Disks

Answer

Azure NetApp Files

Question 15

A company stores customer data in Azure Table Storage. They need to query by a combination of partition key (customer region) and row key (customer ID). Which query pattern is most efficient?

Accepted Answer

Query using both PartitionKey and RowKey. Table Storage is optimized for point queries using both PartitionKey and RowKey. Using both keys allows direct access to the entity without scanning. Filtering only by RowKey across partitions results in a full table scan. Using only PartitionKey retrieves all rows in that partition, which is less efficient. Scanning all entities is the worst.

Answer

Query using RowKey only

Answer

Scan all entities

Answer

Query using PartitionKey only