DP-900 Practice Test 44 — 15 Questions

Question 1

A retail chain needs to blend two data sources for a near real-time dashboard: daily batch files from store systems (CSV files on Azure Blob Storage updated once per day) and live web clickstream data from Azure Event Hubs. The dashboard must refresh every 5 minutes with combined data. Which combination of Azure services should be used to ingest and process both data types most efficiently?

Accepted Answer

C) Azure Synapse Pipelines + Azure Stream Analytics. Option C is correct because Azure Synapse Pipelines can orchestrate the daily batch CSV files from Azure Blob Storage, while Azure Stream Analytics processes the live web clickstream data from Azure Event Hubs in near real-time. Together, they enable a combined data pipeline that refreshes every 5 minutes, meeting the dashboard's latency requirement efficiently.

Answer

A) Azure Data Factory + Azure Analysis Services

Answer

B) Azure Stream Analytics + Power BI

Answer

D) Azure Databricks + Azure Data Lake Storage

Question 2

You need to choose a non-relational data store for a key-value workload where each item is identified by a partition key and row key. Which Azure service should you use?

Accepted Answer

Azure Table Storage. Azure Table Storage is a key-value store that uses partition key and row key. Option A is wrong because Cosmos DB can also do key-value but Table Storage is simpler. Option C is wrong because Blob Storage is for blobs. Option D is wrong because Files is for file shares.

Answer

Azure Blob Storage

Answer

Azure Files

Answer

Azure Cosmos DB

Question 3

Which THREE are benefits of using Azure Cosmos DB? (Choose three.)

Accepted Answer

Automatically indexes all data.. Cosmos DB offers guaranteed low-latency reads/writes, automatic indexing, and global distribution. Option A is wrong because Cosmos DB is a NoSQL database. Option D is wrong because Cosmos DB does not require a schema. Option E is wrong because storage is not unlimited; there are limits per container.

Answer

Supports SQL Server integration.

Answer

Requires a fixed schema for all documents.

Question 4

Which TWO are valid access tiers for Azure Blob Storage? (Choose two.)

Accepted Answer

Cool. Hot, Cool, and Archive are the three access tiers. Premium is a performance tier, not an access tier. Cold is not a standard tier.

Answer

Premium

Answer

Cold

Answer

Frozen

Question 5

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

Accepted Answer

Azure Cosmos DB. Options A and C are correct. Azure Cosmos DB is a NoSQL database (A), and Azure Table Storage is a key-value store (C). Option B is wrong because Azure SQL Database is relational. Option D is wrong because Azure Database for PostgreSQL is relational. Option E is wrong because Azure Synapse Analytics is a relational analytics system.

Answer

Azure SQL Database

Answer

Azure Synapse Analytics

Answer

Azure Database for PostgreSQL

Question 6

Your team needs to store JSON documents that require schema flexibility and global distribution. Which Azure data store should you choose?

Accepted Answer

Azure Cosmos DB. Option B is correct because Azure Cosmos DB is a globally distributed NoSQL database that natively supports JSON documents with flexible schema. Option A is wrong because Azure SQL Database is relational and enforces schema. Option C is wrong because Blob Storage stores unstructured data but does not provide a query interface for JSON documents. Option D is wrong because Table Storage is for key-value data, not document storage.

Answer

Azure Table Storage

Answer

Azure SQL Database

Answer

Azure Blob Storage

Question 7

A company stores sensor data in Azure Blob Storage. The data is appended every minute and rarely modified. The compliance team requires that blobs older than 90 days be moved to a more cost-effective storage tier, and blobs older than 365 days be deleted. Which solution should you recommend?

Accepted Answer

Configure a Blob Storage lifecycle management policy.. A lifecycle management policy can automatically transition blobs to cooler tiers (e.g., Cool after 90 days) and delete them after 365 days. Option B is wrong because Azure Files is for file shares. Option C is wrong because Blob Storage does not have a built-in backup retention policy for this scenario. Option D is wrong because Soft Delete is for recovery, not automated tiering or deletion.

Answer

Use Azure Backup to set a retention policy for the storage account.

Answer

Enable Blob Soft Delete and set retention days to 365.

Answer

Move the blobs to Azure Files and set a file retention policy.

Question 8

Refer to the exhibit. You are analyzing the configuration of an Azure Storage account. Which of the following is true about this account?

Accepted Answer

It supports Azure Data Lake Storage Gen2.. The property 'isHnsEnabled' is set to true, which enables the hierarchical namespace for Azure Data Lake Storage Gen2. Option A is wrong because the storage is not Blob Storage only; it's StorageV2 with HNS. Option C is wrong because the network ACLs have default action 'Deny' and no rules, so access is denied by default. Option D is wrong because the encryption key source is Microsoft.Storage, not Azure Key Vault.

Answer

It allows all network traffic by default.

Answer

Encryption uses Azure Key Vault.

Answer

It is a general-purpose v1 storage account.

Question 9

You are storing log files from multiple applications in Azure Blob Storage. Each log file is a text file with timestamp data. You need to query logs for a specific date range using SQL. Which Azure service can query these files directly?

Accepted Answer

Azure Synapse Serverless SQL. Option B is correct because Azure Synapse Serverless SQL can query text files in Blob Storage using OPENROWSET. Option A is wrong because Azure Stream Analytics is for real-time streaming, not batch query. Option C is wrong because Azure Analysis Services is for semantic models. Option D is wrong because Azure Data Lake Storage is storage, not query.

