DP-900 Practice Test 38 — 15 Questions

Question 1

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 2

A data scientist needs to perform exploratory data analysis on a large dataset stored in Azure Data Lake Storage Gen2 using Python notebooks. The solution must minimize infrastructure management. Which Azure service should the data scientist use?

Accepted Answer

Azure Databricks with collaborative notebooks.. Azure Databricks provides a fully managed, collaborative notebook environment optimized for big data analytics and machine learning. It integrates natively with Azure Data Lake Storage Gen2, allowing the data scientist to perform exploratory data analysis (EDA) using Python notebooks without managing any underlying infrastructure. This minimizes operational overhead while providing autoscaling clusters and built-in Spark capabilities.

Answer

Azure Machine Learning compute instances.

Answer

Power BI with dataflows.

Answer

Azure HDInsight with Jupyter notebooks.

Question 3

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 4

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 5

Which TWO of the following are benefits of using a data lake architecture? (Choose two.)

Accepted Answer

Ability to store raw data in its native format. A data lake architecture is designed to store raw data in its native format without requiring schema-on-write transformations. This allows organizations to ingest data as-is from various sources, preserving the original structure and enabling schema-on-read flexibility for analytics.

Answer

ACID transactions for all operations

Answer

Optimized for high-frequency OLTP workloads

Answer

Built-in data governance without additional tools

Question 6

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 7

Your company uses Azure Databricks to process streaming data from Event Hubs. The data is transformed and written to Azure Data Lake Storage Gen2 as Delta tables. You notice that some records are duplicated in the Delta tables. Which configuration change should you make to prevent duplicates?

Accepted Answer

Enable checkpointing in the streaming query to store progress.. Checkpointing in Spark Structured Streaming stores the offset of the last processed event from Event Hubs. When the query restarts, it reads from the checkpointed offset, ensuring each event is processed exactly once and preventing duplicates in the Delta table.

Answer

Add a separate job to deduplicate the Delta table.

Answer

Use Delta Lake's idempotent write support.

Answer

Increase the batch interval in the streaming query.

Question 8

A company stores IoT sensor data in Azure Blob Storage. The data is written hourly and must be retained for 90 days. After 90 days, it must be automatically deleted. Which access tier should be used for cost optimization during the retention period?

Accepted Answer

Cool tier. The Cool tier is optimized for data that is infrequently accessed and stored for at least 30 days, with lower storage costs and higher access costs. Hot tier is for frequent access and would be more expensive. Archive tier has a 180-day minimum retention penalty. Premium tier is for high transaction volumes and is not cost-effective for this scenario.

Answer

Premium tier

Answer

Archive tier

Answer

Hot tier

Question 9

You are designing a solution to store JSON documents from a web application. Each document is about 10 KB and must be queried by a unique ID. Which Azure data store is most appropriate?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a NoSQL database that natively supports JSON documents and provides low-latency queries by ID. Azure Blob Storage stores blobs but is not optimized for querying by document ID. Azure SQL Database is relational and requires schema. Azure Table Storage is key-value but less feature-rich for JSON documents.

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Blob Storage

Question 10

A company stores backup files in Azure Blob Storage. The backups are taken daily and must be retained for 7 years. The backup files are rarely accessed after the first month. The company wants to minimize storage costs while ensuring that backups are available for retrieval within 5 hours when needed. Which storage tier should they use after the first month?

Accepted Answer

Cool tier. The Cool tier is the most cost-effective option that meets the 5-hour retrieval requirement. Archive tier retrieval can take up to 15 hours, which exceeds the requirement. Hot tier and Premium tier are more expensive and designed for frequent access, not long-term retention with minimal access.

Answer

Archive tier

Answer

Hot tier

Answer

Premium tier

Question 11

An e-commerce application uses Azure SQL Database. The Orders table stores millions of rows with columns: OrderID (primary key, clustered index), CustomerID, OrderDate, OrderStatus, TotalAmount. Queries frequently filter on OrderDate and OrderStatus, and sort results by OrderDate DESC. Which indexing strategy will most improve query performance for these filters and sort?

Accepted Answer

Create a nonclustered index on OrderDate, OrderStatus and include other columns needed by the query.. A nonclustered index on (OrderDate, OrderStatus) supports both the filter and the sort in a single index seek/scan. SQL Server can use the index to locate rows matching both predicates and return them already sorted by OrderDate DESC without a separate sort operation, which is critical for performance on millions of rows.

Answer

Create a nonclustered index on OrderDate only.

Answer

Create a clustered columnstore index on the table.

Answer

Create a nonclustered index on OrderStatus only.

Question 12

Refer to the exhibit. A data engineer runs the PowerShell script shown. What is the purpose of this script?

Accepted Answer

List blobs modified in the last 7 days. The script uses `Get-AzStorageBlob` with the `-Prefix` parameter to filter blobs by name, then applies a `Where-Object` filter to select only blobs whose `LastModified` property is greater than or equal to 7 days ago. This effectively lists blobs modified in the last 7 days. The script does not perform any copy or delete operations, and it does not list all blobs without filtering.

Answer

List all blobs in the container

Answer

Copy blobs to another container

Answer

Delete old blobs from the container

Question 13

Which THREE are benefits of using a data warehouse in Azure?

Accepted Answer

Optimizes query performance for analytical workloads. A data warehouse in Azure (e.g., Azure Synapse Analytics) is optimized for analytical workloads through columnar storage and massively parallel processing (MPP), which significantly improves query performance on large datasets. This architecture is designed for read-heavy, aggregation-based queries typical of business intelligence and reporting, not for transactional or real-time operations.

Answer

Stores unstructured data like videos

Answer

Enables real-time streaming analytics

Question 14

Refer to the exhibit. An analyst runs this Kusto Query Language (KQL) query in Azure Data Explorer. What is the primary purpose of this query?

Accepted Answer

Find the top 5 most common event types in Texas. The query uses the `summarize` operator with `count()` to count events per `EventType`, then `top 5 by count_` to return the five event types with the highest counts, filtered to only rows where `State == 'TEXAS'`. This directly finds the top 5 most common event types in Texas.

Answer

Calculate total damage in Texas

Answer

Identify events with the highest damage

Answer

List all storm events in Texas

Question 15

Which THREE components are essential for building a modern data warehouse architecture on Azure?

Accepted Answer

Azure Databricks. Azure Databricks is correct because it provides an Apache Spark-based analytics platform that enables data engineering, data science, and machine learning on large-scale data. In a modern data warehouse architecture, Azure Databricks is used for data transformation, preparation, and advanced analytics, often feeding into or complementing Azure Synapse Analytics for structured querying and reporting.

Answer

Azure Analysis Services

Answer

Azure Cosmos DB