DP-900 Practice Test 13 — 15 Questions

Question 1

A social networking application needs to store and query relationships between users, such as 'friends of friends' to recommend new connections. The application must traverse these relationships efficiently. Which Azure NoSQL data store and API should they choose?

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

Accepted Answer

Azure Cosmos DB with Gremlin API. Azure Cosmos DB with Gremlin API is correct because it provides a graph database model specifically designed for storing and querying highly connected data, such as user relationships. The Gremlin API supports graph traversal queries (e.g., 'friends of friends') natively using the Apache TinkerPop graph traversal language, enabling efficient navigation of edges and vertices without expensive join operations.

Answer

Azure Cosmos DB with MongoDB API

Answer

Azure Table Storage

Answer

Azure Cosmos DB with SQL API

Question 2

A retail company runs a nightly process that reads all sales transactions from the previous day, aggregates them by product category and store location, and writes the summary results into a data warehouse for reporting. Which type of data processing workload best describes this nightly process?

Accepted Answer

Batch processing. The nightly process reads all sales transactions from the previous day, aggregates them, and writes summary results into a data warehouse. This is a classic batch processing workload because data is collected over a period (the entire previous day), processed in a single offline job, and the output is stored for later reporting. Batch processing is ideal for high-volume, non-real-time transformations like nightly ETL (Extract, Transform, Load) jobs.

Answer

Online Transaction Processing (OLTP)

Answer

Stream processing

Answer

Data warehousing

Question 3

A retail company plans to store product catalog data that includes product ID, name, description, price, and a varying set of attributes (e.g., size, color, material). The application requires low-latency reads and writes, global distribution, and the ability to handle schema flexibility. Which Azure data store is best suited for this workload?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the best choice because it provides low-latency reads and writes (single-digit milliseconds at the 99th percentile), global distribution with multi-region writes, and automatic schema flexibility through its document model. It supports varying product attributes (e.g., size, color, material) without requiring schema changes, and its turnkey global distribution ensures data is replicated across regions for fast access.

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Blob Storage

Question 4

A company needs to store JSON documents that are frequently updated by multiple services. The solution must support indexing and querying by any property. Which Azure data service should they use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a fully managed NoSQL database designed for JSON documents, offering native support for indexing every property automatically without requiring a predefined schema. Its multi-model API (including SQL API) allows querying by any property with low-latency reads and writes, making it ideal for services that frequently update JSON documents.

Answer

Azure Blob Storage

Answer

Azure SQL Database

Answer

Azure Table Storage

Question 5

A logistics company stores shipment tracking data. The shipment ID, destination, and weight are stored in a fixed-schema database table. The shipment's route history is stored as a JSON document where each document can have different fields depending on the route events recorded. Which classification of data best describes the route history data?

Accepted Answer

Semi-structured data. The route history data is stored as JSON documents where each document can have different fields depending on the events recorded. This flexibility in schema—where fields vary per document—is the hallmark of semi-structured data. Unlike structured data with a fixed schema, semi-structured data uses tags or markers (like JSON key-value pairs) to organize the data, making it self-describing.

Answer

Structured data

Answer

Unstructured data

Answer

Analytical data

Question 6

A retail company operates an online store. The store processes each customer's order immediately upon submission, updating inventory and payment records in real-time. Additionally, the company's business analysts run weekly reports that aggregate sales data over the past month to identify trends. Which of the following correctly describes the two workload types represented in this scenario?

Accepted Answer

The order processing is an OLTP workload; the weekly reporting is an OLAP workload.. The order processing system handles individual transactions (inserts/updates) in real-time, which is the hallmark of an Online Transaction Processing (OLTP) workload. The weekly reporting aggregates large volumes of historical data for trend analysis, which is an Online Analytical Processing (OLAP) workload. OLTP is optimized for high-volume, low-latency writes, while OLAP is optimized for complex read-heavy queries over large datasets.

Answer

