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

Question 1

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?

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

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 2

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 3

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

Question 4

You need to provide temporary access to a specific blob in Azure Blob Storage for a limited time. The access should be time-limited and require no authentication from the user. Which mechanism should you use?

Accepted Answer

Shared access signatures (SAS). Shared access signatures (SAS) provide time-limited, delegated access to storage resources without requiring the account key. Storage account keys provide full access and never expire. RBAC is for identity-based access, not anonymous. Access keys are long-lived secrets.

Answer

Storage account keys

Answer

Anonymous public access

Answer

Azure RBAC roles

Question 5

Which TWO of the following are benefits of using Azure Table Storage over Azure Blob Storage for storing semi-structured data?

Accepted Answer

Supports querying by partition key and row key. Table Storage supports key-value access and automatic indexing of partition and row keys, making queries by key efficient. Blob Storage is for unstructured data and does not provide built-in key-based querying. Both have REST APIs. Blob Storage has higher throughput for large files.

Answer

Provides automatic indexing of all attributes

Answer

Supports REST API access

Answer

Offers higher throughput for large files

Question 6

Which THREE of the following are valid considerations when choosing between Azure Blob Storage and Azure Data Lake Storage Gen2 for a big data analytics workload?

Accepted Answer

ADLS Gen2 can be optimized for high-throughput analytics workloads. ADLS Gen2 supports a hierarchical namespace, POSIX-like permissions, and is cost-effective for both hot and cool tiers. Blob Storage lacks hierarchical namespace by default. Both support lifecycle management. ADLS Gen2 can be used with Blob APIs but also has additional features.

Answer

Blob Storage provides POSIX-compliant access control lists (ACLs)

Answer

ADLS Gen2 cannot use Blob Storage APIs

Question 7

Which TWO of the following are features of Azure Cosmos DB that help ensure high availability?

Accepted Answer

Automatic failover. Cosmos DB supports multi-region writes and automatic failover for high availability. Point-in-time restore and change feed are features but not directly for high availability.

Answer

Data encryption at rest

Answer

Change feed

Answer

Point-in-time restore

Question 8

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 policy moves blobs to Cool after 30 days and to Archive after 90 days. Since the blob was modified 200 days ago, it has already been moved to Archive after 90 days. The delete action occurs after 365 days, so it has not been deleted yet. Therefore, the blob is in the Archive tier.

Answer

Hot tier

Answer

The blob has been deleted

Answer

Cool tier

Question 9

You are analyzing a SQL script for an Azure Synapse Analytics dedicated SQL pool as shown in the exhibit. The table 'SensorData' will contain billions of rows. Which statement about the table design is correct?

Accepted Answer

The table uses a clustered columnstore index, which is ideal for large data warehousing tables. A hash distribution on DeviceID distributes rows across distributions based on the hash of DeviceID, which is good for large tables queried frequently by DeviceID. Clustered columnstore index is optimal for large tables in Synapse. Round-robin is for staging tables. Clustered index is for small tables. The table is not replicated because replication is for small dimension tables.

Answer

The table is replicated across all compute nodes

Answer

The table uses round-robin distribution

Answer

The table uses a heap structure

Question 10

You have an Azure Blob Storage container configured with the JSON snippet shown in the exhibit. What does the 'publicAccess' setting of 'Blob' allow?

Accepted Answer

Anonymous users can read blobs if they know the blob URL. The 'Blob' level of public access allows anonymous read access to blobs only; container metadata is not accessible. 'Container' level would allow anonymous listing of blobs. 'None' disables public access. 'Storage' is not a valid value.

Answer

Anonymous users can write blobs

Answer

No anonymous access is allowed

Answer

Anonymous users can list blobs in the container

Question 11

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, making it ideal for user profile pictures and uploaded photos. Azure Files (A) is a managed file share for SMB/NFS, not optimized for high-throughput binary object operations. Azure SQL Database (C) is a relational database for structured data, not designed for large binary objects. Azure Cosmos DB (D) is a NoSQL database primarily for structured or semi-structured data, not for storing large blobs efficiently.

Answer

Azure Files

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Question 12

A company stores IoT sensor data in Azure Table Storage. The data is accessed frequently for the first 30 days, then rarely. You need to minimize storage costs while ensuring data is available for queries within 24 hours of a request. What should you implement?

Accepted Answer

Move data older than 30 days to Azure Blob Storage Cool tier and use an Azure Data Factory pipeline to copy data back to Table Storage when requested.. It addresses the requirement to minimize costs by moving older data to Azure Blob Storage Cool tier, which is cheaper, while still allowing access within 24 hours via an Azure Data Factory pipeline to copy data back to Table Storage on demand. Option A is incorrect because Azure Table Storage does not support automatic lifecycle management policies like Blob Storage does. Option B is incorrect because Azure SQL Database is a relational database and not optimized for IoT sensor data; it would be more expensive and complex. Option C is incorrect because Azure Cosmos DB is generally more expensive than Table Storage and using TTL would delete data permanently, not provide a way to restore it within 24 hours.

Answer

Configure a lifecycle management policy on the Table Storage account to move data to Cool tier after 30 days.

Answer

Store all data in Azure SQL Database and use index maintenance to improve query performance.

Answer

Migrate the data to Azure Cosmos DB and use Time-to-Live (TTL) to expire old data.

Question 13

You need to store JSON documents for a web application that requires low-latency reads and writes globally. The data has no fixed schema. Which Azure service should you use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a globally distributed, multi-model database that natively supports JSON documents with low-latency reads and writes. Option A is wrong because Azure Table Storage is a key-value store, not ideal for complex JSON queries. Option B is wrong because Azure Blob Storage is not optimized for low-latency document queries. Option C is wrong because Azure SQL Database is relational and requires a fixed schema.

Answer

Azure Table Storage

Answer

Azure Blob Storage

Answer

Azure SQL Database

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.. To restrict access to authorized users when serving video files from Azure Blob Storage via Azure CDN, you should implement token-based authentication using shared access signatures (SAS). SAS tokens grant time-limited, specific permissions to clients, and Azure CDN can be configured to require these tokens before delivering content. This ensures only authorized users can access the videos. Option A is incorrect because making the blob container public would allow unrestricted access to anyone. Option B is incorrect because Azure Active Directory authentication is not directly supported by Azure CDN for blob access; token-based authentication with SAS is the standard approach. Option D is incorrect because a storage account firewall restricting to CDN IP addresses only limits the network source, not individual user authorization; any request coming from the CDN IP would still be served without user-level authentication.

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

Your application stores millions of small log entries in Azure Table Storage. Queries by partition key and row key are fast, but you also need to query by timestamp across partitions. The query performance is slow. What is the best way to improve query performance?

Accepted Answer

Create a new table with the timestamp as the partition key and copy data there for time-based queries.. Creating a separate table with timestamp as the partition key allows efficient range queries across all data. Option A (migrate to Azure Cosmos DB) is wrong because Cosmos DB is significantly more expensive and may be overkill for this scenario. Option B (Azure Cognitive Search) is wrong because it is designed for full-text search, not for optimizing time-based queries on Table Storage. Option C is correct as it enables partition-level queries by timestamp. Option D is wrong because Table Storage does not support secondary indexes.

Answer

Migrate the data to Azure Cosmos DB and use the SQL API.

Answer

Use Azure Cognitive Search to index the Table Storage data.

Answer

Add a secondary index on the timestamp column.