DP-900 Describe core data concepts Practice Test 16 — 15 Questions

Question 1

A multinational corporation needs to store archival data for 10 years with the lowest possible storage cost, while still being able to retrieve it within 24 hours if needed. Which Azure storage tier should they use?

Accepted Answer

Archive Blob Storage. Archive Blob Storage is the correct choice because it is designed for long-term retention of data that is rarely accessed, offering the lowest storage cost among Azure blob tiers. The 10-year retention requirement and 24-hour retrieval window align perfectly with Archive's capabilities, as data can be rehydrated to a hot or cool tier within hours (typically up to 15 hours for standard priority rehydration).

Answer

Cool Blob Storage

Answer

Premium Blob Storage

Answer

Hot Blob Storage

Question 2

A healthcare organization needs to store patient records that must be immutable and cannot be modified or deleted for 7 years due to regulatory compliance. Which Azure feature should they use?

Accepted Answer

Azure Blob Storage immutable storage. Azure Blob Storage immutable storage is correct because it provides WORM (Write Once, Read Many) capabilities that prevent data from being modified or deleted for a specified retention period. This directly meets the regulatory requirement for patient records to remain immutable for 7 years, as the policy is enforced at the storage level and cannot be overridden by any user, including administrators.

Answer

Microsoft Purview

Answer

Azure Policy

Answer

Microsoft Defender for Cloud

Question 3

A company wants to run SQL queries on data stored in Azure Cosmos DB for NoSQL. Which API should they use?

Accepted Answer

Core (SQL) API. The Core (SQL) API is the native API for Azure Cosmos DB for NoSQL, designed to query JSON documents using a SQL-like syntax. Since the requirement is to run SQL queries on data stored in Azure Cosmos DB for NoSQL, this API directly supports that need without requiring any protocol translation or schema mapping.

Answer

Gremlin API

Answer

Cassandra API

Answer

MongoDB API

Question 4

A data analyst needs to create interactive dashboards that display real-time data from Azure SQL Database. Which Microsoft tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for creating interactive dashboards and reports, and it supports real-time data connectivity to Azure SQL Database through DirectQuery or streaming datasets. This allows the data analyst to visualize live data without manual refreshes, meeting the requirement for real-time dashboards.

Answer

Microsoft Excel

Answer

Microsoft Copilot

Answer

Azure Data Studio

Question 5

An e-commerce company uses Azure Cosmos DB for its product catalog. They need to ensure that read requests are served from the nearest Azure region to reduce latency. Which feature should they use?

Accepted Answer

Cosmos DB multi-region writes. Cosmos DB multi-region writes (correctly referred to as multi-region reads in this context) allows you to configure your database account to be read from multiple Azure regions, enabling the SDK to automatically route read requests to the nearest region based on the client's location. This reduces latency by serving reads from a local replica without requiring a separate global load-balancing service.

Answer

Azure Front Door

Answer

Azure Content Delivery Network

Answer

Microsoft Traffic Manager

Question 6

Which TWO Azure services are primarily used for data integration and orchestration?

Accepted Answer

Azure Logic Apps. Azure Logic Apps is correct because it is a serverless workflow service that integrates apps, data, and services using connectors and triggers, making it ideal for data integration and orchestration. Azure Data Factory is correct because it is a cloud-based ETL and data integration service that orchestrates and automates data movement and transformation across various data stores.

Answer

Azure Synapse Analytics

Answer

Azure Stream Analytics

Answer

Azure Analysis Services

Question 7

Which THREE are valid Azure data storage services that support semi-structured data?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a fully managed NoSQL database service that natively supports semi-structured data through its flexible schema model, allowing documents, key-value pairs, and graph data. It provides multiple APIs (SQL, MongoDB, Cassandra, Gremlin, and Table) to interact with semi-structured data, making it a valid choice for this question.

Answer

Azure SQL Database

Answer

Azure Data Lake Storage

Question 8

Which TWO are advantages of using a NoSQL database like Azure Cosmos DB over a relational database like Azure SQL Database?

Accepted Answer

Flexible schema design. Option C is correct because NoSQL databases like Azure Cosmos DB are schema-agnostic, allowing each document or item to have a different structure without requiring migrations or predefined table schemas. This flexibility is ideal for rapidly evolving applications or when ingesting heterogeneous data, whereas Azure SQL Database enforces a rigid schema that must be defined and altered explicitly.

Answer

Support for complex joins

Answer

ACID transactions across multiple records

Answer

Enforced referential integrity

Question 9

A company wants to store historical sales data for long-term analysis. The data is accessed infrequently but must be retained for 7 years. Which Azure storage tier minimizes cost while meeting these requirements?

