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

Question 1

A company uses Azure Data Lake Storage Gen2 to store analytics data. The security team requires that all data access be audited, including read, write, and delete operations. Which feature should you enable?

Accepted Answer

Enable Storage Analytics logging.. Storage Analytics logging captures detailed information about successful and failed requests to a storage account, including read, write, and delete operations. This log data can be used for auditing and analysis, meeting the security team's requirement to audit all data access. The logs are stored in a $logs container within the same storage account.

Answer

Enable Microsoft Purview.

Answer

Enable Azure Monitor for the storage account.

Answer

Enable Microsoft Defender for Cloud.

Question 2

You need to choose a non-relational data store for a key-value workload where each item is identified by a partition key and row key. Which Azure service should you use?

Accepted Answer

Azure Table Storage. Azure Table Storage is a key-value store that uses partition key and row key. Option A is wrong because Cosmos DB can also do key-value but Table Storage is simpler. Option C is wrong because Blob Storage is for blobs. Option D is wrong because Files is for file shares.

Answer

Azure Blob Storage

Answer

Azure Files

Answer

Azure Cosmos DB

Question 3

Which TWO scenarios are appropriate for using Azure Blob Storage? (Choose two.)

Accepted Answer

Storing backup files and archival data.. Azure Blob Storage is designed for storing large amounts of unstructured data, such as binary files and text. Backup files and archival data are ideal use cases because Blob Storage supports hot, cool, and cold access tiers optimized for long-term retention and cost-effective storage. Additionally, storing images and videos for a website leverages Blob Storage's ability to serve static assets directly via HTTP/HTTPS, with built-in CDN integration for fast global delivery.

Answer

Storing key-value pairs with partition and row keys.

Answer

Running SQL queries on structured data.

Answer

Storing JavaScript functions for server-side logic.

Question 4

Which THREE are benefits of using Azure Cosmos DB? (Choose three.)

Accepted Answer

Automatically indexes all data.. Cosmos DB offers guaranteed low-latency reads/writes, automatic indexing, and global distribution. Option A is wrong because Cosmos DB is a NoSQL database. Option D is wrong because Cosmos DB does not require a schema. Option E is wrong because storage is not unlimited; there are limits per container.

Answer

Supports SQL Server integration.

Answer

Requires a fixed schema for all documents.

Question 5

Which TWO are valid access tiers for Azure Blob Storage? (Choose two.)

Accepted Answer

Cool. Hot, Cool, and Archive are the three access tiers. Premium is a performance tier, not an access tier. Cold is not a standard tier.

Answer

Premium

Answer

Cold

Answer

Frozen

Question 6

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 7

Refer to the exhibit. You are analyzing the configuration of an Azure Storage account. Which of the following is true about this account?

Accepted Answer

It supports Azure Data Lake Storage Gen2.. The property 'isHnsEnabled' is set to true, which enables the hierarchical namespace for Azure Data Lake Storage Gen2. Option A is wrong because the storage is not Blob Storage only; it's StorageV2 with HNS. Option C is wrong because the network ACLs have default action 'Deny' and no rules, so access is denied by default. Option D is wrong because the encryption key source is Microsoft.Storage, not Azure Key Vault.

Answer

It allows all network traffic by default.

Answer

Encryption uses Azure Key Vault.

Answer

It is a general-purpose v1 storage account.

Question 8

Refer to the exhibit. You are reviewing an Azure Cosmos DB account configuration. Which API is this account configured to use?

Accepted Answer

Cassandra API. The 'capabilities' array includes 'EnableCassandra', which indicates the Cassandra API is enabled. Option A is wrong because SQL API would have 'EnableSQL' capability. Option C is wrong because MongoDB would have 'EnableMongo'. Option D is wrong because Table API would have 'EnableTable'.

Answer

Table API

Answer

SQL (Core) API

Answer

MongoDB API

Question 9

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 10

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. Option D is correct because 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 11

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. Option B is correct because Azure Cosmos DB is a globally distributed NoSQL database that natively supports JSON documents with flexible schema. Option A is wrong because Azure SQL Database is relational and enforces schema. Option C is wrong because Blob Storage stores unstructured data but does not provide a query interface for JSON documents. Option D is wrong because Table Storage is for key-value data, not document storage.

Answer

Azure Table Storage

Answer

Azure SQL Database

Answer

Azure Blob Storage

Question 12

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 13

A retail company uses Azure Cosmos DB to store product catalog data. They experience high request unit (RU) consumption during peak hours, leading to throttling. Which action should they take to reduce RU consumption without changing the application code?

Accepted Answer

Enable the Azure Cosmos DB integrated cache. Option D is correct because enabling Cosmos DB caching (Azure Cosmos DB integrated cache) reduces RU consumption by serving repeated queries from cache. Option A is wrong because increasing RU/s would raise costs and not reduce consumption. Option B is wrong because creating a secondary index would increase RU consumption for writes. Option C is wrong because switching to Cassandra API may not reduce RU consumption.

Answer

Switch to the Cassandra API

Answer

Create a composite index on frequently queried fields

Answer

Increase the provisioned RU/s

Question 14

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. Option A is correct because Azure Blob Storage provides durable, highly available storage for JSON blobs with schema-less format. Option B is wrong because Azure SQL Database requires a schema. Option C is wrong because Azure Event Hubs is for ingestion, not long-term storage. Option D is wrong because Azure Data Factory is an orchestration service.

Answer

Azure SQL Database

Answer

Azure Event Hubs

Answer

Azure Data Factory

Question 15

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. Option A is correct because using UserID as partition key ensures all data for a user is stored in one partition, enabling fast point queries. Option B is wrong because Timestamp as partition key would scatter user data. Option C is wrong because Region may not group user data. Option D is wrong because random GUID would scatter data.

Answer

Region

Answer

Random GUID

Answer

Timestamp