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

Question 1

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 2

The exhibit shows a SQL query run against Azure SQL Database. What is the purpose of the HAVING clause in this query?

Accepted Answer

To filter groups based on aggregate conditions. The HAVING clause in SQL is used to filter groups after the GROUP BY clause has been applied, based on aggregate conditions such as SUM, COUNT, or AVG. In this query against Azure SQL Database, HAVING restricts the result to only those groups that satisfy the specified aggregate condition, which cannot be done with a WHERE clause because WHERE filters individual rows before grouping.

Answer

To filter rows before grouping

Answer

To sort the result set

Answer

To join two tables

Question 3

The exhibit shows a Kusto Query Language (KQL) query run in Azure Data Explorer. What is the output of this query?

Accepted Answer

The top 5 event types in Texas by total property damage. The query uses `summarize sum(PropertyDamage) by EventType` to aggregate total property damage per event type, then `top 5 by TotalPropertyDamage` to return the five event types with the highest totals. The `where State == 'TEXAS'` filter ensures only Texas storms are considered. This directly yields the top 5 event types in Texas by total property damage.

Answer

All storm events in Texas with property damage

Answer

The total property damage for all event types in Texas

Answer

A list of the top 5 property damage amounts in Texas

Question 4

A company stores customer transaction data in Azure Blob Storage. The data is rarely accessed after 30 days, but must be retained for 7 years for compliance. Which access tier minimizes storage cost while meeting the retention requirement?

Accepted Answer

Archive tier. The Archive tier is the correct choice because it offers the lowest storage cost for data that is rarely accessed, which aligns with the scenario where data is accessed infrequently after 30 days but must be retained for 7 years. Azure Blob Storage's Archive tier is designed for long-term retention with a retrieval latency of several hours, making it cost-effective for compliance-driven data that does not require immediate access.

Answer

Hot tier

Answer

Cool tier

Answer

Premium tier

Question 5

You need to query data stored in Azure Cosmos DB for NoSQL using SQL-like syntax. Which feature should you use?

Accepted Answer

Use the SQL API built into Cosmos DB. Azure Cosmos DB for NoSQL provides a native SQL API that allows you to query JSON documents using SQL-like syntax. This API translates standard SQL queries into Cosmos DB's internal query engine, enabling you to SELECT, filter, and project data directly from containers without any additional services or connectors.

Answer

Use Azure SQL Database elastic query

Answer

Use Power BI DirectQuery

Answer

Use Azure Synapse Analytics Serverless SQL pool

Question 6

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 7

A company wants to store JSON documents that need to be queried with high throughput and low latency globally. Which Azure data service is most appropriate?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the most appropriate service because it is a globally distributed, multi-model database that natively supports JSON documents and provides guaranteed single-digit-millisecond latency at the 99th percentile, along with high throughput via configurable request units (RUs). Its turnkey global distribution enables low-latency reads and writes across multiple Azure regions, making it ideal for globally queried JSON workloads.

Answer

Azure Table Storage

Answer

Azure SQL Database

Answer

Azure Blob Storage

Question 8

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 9

A company needs to store semi-structured data from IoT devices, including temperature readings and device status. The data will be queried by time range and device ID. Which Azure data service is most cost-effective for this use case?

Accepted Answer

Azure Table Storage. Azure Table Storage is a NoSQL key-value store that is optimized for storing large amounts of semi-structured data without requiring a fixed schema. It supports efficient queries by partition key (device ID) and row key (timestamp), making it ideal for time-series IoT data at a lower cost than other Azure data services.

Answer

Azure Blob Storage

Answer

Azure Cosmos DB

Answer

Azure SQL Database

Question 10

You need to design a data storage solution for an e-commerce platform that requires ACID transactions for order processing and high availability across regions. Which Azure service meets these requirements?

Accepted Answer

Azure SQL Database with active geo-replication. Azure SQL Database with active geo-region replication supports ACID transactions natively and provides automatic failover to a secondary region, ensuring high availability across regions. This meets the e-commerce platform's need for transactional consistency and regional resilience.

Answer

Azure Database for MySQL with read replicas

Answer

Azure Synapse Analytics

Answer

Azure Cosmos DB with multiple write regions

Question 11

Which TWO Azure services are primarily used for batch processing of large volumes of data? (Choose two.)

Accepted Answer

Azure Synapse Analytics. Azure Synapse Analytics is correct because it provides a cloud-based data warehousing and analytics service that uses massively parallel processing (MPP) to run complex queries and batch processing jobs over large datasets, often using PolyBase or T-SQL to transform and load data in bulk. Azure Databricks is correct because it is an Apache Spark-based analytics platform optimized for batch processing, allowing users to run distributed data processing jobs (e.g., ETL, data transformation) across large volumes of data using DataFrames and RDDs in a cluster environment.

Answer

Azure SQL Database

Answer

Azure Stream Analytics

Answer

Azure Data Lake Storage

Question 12

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 13

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 14

Refer to the exhibit. A data engineer needs to query the orders.csv file using Azure Synapse Serverless SQL. What is the most efficient way to access this data?

Accepted Answer

Use OPENROWSET in Serverless SQL. Azure Synapse Serverless SQL is designed for on-demand querying of data stored in data lakes without provisioning storage. The OPENROWSET function with the BULK option allows direct querying of CSV files using T-SQL, making it the most efficient method for ad-hoc analysis of the orders.csv file without data movement or schema management.

Answer

Use PolyBase to create external table

Answer

Copy data to Azure SQL Database using ADF

Answer

Load data into a dedicated SQL pool

Question 15

Refer to the exhibit. The JSON shows a configuration for which Azure service?

Accepted Answer

Azure Data Factory. The JSON snippet defines a pipeline with a copy activity that moves data from a source (Azure Blob Storage) to a sink (Azure SQL Database). This is the core pattern of Azure Data Factory (ADF), which orchestrates and automates data movement and transformation. The structure with 'name', 'properties', 'activities', 'typeProperties', 'source', and 'sink' is specific to ADF pipeline definitions.

Answer

Azure Analysis Services

Answer

Power BI

Answer

Azure Synapse Analytics