DP-900 Practice Test 39 — 15 Questions

Question 1

A company wants to build a real-time dashboard that visualizes sales data as transactions occur. Which combination of Azure services should they use?

Accepted Answer

Azure Stream Analytics and Power BI. Azure Stream Analytics is a real-time event processing engine that can ingest streaming data (e.g., from Azure Event Hubs or IoT Hub) and output results directly to Power BI via the built-in Power BI output sink. This combination enables a live dashboard that updates automatically as sales transactions occur, without requiring batch processing or manual refresh.

Answer

Azure Synapse Analytics and PolyBase

Answer

Azure Data Explorer and Azure Data Lake Storage

Answer

Azure Analysis Services and Excel

Question 2

A data scientist needs to train a machine learning model using data stored in Azure Data Lake Storage. They want to use a collaborative notebook environment with built-in experiment tracking. Which Azure service should they use?

Accepted Answer

Azure Machine Learning. Azure Machine Learning provides a collaborative notebook environment (Jupyter notebooks) with built-in experiment tracking, model management, and automated ML capabilities. It is the correct choice for training machine learning models with data from Azure Data Lake Storage while tracking experiments.

Answer

Azure Synapse Analytics

Answer

Azure Databricks

Answer

Azure Data Studio

Question 3

An organization has a large dataset stored in Azure Blob Storage. They need to run complex analytics using SQL queries and also want to use the same data for machine learning models. Which Azure service provides both SQL-based analytics and native integration with ML frameworks?

Accepted Answer

Azure Synapse Analytics. Azure Synapse Analytics is correct because it provides a unified analytics platform that combines enterprise data warehousing with big data analytics. It offers built-in SQL-based querying via dedicated SQL pools or serverless SQL pools, and it natively integrates with machine learning frameworks like Apache Spark and Azure Machine Learning for building and training models on the same data stored in Azure Blob Storage.

Answer

Azure Data Factory

Answer

Azure Analysis Services

Answer

Azure SQL Database

Question 4

Which TWO Azure services can be used to perform data transformation in an analytics pipeline? (Choose two.)

Accepted Answer

Azure Data Factory. Azure Data Factory is a cloud-based ETL service that allows you to create data pipelines to transform data at scale using mapping data flows or by invoking external compute services like Azure Databricks. It supports code-free visual transformations as well as custom code via Azure HDInsight or Databricks, making it a core service for data transformation in analytics pipelines.

Answer

Azure Data Lake Storage Gen2

Answer

Azure Event Hubs

Answer

Power BI

Question 5

Refer to the exhibit. A database administrator runs this KQL query in Azure Monitor Log Analytics. The query returns no results. What is the most likely reason?

Accepted Answer

The ResourceType filter is incorrect. The KQL query filters on `ResourceType` with a value that does not match any actual Azure resource type (e.g., a typo or incorrect casing). Since Azure Monitor Log Analytics stores resource types in a specific format (e.g., 'microsoft.compute/virtualmachines'), an incorrect filter will return zero results even if data exists. The query syntax, render command, and time range are all valid, so the filter is the most likely cause.

Answer

The summarize operator syntax is wrong

Answer

The render command is not supported

Answer

The time range is incorrect

Question 6

A company has a Power BI dashboard that refreshes daily from an Azure SQL Database. During refresh, the database experiences high CPU usage that impacts transactional applications. They need to minimize impact while keeping the dashboard up-to-date. What should they do?

Accepted Answer

Configure Azure SQL Database with a readable secondary replica. Configuring Azure SQL Database with a readable secondary replica offloads read-only workloads, such as Power BI refreshes, to the secondary replica. This eliminates CPU contention on the primary replica, protecting transactional applications from performance degradation while keeping the dashboard up-to-date with near-real-time data. Option A (Disable Query Store) is irrelevant to reducing refresh CPU impact. Option B (read-only user) does not physically separate the read workload. Option C (lower-capacity license) does not change query execution location.

Answer

Disable the Query Store in the database

Answer

Create a read-only user for Power BI

Answer

Set Power BI to use a lower-capacity license

Question 7

A data engineering team is building a data pipeline to run daily batch loads from an on-premises SQL Server to Azure Synapse Analytics. The pipeline must include data transformation using a visual interface with no coding, and must support schema mapping and data validation. Which THREE Azure services should be used together?

Accepted Answer

Azure Synapse Analytics. Azure Synapse Analytics is the correct destination for the pipeline because it is a cloud-based data warehouse that supports high-performance analytics on large-scale data, making it ideal for daily batch loads from SQL Server. It integrates natively with Azure Data Factory for orchestration and Azure Blob Storage for staging, enabling schema mapping and data validation through visual interfaces without coding.

Answer

Azure Databricks

Answer

Azure Analysis Services

Question 8

A marketing company collects data from social media feeds including text posts, images, and videos. The data arrives in various formats with no fixed structure or schema. This type of data is best described as:

Accepted Answer

C) Unstructured data. Unstructured data lacks a predefined data model or schema, making it ideal for storing text posts, images, and videos that arrive in varied formats. Unlike structured or semi-structured data, unstructured data cannot be easily organized into rows and columns or parsed with tags, which is why option C is correct for this scenario.

Answer

A) Structured data

Answer

B) Semi-structured data

Answer

D) Relational data

Question 9

