DP-900 Practice Test 13 — 15 Questions

Question 1

Refer to the exhibit. A team is deploying an Azure Storage container using an ARM template. The template sets publicAccess to 'None'. However, after deployment, users report they cannot access data even with a valid SAS token. What is the most likely cause?

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

Accepted Answer

The SAS token was generated with insufficient permissions. The ARM template sets publicAccess to 'None', which only disables anonymous public access to the container. It does not affect SAS token access. The most likely cause is that the SAS token was generated with insufficient permissions (e.g., missing read, list, or write permissions) or with a restricted scope (e.g., limited to a specific blob or with a short expiry), preventing users from accessing the data even though the container is private.

Answer

The container disables SAS tokens by default

Answer

The storage account firewall is blocking all traffic

Answer

The storage account requires RBAC permissions, not SAS

Question 2

A retail company uses Azure Data Lake Storage Gen2 to store raw clickstream data. They need to process this data using Azure Databricks to create hourly aggregated reports. The data pipeline must minimize costs while meeting a five-minute processing SLA. What is the most cost-effective compute option?

Accepted Answer

Use job clusters with pool-based allocation. Job clusters with pool-based allocation are the most cost-effective compute option for this scenario because job clusters are ephemeral—they start only when a job runs and terminate automatically after completion, eliminating idle costs. Pool-based allocation further reduces startup latency by maintaining a warm pool of pre-initialized VMs, enabling the pipeline to meet the five-minute SLA without paying for always-on compute.

Answer

Use interactive clusters with autoscaling

Answer

Use Azure Synapse Serverless SQL pools

Answer

Provision a dedicated SQL pool in Azure Synapse

Question 3

A company stores product information such as product ID, name, price, and category in a relational database with rows and columns. This data is best described as:

Accepted Answer

Structured data. Structured data conforms to a predefined schema with rows and columns, making it easily searchable and queryable via SQL. The product information (ID, name, price, category) fits this model exactly, as each attribute has a fixed data type and is stored in a relational database table.

Answer

Semi-structured data

Answer

Unstructured data

Answer

Transactional data

Question 4

A data engineering team is designing a modern data warehouse using Azure Synapse Analytics. They want to follow a lakehouse architecture where raw data is stored in its native format and then processed and curated for reporting. Which component in Azure Synapse Analytics is primarily used to store raw data in its original format without requiring a schema?

Accepted Answer

Data Lake Storage Gen2. Azure Data Lake Storage Gen2 (ADLS Gen2) is the correct component because it provides a scalable, hierarchical file system that can store raw data in any native format (e.g., CSV, JSON, Parquet) without requiring a predefined schema. This aligns with the lakehouse architecture's requirement to ingest and persist raw data as-is before any transformation or curation.

Answer

Dedicated SQL pool

Answer

Serverless SQL pool

Answer

Synapse Pipeline

Question 5

A financial application requires strict consistency and transaction support (ACID). Which Azure data service is most appropriate for storing its core transactional data?

Accepted Answer

Azure SQL Database. Azure SQL Database is a fully managed relational database service that provides full ACID (Atomicity, Consistency, Isolation, Durability) transaction support through its SQL Server engine. It is the correct choice for a financial application requiring strict consistency and transactional integrity, as it guarantees that all transactions are processed reliably and adhere to the ACID properties.

Answer

Azure Cosmos DB

Answer

Azure Table Storage

Answer

Azure Data Lake Storage

Question 6

A company uses Azure SQL Database for a sales application. They need to replicate the database to a secondary region for disaster recovery. The secondary should be readable for reporting purposes and data should be synchronized within seconds. Which feature should they use?

Accepted Answer

Active Geo-Replication. Active Geo-Replication is the correct choice because it creates a readable secondary replica in a different Azure region, with data synchronized within seconds via asynchronous replication. This meets the requirement for both disaster recovery and read-only reporting access, as the secondary can be queried directly without impacting the primary database.

Answer

Auto-failover groups

Answer

Point-in-time restore

Answer

Long-term retention

Question 7

Which TWO of the following Azure services are considered non-relational data stores?

Accepted Answer

Azure Cosmos DB. Options B and C are correct. Azure Cosmos DB (B) is a globally distributed, multi-model NoSQL database service, making it a non-relational data store. Azure Table Storage (C) is a key-value store that is also non-relational. Option A is wrong because Azure SQL Database is a relational database. Option D is wrong because Azure Synapse Analytics is a relational analytics system. Option E is wrong because Azure Database for PostgreSQL is a relational database.

Answer

Azure SQL Database

Answer

Azure Synapse Analytics

Answer

Azure Database for PostgreSQL

Question 8

