DP-900 Practice Test 37 — 15 Questions

Question 1

Which TWO of the following are characteristics of structured data?

Accepted Answer

It has a predefined schema. Structured data adheres to a predefined schema, meaning its fields, data types, and relationships are defined in advance, typically enforced by a database management system. This schema ensures consistency and enables efficient querying using SQL. Relational databases are the primary storage system for structured data, organizing it into tables with rows and columns that follow the schema.

Answer

It is stored in Azure Blob Storage as objects

Answer

It can contain images and videos

Answer

It uses tags to describe the data

Question 2

Which TWO of the following are correct descriptions of data processing workloads in Azure?

Accepted Answer

Streaming processing is used to process data in real time as it arrives.. Streaming processing in Azure (e.g., Azure Stream Analytics, Event Hubs, or Kafka on HDInsight) is designed to ingest, analyze, and act on data in near real-time as it arrives, often with sub-second latency. This is fundamentally different from batch processing, which handles data at rest.

Answer

Streaming processing is used for interactive queries on historical data.

Answer

Streaming processing is used to process data at rest.

Answer

Batch processing is used to process data in real time as it arrives.

Question 3

The exhibit shows a Kusto Query Language (KQL) query run in Azure Data Explorer. What is the output of this query?

Accepted Answer

The top 5 event types in Texas by total property damage. The query uses `summarize sum(PropertyDamage) by EventType` to aggregate total property damage per event type, then `top 5 by TotalPropertyDamage` to return the five event types with the highest totals. The `where State == 'TEXAS'` filter ensures only Texas storms are considered. This directly yields the top 5 event types in Texas by total property damage.

Answer

All storm events in Texas with property damage

Answer

The total property damage for all event types in Texas

Answer

A list of the top 5 property damage amounts in Texas

Question 4

You are reviewing a Data Factory mapping data flow definition. What is the primary purpose of this data flow?

Accepted Answer

Remove duplicate OrderIDs by counting them. The mapping data flow includes an Aggregate transformation configured with a group by on OrderID and a count aggregation. This removes duplicate OrderIDs by collapsing multiple rows with the same OrderID into a single row and counting the occurrences, which is the primary purpose of the data flow.

Answer

Pivot the data by OrderID

Answer

Filter rows where OrderID is null

Answer

Merge two data sources

Question 5

Which THREE of the following are valid Azure data storage services? (Choose three.)

Accepted Answer

Azure Files. Azure Files provides fully managed file shares in the cloud that can be accessed via the Server Message Block (SMB) protocol or the Network File System (NFS) protocol. It is a valid Azure data storage service because it stores data as files in a hierarchical structure, making it suitable for lift-and-shift scenarios for on-premises file servers.

Answer

Azure Redis Cache

Answer

Azure Service Bus

Question 6

A company stores customer transaction data in Azure Blob Storage. They need to query the data using SQL-based tools without moving the data. Which Azure service should they use?

Accepted Answer

Azure Synapse Serverless SQL pool. Azure Synapse Serverless SQL pool allows you to query data directly from Azure Blob Storage using T-SQL without moving or copying the data. It uses a pay-per-query model and supports reading common file formats like Parquet, CSV, and JSON, making it ideal for ad-hoc querying over data lakes.

Answer

Azure SQL Database

Answer

Azure Analysis Services

Answer

Azure Cosmos DB

Question 7

Which TWO of the following are characteristics of structured data?

Accepted Answer

Data is organized in rows and columns. Structured data is defined by its organization into rows and columns, typically within a relational database or spreadsheet, where each column represents a specific attribute and each row a record. This tabular format enables efficient querying, sorting, and aggregation using SQL. Option B correctly identifies this core characteristic.

Answer

Data uses tags or markers to separate elements

Answer

Data is stored in Azure Cosmos DB

Answer

Data has no predefined schema

Question 8

Your organization uses Microsoft Fabric to build a data lakehouse. Data engineers need to transform data using Spark and store results in Delta Lake format. Which Fabric component should they use?

Accepted Answer

Notebooks. Notebooks in Microsoft Fabric provide an interactive environment for writing and executing Spark code, which is required for transforming data using Spark. The results can be directly written to Delta Lake format, making Notebooks the correct component for this task.

Answer

Dataflows Gen2

Answer

Pipelines

Answer

Semantic models

Question 9

A company has an Azure SQL Database and needs to run a weekly data aggregation job that takes several hours. They want to minimize cost and avoid impacting production workload. Which approach should they use?

Accepted Answer

Create a read-only replica and run the aggregation on the replica. Creating a read-only replica allows the weekly aggregation job to run against a separate copy of the database without affecting the production workload. Since the replica is read-only, it incurs additional compute costs only during the aggregation window, and you can scale it down or stop it when not in use, minimizing overall cost.

