DP-900 Practice Test 33 — 15 Questions

Question 1

A startup is building a mobile app that requires offline data synchronization. The app needs to store user-generated content locally on the device and sync with Azure when connectivity is available. Which Azure service should they use for the cloud backend?

Accepted Answer

Azure Cosmos DB. Option B is correct because Azure Cosmos DB, combined with offline data sync (via Mobile Apps SDK), provides offline capabilities. Option A is wrong because Azure Blob Storage does not have built-in offline sync for mobile apps. Option C is wrong because Azure SQL Database is relational and not the best for offline sync scenarios. Option D is wrong because Azure Table Storage lacks robust offline sync support.

Answer

Azure Blob Storage

Answer

Azure SQL Database

Answer

Azure Table Storage

Question 2

A company uses Azure Cosmos DB with the SQL API. They need to implement a data partitioning strategy to optimize query performance and avoid hot partitions. Which THREE practices should they follow?

Accepted Answer

Use a synthetic partition key if natural keys are not suitable. Choosing a high-cardinality partition key (option A) distributes data evenly. Using a synthetic partition key (option C) can combine multiple attributes for better distribution. Avoiding monotonically increasing keys (option D) prevents hot partitions. Option B (using the same partition key for all items) is incorrect for large datasets. Option E (keeping partition key values very small) is not a primary consideration.

Answer

Use the same partition key for all items

Answer

Keep partition key values as small as possible

Question 3

A retail company uses Azure Cosmos DB to store product catalog data. They experience high request unit (RU) consumption during peak hours, leading to throttling. Which action should they take to reduce RU consumption without changing the application code?

Accepted Answer

Enable the Azure Cosmos DB integrated cache. Option D is correct because enabling Cosmos DB caching (Azure Cosmos DB integrated cache) reduces RU consumption by serving repeated queries from cache. Option A is wrong because increasing RU/s would raise costs and not reduce consumption. Option B is wrong because creating a secondary index would increase RU consumption for writes. Option C is wrong because switching to Cassandra API may not reduce RU consumption.

Answer

Switch to the Cassandra API

Answer

Create a composite index on frequently queried fields

Answer

Increase the provisioned RU/s

Question 4

Refer to the exhibit. You have a CSV file stored in Azure Blob Storage. You want to query this file using Azure Synapse Serverless SQL. Which OPENROWSET option should you use?

Accepted Answer

FORMAT = 'CSV'. Option D is correct because FORMAT = 'CSV' specifies the file format for CSV files. Option A is wrong because FORMAT = 'JSON' is for JSON files. Option B is wrong because FORMAT = 'PARQUET' is for Parquet files. Option C is wrong because FORMAT = 'DELTA' is for Delta Lake.

Answer

FORMAT = 'JSON'

Answer

FORMAT = 'PARQUET'

Answer

FORMAT = 'DELTA'

Question 5

A data analyst needs to query large datasets stored as Parquet files in Azure Data Lake Storage Gen2. The queries are ad-hoc and infrequent. The analyst wants to run SQL queries directly on the data without creating any storage or compute infrastructure, and only pay for the amount of data processed. They also need to create T-SQL views to simplify queries for Power BI reports. Which Azure service should they use?

Accepted Answer

Azure Synapse Serverless SQL pool. Azure Synapse Serverless SQL pool is the correct choice because it allows querying data directly from Azure Data Lake Storage Gen2 using T-SQL without provisioning any compute or storage infrastructure. It supports ad-hoc, infrequent queries with a pay-per-query pricing model based on the amount of data processed, and it enables the creation of T-SQL views that can be used directly by Power BI for reporting.

Answer

Azure SQL Database

Answer

Azure HDInsight with Spark

Answer

Azure Databricks

Question 6

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

Question 7

Your application stores millions of small log entries in Azure Table Storage. Queries by partition key and row key are fast, but you also need to query by timestamp across partitions. The query performance is slow. What is the best way to improve query performance?

Accepted Answer

Create a new table with the timestamp as the partition key and copy data there for time-based queries.. Creating a separate table with timestamp as the partition key allows efficient range queries across all data. Option A is wrong because indexing options in Table Storage are limited. Option B is wrong because Cosmos DB is more expensive and may not be necessary. Option D is wrong because a secondary index is not supported in Table Storage.

Answer

Migrate the data to Azure Cosmos DB and use the SQL API.

Answer

Use Azure Cognitive Search to index the Table Storage data.

Answer

