DP-900 Describe an analytics workload on Azure Practice Test 10 — 15 Questions

Question 1

A data analyst uses Power BI to create a report that combines data from Azure Synapse Analytics and an on-premises SQL Server database. The on-premises data must be refreshed every hour. Which component is required to connect to the on-premises data source?

Accepted Answer

On-premises data gateway. The on-premises data gateway is required to securely connect Power BI to on-premises SQL Server databases for scheduled refreshes. It acts as a bridge, transmitting data from the on-premises source to the Power BI service without opening inbound firewall ports. This component is specifically designed for self-service analytics scenarios where cloud services need to access on-premises data sources.

Answer

Azure VPN Gateway

Answer

Azure ExpressRoute

Answer

Azure Data Factory

Question 2

A company uses Azure Databricks for data engineering. The team wants to implement a medallion architecture (bronze, silver, gold) to organize data quality layers. In which layer should data be stored in a format optimized for analytics and reporting?

Accepted Answer

Gold layer. The gold layer in a medallion architecture contains data that has been refined, aggregated, and validated for business-level analytics and reporting. This layer stores data in a format optimized for query performance, such as Delta Lake with partitioning and Z-ordering, enabling efficient consumption by tools like Power BI or Azure Synapse.

Answer

Bronze layer

Answer

Silver layer

Answer

Lakehouse layer

Question 3

Which TWO Azure services can be used to orchestrate and automate data pipelines? (Choose two.)

Accepted Answer

Azure Synapse Pipelines. Azure Data Factory (E) is a dedicated cloud-based ETL and data integration service that allows you to create, schedule, and orchestrate data pipelines at scale. Azure Synapse Pipelines (B) is built on the same engine as Azure Data Factory and provides native pipeline orchestration within the Synapse Analytics workspace, enabling you to move and transform data across various sources and sinks. Both services offer visual design tools, code-free transformations, and robust scheduling capabilities for automating data workflows.

Answer

Azure SQL Database

Answer

Power BI

Answer

Azure Databricks

Question 4

Which THREE components are required to implement a real-time analytics solution using Azure Stream Analytics? (Choose three.)

Accepted Answer

Stream input (e.g., Azure Event Hubs). A stream input like Azure Event Hubs is required because Azure Stream Analytics processes data in real time from a streaming source. Event Hubs ingests millions of events per second, providing the low-latency, ordered event stream that Stream Analytics consumes via its input binding. Without a streaming source, the service cannot perform continuous, real-time analytics.

Answer

Batch input (e.g., Azure Blob Storage)

Answer

Machine learning model

Question 5

Which TWO Azure services can be used to store semi-structured data? (Choose two.)

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a NoSQL database service that natively supports semi-structured data through its flexible schema model. It allows storing JSON documents, key-value pairs, and graph data without requiring a fixed schema, making it ideal for semi-structured data like user profiles, IoT telemetry, or product catalogs.

Answer

Azure SQL Database

Answer

Azure Synapse Analytics

Answer

Power BI

Question 6

A company uses Azure Synapse Analytics for its data warehouse. They notice that queries against a large fact table are slow. The table is partitioned by month and uses clustered columnstore index. Which action would most likely improve query performance?

Accepted Answer

Rebuild the clustered columnstore index.. Option C is correct: Rebuilding the columnstore index reorganizes data and improves compression and query performance, especially if there have been many updates/deletes. Option A is wrong because increasing DWU may help but is not a targeted fix. Option B is wrong because rowstore is slower for analytical queries. Option D is wrong because partitioning by day may increase partition count and overhead.

Answer

Change partitioning to daily partitions.

Answer

Convert the table to a clustered rowstore index.

Answer

Increase the data warehouse performance level (DWU).

Question 7

Your company uses Azure Data Lake Storage Gen2 and wants to grant a data scientist read-only access to a specific container. Which built-in RBAC role should you assign?

Accepted Answer

Storage Blob Data Reader. Storage Blob Data Reader (D) is the correct built-in RBAC role because it grants read-only access to Azure Storage blob containers and data, including Data Lake Storage Gen2. This role provides the necessary permissions for a data scientist to read data from a specific container without allowing write or delete operations.

Answer

Storage Account Contributor

Answer

Reader

Answer

Storage Blob Data Contributor

Question 8

An organization uses Azure Stream Analytics to process real-time IoT data from millions of devices. They need to ensure that the output is exactly once delivery semantics to a Power BI dataset. Which output configuration should they use?

Accepted Answer

Configure the Power BI output with 'Exactly once' delivery mode.. Azure Stream Analytics supports exactly-once delivery semantics for Power BI output when the 'Exactly once' delivery mode is configured. This ensures that each event is processed and delivered precisely once, preventing duplicates in the Power BI dataset. The 'Exactly once' mode uses checkpointing and idempotent writes to guarantee consistency, which is critical for accurate real-time analytics from millions of IoT devices.

Answer

Output to Azure Data Explorer and then use a Power BI dashboard.

