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

Question 1

Refer to the exhibit. An administrator deploys this Azure Policy assignment. What is the most likely effect on storage account 'storage1'?

Accepted Answer

Public network access will be denied.. The Azure Policy assignment shown in the exhibit denies the creation or update of storage accounts that do not have public network access disabled. Since 'storage1' is subject to this policy, the policy will enforce the 'Deny' effect, preventing any configuration that allows public network access. If 'storage1' already exists and is compliant, it remains; if it is non-compliant, the policy will block changes that would enable public access, effectively denying public network access.

Answer

The storage account will be deleted.

Answer

Firewall rules will be added.

Answer

Soft Delete will be enabled.

Question 2

A company uses Azure Table storage to store session state for a web application. They notice that read latency increases during peak hours. Which design change should they implement to reduce latency?

Accepted Answer

Use a partition key that distributes load evenly, such as UserID. Azure Table storage partitions data based on the partition key. Using a partition key that distributes load evenly, such as UserID, ensures that read requests are spread across multiple partition servers, preventing hot partitions and reducing latency during peak hours.

Answer

Change to Azure Blob storage

Answer

Store large attributes in a separate table

Answer

Switch to Azure Queue storage

Question 3

Your team needs to store JSON documents that require schema flexibility and global distribution. Which Azure data store should you choose?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a globally distributed, multi-model database service that natively supports JSON documents with schema flexibility. It offers turnkey global distribution, multi-master replication, and low-latency access worldwide, making it the ideal choice for JSON documents requiring global distribution.

Answer

Azure Table Storage

Answer

Azure SQL Database

Answer

Azure Blob Storage

Question 4

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?

Accepted Answer

Azure Blob Storage. Azure Blob Storage is the correct choice because it is designed for storing large unstructured binary data (videos, images, documents) and supports tiered storage — Hot, Cool, Cold, and Archive access tiers — to optimize costs based on access frequency. Cosmos DB is a NoSQL database, Azure Files is a managed SMB/NFS file share, and Azure Disk Storage provides block-level disks for VMs, none of which offer blob-specific tiering for large media files.

Answer

Azure Cosmos DB

Answer

Azure Files

Answer

Azure Disk Storage

Question 5

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 is the correct choice because it natively stores unstructured and schema-less data such as JSON at massive scale, with built-in durability (LRS/GRS/ZRS) and high availability. It is designed for exactly this scenario: ingesting event data from multiple sources in raw format for later analytics via tools like Azure Synapse or Databricks. Blob Storage does not impose a schema, making it ideal for JSON payloads that may vary between sources.

Answer

Azure SQL Database

Answer

Azure Event Hubs

Answer

Azure Data Factory

Question 6

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. In Azure Table Storage, the partition key determines which partition stores the entity, and entities with the same partition key are stored together and can be retrieved with a single partition scan. Using UserID as the partition key groups all preferences for a user into one partition, enabling fast point queries by PartitionKey + RowKey.

Answer

Region

Answer

Random GUID

Answer

Timestamp

Question 7

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 8

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 pool can query text files in Azure Blob Storage directly using T-SQL with OPENROWSET or external tables, without loading the data. It supports querying CSV, JSON, and Parquet files and can filter by timestamp columns. This makes it ideal for ad-hoc SQL queries over log files stored in Blob Storage.

Answer

Azure Stream Analytics

Answer

Azure Data Lake Storage

Answer

Azure Analysis Services

Question 9

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

Accepted Answer

Supports access tiers (Hot, Cool, Archive). Option B is correct because Azure Blob Storage natively supports access tiers — Hot, Cool, Cold, and Archive — allowing you to optimize storage cost versus access latency based on how frequently data is read. Option C is correct because Blob Storage is designed for unstructured data and can store massive binary objects such as videos, images, backups, and disk images, with block blobs supporting up to roughly 190.7 TiB per blob. Option A is incorrect because Blob Storage is schema-less and stores unstructured data, unlike Azure Table Storage or a relational database. Option D is incorrect because ACID transactions across multiple records are a feature of relational databases such as Azure SQL Database, not Blob Storage. Option E is incorrect because Blob Storage supports three blob types — block blobs, append blobs, and page blobs — not only block blobs.

Answer

Enforces a fixed schema for stored data

Answer

Provides ACID transactions across multiple records

Answer

Only supports block blobs

Question 10

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. Option B is correct because Azure Cosmos DB exposes five well-defined consistency levels (strong, bounded staleness, session, consistent prefix, and eventual), letting you trade off latency and consistency per workload, whereas Azure Table Storage offers only strong consistency within a region. Option C is correct because Cosmos DB supports multi-region writes (multi-master) across its configured regions, allowing writes to any region and automatic conflict resolution, which is a key differentiator from Table Storage. Option E is correct because Cosmos DB automatically indexes every property in a document by default (with an indexing policy you can tune), so no manual index management is needed, unlike Table Storage where you must design and maintain partition/row key indexes yourself. Option A is not correct because Azure Table Storage is single-region for writes; it supports read-access geo-redundant storage (RA-GRS) for read-only replicas, not multi-region writes. Option D is not correct because Cosmos DB's SQL (Core) API stores data as JSON documents, and it also offers APIs for other models, so it fully supports JSON.

Answer

Table Storage supports multi-region writes

Answer

Cosmos DB does not support JSON documents

Question 11

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 12

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'. In Azure Table storage the PartitionKey groups all entities belonging to the same logical partition, and specifying both PartitionKey eq 'user123' and RowKey eq 'settings' performs a precise point query that targets a single entity with the lowest latency and lowest RU cost. Since the scenario asks for all settings for user123, using PartitionKey 'user123' with the specific RowKey 'settings' retrieves exactly that entity efficiently. Option A is inefficient because filtering only on RowKey forces a full table scan across all partitions. Option C would return all entities for user123 across different RowKeys, which may be broader than needed and less efficient than a point query. Option D uses an OR condition on PartitionKey and RowKey, which prevents an efficient index seek and results in a full table scan.

Answer

Filter by RowKey eq 'settings'

Answer

Filter by PartitionKey eq 'user123'

Answer

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

Question 13

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 14

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'. OPENROWSET in Azure Synapse serverless SQL pools uses the FORMAT argument to tell the parser how to interpret the file. Since the file is a CSV, FORMAT = 'CSV' is the correct option — it invokes the CSV parser and allows you to specify FIELDTERMINATOR, ROWTERMINATOR, and FIRSTROW parameters. The other FORMAT values correspond to entirely different file structures and would cause parsing errors or empty result sets.

Answer

FORMAT = 'JSON'

Answer

FORMAT = 'PARQUET'

Answer

FORMAT = 'DELTA'

Question 15

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 globally distributed, multi-model database that natively supports JSON documents and provides low-latency, high-throughput access. It allows querying by unique ID and is designed for flexible schema, making it ideal for storing JSON documents from a web application. Its Core (SQL) API supports JSON natively.

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Blob Storage