A company needs to migrate 10 on-premises SQL Server databases (each 50–200 GB) to Azure. The databases frequently run cross-database queries using three-part names (e.g., DB1.dbo.table) and rely on SQL Server Agent for maintenance tasks. They want to minimize management overhead and share resources across databases to reduce costs. Which Azure SQL deployment option should they choose?

Accepted Answer

Azure SQL Managed Instance. Azure SQL Managed Instance is correct because it provides native support for cross-database queries using three-part names (e.g., DB1.dbo.table) and SQL Server Agent for maintenance tasks, which are critical requirements. It also offers a fully managed platform that minimizes management overhead while allowing resource sharing across databases within the instance, reducing costs compared to single databases or VMs.

Answer

Azure SQL Database elastic pool

Answer

SQL Server on Azure Virtual Machine

Answer

Azure SQL Database single database

Question 9

You need to store semi-structured JSON documents from a web application in Azure. The data will be accessed by a key/value lookup. Which Azure data store should you use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it natively supports semi-structured JSON documents and provides key/value lookup via its partition key mechanism. It offers single-digit millisecond latency for point reads, making it ideal for web application data that needs fast, scalable access by a unique key.

Answer

Azure Blob Storage

Answer

Azure Table Storage

Answer

Azure SQL Database

Question 10

A company uses Azure Data Factory to run a pipeline that copies new orders from an on-premises SQL Server database to Azure Data Lake Storage every hour. After the data is in the data lake, an Azure Databricks notebook transforms it and loads it into Azure Synapse Analytics for reporting. Which type of data processing does the hourly copy operation represent?

Accepted Answer

Batch processing. The hourly copy operation from on-premises SQL Server to Azure Data Lake Storage is a classic batch processing pattern: data is collected over a fixed time interval (1 hour) and processed as a single unit. Azure Data Factory orchestrates this scheduled, non-continuous transfer, which aligns with batch processing's definition of handling data in discrete, periodic chunks rather than in real-time.

Answer

Real-time streaming

Answer

Interactive query

Answer

Transactional processing

Question 11

A media company needs to store millions of high-resolution photos for a public website. Each photo can be up to 50 MB. The storage solution must support secure access via URLs. Which Azure service should they use?

Accepted Answer

Azure Blob Storage. Azure Blob Storage is the correct choice because it is designed for storing massive amounts of unstructured data, such as high-resolution photos, and supports objects up to 4.7 TB per blob, easily accommodating 50 MB files. It provides secure access via URLs using shared access signatures (SAS) or public access levels, making it ideal for a public website serving media content.

Answer

Azure Table Storage

Answer

Azure Files

Answer

Azure SQL Database

Question 12

A media company needs to store thousands of high-resolution videos. Each video is up to 10 GB in size and must be accessible via HTTP/HTTPS URLs for playback. The company does not require a file system hierarchy or SMB protocol support. Which Azure storage solution is most appropriate for this scenario?

Accepted Answer

Azure Blob Storage. Azure Blob Storage is designed for storing massive amounts of unstructured data, such as high-resolution videos, and provides HTTP/HTTPS access via URLs. It supports objects up to 4.77 TiB (or larger with premium block blobs), easily accommodating 10 GB files, and offers no file system hierarchy or SMB protocol, matching the company's requirements exactly.

Answer

Azure Files

Answer

Azure Queue Storage

Answer

Azure Table Storage

Question 13

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 14

Your company runs a global e-commerce platform that generates over 5 TB of clickstream data daily. The data is currently stored as raw CSV files in Azure Blob Storage. The data engineering team needs to transform this data into a star schema for business intelligence reporting. They want to use a serverless, code-first approach where they can write Python or SQL transformations. The transformed data should be stored in a format that optimizes query performance for Power BI. You also need to ensure that the solution can handle variable data volumes without manual scaling. Which Azure service should you use for the transformation?

Accepted Answer

Azure Databricks. Azure Databricks is the correct choice because it provides a serverless, code-first environment where data engineers can write Python or SQL transformations using Apache Spark. It can handle variable data volumes without manual scaling, and it can output transformed data in optimized formats like Parquet, which significantly improves query performance for Power BI. This aligns perfectly with the requirement for a serverless, code-first approach and star schema transformation.

Answer

Azure Stream Analytics

Answer

Azure Synapse Serverless SQL

Answer

Azure Data Factory

Question 15

Which TWO of the following are benefits of using Azure Table Storage over Azure Blob Storage for storing semi-structured data?

Accepted Answer

Supports querying by partition key and row key. Table Storage supports key-value access and automatic indexing of partition and row keys, making queries by key efficient. Blob Storage is for unstructured data and does not provide built-in key-based querying. Both have REST APIs. Blob Storage has higher throughput for large files.

Answer

Provides automatic indexing of all attributes

Answer

Supports REST API access

Answer

Offers higher throughput for large files