DP-900 Practice Test 33 — 15 Questions

Question 1

A data engineering team needs to build a real-time dashboard showing sales totals by region. Sales transactions are streamed from point-of-sale systems into Azure Event Hubs. The team wants to aggregate the data in near real-time (e.g., every minute) and store the results in Azure SQL Database for visualization in Power BI. Which Azure service should they use for the aggregation step?

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

Accepted Answer

Azure Stream Analytics. Azure Stream Analytics is the correct choice because it is designed for real-time stream processing, allowing you to define a query that aggregates sales data from Event Hubs over a one-minute tumbling window and output the results directly to Azure SQL Database. This meets the requirement for near real-time aggregation without needing to write custom code or manage infrastructure.

Answer

Azure Data Factory

Answer

Azure Synapse Pipelines

Answer

Azure Logic Apps

Question 2

Which TWO of the following are characteristics of structured data? (Choose two.)

Accepted Answer

Stored in rows and columns. Structured data is organized in a tabular format with rows and columns, which is the defining characteristic of relational databases like SQL Server or Azure SQL Database. This structure enforces a fixed schema, meaning the data types and relationships are defined before data is entered, ensuring consistency and enabling efficient querying via SQL.

Answer

No predefined schema

Answer

Key-value pairs

Answer

Schema-on-read

Question 3

A social media company stores user profiles as JSON documents where each profile may have different attributes (e.g., some profiles include 'education' while others include 'work history'). The company also stores user-generated posts in a relational database table with fixed columns (PostID, UserID, Content, Timestamp). Which of the following best describes the data types used for user profiles and user posts?

Accepted Answer

User profiles are semi-structured data; posts are structured data.. User profiles are stored as JSON documents with varying attributes, which is a classic example of semi-structured data because it has some organizational properties (key-value pairs) but does not enforce a fixed schema. User posts are stored in a relational database table with fixed columns (PostID, UserID, Content, Timestamp), which is structured data because it adheres to a rigid schema with defined data types and relationships.

Answer

User profiles are structured data; posts are unstructured data.

Answer

Both are semi-structured data.

Answer

User profiles are unstructured data; posts are structured data.

Question 4

You are designing a data solution for a retail company that needs to store transactional data (orders, payments) with strong consistency and support for complex joins. The data volume is moderate but expected to grow. Which Azure service should you choose?

Accepted Answer

Azure SQL Database. Azure SQL Database is a fully managed relational database that provides ACID transactions with strong consistency and supports complex joins via T-SQL. It is ideal for transactional workloads like orders and payments where data integrity and relational queries are critical, and it scales elastically to accommodate growing data volumes.

Answer

Azure Cosmos DB

Answer

Azure Table Storage

Answer

Azure Synapse Analytics

Question 5

A company has a database that processes millions of small credit card transactions per second for payment authorization. They also need to run complex reports that aggregate transaction data over months to detect fraud patterns. Which type of workload describes the payment authorization process?

Accepted Answer

OLTP (Online Transaction Processing). The payment authorization process involves high-volume, low-latency transactions that read, insert, and update individual records in real time. This is the classic definition of OLTP (Online Transaction Processing), which is optimized for ACID-compliant, row-based operations on current data. The scenario explicitly states 'millions of small credit card transactions per second,' which aligns with OLTP workloads like order entry or banking.

Answer

OLAP (Online Analytical Processing)

Answer

HTAP (Hybrid Transactional/Analytical Processing)

Answer

ETL (Extract, Transform, Load)

Question 6

A company stores customer orders in a database. Each order has an OrderID (integer), CustomerName (text), OrderDate (date), and a JSON column for order details that contains varying fields such as discount codes or gift messages. Which statement best describes the data types in this table?

Accepted Answer

The table stores both structured and semi-structured data.. The table includes structured columns (OrderID integer, CustomerName text, OrderDate date) and a JSON column for order details, which stores semi-structured data because JSON allows flexible schemas with varying fields like discount codes or gift messages. This combination of fixed-schema columns and a schema-less JSON column means the table holds both structured and semi-structured data, making option B correct.

Answer

The table stores only structured data.

Answer

The table stores only unstructured data.

Answer

The table stores only semi-structured data.

Question 7

A company is building a data lake and collects data from three sources: (1) a relational database exporting CSV files with fixed columns for customer records, (2) API responses stored as JSON files with varying fields for product reviews, and (3) scanned handwritten notes stored as TIFF images. Which statement correctly categorizes these data by structure type?

Accepted Answer

1: structured, 2: semi-structured, 3: unstructured. CSV files from a relational database have a fixed schema (rows and columns), making them structured data. JSON files from API responses with varying fields are semi-structured, as they use tags/keys to organize data without a rigid schema. TIFF images of handwritten notes are unstructured, lacking a predefined data model or organization.

Answer

1: semi-structured, 2: structured, 3: unstructured

Answer

1: structured, 2: unstructured, 3: semi-structured

Answer

1: unstructured, 2: semi-structured, 3: structured

Question 8

You are reviewing an ARM template for an Azure Storage account. The container named 'data' is created with public access set to 'None'. What is the primary benefit of this configuration?

Accepted Answer