Answer

Migrate the database to the Hyperscale service tier

Answer

Use Azure Elastic Jobs to run the aggregation during off-peak hours

Answer

Increase the DTU or vCore size of the database to handle the load

Question 10

You are a data architect at a global retail company. The company has an Azure Data Lake Storage Gen2 account that stores petabytes of clickstream data. They need to provide near real-time analytics dashboards for regional managers. The data arrives in batches every 5 minutes. Currently, they use Azure Databricks to transform the data and load it into Azure Synapse Analytics, but the dashboards show data that is 30 minutes old. The business requires dashboards to reflect data within 10 minutes of ingestion. You propose a new solution. Which approach should you recommend?

Accepted Answer

Ingest data into Azure Event Hubs, use Azure Stream Analytics to process and output to Power BI for real-time dashboards.. It uses Azure Event Hubs for low-latency ingestion and Azure Stream Analytics for real-time processing, enabling near real-time dashboards in Power BI with sub-minute latency. This architecture bypasses the batch-oriented pipeline that causes the current 30-minute delay, meeting the 10-minute requirement.

Answer

Keep current pipeline but replace Synapse with Azure Analysis Services for faster query performance.

Answer

Use Azure Data Factory with tumbling window triggers every 5 minutes to load data from Data Lake to Synapse.

Answer

Increase the number of Databricks clusters and use Auto Loader to speed up transformations.

Question 11

Your organization uses Azure SQL Database and needs to audit all database operations for compliance. The audit logs must be stored for at least five years and be easily searchable. What should you configure?

Accepted Answer

Enable auditing and store logs in Azure Blob Storage with a retention policy of five years.. Azure SQL Database auditing can store audit logs in Azure Storage or Log Analytics. For long-term retention (five years) and easy searchability, storing logs in Azure Blob Storage with a retention policy is the most cost-effective and appropriate solution. Option B (Azure Monitor Logs) can be used but may be more expensive for long-term retention. Option C (Azure Sentinel) is a SIEM solution and not primarily for audit log storage. Option D (Transparent Data Encryption) is for encryption at rest, not auditing.

Answer

Enable auditing and store logs in Azure Monitor Logs.

Answer

Use Azure Sentinel to collect and store audit logs.

Answer

Enable Transparent Data Encryption (TDE) to track changes.

Question 12

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database deployment. What is the maximum size (in GB) of the database?

Accepted Answer

250 GB. The ARM template specifies the 'maxSizeBytes' property as 268,435,456,000 bytes. Converting this to gigabytes (divide by 1024^3) yields exactly 250 GB. This is the maximum size of the database as defined in the template.

Answer

256 GB

Answer

500 GB

Answer

268 GB

Question 13

A company is migrating on-premises Hadoop HDFS data to Azure. They want to keep the same file system semantics for compatibility with existing analytics jobs. Which Azure storage solution should they use?

Accepted Answer

Azure Data Lake Storage Gen2. Azure Data Lake Storage Gen2 (ADLS Gen2) provides Hadoop-compatible file system semantics (hierarchical namespace) and is built on Blob Storage. Azure Blob Storage does not have a hierarchical namespace by default. Azure Cosmos DB and Azure SQL are not file systems.

Answer

Azure Blob Storage

Answer

Azure SQL Database

Answer

Azure Cosmos DB

Question 14

A company stores customer data in Azure Table Storage. They need to query by a combination of partition key (customer region) and row key (customer ID). Which query pattern is most efficient?

Accepted Answer

Query using both PartitionKey and RowKey. Table Storage is optimized for point queries using both PartitionKey and RowKey. Using both keys allows direct access to the entity without scanning. Filtering only by RowKey across partitions results in a full table scan. Using only PartitionKey retrieves all rows in that partition, which is less efficient. Scanning all entities is the worst.

Answer

Query using RowKey only

Answer

Scan all entities

Answer

Query using PartitionKey only

Question 15

A company stores IoT sensor data in Azure Blob Storage. The data is structured as JSON files organized by date. Data scientists need to query this data using SQL statements without moving it. Which Azure service should they use to enable this?

Accepted Answer

Azure Synapse Serverless SQL. Azure Synapse Serverless SQL enables querying JSON files directly in Azure Blob Storage using T-SQL without moving the data. Option A (Azure SQL Database) is a relational database that requires data to be loaded into tables. Option B (Azure Data Lake Storage Gen2) is a storage layer, not a query service. Option C (Azure Cosmos DB) is a NoSQL database that can store JSON but requires moving data from Blob Storage.

Answer

Azure SQL Database

Answer

Azure Data Lake Storage Gen2

Answer

Azure Cosmos DB