The order processing is an OLAP workload; the weekly reporting is an OLTP workload.

Answer

Both workloads are OLTP workloads.

Answer

Both workloads are batch processing workloads.

Question 7

A retail company ingests clickstream data from its e-commerce website into Azure Event Hubs. They need to detect customer journey patterns in real time within seconds and also prepare aggregated data for daily trend reports stored in Azure Data Lake Storage Gen2. The real-time processing must handle high throughput and support complex temporal queries like sessionization. The daily aggregation should be cost-effective and use serverless compute. Which combination of Azure services should they use?

Accepted Answer

Azure Stream Analytics for real-time processing and Azure Data Factory for daily batch aggregation. Azure Stream Analytics is ideal for real-time processing of high-throughput clickstream data from Event Hubs, supporting complex temporal queries like sessionization with low latency (seconds). Azure Data Factory provides cost-effective, serverless orchestration for daily batch aggregation, efficiently moving and transforming data to Azure Data Lake Storage Gen2 without managing infrastructure.

Answer

Azure Functions for real-time processing and Azure Databricks for daily batch aggregation

Answer

Azure Stream Analytics for real-time processing and Azure Batch for daily batch aggregation

Answer

Azure Data Lake Analytics for real-time processing and Azure Data Factory for daily batch aggregation

Question 8

A business analyst needs to explore and create interactive visualizations of sales data stored in Azure Data Lake Storage Gen2 without writing SQL code. Which Azure service is best suited for this drag-and-drop data exploration?

Accepted Answer

Microsoft Power BI. Microsoft Power BI is the correct choice because it provides a drag-and-drop interface for creating interactive visualizations and exploring data without requiring SQL code. It can directly connect to Azure Data Lake Storage Gen2 using Power Query or the ADLS connector, enabling business analysts to build reports and dashboards through intuitive visual interactions.

Answer

Azure Stream Analytics

Answer

Azure Data Factory

Answer

Azure Databricks

Question 9

A company collects data from three sources: Source A: Customer records from a relational database with fixed columns (CustomerID, Name, Address). Source B: Social media posts in JSON format with varying fields (e.g., some posts have 'likes', others have 'shares'). Source C: Handwritten notes saved as scanned images in TIFF format. Which statement correctly categorizes the data by structure?

Accepted Answer

Source A: Structured, Source B: Semi-structured, Source C: Unstructured. Source A's relational database with fixed columns (CustomerID, Name, Address) enforces a strict schema, making it structured data. Source B's JSON format allows varying fields like 'likes' or 'shares' per record, which is the hallmark of semi-structured data (self-describing, schema-on-read). Source C's scanned TIFF images are binary blobs with no inherent internal structure for querying, classifying them as unstructured data. This matches the standard DP-900 categorization: structured (fixed schema), semi-structured (flexible schema), unstructured (no schema).

Answer

Source A: Structured, Source B: Unstructured, Source C: Semi-structured

Answer

Source A: Semi-structured, Source B: Structured, Source C: Unstructured

Answer

Source A: Semi-structured, Source B: Unstructured, Source C: Structured

Question 10

A data engineer is classifying data types collected from three sources for a data lake. Source 1: Customer records from a SQL database exported as CSV files with fixed columns (CustomerID, Name, Address). Source 2: Product reviews obtained via API as JSON documents with varying fields (e.g., some reviews include 'rating' and 'verified_purchase', others include 'comment'). Source 3: Scanned handwritten order forms saved as TIFF images. Which statement correctly categorizes these data by structure?

Accepted Answer

Source 1: Structured; Source 2: Semi-structured; Source 3: Unstructured. Source 1 (CSV from SQL) has a fixed schema with defined columns, making it structured data. Source 2 (JSON from API) allows varying fields per document, which is the hallmark of semi-structured data. Source 3 (TIFF images) contains no inherent schema or machine-readable structure, classifying it as unstructured data.

Answer

