DP-900 Describe core data concepts Practice Test 11 — 15 Questions

Question 1

Your organization has a large dataset of customer transactions stored in Azure Blob Storage as CSV files. You need to run ad-hoc SQL queries on this data without loading it into a database. Which Azure service should you use?

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

Accepted Answer

Azure Synapse Serverless SQL pool. Azure Synapse Serverless SQL pool allows you to query data directly from files in Azure Blob Storage using standard T-SQL syntax, without needing to load or move the data into a database. It uses a pay-per-query model and supports CSV, Parquet, and JSON formats, making it ideal for ad-hoc analytical queries over large datasets stored in data lakes.

Answer

Azure Data Factory

Answer

Azure SQL Database

Answer

Azure Analysis Services

Question 2

A company is designing a data solution for their e-commerce platform. They need to store product catalogs with varying attributes, support high-throughput read/write operations, and ensure low-latency access globally. Which Azure data store is most appropriate?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the most appropriate choice because it is a globally distributed, multi-model database service that supports schema-agnostic storage of product catalogs with varying attributes. It offers guaranteed single-digit-millisecond latency for reads and writes at any scale, and its turnkey global distribution enables low-latency access from multiple regions, meeting the e-commerce platform's high-throughput and global requirements.

Answer

Azure SQL Database

Answer

Azure Redis Cache

Answer

Azure Data Lake Storage

Question 3

You are implementing a data pipeline that ingests millions of events per second from IoT devices. The pipeline must tolerate failures and guarantee exactly-once processing. Which Azure service should you use to ingest the events?

Accepted Answer

Azure Event Hubs. Azure Event Hubs is the correct choice because it is a big data streaming platform and event ingestion service designed for high-throughput scenarios, capable of ingesting millions of events per second. It supports exactly-once processing through checkpointing and partition-based offset management, and its built-in replication and availability zones provide fault tolerance.

Answer

Azure IoT Hub

Answer

Azure Service Bus

Answer

Azure Queue Storage

Question 4

A company wants to run complex analytics queries across petabytes of data stored in Azure Data Lake Storage. They need a serverless option that supports T-SQL. Which Azure service should they use?

Accepted Answer

Azure Synapse Serverless SQL pool. Azure Synapse Serverless SQL pool is the correct choice because it provides a serverless, on-demand query service that allows you to run T-SQL queries directly against data stored in Azure Data Lake Storage (ADLS). It supports complex analytics over petabytes of data without provisioning any infrastructure, and it uses T-SQL as the query language, meeting all the stated requirements.

Answer

Azure SQL Database serverless

Answer

Azure Analysis Services

Answer

Azure Databricks

Question 5

Your team is building a real-time dashboard for monitoring website traffic. The data source is streaming click events from Azure Event Hubs. The dashboard must update within seconds. Which Azure service should you use to process the stream?

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics is designed for real-time stream processing with low-latency output, making it ideal for processing click events from Event Hubs and updating a dashboard within seconds. It provides a SQL-like query language to define transformations and can output directly to Power BI or other visualization tools for near-instantaneous dashboard updates.

Answer

Azure Synapse Pipelines

Answer

Azure Data Factory

Answer

Azure Databricks Structured Streaming

Question 6

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database deployment. The database must support a read-only workload that requires low latency. The current configuration uses General Purpose tier with 4 vCores. What is the most significant performance improvement you can make without changing the tier?

Accepted Answer

Enable read scale-out by adding 'readScale' property. Enabling read scale-out by adding the 'readScale' property allows the database to use a read-only replica, offloading read workloads from the primary and providing low-latency reads. This is the most significant performance improvement within the General Purpose tier because it directly addresses the read-only workload requirement without changing the tier or incurring additional compute costs.

Answer

Increase maxSizeBytes to 1 TB

Answer

Set the edition to 'Serverless'

Answer

Change requestedBackupStorageRedundancy to 'Local'

Question 7

Which TWO Azure services can be used to perform real-time stream processing?

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics (B) is a fully managed, real-time analytics service designed to ingest continuous streams from sources like Event Hubs, IoT Hub, or Blob Storage and run SQL-like queries with temporal windows (Tumbling, Hopping, Sliding, Session) to produce low-latency output to sinks such as Power BI, Cosmos DB, or SQL Database, making it a canonical real-time stream processing engine. Azure Databricks Structured Streaming (D) is built on Apache Spark and treats a live data stream as an unbounded table, supporting exactly-once semantics, event-time processing with watermarking, and continuous or micro-batch execution against sources like Kafka, Event Hubs, and Delta Lake, so it also performs real-time stream processing. Azure Data Factory (A) is a batch-oriented data integration and orchestration service using pipelines and activities, not a streaming engine. Azure Analysis Services (C) provides semantic tabular modeling and OLAP query capabilities over pre-processed data rather than processing live streams. Azure Synapse Pipelines (E) is the orchestration component of Synapse Analytics, used for scheduled batch ETL/ELT workflows, not real-time stream processing.

Answer

Azure Data Factory

Answer

Azure Analysis Services

Answer