A software company is migrating an on-premises SQL Server database to Azure SQL Database. The database currently uses SQL Server Agent jobs for regular maintenance tasks. The company wants to minimize code changes during migration. Which Azure SQL Database feature should they use to replace SQL Server Agent jobs?

Accepted Answer

Elastic Jobs. (Elastic Jobs) is the correct answer because Elastic Jobs in Azure SQL Database can replace SQL Server Agent jobs for scheduling maintenance tasks with minimal code changes. Option A (Azure Functions) is wrong because while it can run scripts, it is not a direct replacement and requires more development effort. Option B (Azure Automation) is wrong because it is more suited for Azure resource management rather than database job scheduling. Option D is wrong because SQL Server Agent is not available in Azure SQL Database; it is only available in SQL Server on-premises or on Azure VMs.

Answer

Azure Functions

Answer

Azure Automation

Answer

SQL Server Agent (available in Azure SQL Database)

Question 10

A retail company wants to analyze customer clickstream data in real-time to detect patterns and trigger personalized offers. They also store the raw clickstream data in Azure Data Lake Storage for later batch analysis. Which Azure service should they use for the real-time processing component?

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics is the correct choice because it is designed for real-time data processing and analytics on streaming data, such as clickstream events. It can ingest data from sources like Azure Event Hubs, apply SQL-like queries to detect patterns, and output results to triggers or storage, all with sub-second latency. This matches the requirement for real-time pattern detection and personalized offer triggering.

Answer

Azure Data Factory

Answer

Azure Batch

Answer

Azure Data Lake Analytics

Question 11

A company stores employee records in a relational database table with columns EmployeeID, FirstName, LastName, Department. They also store employee handbooks as PDF files, and customer feedback as XML documents. Which of the following correctly classifies these data types?

Accepted Answer

Employee records: structured, Employee handbooks: unstructured, Customer feedback: semi-structured. Employee records in a relational database table have a fixed schema (columns and data types), making them structured data. Employee handbooks stored as PDF files have no internal schema and are binary blobs, classifying them as unstructured data. Customer feedback stored as XML documents have a flexible, self-describing schema with tags, making them semi-structured data.

Answer

Employee records: structured, Employee handbooks: semi-structured, Customer feedback: unstructured

Answer

Employee records: semi-structured, Employee handbooks: unstructured, Customer feedback: structured

Answer

Employee records: unstructured, Employee handbooks: semi-structured, Customer feedback: structured

Question 12

Drag and drop the steps to configure a firewall rule for Azure SQL Database in the correct order.

Accepted Answer

Identify the client IP address, then add a firewall rule with that IP range to the Azure SQL Server, then save the rule.. Firewall rules are set at the server level to allow client IP addresses to access the database.

Answer

Add a firewall rule with a broad IP range to the Azure SQL Server, then identify the client IP address, then save the rule.

Answer

Add a firewall rule to the Azure SQL Server, save the rule, then identify the client IP address.

Answer

Identify the client IP address, then save the rule, then add a firewall rule to the Azure SQL Server.

Question 13

A retail company stores years of historical sales data in Azure Data Lake Storage Gen2 as Parquet files. Business analysts need to run complex SQL queries over this data to identify sales trends, and they want to visualize the results in Power BI dashboards. They prefer to avoid moving data into a separate database to minimize storage costs and latency. Which Azure service should they use to query the data directly in the lake?

Accepted Answer

Azure Synapse Analytics. Azure Synapse Analytics provides the serverless SQL pool capability that allows you to query data directly in Azure Data Lake Storage Gen2 using T-SQL without moving or copying the data. This enables business analysts to run complex SQL queries over Parquet files in the lake and connect the results to Power BI for visualization, minimizing storage costs and latency by avoiding a separate database.

Answer

Azure SQL Database

Answer

Azure Data Factory

Answer

Azure Analysis Services

Question 14

A startup is building a new application and needs a relational database that supports JSON data, automatic scaling, and a serverless compute tier to minimize costs during low usage periods. Which Azure data service should they choose?

Accepted Answer

Azure SQL Database serverless tier. Azure SQL Database serverless tier is a relational database that supports JSON data, offers automatic scaling, and pauses during idle periods to reduce costs. Option A is incorrect because Azure Database for PostgreSQL serverless, while relational and supporting JSON, does not have the same level of automatic scaling and serverless compute optimization as Azure SQL Database serverless. Option B is incorrect because Azure Cosmos DB is a NoSQL database, not relational. Option D is incorrect because Azure SQL Managed Instance does not have a serverless tier.

Answer

Azure Database for PostgreSQL serverless

Answer

Azure Cosmos DB

Answer

Azure SQL Managed Instance

Question 15

A retail company needs to analyze clickstream data from their website in real time to detect fraudulent activity and also run complex historical queries on months of data to identify shopping trends. They want a single service that can handle both streaming and batch analytics using a unified query language, minimizing data movement. Which Azure service should they use?

Accepted Answer

Azure Data Explorer. Azure Data Explorer (ADX) is designed for real-time analytics on streaming data and can also handle complex historical queries over large volumes of data using the Kusto Query Language (KQL). It minimizes data movement by ingesting streaming data directly and storing it in a columnar format optimized for both real-time and batch queries, making it the ideal single service for this scenario.

Answer

Azure Stream Analytics

Answer

Azure Synapse Analytics

Answer

Azure HDInsight