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

Question 1

Drag and drop the steps to configure a firewall rule for Azure SQL Database in the correct order.

Accepted Answer

Identify the client IP address, then add a firewall rule with that IP range to the Azure SQL Server, then save the rule.. Firewall rules are set at the server level to allow client IP addresses to access the database.

Answer

Add a firewall rule with a broad IP range to the Azure SQL Server, then identify the client IP address, then save the rule.

Answer

Add a firewall rule to the Azure SQL Server, save the rule, then identify the client IP address.

Answer

Identify the client IP address, then save the rule, then add a firewall rule to the Azure SQL Server.

Question 2

Match each Azure storage redundancy option to its description.

Accepted Answer

LRS: Data is replicated three times within a single datacenter in the primary region.. Azure storage redundancy options differ in durability and availability. LRS is cost-effective, ZRS protects against zone failures, GRS adds geo-replication, and RA-GRS enables read access to the secondary region.

Answer

LRS: Data is replicated across multiple geographical regions.

Answer

ZRS: Data is replicated within a single datacenter.

Question 3

Match each Azure SQL Database tier to its description.

Accepted Answer

Basic: For low-cost, small-scale workloads with limited performance needs. Azure SQL Database tiers: Basic (low-cost, small), Standard (mid-range, predictable), Premium (high-performance, mission-critical), Hyperscale (large, scalable). Common confusions: mixing Premium and Basic, or Standard and Hyperscale.

Answer

Basic: For high-performance, mission-critical workloads with low latency

Answer

Standard: For extremely large databases and high scalability

Question 4

A company stores sensor data in Azure Blob Storage. The data is appended every minute and rarely modified. The compliance team requires that blobs older than 90 days be moved to a more cost-effective storage tier, and blobs older than 365 days be deleted. Which solution should you recommend?

Accepted Answer

Configure a Blob Storage lifecycle management policy.. A lifecycle management policy can automatically transition blobs to cooler storage tiers (e.g., Cool after 90 days) and delete blobs after 365 days. This directly meets the compliance requirements. Option A is incorrect because Azure Backup is for backing up data, not for lifecycle management. Option C is incorrect because Soft Delete is for recovery from accidental deletion, not for automated tiering or deletion. Option D is incorrect because Azure Files is a file share service, not designed for automated lifecycle policies on blobs.

Answer

Use Azure Backup to set a retention policy for the storage account.

Answer

Enable Blob Soft Delete and set retention days to 365.

Answer

Move the blobs to Azure Files and set a file retention policy.

Question 5

A company stores terabytes of historical log data in Azure Blob Storage. The data is rarely accessed but must be retained for 10 years for compliance. The company wants to minimize storage costs. Which storage tier should you use?

Accepted Answer

Archive tier. The Archive tier is the correct choice because it is designed for data that is rarely accessed and has a flexible retrieval latency (hours), making it ideal for long-term retention of historical logs. It offers the lowest storage cost among Azure Blob Storage tiers, which directly minimizes costs for data that must be kept for 10 years but is seldom read.

Answer

Cool tier

Answer

Hot tier

Answer

Premium tier

Question 6

A company uses Azure Table Storage to store user session data. The data must be encrypted at rest. What should you do?

Accepted Answer

No action is required; Azure Storage encrypts data at rest by default.. Azure Table Storage, as part of Azure Storage, automatically encrypts all data at rest using Azure Storage Service Encryption (SSE) with 256-bit AES encryption. This encryption is enabled by default for all new and existing storage accounts, including Table Storage, and cannot be disabled. Therefore, no additional action is required to meet the encryption-at-rest requirement.

Answer

Enable Azure Storage Service Encryption (SSE).

Answer

Use Azure SQL Database Transparent Data Encryption (TDE).

Answer

Implement client-side encryption before storing data.

Question 7

You are designing a solution to store IoT device telemetry data. Each message is a small JSON payload (1-2 KB). The data is written once and read frequently for real-time dashboards. Which Azure data store should you use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it is a globally distributed, multi-model database service that offers single-digit millisecond read and write latencies at any scale, making it ideal for real-time dashboards consuming IoT telemetry. Its support for JSON documents natively aligns with the small JSON payloads, and its ability to handle high-throughput writes (once) and low-latency reads (frequently) without schema management fits the workload perfectly.

Answer

Azure SQL Database

Answer

Azure Blob Storage

Answer

Azure Table Storage

Question 8

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 9

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 10

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 11

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 correct because this configuration supports Azure Data Lake Storage Gen2. Option B is wrong because the network ACLs have default action 'Deny' and no rules, so access is denied by default. Option C is wrong because the encryption key source is Microsoft.Storage, not Azure Key Vault. Option D is wrong because the account kind is StorageV2, not general-purpose v1.

Answer

It allows all network traffic by default.

Answer

Encryption uses Azure Key Vault.

Answer

It is a general-purpose v1 storage account.

Question 12

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 C is correct. Option A (Table API) would have 'EnableTable', Option B (SQL/Core API) would have 'EnableSQL' or no capability, and Option D (MongoDB API) would have 'EnableMongo'.

Answer

Table API

Answer

SQL (Core) API

Answer

MongoDB API

Question 13

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. Azure Synapse Serverless SQL (part of Azure Synapse Analytics) can directly query JSON files stored in Azure Blob Storage using T-SQL statements via OPENROWSET, without the need to move or load the data. Option A is wrong because Azure SQL Database is a relational database service that requires data to be imported into tables. Option B is wrong because Azure Cosmos DB is a NoSQL database service, not a query engine for Blob Storage. Option C is wrong because Azure Data Lake Storage Gen2 is a hierarchical storage service, not a query capability.

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Answer

Azure Data Lake Storage Gen2

Question 14

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 15

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

Answer

Azure Table Storage

Answer

Azure SQL Database

Answer

Azure Blob Storage