DP-900 Practice Test 34 — 15 Questions

Question 1

A data engineer needs to build a pipeline that runs every hour, copies new sales data from an on-premises SQL Server to Azure Data Lake Storage Gen2, transforms the data using PySpark, and then loads it into Azure Synapse Analytics dedicated SQL pool. Which Azure service should be used to orchestrate the entire pipeline?

Accepted Answer

Azure Data Factory. Azure Data Factory (ADF) is the correct choice because it is a cloud-based ETL and data integration service designed to orchestrate complex pipelines. It can copy data from on-premises SQL Server via a self-hosted integration runtime, trigger the pipeline on an hourly schedule, execute PySpark transformations in Azure Databricks or HDInsight, and load the results into Azure Synapse Analytics dedicated SQL pool—all within a single, managed orchestration workflow.

Answer

Azure Stream Analytics

Answer

Azure Logic Apps

Answer

Azure Databricks

Question 2

You are creating an Azure SQL Database and need to connect using Microsoft Entra ID authentication. Which user type must you create in the database to represent the authenticated Microsoft Entra ID identity?

Accepted Answer

Contained database user mapped to a Microsoft Entra ID identity. Option C is correct because a contained database user mapped to a Microsoft Entra ID identity is required. Option A is wrong because SQL authentication uses a SQL login. Option B is wrong because a database user without login is for SQL authentication. Option D is wrong because an external user is not a valid concept.

Answer

SQL login with password

Answer

External user from Microsoft Entra ID

Answer

Database user without login

Question 3

Refer to the exhibit. You are designing an Azure Table storage schema for user settings. The JSON shows a sample entity. Which query will retrieve all settings for user123 efficiently?

Accepted Answer

Filter by PartitionKey eq 'user123' and RowKey eq 'settings'. Option B is correct because using PartitionKey and RowKey together is a point query, which is the most efficient in Table storage. Option A is wrong because filtering only by PartitionKey scans the entire partition. Option C is wrong because filtering by RowKey without PartitionKey performs a full table scan. Option D is wrong because filtering by both properties with OR is inefficient.

Answer

Filter by RowKey eq 'settings'

Answer

Filter by PartitionKey eq 'user123'

Answer

Filter by PartitionKey eq 'user123' or RowKey eq 'settings'

Question 4

You need to provide temporary access to a specific blob in Azure Blob Storage for a limited time. The access should be time-limited and require no authentication from the user. Which mechanism should you use?

Accepted Answer

Shared access signatures (SAS). Shared access signatures (SAS) provide time-limited, delegated access to storage resources without requiring the account key. Storage account keys provide full access and never expire. RBAC is for identity-based access, not anonymous. Access keys are long-lived secrets.

Answer

Storage account keys

Answer

Anonymous public access

Answer

Azure RBAC roles

Question 5

You need to store JSON documents for a web application that requires low-latency reads and writes globally. The data has no fixed schema. Which Azure service should you use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a globally distributed, multi-model database that natively supports JSON documents with low-latency reads and writes. Option A is wrong because Azure Blob Storage is not optimized for low-latency document queries. Option B is wrong because Azure Table Storage is a key-value store, not ideal for complex JSON queries. Option D is wrong because Azure SQL Database is relational and requires a fixed schema.

Answer

Azure Table Storage

Answer

Azure Blob Storage

Answer

Azure SQL Database

Question 6

Refer to the exhibit. You are reviewing an ARM template snippet for an Azure storage account. You need to ensure that the storage account supports POSIX-like permissions for data lake workloads. Which property must be enabled?

Accepted Answer

"hierarchicalNamespace": {"enabled": true}. The exhibit shows that hierarchicalNamespace is enabled. This is required for Data Lake Storage Gen2, which supports POSIX ACLs. The question asks which property must be enabled; the answer is the hierarchical namespace. Option A is wrong because encryption key source is separate. Option C is wrong because data lake storage gen2 is not a property but the result. Option D is wrong because blob public access is unrelated.

Answer

"allowBlobPublicAccess": false

Answer

"kind": "DataLakeStorageGen2"

Answer

"keySource": "Microsoft.Storage"

Question 7

A healthcare organization uses Azure SQL Database to store patient records. To comply with HIPAA regulations, they need to encrypt sensitive columns (e.g., Social Security numbers) at rest and control access to the encryption keys. Which feature should they use?

Accepted Answer

Always Encrypted. Option A is correct because Always Encrypted with secure enclaves protects sensitive columns at rest and allows client-side key management. Option B is wrong because Transparent Data Encryption encrypts the entire database but does not allow column-level key control. Option C is wrong because Dynamic Data Masking obfuscates data but does not encrypt it. Option D is wrong because Row-Level Security restricts row access but does not encrypt columns.

Answer

Dynamic Data Masking

Answer

Row-Level Security

Answer

Transparent Data Encryption (TDE)

Question 8

You are designing a solution to store and analyze large volumes of streaming data from social media feeds. The data is semi-structured (JSON) and will be used for real-time dashboards. You need to choose a storage solution that can handle high-ingestion throughput and support querying with Azure Synapse Serverless SQL. Which storage option should you choose?

Accepted Answer