It restricts access to authorized users only.. Setting public access to 'None' on a container means that anonymous read requests are not allowed. The primary benefit is that only requests with proper authorization (e.g., using an account key, a shared access signature, or Azure AD credentials) can access the blobs within that container. This directly restricts access to authorized users only, which is the core security advantage.

Answer

It encrypts data at rest.

Answer

It enables soft delete for the container.

Answer

It prevents accidental deletion of blobs.

Question 9

Drag and drop the steps to create an Azure SQL Database in the correct order.

Accepted Answer

Step 1: Select SQL Database service, Step 2: Configure server (create new server), Step 3: Configure database settings (name, pricing tier, compute+storage), Step 4: Review and create. Creating an Azure SQL Database involves selecting the service, configuring the server and database settings, choosing the appropriate tier, and finally deploying.

Answer

Step 1: Configure server (create new server), Step 2: Select SQL Database service, Step 3: Configure database settings (name, pricing tier, compute+storage), Step 4: Review and create

Answer

Step 1: Select SQL Database service, Step 2: Configure database settings (name, pricing tier, compute+storage), Step 3: Configure server (create new server), Step 4: Review and create

Answer

Step 1: Configure database settings (name, pricing tier, compute+storage), Step 2: Select SQL Database service, Step 3: Configure server (create new server), Step 4: Review and create

Question 10

Your team uses Azure SQL Database and wants to implement row-level security (RLS) to restrict access to sales data by region. Which type of data workload characteristic does RLS primarily address?

Accepted Answer

Security. Row-level security (RLS) in Azure SQL Database restricts data access at the database engine level by applying a security predicate that filters rows based on user attributes, such as region. This directly addresses the security characteristic of a data workload by ensuring that users can only see data they are authorized to view, without requiring application-level changes.

Answer

Concurrency

Answer

Consistency

Answer

Durability

Question 11

A data engineer needs to load data from an on-premises SQL Server database to Azure Synapse Analytics every hour with minimal latency. Which Azure service should they use?

Accepted Answer

Azure Data Factory. Azure Data Factory (ADF) is the correct choice because it provides a fully managed, code-free ETL service that can connect to on-premises SQL Server via self-hosted integration runtime, and load data into Azure Synapse Analytics with low latency using a scheduled trigger (e.g., every hour). ADF supports incremental data loading and parallel copy activities, minimizing latency while handling the required frequency.

Answer

Azure Databricks

Answer

Azure SQL Database

Answer

Azure HDInsight

Question 12

Refer to the exhibit. The JSON shows an Azure Policy definition. Which effect should be used to proactively prevent creation of storage accounts without encryption?

Accepted Answer

Deny. The 'Deny' effect is correct because it proactively blocks the creation or update of a storage account that does not meet the encryption requirement, preventing non-compliant resources from being provisioned. This aligns with Azure Policy's ability to enforce compliance at resource creation time, rather than auditing or remediating after the fact.

Answer

AuditIfNotExists

Answer

Disabled

Answer

Append

Question 13

A healthcare organization stores patient records in Azure Blob Storage and must comply with data retention policies that require deleting records after 7 years. They also need to prevent any modification or deletion of records before the retention period ends. Which Azure feature should they use?

Accepted Answer

Immutable storage with time-based retention policy. Immutable storage with a time-based retention policy (WORM – Write Once, Read Many) ensures that blobs cannot be modified or deleted until the retention period expires. This directly meets the dual requirement of preventing premature deletion while enforcing a 7-year retention, as the policy locks the data for the specified duration.

Answer

Azure Backup for Blob Storage

Answer

Soft delete for Blob Storage

Answer

Azure Blob Storage lifecycle management

Question 14

Refer to the exhibit. You are analyzing a Kusto query in Azure Data Explorer. The query is intended to return the top 5 event types that caused the most property damage in Florida. However, the query returns an error. What is the most likely cause?

Accepted Answer

The table or column names are incorrect.. The query returns an error because the table or column names referenced in the query do not match the actual schema in Azure Data Explorer. In Kusto Query Language (KQL), if a table name like 'Events' or a column like 'PropertyDamage' does not exist in the database, the query will fail with a 'semantic error' indicating an unknown table or column. This is the most likely cause given that the query logic (where, summarize, top) is syntactically correct.

Answer

The where clause must specify a numeric value.

Answer

The summarize operator cannot use sum aggregation.

Answer

The top operator requires an order by clause.

Question 15

You design a data solution for an e-commerce platform. Transactional data must be stored with ACID compliance for order processing, while clickstream data from the website will be used for analytics. Which combination of Azure data services best meets these needs?

Accepted Answer

Azure SQL Database for transactions; Azure Synapse Analytics for analytics. Azure SQL Database provides full ACID compliance for transactional workloads like order processing, ensuring data integrity. Azure Synapse Analytics is optimized for large-scale analytics on clickstream data, offering massively parallel processing (MPP) and integration with data lakes. This combination separates OLTP and OLAP workloads efficiently.

Answer

Azure Cosmos DB for transactions; Azure SQL Database for analytics

Answer

Azure Blob Storage for transactions; Azure Data Lake Storage for analytics

Answer

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