Accepted Answer

Cool storage tier. The Cool storage tier is designed for data that is accessed infrequently but must be retained for extended periods, offering lower storage costs than Hot tier while still providing low-latency access when needed. With a 30-day minimum storage duration and a cost structure optimized for infrequent reads, it balances cost and accessibility for 7-year retention of historical sales data.

Answer

Archive storage tier

Answer

Premium storage tier

Answer

Hot storage tier

Question 10

You design a data solution for an e-commerce platform. Transactional data must be stored with ACID compliance for order processing, while clickstream data from the website will be used for analytics. Which combination of Azure data services best meets these needs?

Accepted Answer

Azure SQL Database for transactions; Azure Synapse Analytics for analytics. Azure SQL Database provides full ACID compliance for transactional workloads like order processing, ensuring data integrity. Azure Synapse Analytics is optimized for large-scale analytics on clickstream data, offering massively parallel processing (MPP) and integration with data lakes. This combination separates OLTP and OLAP workloads efficiently.

Answer

Azure Cosmos DB for transactions; Azure SQL Database for analytics

Answer

Azure Blob Storage for transactions; Azure Data Lake Storage for analytics

Answer

Azure Database for MySQL for transactions; Azure Analysis Services for analytics

Question 11

Refer to the exhibit. You are configuring a custom role in Azure RBAC for a team that needs to read and list blobs in a storage account. The JSON snippet shows the permissions assigned. After assigning this role to a user, they report they cannot see the storage account in the Azure portal. What is the most likely cause?

Accepted Answer

The role does not include read permission on the storage account resource.. Option C is correct because the role only includes dataActions for blob read, but lacks read access to the storage account resource itself (e.g., Microsoft.Storage/storageAccounts/read). To see the storage account in the portal, the user needs read permissions on the resource. Option A is wrong because the role is scoped to the storage account, not subscription level. Option B is wrong because portal access does not require Contributor role; Reader role suffices. Option D is wrong because dataActions are correctly used for blob-level permissions.

Answer

The dataActions should be actions instead of dataActions.

Answer

The role is not assigned at the subscription scope.

Answer

The user needs the Contributor role to view the storage account.

Question 12

A data analyst needs to visualize sales data from Azure SQL Database in real-time dashboards. Which tool should they use to create interactive reports?

Accepted Answer

Microsoft Power BI. Microsoft Power BI is the correct tool because it is designed specifically for creating interactive, real-time dashboards and reports from various data sources, including Azure SQL Database. It supports live connections and DirectQuery to enable near-real-time visualization without requiring data movement.

Answer

Azure Data Studio

Answer

Azure Synapse Analytics

Answer

Microsoft Excel

Question 13

Your company stores customer data in Azure Blob Storage. To comply with data residency regulations, you must ensure data is replicated within the same Azure region. Which replication option should you choose?

Accepted Answer

Locally-redundant storage (LRS). Locally-redundant storage (LRS) replicates data three times within a single physical location in the same Azure region, ensuring data residency compliance by never copying data outside that region. This is the only option that guarantees all replicas stay within one region without any cross-region or cross-zone replication.

Answer

Zone-redundant storage (ZRS)

Answer

Geo-redundant storage (GRS)

Answer

Read-access geo-redundant storage (RA-GRS)

Question 14

Refer to the exhibit. You are analyzing storm event data in Azure Data Explorer. The KQL query returns the top 5 event types by count in Texas. However, the results show event types with very low counts (e.g., 'Volcanic Ash' with 2 events). What is the most likely reason for this?

Accepted Answer

The state filter is case-sensitive and the actual state value differs.. Option B is correct because the StormEvents sample table contains data from multiple states, but the filter for 'TEXAS' may be case-sensitive or the state might be stored as 'Texas' or 'tx'. If the case does not match exactly, the filter returns few or no rows, leading to unexpected results. Option A is wrong because the 'take' operator limits rows, not aggregates. Option C is wrong because summarizing by EventType should work regardless of state. Option D is wrong because the query is syntactically correct.

Answer

The query has a syntax error.

Answer

The 'take' operator limits the number of events, not the number of types.

Answer

The 'summarize' operator cannot be used with 'where'.

Question 15

A company needs to store JSON documents that require flexible schema and low-latency access globally. Which Azure data service should they use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it is a globally distributed, multi-model database service that natively supports JSON documents with flexible schema. It offers turnkey global distribution, single-digit-millisecond latency at the 99th percentile, and multiple consistency models, making it ideal for low-latency access worldwide.

Answer

Azure Table Storage

Answer

Azure SQL Database

Answer

Azure Blob Storage