Answer

Set the output to Power BI with 'At least once' delivery mode.

Answer

Output to Azure Event Hubs and then use Azure Functions to write to Power BI.

Question 9

A data engineer needs to load data from an on-premises SQL Server database to Azure Synapse Analytics. The data volume is approximately 2 TB and the network bandwidth is limited. Which approach minimizes data transfer time?

Accepted Answer

Use Azure Data Box to physically ship the data.. Azure Data Box is the correct approach because it physically ships the 2 TB of data on a secure storage device, bypassing the limited network bandwidth entirely. For large data volumes (multiple TB) with constrained connectivity, offline data transfer is significantly faster than any online method, as it avoids network latency and bandwidth bottlenecks.

Answer

Use SQL Server Integration Services (SSIS) to transfer data over the internet.

Answer

Establish a site-to-site VPN and use Azure Data Factory.

Answer

Use Azure Data Factory with a self-hosted integration runtime over the internet.

Question 10

Your company wants to use Microsoft Fabric to create a unified analytics platform. Which component in Microsoft Fabric provides a lake-centric, collaborative, and governed data foundation?

Accepted Answer

OneLake. OneLake is the correct answer because it is the single, unified, lake-centric data foundation in Microsoft Fabric. It provides a multi-cloud, SaaS-based data lake that is automatically provisioned for every Fabric tenant, enabling collaborative and governed access to data without data duplication, while supporting open formats like Delta Parquet.

Answer

Power BI

Answer

Data Factory

Answer

Synapse Data Engineering

Question 11

A data analyst is using Azure Databricks to transform streaming data from Event Hubs. They need to ensure that if a failure occurs, the streaming job can resume processing from the last committed offset. Which checkpointing mechanism should they configure?

Accepted Answer

Use Structured Streaming with checkpointing to Azure Data Lake Storage Gen2.. Structured Streaming in Azure Databricks uses checkpointing to store the current state and offsets of the streaming query in a reliable, external storage system. By configuring checkpointing to Azure Data Lake Storage Gen2, the job can recover from failures and resume processing exactly from the last committed offset, ensuring exactly-once semantics. This is the recommended approach for production streaming workloads on Azure.

Answer

Enable write-ahead logs on the Event Hubs namespace.

Answer

Use checkpointing to Hive metastore.

Answer

Use checkpointing to DBFS (Databricks File System).

Question 12

Your organization uses Azure Purview to scan data sources. You need to set up a scan rule set that automatically classifies credit card numbers in Azure SQL Database. Which built-in classification rule should you enable?

Accepted Answer

Enable the 'Credit Card Number' classification.. Option D is correct because Azure Purview includes a built-in 'Credit Card Number' classification rule that uses a predefined regular expression pattern to detect credit card numbers in data sources like Azure SQL Database. Enabling this rule automatically classifies the data without requiring custom development, aligning with the requirement to use a built-in classification.

Answer

Use a regular expression pattern matching.

Answer

Create a custom classification rule.

Answer

Enable the 'Personally Identifiable Information (PII)' classification.

Question 13

A company runs a critical workload in Azure Synapse Analytics. They need to ensure that if a single node fails, the data in the control node and compute nodes is not lost. Which configuration should they use?

Accepted Answer

No additional configuration is needed; Synapse provides built-in fault tolerance.. Azure Synapse Analytics (formerly SQL DW) is a distributed MPP (Massively Parallel Processing) system that automatically replicates data across multiple internal copies within the control node and compute nodes. This built-in fault tolerance ensures that if a single node fails, data is not lost because Synapse maintains at least three synchronous replicas of all data and metadata. No additional configuration is required for node-level failure protection.

Answer

Deploy a SQL Server Always On availability group.

Answer

Configure active geo-replication.

Answer

Use a Windows Server Failover Cluster.

Question 14

A data analyst needs to create a real-time dashboard in Power BI that refreshes every second from an Azure Stream Analytics job. Which Power BI feature should they use?

Accepted Answer

Streaming dataset. Option B is correct: Power BI streaming datasets support real-time refresh from Stream Analytics. Option A is wrong because scheduled refresh is for periodic data. Option C is wrong because DirectQuery is for interactive queries, not real-time streaming. Option D is wrong because import mode is for static data.

Answer

Scheduled refresh

Answer

DirectQuery

Answer

Import mode

Question 15

Which TWO Azure services can be used to perform interactive data analytics on large datasets without managing infrastructure? (Choose two.)

Accepted Answer

Azure Synapse Analytics Serverless SQL pool. Azure Synapse Analytics Serverless SQL pool is correct because it enables interactive analytics on large datasets stored in Azure Data Lake Storage or other sources using T-SQL queries, without requiring any infrastructure management. It automatically scales compute resources based on query demand, allowing analysts to run ad-hoc queries on petabyte-scale data without provisioning or managing servers.

Answer

Azure SQL Database

Answer

Azure Data Factory

Answer

Azure Data Lake Storage Gen2