Azure Data Lake Storage Gen2. Option A is correct because Azure Data Lake Storage Gen2 (ADLS Gen2) is built on Blob Storage, supports high-throughput ingestion, and can be queried by Azure Synapse Serverless SQL. Option B is wrong because Azure Cosmos DB is optimized for transactional workloads, not analytical queries with Synapse Serverless SQL directly (though Synapse Link exists). Option C is wrong because Azure Table Storage is not designed for analytics. Option D is wrong because Azure Cache for Redis is an in-memory cache.

Answer

Azure Table Storage

Answer

Azure Cosmos DB

Answer

Azure Cache for Redis

Question 9

A company is designing a solution to store time-series data from millions of IoT devices. Which TWO Azure services are most suitable for this scenario?

Accepted Answer

Azure Data Explorer. Azure Cosmos DB (option B) is suitable for time-series data with its flexible schema and low latency. Azure Data Explorer (option D) is optimized for time-series analytics. Option A (Azure SQL Database) is relational and less efficient for high-volume time-series. Option C (Azure Blob Storage) is for unstructured data. Option E (Azure Redis Cache) is a cache, not primary storage.

Answer

Azure Blob Storage

Answer

Azure Redis Cache

Answer

Azure SQL Database

Question 10

A company stores customer data in Azure Table Storage. They need to query by a combination of partition key (customer region) and row key (customer ID). Which query pattern is most efficient?

Accepted Answer

Query using both PartitionKey and RowKey. Table Storage is optimized for point queries using both PartitionKey and RowKey. Using both keys allows direct access to the entity without scanning. Filtering only by RowKey across partitions results in a full table scan. Using only PartitionKey retrieves all rows in that partition, which is less efficient. Scanning all entities is the worst.

Answer

Query using RowKey only

Answer

Scan all entities

Answer

Query using PartitionKey only

Question 11

A company stores IoT sensor data in Azure Table Storage. The data is accessed frequently for the first 30 days, then rarely. You need to minimize storage costs while ensuring data is available for queries within 24 hours of a request. What should you implement?

Accepted Answer

Move data older than 30 days to Azure Blob Storage Cool tier and use an Azure Data Factory pipeline to copy data back to Table Storage when requested.. Azure Table Storage does not natively support lifecycle management policies like Blob Storage does. Moving the data to Azure Storage with lifecycle management (via Azure Data Factory or AzCopy) is the correct approach. Option A is wrong because Azure Table Storage does not have automatic tiering like Blob Storage. Option B is wrong because Azure Cosmos DB is more expensive and not necessary. Option D is wrong because Azure SQL Database is a relational option not suited for this scenario.

Answer

Configure a lifecycle management policy on the Table Storage account to move data to Cool tier after 30 days.

Answer

Store all data in Azure SQL Database and use index maintenance to improve query performance.

Answer

Migrate the data to Azure Cosmos DB and use Time-to-Live (TTL) to expire old data.

Question 12

Which TWO of the following are true about Azure Cosmos DB?

Accepted Answer

It guarantees single-digit millisecond latency for reads and writes at the 99th percentile.. Azure Cosmos DB is a globally distributed, multi-model database. Option A is correct: it supports multiple APIs including SQL, MongoDB, Cassandra, etc. Option D is correct: it offers guaranteed single-digit millisecond latency at the 99th percentile. Option B is wrong because Cosmos DB does not support the relational model natively; it uses non-relational models. Option C is wrong because Cosmos DB uses provisioned throughput (RU/s), not DTUs. Option E is wrong because the default consistency level is Session, not Strong.

Answer

The default consistency level is Strong.

Answer

It uses DTUs to measure performance.

Answer

It is a relational database management system.

Question 13

A company is building a modern data warehouse on Azure using a lakehouse approach. Arrange the following steps in the correct order to implement a typical pipeline that starts with raw data ingestion and ends with business reporting.

Accepted Answer

Ingest raw data from various sources into Azure Data Lake Storage Gen2. The lakehouse pipeline starts with raw data ingestion, followed by transformation and loading into a curated layer, then creating tables for querying, and finally reporting with Power BI.

Question 14

A company stores backup files in Azure Blob Storage. The backups are taken daily and must be retained for 7 years. The backup files are rarely accessed after the first month. The company wants to minimize storage costs while ensuring that backups are available for retrieval within 5 hours when needed. Which storage tier should they use after the first month?

Accepted Answer

Cool tier. Option C is correct because the Cool tier has a retrieval time of minutes to hours (typically), and is cheaper than Hot. Archive tier is the cheapest but retrieval time can be up to 15 hours, which exceeds the 5-hour requirement. Option A is wrong because Hot is more expensive. Option B is wrong because Archive retrieval time is too long. Option D is wrong because Premium is expensive and designed for low-latency access.

Answer

Archive tier

Answer

Hot tier

Answer

Premium tier

Question 15

A company needs to store large amounts of unstructured data (videos and images) for a media streaming application. The data must be accessible via HTTP/HTTPS and support tiered storage for cost optimization. Which Azure storage solution should they choose?

Accepted Answer

Azure Blob Storage. Azure Blob Storage is designed for unstructured data, supports HTTP access, and offers hot, cool, and archive tiers. Option A (Azure Files) is for file shares; Option B (Azure Disk Storage) is for VM disks; Option D (Azure Table Storage) is for NoSQL key-value data.

Answer

Azure Disk Storage

Answer

Azure Table Storage

Answer

Azure Files