Answer

Azure Stream Analytics

Answer

Azure Data Lake Storage

Answer

Azure Analysis Services

Question 10

You need to store telemetry data from millions of devices. Each record includes a device ID, timestamp, and metric value. The data will be queried by device ID and time range. Which Azure data store is best suited for this scenario?

Accepted Answer

Azure Data Explorer. Azure Data Explorer (ADX) is optimized for time-series data and can ingest high volumes of telemetry, with fast queries on time ranges and device IDs. Azure Cosmos DB is good for real-time apps but less efficient for large-scale time-series analytics. Azure SQL Database is relational and may not scale as well. Azure Storage Queues are for messaging, not storage/query.

Answer

Azure SQL Database

Answer

Azure Storage Queues

Answer

Azure Cosmos DB

Question 11

You are analyzing a SQL script for an Azure Synapse Analytics dedicated SQL pool as shown in the exhibit. The table 'SensorData' will contain billions of rows. Which statement about the table design is correct?

Accepted Answer

The table uses a clustered columnstore index, which is ideal for large data warehousing tables. A hash distribution on DeviceID distributes rows across distributions based on the hash of DeviceID, which is good for large tables queried frequently by DeviceID. Clustered columnstore index is optimal for large tables in Synapse. Round-robin is for staging tables. Clustered index is for small tables. The table is not replicated because replication is for small dimension tables.

Answer

The table is replicated across all compute nodes

Answer

The table uses round-robin distribution

Answer

The table uses a heap structure

Question 12

Your company needs to store large amounts of data that will be accessed only a few times a year for compliance audits. The data must be retained for 7 years. Which Azure Blob Storage access tier should you choose?

Accepted Answer

Archive. Azure Blob Storage Archive tier is the most cost-effective for data that is rarely accessed and has a long retention period. Option A is wrong because Hot tier is for frequently accessed data. Option B is wrong because Cool tier is for infrequently accessed data but cheaper than Hot; however, Archive is even cheaper. Option D is wrong because Premium tier is for high-performance scenarios.

Answer

Cool

Answer

Premium

Answer

Hot

Question 13

You need to store log files from multiple virtual machines in a central location. Each log file is appended to continuously and can be up to 1 TB. The solution must support concurrent appends from many VMs and provide low-latency read access for real-time monitoring. Which Azure storage solution should you choose?

Accepted Answer

Azure Blob Storage with append blobs. Option A is correct because Azure Blob Storage (with append blobs) is designed for append-only logs, supports concurrent appends, and provides low-latency read access. Option B is wrong because Cosmos DB is not optimized for large append-only logs. Option C is wrong because Azure Files is a file share, not optimized for concurrent appends from many clients. Option D is wrong because Azure NetApp Files is expensive and overkill for log storage.

Answer

Azure Cosmos DB

Answer

Azure Files

Answer

Azure NetApp Files

Question 14

Refer to the exhibit. You deploy an Azure Cosmos DB account using this ARM template. Users in East US report that reads are slower than writes. What is the most likely cause?

Accepted Answer

The East US region is configured as a read region, but the client is connecting to the write endpoint in West US.. The exhibit shows that the write region (failoverPriority 0) is West US, and East US is a read region (failoverPriority 1). Users in East US are reading from the local region, but because the consistency level is Session, reads may not see the latest writes if the write is still propagating from West US. However, the question asks about slower reads than writes. The most likely cause is that read requests are being served from a different region than the user's location due to Cosmos DB's routing policy. But since East US is a read region, reads should be local. The exhibit does not show multi-region writes. The typical cause is that reads are not local; but in this case, East US is a read region, so reads should be local. Another possibility: the consistency level Session requires a session token, but that doesn't cause slowness. The exhibit does not specify multi-region writes. However, a common mistake is that if the account has only one write region, reads from other regions might be served from the write region if not configured properly. But the exhibit shows two regions, so reads should be local. Perhaps the issue is that the client is not using the correct endpoint. The most likely cause from the exhibit is that the account has only one write region (West US), and reads in East US are still going to West US due to client configuration. But the exhibit does not show client config. Another possibility: the default consistency level Session can cause slightly higher latency for reads that need to check the session token. However, the best answer is that the read requests are being routed to the write region because the client is not configured to use the local endpoint. But since the question is diagnostic, we'll go with a common issue: the client is using the write endpoint for reads. However, the options need to reflect plausible causes. Let's design options accordingly.

Answer

The consistency level is set to Session, which requires a round-trip to the write region for every read.

Answer

The failover priority for East US is 1, which means it is not enabled for reads.

Answer

The database account offer type is Standard, which limits throughput.

Question 15

Which TWO Azure services can be used to store non-relational data? (Choose two.)

Accepted Answer

Azure Cosmos DB. Option A (Azure Cosmos DB) is correct because it is a NoSQL database. Option D (Azure Table Storage) is correct because it is a key-value store (non-relational). Option B is wrong because Azure SQL Database is relational. Option C is wrong because Azure Database for MySQL is relational. Option E is wrong because Azure Synapse Analytics is a relational analytics service.

Answer

Azure SQL Database

Answer

Azure Synapse Analytics

Answer

Azure Database for MySQL