Add a secondary index on the timestamp column.

Question 8

Which THREE factors should you consider when choosing between Azure Blob Storage and Azure Cosmos DB for a new application? (Choose three.)

Accepted Answer

Global distribution and multi-region writes. Option A (Data structure) is correct because Blob Storage stores unstructured blobs, while Cosmos DB stores structured documents. Option C (Query requirements) is correct because Cosmos DB supports complex queries, while Blob Storage does not. Option E (Global distribution) is correct because Cosmos DB offers multi-region writes, while Blob Storage does not. Option B is wrong because both services are highly scalable. Option D is wrong because both support encryption at rest.

Answer

Encryption at rest support

Answer

Scalability limits

Question 9

Your application uses Azure Table storage to store user preferences. You need to retrieve all preferences for a specific user quickly. Which key should you use as the partition key?

Accepted Answer

UserID. Option A is correct because using UserID as partition key ensures all data for a user is stored in one partition, enabling fast point queries. Option B is wrong because Timestamp as partition key would scatter user data. Option C is wrong because Region may not group user data. Option D is wrong because random GUID would scatter data.

Answer

Region

Answer

Random GUID

Answer

Timestamp

Question 10

You are designing a solution to store JSON documents from a web application. Each document is about 10 KB and must be queried by a unique ID. Which Azure data store is most appropriate?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is a NoSQL database that natively supports JSON documents and provides low-latency queries by ID. Azure Blob Storage stores blobs but is not optimized for querying by document ID. Azure SQL Database is relational and requires schema. Azure Table Storage is key-value but less feature-rich for JSON documents.

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Blob Storage

Question 11

Which TWO of the following are features of Azure Cosmos DB that help ensure high availability?

Accepted Answer

Automatic failover. Cosmos DB supports multi-region writes and automatic failover for high availability. Point-in-time restore and change feed are features but not directly for high availability.

Answer

Data encryption at rest

Answer

Change feed

Answer

Point-in-time restore

Question 12

You are designing a solution to store customer preferences as key-value pairs. The data will be accessed frequently and must support high availability across multiple Azure regions. The solution should minimize management overhead. Which Azure service should you use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB provides global distribution, high availability, and low-latency access for key-value data with minimal management. Option A is wrong because Azure Cache for Redis is a cache, not a durable store. Option C is wrong because Azure SQL Database is relational and overkill. Option D is wrong because Azure Storage Queue is for messaging.

Answer

Azure SQL Database

Answer

Azure Cache for Redis

Answer

Azure Queue Storage

Question 13

You are designing a solution to store large binary files (up to 100 GB each) that are frequently read but rarely updated. The data must be accessible via HTTPS and support concurrent reads. Which Azure data store should you use?

Accepted Answer

Azure Blob Storage. Option B is correct because Azure Blob Storage supports large blobs (up to 190.7 TiB) and is optimized for read-heavy workloads with HTTPS access and concurrent reads. Option A is wrong because Azure Files has a maximum file size of 4 TiB and is designed for file shares, not large binary blobs. Option C is wrong because Cosmos DB is for NoSQL transactional data, not large binary files. Option D is wrong because Azure NetApp Files is for high-performance file workloads, but more complex and expensive for simple blob storage.

Answer

Azure Files

Answer

Azure Cosmos DB

Answer

Azure NetApp Files

Question 14

Which TWO storage tiers are available in Azure Blob Storage for general-purpose v2 storage accounts? (Choose two.)

Accepted Answer

Cool. Option A (Hot) is correct and Option D (Cool) is correct. Archive is a tier but not listed here; Premium is a separate account type. Option B is wrong because there is no 'Cold' tier. Option C is wrong because 'Frozen' is not a tier. Option E is wrong because 'Standard' is not a tier name (it's an account type).

Answer

Frozen

Answer

Standard

Answer

Cold

Question 15

A company needs to ensure that their Azure SQL Database is accessible only from a specific virtual network and deny access from public endpoints. Which feature should they configure?

Accepted Answer

Virtual network service endpoints and firewall rules. Option C is correct because virtual network service endpoints and firewall rules allow restricting access to a specific VNet. Option A is wrong because Private Link provides private connectivity but is more complex. Option B is wrong because Azure SQL Database always has a public endpoint by default; disabling it without Private Link would block all access. Option D is wrong because IP firewall rules allow public IPs, not VNet-specific.

Answer

Disable public network access

Answer

IP firewall rules

Answer

Azure Private Link