Source 1: Structured; Source 2: Structured; Source 3: Unstructured

Answer

Source 1: Semi-structured; Source 2: Structured; Source 3: Unstructured

Answer

Source 1: Structured; Source 2: Unstructured; Source 3: Semi-structured

Question 11

A company stores backup files in Azure Blob Storage. The backup files are accessed frequently for the first 30 days, then only rarely for the next six months. After one year, the files must be retained for compliance but are never accessed. The company wants to minimize storage costs. Which solution should they use?

Accepted Answer

Use Azure Blob Storage lifecycle management policies. Azure Blob Storage lifecycle management policies allow you to automatically transition blobs to cooler tiers (e.g., from Hot to Cool after 30 days, then to Archive after one year) and delete blobs after a specified period, all without manual intervention. This directly matches the access pattern: frequent access for 30 days, rare access for six months, and never accessed after one year, minimizing storage costs by using the most cost-effective tier for each phase.

Answer

Manually move files between storage accounts

Answer

Use Azure File Sync

Answer

Use Azure NetApp Files

Question 12

A company runs an e-commerce application on Azure SQL Database. The application experiences unpredictable traffic spikes during flash sales and promotional events. The company wants to automatically scale compute resources based on actual demand and pay only for the resources consumed. Which Azure SQL Database deployment option best meets these requirements?

Accepted Answer

Serverless. The Serverless deployment option for Azure SQL Database automatically scales compute resources (vCores) based on actual demand, pausing the database during idle periods and resuming on the first connection. This model charges per second for the compute used, making it ideal for unpredictable traffic spikes like flash sales, as it eliminates the need to over-provision and ensures you pay only for consumed resources.

Answer

Provisioned DTU

Answer

Provisioned vCore

Answer

Hyperscale

Question 13

A startup is building a mobile app that allows users to share short text updates. Each update includes a user ID, timestamp, and message text. The development team expects rapid growth and needs a storage solution that can scale horizontally, handle high write throughput, and provide low-latency reads globally. Which Azure data service is most appropriate?

Accepted Answer

Azure Cosmos DB with a multi-master configuration and partition on user ID.. Azure Cosmos DB with a multi-master configuration is the most appropriate choice because it provides global distribution with multiple write regions, enabling horizontal scaling and low-latency reads and writes worldwide. Partitioning on user ID ensures even data distribution and efficient query performance for the app's high write throughput requirements.

Answer

Azure SQL Database with a single database.

Answer

Azure Blob Storage with append blobs.

Answer

Azure Table Storage with user ID as partition key and timestamp as row key.

Question 14

A financial analytics company has petabytes of transaction data stored as Parquet files in Azure Data Lake Storage Gen2. Data analysts need to run complex SQL queries that join multiple tables and return results within seconds. The company wants to query the data directly without moving it to another store. Which Azure service should they use?

Accepted Answer

Azure Synapse Serverless SQL pool. Azure Synapse Serverless SQL pool is correct because it allows querying data directly from Azure Data Lake Storage Gen2 using T-SQL without moving or loading the data. It uses a distributed query engine that can process petabytes of Parquet files and return results in seconds by leveraging pushdown computation and columnar storage formats.

Answer

Azure SQL Database

Answer

Azure HDInsight

Answer

Azure Databricks

Question 15

A company wants to build a near-real-time analytics solution on Azure. IoT devices send telemetry data to Azure Event Hubs. The data must be processed and stored in Azure Cosmos DB for low-latency queries. Which Azure service should be used to process the streaming data?

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics is the correct choice because it is a fully managed stream processing engine designed specifically for real-time analytics on high-throughput data streams from sources like Azure Event Hubs. It can run SQL-like queries to filter, aggregate, and join streaming data, and output results directly to Azure Cosmos DB for low-latency queries, making it ideal for near-real-time IoT analytics.

Answer

Azure Logic Apps

Answer

Azure Functions

Answer

Azure Data Factory