DP-900 Practice Test 36 — 15 Questions

Question 1

A company uses Azure Stream Analytics to process IoT data from thousands of devices. They need to store the results in a way that supports fast querying for historical analysis. Which output sink should they use?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Azure Data Lake Storage Gen2. Azure Data Lake Storage Gen2 (ADLS Gen2) is the correct output sink because it combines a hierarchical namespace with Azure Blob Storage's scalable object storage, enabling fast querying for historical analysis via tools like Azure Synapse Analytics, PolyBase, or Apache Spark. ADLS Gen2 supports high-throughput writes from Stream Analytics and allows efficient directory-level operations and fine-grained access control, which are critical for large-scale IoT data analytics.

Answer

Azure Table Storage

Answer

Azure Blob Storage

Answer

Azure Event Hubs

Question 2

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 3

A company plans to implement a near-real-time analytics solution for streaming IoT sensor data. Which Azure service should they use to ingest and process the data streams?

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics is a real-time event processing engine designed to ingest, process, and analyze high-velocity streaming data from sources like IoT sensors. It supports SQL-based queries to transform and route data streams to outputs such as Power BI or Azure Synapse, making it ideal for near-real-time analytics.

Answer

Azure Data Factory

Answer

Azure Synapse Analytics

Answer

Azure Data Lake Storage Gen2

Question 4

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 5

Refer to the exhibit. You execute the above T-SQL statements in Azure Synapse Analytics. What is the purpose of this code?

Accepted Answer

To create an external table that can query Parquet files stored in Azure Data Lake Storage Gen2.. The T-SQL code creates an external data source pointing to Azure Data Lake Storage Gen2, an external file format for Parquet, and an external table that references the Parquet files. This allows querying the Parquet files directly without importing them into the database, which is the definition of an external table in Azure Synapse Analytics.

Answer

To create a view over the Parquet files.

Answer

To import data from Parquet files into a permanent table in Synapse.

Answer

To create a regular table in the Synapse database.

Question 6

Refer to the exhibit. You have an Azure Data Factory pipeline definition as shown. The pipeline fails with a 'Source not found' error. The BlobInputDataset points to a container that exists. What is the most likely cause?

Accepted Answer

The dataset's file path is incorrect or no files match the pattern.. The 'Source not found' error in Azure Data Factory indicates that the source dataset cannot locate the specified file or blob. Since the container exists, the most likely cause is that the file path defined in the dataset is incorrect or that no files match the specified pattern (e.g., wildcard or prefix). This is a common configuration issue when the dataset's folder path or file name does not correspond to the actual blob location.

Answer

The Azure Blob Storage container is empty.

Answer

The Azure Data Factory managed identity does not have access to the storage account.

Answer

The SQL sink database does not exist.

Question 7

Your company is developing a new analytics solution to track customer sentiment from social media feeds. The data arrives as a continuous stream of JSON messages. The solution must process the data in near real-time, enrich it with customer profile data stored in Azure Cosmos DB, and then store the results in a data lake for historical analysis. The team wants to use a low-code approach for the data processing logic. You are considering the following architectures: A) Use Azure Event Hubs to ingest the stream, Azure Stream Analytics to process and enrich the data using Cosmos DB as a reference data source, and output to Azure Data Lake Storage Gen2. B) Use Azure IoT Hub to ingest the stream, Azure Databricks to process the data, and write to Azure Blob Storage. C) Use Azure Event Hubs to ingest the stream, Azure Functions to process each message, query Cosmos DB for enrichment, and write to Azure Data Lake Storage Gen2. D) Use Azure Event Hubs to ingest the stream, Azure Data Factory to execute a mapping data flow for enrichment, and write to Azure Data Lake Storage Gen2. Which architecture best meets the requirements of near real-time processing, enrichment, and low-code?

Accepted Answer

Option A. Azure Stream Analytics provides a low-code, SQL-based approach for near real-time processing, and it can natively enrich streaming data by using Azure Cosmos DB as a reference data source via a JOIN operation. The output is directly written to Azure Data Lake Storage Gen2, meeting all requirements without custom code.

Answer

Option C

Answer

Option D

Answer

Option B

Question 8

A small business wants to start using Azure for analytics. They have a few CSV files stored on-premises that they want to analyze. They have no budget for complex infrastructure and prefer a fully managed, serverless solution. They need to create interactive visualizations and share them with their team. The data does not change frequently, so they are okay with daily refreshes. Which of the following options should they choose? A) Upload the CSV files to Azure Data Lake Storage Gen2, use Azure Databricks to create a data processing pipeline, and then use Power BI to visualize the results. B) Upload the CSV files to Azure Blob Storage, use Azure Data Factory to load the data into Azure SQL Database, and then use Power BI to connect and visualize. C) Upload the CSV files to OneDrive for Business, use Power BI Desktop to import the data, and publish to Power BI Service with scheduled refresh. D) Upload the CSV files to Azure Data Lake Storage Gen2, use Azure Synapse Serverless SQL pool to query the data, and then use Power BI to connect. Which option is the simplest and most cost-effective?

