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

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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.. Azure Table Storage does not natively support lifecycle management policies like Blob Storage does. Moving the data to Azure Storage with lifecycle management (via Azure Data Factory or AzCopy) is the correct approach. Option A is wrong because Azure Table Storage does not have automatic tiering like Blob Storage. Option B is wrong because Azure Cosmos DB is more expensive and not necessary. Option D is wrong because Azure SQL Database is a relational option not suited for this scenario.

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 11

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 Blob Storage is not optimized for low-latency document queries. Option B is wrong because Azure Table Storage is a key-value store, not ideal for complex JSON queries. Option D 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 12

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 13

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 is wrong because indexing options in Table Storage are limited. Option B is wrong because Cosmos DB is more expensive and may not be necessary. Option D is wrong because a secondary index is not supported in Table Storage.

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.

Question 14

Your team needs to store unstructured data such as documents, images, and videos for a data lake analytics project. The data will be processed by Azure Data Lake Storage Gen2. Which storage account type should you create?

Accepted Answer

StorageV2 (general-purpose v2) with hierarchical namespace enabled. Azure Data Lake Storage Gen2 requires a storage account with hierarchical namespace enabled. Option A is wrong because Blob Storage alone does not have hierarchical namespace. Option B is wrong because File Storage is for file shares. Option D is wrong because Queue Storage is for messaging.

Answer

BlobStorage

Answer

QueueStorage

Answer

FileStorage

Question 15

You are designing a solution to store customer preferences as key-value pairs. The data will be accessed frequently and must support high availability across multiple Azure regions. The solution should minimize management overhead. Which Azure service should you use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB provides global distribution, high availability, and low-latency access for key-value data with minimal management. Option A is wrong because Azure Cache for Redis is a cache, not a durable store. Option C is wrong because Azure SQL Database is relational and overkill. Option D is wrong because Azure Storage Queue is for messaging.

Answer

Azure SQL Database

Answer

Azure Cache for Redis

Answer

Azure Queue Storage