DP-900 Describe an analytics workload on Azure Practice Test 15 — 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

An organization has a data lake that contains both structured and unstructured data. They need to catalog the data assets and enable data discovery for users. Which Azure service should they use?

Accepted Answer

Microsoft Purview. Microsoft Purview is a unified data governance service that helps you manage and govern your on-premises, multicloud, and software-as-a-service (SaaS) data. It provides automated data discovery, sensitive data classification, and end-to-end data lineage, making it the correct choice for cataloging both structured and unstructured data assets in a data lake and enabling data discovery for users.

Answer

Azure Data Factory

Answer

Azure Synapse Analytics

Answer

Azure Data Lake Storage

Question 5

A financial services company needs to run ad-hoc SQL queries on petabytes of data stored in Azure Data Lake Storage without provisioning a dedicated data warehouse. Which Azure service should they use?

Accepted Answer

Azure Synapse Analytics serverless SQL pool. Azure Synapse Analytics serverless SQL pool is the correct choice because it allows you to run ad-hoc SQL queries directly against data in Azure Data Lake Storage without provisioning any dedicated compute resources. It uses a pay-per-query model, automatically scaling compute to handle petabytes of data, making it ideal for intermittent, exploratory workloads.

Answer

Azure Analysis Services

Answer

Azure SQL Database

Answer

Azure Data Lake Storage

Question 6

A company runs a SQL Server database on an Azure virtual machine. They need to offload reporting queries to a read-only copy without modifying the application. Which Azure service should they use?

Accepted Answer

Azure SQL Database with read scale-out. Azure SQL Database with read scale-out (C) is correct because it creates a read-only replica of the database that can handle reporting queries without modifying the application. The application simply adds `ApplicationIntent=ReadOnly` to the connection string, and the Azure gateway automatically routes read-only queries to the secondary replica, offloading the primary from reporting workloads.

Answer

Azure Analysis Services

Answer

Azure SQL Managed Instance

Answer

Azure Synapse Analytics dedicated SQL pool

Question 7

A data engineer needs to transform and clean data from multiple sources before loading it into Azure Synapse Analytics. Which Azure service should they use for this ETL process?

Accepted Answer

Azure Data Factory. Azure Data Factory is the correct service because it is a cloud-based ETL (Extract, Transform, Load) service designed specifically to orchestrate and automate data movement and transformation from multiple sources. It provides built-in connectors for various data stores and supports data flows for cleaning and transforming data before loading it into Azure Synapse Analytics.

Answer

Azure Analysis Services

Answer

Azure Databricks

Answer

Azure Stream Analytics

Question 8

A company uses Azure Data Lake Storage Gen2 as a data lake. They need to enforce row-level security for sensitive data so that sales representatives can only see rows for their assigned region. Which approach should they use?

Accepted Answer

Load data into Azure Synapse Analytics dedicated SQL pool and implement row-level security (RLS). Row-level security (RLS) in Azure Synapse Analytics dedicated SQL pool allows you to restrict data access at the row level based on a user's identity or group membership. By loading the data into a dedicated SQL pool and defining a security policy with a predicate function that filters rows by region, you can ensure sales representatives only see rows for their assigned region. This is the correct approach because RLS is designed specifically for this purpose and integrates with Azure Active Directory for user authentication.

Answer

Apply sensitivity labels in Microsoft Purview

Answer

Use Azure RBAC roles on the storage account

Answer

Use Azure Data Lake Storage Gen2 access control lists (ACLs) on folders per region

Question 9

An organization wants to build a real-time dashboard that visualizes IoT sensor data as it arrives. Which Azure service should they use for processing the streaming data?

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics is a real-time analytics service designed to process streaming data from sources like IoT devices. It can ingest data from Azure Event Hubs or IoT Hub, apply SQL-based queries to detect patterns or anomalies, and output results to a dashboard or storage with sub-second latency, making it ideal for real-time IoT dashboards.

Answer

Azure Analysis Services

Answer

Azure Data Factory

Answer

Azure Databricks

Question 10

A company is designing a data analytics solution. They need to store large volumes of raw data in its native format and support schema-on-read for data science exploration. Which storage technology should they use?

Accepted Answer

Azure Data Lake Storage Gen2. Azure Data Lake Storage Gen2 (ADLS Gen2) is the correct choice because it combines a hierarchical namespace with Azure Blob Storage's scalable object storage, allowing raw data to be stored in its native format (e.g., CSV, JSON, Parquet) without transformation. It supports schema-on-read, meaning the schema is applied at query time (e.g., via Apache Spark or Azure Synapse SQL), which is ideal for data science exploration where the data structure may not be predefined.

Answer

Azure Blob Storage

Answer

Azure Cosmos DB

Answer

Azure SQL Database

Question 11

A data analyst needs to create an interactive report that combines sales data from Azure SQL Database and Azure Cosmos DB. The report must refresh daily. Which tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed for creating interactive reports and dashboards, and it can directly connect to both Azure SQL Database and Azure Cosmos DB as data sources. Its scheduled refresh capability allows the report to refresh daily without manual intervention, meeting the requirement for an interactive, combined report.

Answer

Azure Data Factory

Answer

Azure Synapse Studio

Answer

Azure Analysis Services

Question 12

A company uses Azure Synapse Analytics for their data warehouse. They notice that queries against the fact table are slow. The fact table is hash-distributed on OrderID. Most queries filter by CustomerID. What should they do to improve performance?

Accepted Answer

Change the distribution column to CustomerID. The fact table is hash-distributed on OrderID, but queries filter by CustomerID. This causes data movement across nodes for each query, as the filter column doesn't align with the distribution key. Changing the distribution column to CustomerID ensures that rows for the same CustomerID are co-located on the same compute node, eliminating unnecessary data shuffling and improving query performance.

Answer

Change to round-robin distribution

Answer

Use rowstore instead of columnstore

Answer

Replicate the fact table to all compute nodes

Question 13

A business user wants to ask natural language questions about their data in Power BI and get answers without writing DAX. Which Power BI feature should they use?

Accepted Answer

Q&A visual. The Q&A visual in Power BI allows users to type natural language questions about their data and receive answers in the form of charts or tables, without needing to write DAX expressions. It uses an underlying natural language engine that interprets the query and automatically generates the appropriate visual or summary. This directly matches the business user's requirement for a no-code, natural language interface.

Answer

Copilot for Microsoft 365

Answer

Power Automate

Answer

Quick Insights

Question 14

A company ingests streaming data from thousands of devices into Azure Event Hubs. They need to transform and aggregate the data in real time before storing it in Azure Data Lake Storage Gen2. Which Azure service should they use between Event Hubs and ADLS Gen2?

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics is purpose-built for real-time data processing and analytics, allowing you to define SQL-like queries to transform and aggregate streaming data from Event Hubs before outputting it directly to Azure Data Lake Storage Gen2. It provides exactly-once delivery semantics and low-latency processing, making it the ideal service for this ingestion-to-storage pipeline.

Answer

Azure Functions

Answer

Azure Databricks

Answer

Azure Data Factory

Question 15

Which TWO Azure services can be used to build a data pipeline that moves data from on-premises SQL Server to Azure Synapse Analytics?

Accepted Answer

Azure Data Factory. Azure Data Factory (A) is correct because it is a cloud-based ETL and data integration service that provides built-in connectors for both on-premises SQL Server (via self-hosted integration runtime) and Azure Synapse Analytics, enabling you to create, schedule, and orchestrate data pipelines that move and transform data between these sources.

Answer

Azure Machine Learning

Answer

Azure Stream Analytics

Answer

Azure Analysis Services