DP-900 Practice Test 32 — 15 Questions

Question 1

A company stores IoT sensor data in Azure Blob Storage. The data is structured as JSON files organized by date. Data scientists need to query this data using SQL statements without moving it. Which Azure service should they use to enable this?

Accepted Answer

Azure Synapse Serverless SQL. Azure Synapse Serverless SQL can query JSON files in Blob Storage directly using T-SQL. Option A (Azure Cosmos DB) is for NoSQL data; Option C (Azure SQL Database) is a relational database; Option D (Azure Data Lake Storage Gen2) is a storage layer, not a query service.

Answer

Azure SQL Database

Answer

Azure Data Lake Storage Gen2

Answer

Azure Cosmos DB

Question 2

A DBA runs the above KQL query in Azure Monitor for an Azure SQL Database. The query returns no results. What is the most likely reason?

Accepted Answer

Query Store is not enabled on the database. Option B is correct because the Query Store must be enabled for each database to generate runtime statistics. Option A is wrong because AzureDiagnostics is a common table for SQL diagnostics. Option C is wrong because the category name is correct. Option D is wrong because the syntax is valid.

Answer

The AzureDiagnostics table does not contain SQL data

Answer

The category name is misspelled

Answer

The KQL syntax is incorrect

Question 3

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. Option A is correct because Azure Synapse Serverless SQL can query JSON data directly from Blob Storage using OPENROWSET with SQL. Option B is wrong because Azure Cosmos DB is a NoSQL database, not a query service over Blob Storage. Option C is wrong because Azure Data Lake Storage is a storage service, not a query engine. Option D is wrong because SQL Database is a relational database, not for querying files in Blob Storage.

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Answer

Azure Data Lake Storage Gen2

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

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 6

You are designing a data storage solution for a social media application that stores user profile pictures and uploaded photos. The solution must support high throughput and be optimized for reading and writing large binary objects. Which Azure data service should you recommend?

Accepted Answer

Azure Blob Storage. Azure Blob Storage is optimized for storing large amounts of unstructured data, such as images and videos, and provides high throughput for read/write operations. Option A is wrong because Azure Cosmos DB is a NoSQL database for structured data, not optimized for large binary objects. Option B is wrong because Azure Files is a fully managed file share for SMB/NFS, not ideal for high-throughput binary object storage. Option D is wrong because Azure SQL Database is a relational database for structured data.

Answer

Azure Files

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Question 7

Which THREE of the following are features of Azure Data Lake Storage Gen2?

Accepted Answer

Integration with Azure Active Directory (Microsoft Entra ID). Azure Data Lake Storage Gen2 combines Blob Storage with a hierarchical namespace. Option A is correct: it supports POSIX-like access control lists. Option B is correct: it integrates with Azure Active Directory (Microsoft Entra ID) for authentication. Option C is correct: it supports atomic rename of directories. Option D is wrong because fixed-size blocks are a feature of Blob Storage, but Data Lake Storage Gen2 uses hierarchical namespace, not fixed-size blocks. Option E is wrong because Geo-redundant storage (GRS) is a replication option, not a feature specific to Data Lake Storage Gen2.

Answer

Geo-redundant storage (GRS)

Answer

Fixed-size block storage

Question 8

You need to store a collection of JSON documents that contain user profile data. The data is frequently queried by user ID and by email address. The solution must support indexing on multiple fields and provide low-latency queries. Which Azure service should you use?

Accepted Answer

Azure Cosmos DB. Option C is correct because Azure Cosmos DB is a NoSQL database that supports indexing on multiple fields and provides low-latency queries on JSON documents. Option A is wrong because Azure Blob Storage does not support indexing on document fields. Option B is wrong because Azure Table Storage is a key-value store with limited indexing. Option D is wrong because Azure Cache for Redis is an in-memory cache, not a durable indexed store.

Answer

Azure Table Storage

Answer

Azure Cache for Redis

Answer

Azure Blob Storage

Question 9

A company uses Azure Cosmos DB for a global e-commerce application. The application needs to support multi-region writes and provide strong consistency for inventory updates. Which configuration minimizes write latency while meeting the consistency requirement?

Accepted Answer

Single-region writes with strong consistency. Multi-region writes with strong consistency is not supported in Cosmos DB. To minimize write latency with strong consistency, use single-region writes with strong consistency. Option A (multi-master with bounded staleness) does not provide strong consistency; Option C (multi-master with eventual consistency) is weaker; Option D (single-region with session consistency) is not strong.

Answer

Multi-master with bounded staleness consistency

Answer

Single-region writes with session consistency

Answer

Multi-master with eventual consistency

Question 10

A company is choosing a non-relational data store for a new application that requires flexible schema, high availability, and low latency across multiple geographic regions. Which TWO Azure services meet these requirements?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB (option A) offers multi-region replication, flexible schema, and low latency. Azure Table Storage (option D) is a NoSQL key-value store with global replication (read-access geo-redundant storage) and low latency. Option B (Azure SQL Database) is relational. Option C (Azure Files) is file storage. Option E (Azure Cache for Redis) is an in-memory cache, not a primary data store.

Answer

Azure Files

Answer

Azure SQL Database

Answer

Azure Cache for Redis

Question 11

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. Option C is correct because Azure Blob Storage supports access tiers (Hot, Cool, Archive) for cost optimization. Option A is wrong because Azure Files is for file shares, not tiered storage for videos. Option B is wrong because Azure Disk Storage is for VM disks, not object storage. Option D is wrong because Azure Cosmos DB is a database, not for storing large binary files.

Answer

Azure Cosmos DB

Answer

Azure Files

Answer

Azure Disk Storage

Question 12

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 13

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 avoiding cross-partition scans. However, if the property is not the partition key, queries may still need to fan out across partitions. Changing the partition key would require data migration. Increasing RU/s improves throughput but does not directly address the indexing issue. Enabling analytical store 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 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 with token authentication (using shared access signatures or custom tokens) can restrict access to authorized users. Option A is wrong because public access would allow anyone. Option B is wrong because network restrictions don't work well for global users. Option C is wrong because Azure AD authentication is not directly supported by CDN for blob access; token auth is the standard approach.

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

Refer to the exhibit. An administrator creates a storage account with the Hot tier and then creates a container with the Cool tier. Data is uploaded to the container. Which access tier applies to the uploaded blobs by default?

Accepted Answer

Cool, because the container's default tier is Cool.. In Azure Blob Storage, when a container has a default access tier set, blobs uploaded without specifying a tier inherit the container's default tier. The exhibit shows the container's accessTier is Cool, so blobs will be Cool. Option A is wrong because the container's tier overrides the account tier for new blobs. Option C is wrong because this is not a serverless scenario. Option D is wrong because the cool tier is set at the container level.

Answer

Hot, because the storage account tier is Hot.

Answer

No tier; blobs are not charged until accessed.

Answer

Archive, because no tier is set.