Accepted Answer

Option C. It uses OneDrive for Business as a simple storage location, Power BI Desktop for importing CSV data, and Power BI Service for publishing and sharing interactive visualizations with scheduled daily refresh. This is fully managed, serverless, and requires no complex infrastructure, aligning perfectly with the small business's budget and simplicity requirements.

Answer

Option B

Answer

Option D

Answer

Option A

Question 9

Refer to the exhibit. A data engineer wants to ensure that all Azure Storage accounts used for analytics use customer-managed keys. They apply this Azure Policy. What is the outcome?

Accepted Answer

The policy denies creation of StorageV2 accounts that use Microsoft-managed keys. The Azure Policy in the exhibit uses the 'Deny' effect on storage accounts that do not use customer-managed keys (i.e., that use Microsoft-managed keys). This means any attempt to create or update a storage account without customer-managed encryption will be blocked. Option D correctly identifies that the policy denies creation of StorageV2 accounts (or any storage account type covered by the policy scope) that use Microsoft-managed keys.

Answer

The policy audits existing storage accounts for compliance

Answer

The policy allows all storage accounts whether they use customer-managed keys or not

Answer

The policy only applies to storage accounts with hierarchical namespace enabled

Question 10

A car manufacturing company has two data processing systems: one system processes real-time sensor data from assembly lines to immediately detect equipment failures, and another system processes historical production records to generate monthly efficiency reports. Which two types of data processing workloads best describe these systems?

Accepted Answer

Stream processing and batch processing. Stream processing (option A) handles real-time sensor data from the assembly line to detect equipment failures immediately, while batch processing (option A) is ideal for processing historical production records on a scheduled basis to generate monthly efficiency reports. Transactional processing (option D) refers to OLTP workloads that process business transactions, not real-time sensor streams, so it is not a correct description for the first system. The correct answer is A only.

Answer

OLTP and OLAP

Answer

Online processing and offline processing

Answer

Transactional processing and analytical processing

Question 11

Which TWO are benefits of using Azure SQL Database elastic pools?

Accepted Answer

Predictable pricing for a group of databases. Azure SQL Database elastic pools provide predictable pricing because you pay for a fixed set of resources (eDTUs or vCores) allocated to the pool, regardless of how many databases use them. This allows you to budget for a group of databases with variable usage patterns without incurring per-database costs, making it cost-effective for workloads with intermittent or unpredictable demand.

Answer

Unlimited storage per database

Answer

Isolated performance for each database

Answer

Support for databases over 1 TB each

Question 12

Drag and drop the steps to create an Azure Stream Analytics job in the correct order.

Accepted Answer

Create the Stream Analytics job, then configure inputs, then configure outputs, then define the transformation query.. Creating a Stream Analytics job involves setting up the job parameters, then configuring inputs, outputs, and the transformation query.

Answer

Create the Stream Analytics job, then define the transformation query, then configure inputs, then configure outputs.

Answer

Configure inputs, then configure outputs, then create the Stream Analytics job, then define the transformation query.

Answer

Define the transformation query, then create the Stream Analytics job, then configure inputs, then configure outputs.

Question 13

Match each Azure data tool to its purpose.

Accepted Answer

Azure Data Lake Storage: A scalable and secure data lake for high-performance analytics.. The correct matches are: Azure Data Lake Storage for scalable data lake storage, Azure Data Factory for data integration, and Azure Stream Analytics for real-time stream processing. Azure Synapse Analytics is a unified analytics platform, and Azure Databricks is an Apache Spark-based analytics platform. Common confusions include mixing up Synapse Analytics with Data Factory, and Databricks with Stream Analytics.

Answer

Azure Synapse Analytics: A cloud-based data integration service.

Answer

Azure Databricks: A real-time stream processing engine.

Question 14

Which THREE are characteristics of structured data? (Choose three.)

Accepted Answer

Has a predefined schema. Structured data has a predefined schema, meaning the data types, relationships, and constraints are defined before data is entered. This schema ensures consistency and enables efficient querying, which is why relational databases enforce a fixed schema through table definitions and constraints like primary keys and foreign keys.

Answer

Consists of audio and video files

Answer

Uses JSON or XML format

Question 15

Which TWO Azure services are primarily used for data integration and orchestration?

Accepted Answer

Azure Logic Apps. Azure Logic Apps is correct because it is a serverless workflow service that integrates apps, data, and services using connectors and triggers, making it ideal for data integration and orchestration. Azure Data Factory is correct because it is a cloud-based ETL and data integration service that orchestrates and automates data movement and transformation across various data stores.

Answer

Azure Synapse Analytics

Answer

Azure Stream Analytics

Answer

Azure Analysis Services