Azure Synapse Pipelines

Question 8

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 9

Which THREE Azure services can be used to move data from on-premises SQL Server to Azure?

Accepted Answer

Azure Database Migration Service. Azure Database Migration Service (A) is correct because it is purpose-built to migrate on-premises SQL Server databases to Azure targets such as Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs, using the Data Migration Assistant for assessment and a migration project with an online or offline mode. Azure Data Factory (B) is correct because its copy activity and self-hosted integration runtime can connect to an on-premises SQL Server and move data to Azure destinations like Azure SQL Database, Blob Storage, or Azure Synapse, supporting scheduled and incremental pipelines. Azure Data Box (E) is correct because it is a physical data-transfer appliance used to ship large volumes of data (including SQL Server database backups such as BACPAC or .bak files) to Azure when network transfer is impractical. Azure Analysis Services (C) is not a data-movement service; it hosts semantic tabular models for analytics and consumes data rather than migrating it. Azure Synapse Serverless SQL pool (D) is a query engine over data in the lake and does not provide a migration mechanism from on-premises SQL Server.

Answer

Azure Analysis Services

Answer

Azure Synapse Serverless SQL pool

Question 10

Refer to the exhibit. You are analyzing a message from an IoT device captured in Azure Event Hubs. The message contains system properties indicating the device ID and authentication method. You need to route messages from device-01 to a separate storage container for compliance. Which property should you use in a Stream Analytics query to filter messages?

Accepted Answer

iothub-connection-device-id. The `iothub-connection-device-id` system property is automatically added by Azure IoT Hub to every device-to-cloud message. In a Stream Analytics query, you can reference this property directly (e.g., `WHERE iothub-connection-device-id = 'device-01'`) to filter messages from a specific device for routing to a separate storage container for compliance.

Answer

partitionId

Answer

consumerGroup

Answer

deviceId

Question 11

Refer to the exhibit. You are reviewing an Azure Resource Manager template for a Blob Storage container named 'sales'. The container has versioning enabled. A developer accidentally overwrites a blob. What is the simplest way to recover the previous version?

Accepted Answer

Access the previous version through the version list and restore it. Azure Blob Storage versioning automatically maintains a history of blob versions. When a blob is overwritten, the previous version is preserved and can be accessed via the version list. The simplest recovery method is to promote the previous version to the current version, which restores the blob to its prior state without needing additional services or configurations.

Answer

Use blob soft delete to recover the blob

Answer

Restore from a backup using Azure Backup

Answer

Perform a point-in-time restore of the container

Question 12

A retail company uses Azure SQL Database to store customer transactions. They need to analyze sales trends over time. Which Azure service should they use to build interactive dashboards and reports without moving data out of Azure?

Accepted Answer

Power BI. Power BI is the correct choice because it is a business analytics service that can connect directly to Azure SQL Database to build interactive dashboards and reports without requiring data movement. It supports DirectQuery mode, which queries the source database in real-time, enabling live analysis of sales trends while data remains in Azure.

Answer

Azure Analysis Services

Answer

Azure Synapse Analytics

Answer

Microsoft Purview

Question 13

A company wants to store JSON documents from IoT devices with low latency and high availability. Which Azure data store should they use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it is a fully managed NoSQL database designed for low-latency, high-availability workloads, with native support for JSON documents. It offers single-digit millisecond read/write latencies at the 99th percentile, global distribution with multi-region writes, and multiple consistency models, making it ideal for IoT scenarios that require fast, always-on access to semi-structured data.

Answer

Azure Blob Storage

Answer

Azure Table Storage

Answer

Azure SQL Database

Question 14

You are designing a data solution for a healthcare application that requires ACID transactions for patient records and needs to run complex analytics queries. Which combination of Azure services should you recommend?

Accepted Answer

Azure SQL Database for transactions, Azure Synapse Analytics for analytics. Azure SQL Database provides full ACID (Atomicity, Consistency, Isolation, Durability) transaction support, which is essential for healthcare patient records where data integrity is critical. Azure Synapse Analytics is a cloud-based analytics service that can run complex queries against large datasets, including those from Azure SQL Database, using its massively parallel processing (MPP) architecture. This combination allows transactional and analytical workloads to coexist without compromising performance or consistency.

Answer

Azure Cosmos DB for transactions, Power BI for analytics

Answer

Azure Database for MySQL for transactions, Azure Analysis Services for analytics

Answer

Azure Blob Storage for transactions, Azure Machine Learning for analytics

Question 15

A data engineer needs to load 500 GB of CSV files from an on-premises server into Azure Data Lake Storage Gen2 daily. The data must be transferred securely over the internet. Which Azure tool should they use?

Accepted Answer

AzCopy. AzCopy is the correct tool because it is a command-line utility designed for high-performance, secure copying of data to and from Azure Blob Storage and Azure Data Lake Storage Gen2. It supports the required 500 GB daily transfer over the internet using HTTPS encryption, and can be scripted for automation without the overhead of a full orchestration service.

Answer

Azure Data Factory

Answer

Azure PowerShell

Answer

Azure Import/Export service