DP-900 Practice Exam 52 — 20 Questions

Question 1

A company has both transactional and analytical workloads on the same SQL Server database. They want to move to Azure and separate these workloads to improve performance. They need a solution that supports both workloads without duplicating data. What should they do?

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

Accepted Answer

Use Azure Synapse Link for SQL to replicate data in near real-time to an analytical store.. Azure Synapse Link for SQL enables near real-time replication of transactional data from Azure SQL Database to Synapse Analytics for analytical queries without ETL and without duplicating data. Option A is wrong because Azure Data Factory does not provide real-time replication and would require data duplication. Option C is wrong because using Azure SQL Database and SQL Data Warehouse separately with periodic data copy duplicates data. Option D is wrong because using Azure SQL Database for both workloads does not separate workloads.

Answer

Use Azure Data Factory to move data between two Azure SQL Databases.

Answer

Use Azure SQL Database for transactions and Azure SQL Data Warehouse for analytics, with periodic data copy.

Answer

Use Azure SQL Database for both workloads.

Question 2

A company uses Azure SQL Database with active geo-replication for disaster recovery. During a regional outage, the secondary database is promoted. After the primary region recovers, what is the best practice to re-establish geo-replication?

Accepted Answer

Perform a planned failover to make the old primary the primary again. Performing a planned failover properly fails back to the original primary and re-establishes geo-replication. Option A is wrong because deleting the old primary loses data and is unnecessary. Option B is wrong because while you can add the old primary as a secondary, it is not the best practice; a planned failover is preferred. Option C is wrong because automatic reversal of geo-replication direction is not supported; you must manually reconfigure.

Answer

Delete the old primary database and create a new geo-replication

Answer

Add the old primary as a secondary to the new primary

Answer

Reverse the geo-replication direction automatically

Question 3

A mobile gaming company is building a new feature that stores player profiles and game settings as key-value pairs. The development team is most familiar with SQL queries and wants to minimize the learning curve. They require low-latency reads and writes, and the data does not require complex joins. Which Azure Cosmos DB API should they choose?

Accepted Answer

A. Core (SQL) API. The Core (SQL) API is the correct choice because it provides native support for SQL queries, which aligns with the development team's familiarity with SQL and minimizes the learning curve. It stores data in JSON documents with key-value pairs, supports low-latency reads and writes, and does not require complex joins, making it ideal for player profiles and game settings.

Answer

B. Azure Cosmos DB for Table API

Answer

C. Azure Cosmos DB for MongoDB API

Answer

D. Azure Cosmos DB for Cassandra API

Question 4

A social media company stores user posts in Azure Cosmos DB. Each post document contains fields like postId, userId, content, timestamp, and an array of comments. The comments array can grow large (hundreds per post), and the application frequently retrieves a post without its comments to display in a feed. To optimize read performance and minimize request units (RU) consumption, which data modeling approach should the company adopt?

Accepted Answer

B. Store comments as separate documents and reference them from the post document via a comments array of IDs.. Storing comments as separate documents and referencing them via an array of IDs in the post document allows the application to retrieve the post without comments in a single point read, consuming minimal request units (RUs). This avoids loading the large comments array when only the post metadata is needed for the feed, significantly reducing RU consumption and improving read performance in Azure Cosmos DB.

Answer

A. Store comments in a separate container to isolate the data.

Answer

C. Use a vertical partition within the same document to separate the comments array.

Answer

D. Migrate the data to Azure SQL Database to use normalized tables and indexes.

Question 5

Your organization has a large dataset of customer transactions stored in Azure Blob Storage as CSV files. You need to run ad-hoc SQL queries on this data without loading it into a database. Which Azure service should you use?

Accepted Answer

Azure Synapse Serverless SQL pool. Azure Synapse Serverless SQL pool allows you to query data directly from files in Azure Blob Storage using standard T-SQL syntax, without needing to load or move the data into a database. It uses a pay-per-query model and supports CSV, Parquet, and JSON formats, making it ideal for ad-hoc analytical queries over large datasets stored in data lakes.

Answer

Azure Data Factory

Answer

Azure SQL Database

Answer

Azure Analysis Services

Question 6

A company stores sensitive customer data in Azure Blob Storage. They need to ensure that data at rest is encrypted using a customer-managed key that is stored in Azure Key Vault. Additionally, they want to prevent data from being accessed by unauthorized users even if the storage account key is compromised. Which combination should they use?

Accepted Answer

Enable customer-managed keys and use Azure Defender for Storage. Customer-managed keys (CMK) stored in Azure Key Vault allow you to control and revoke the encryption key, thereby preventing decryption of data at rest even if the storage account key is compromised. Azure Defender for Storage provides threat detection and can trigger alerts or automated responses (e.g., revoking the key) to stop unauthorized access. Together, CMK gives you control over encryption and Defender enables detection and response, effectively preventing unauthorized access. Options B, C, and D do not provide either encryption control or security monitoring necessary to meet the requirements.

Answer

Enable customer-managed keys and use Azure Monitor

Answer

Enable infrastructure encryption and use Azure Backup

Answer

Enable storage account encryption and use Azure Sentinel

Question 7

A company wants to analyze customer feedback from surveys and social media. The data includes both structured (ratings) and unstructured (comments) text. They plan to use Azure Cognitive Services for sentiment analysis. Which service should they use for text analytics?

Accepted Answer

Azure AI Language. Azure AI Language (formerly part of Azure Cognitive Services) provides pre-built text analytics capabilities, including sentiment analysis, key phrase extraction, and language detection. This service is specifically designed to process unstructured text data like survey comments and social media posts, making it the correct choice for analyzing customer feedback.

Answer

Azure Synapse Analytics

Answer

Azure Cosmos DB

Answer

Azure Machine Learning

Question 8

A retail company processes petabytes of sales transaction data stored in Azure Data Lake Storage Gen2. They need to run recurring complex queries that involve large joins and aggregations. The queries must consistently complete within a fixed time window overnight. The company wants predictable performance and costs. Which Azure service should they use?

Accepted Answer

Azure Synapse Analytics Dedicated SQL pool. Azure Synapse Analytics Dedicated SQL pool provides reserved, fixed compute resources that ensure predictable performance and cost for recurring complex queries involving large joins and aggregations. It is designed for petabyte-scale data warehousing workloads with consistent SLAs, making it ideal for overnight batch processing within a fixed time window.

Answer

Azure Synapse Analytics Serverless SQL pool

Answer

Azure SQL Database

Answer

Azure Analysis Services

Question 9

Refer to the exhibit. You are configuring a custom role in Azure RBAC for a team that needs to read and list blobs in a storage account. The JSON snippet shows the permissions assigned. After assigning this role to a user, they report they cannot see the storage account in the Azure portal. What is the most likely cause?

Accepted Answer

The role does not include read permission on the storage account resource.. The custom role definition only includes dataActions for reading and listing blobs, but lacks any actions that grant read permission on the storage account resource itself. In Azure RBAC, viewing a storage account in the Azure portal requires the 'Microsoft.Storage/storageAccounts/read' action at the resource scope. Without this, the user cannot see the storage account in the portal, even though they can interact with blobs via APIs or tools that bypass the portal.

Answer

The dataActions should be actions instead of dataActions.

Answer

The role is not assigned at the subscription scope.

Answer

The user needs the Contributor role to view the storage account.

Question 10

A media company stores user profile images in Azure Blob Storage. Regulators require that the images cannot be deleted or overwritten for a period of 90 days after upload. Which Azure Blob Storage feature should the company enable to meet this requirement?

Accepted Answer

B: Immutable storage with a time-based retention policy. Immutable storage with a time-based retention policy (also known as WORM – Write Once, Read Many) prevents blobs from being deleted or overwritten for a specified retention interval. By setting a 90-day policy, the company ensures that user profile images remain unmodifiable and undeletable during that period, directly satisfying the regulatory requirement.

Answer

A: Soft delete

Answer

C: Access tiers (Hot, Cool, Archive)

Answer

D: Lifecycle management rules

Question 11

A travel booking application stores booking data in Azure Cosmos DB using the NoSQL API. Each booking document contains: BookingID (unique), UserID, Destination, TravelDate, Price. The most common query is: 'Retrieve all bookings for a specific UserID, sorted by TravelDate descending.' To minimize Request Unit (RU) consumption, which property should be chosen as the partition key?

Accepted Answer

UserID. UserID is the correct partition key because the most common query filters on UserID, and Cosmos DB routes queries to the exact physical partition(s) containing that UserID's data. This minimizes cross-partition fan-out, reducing RU consumption. A partition key should align with the primary query filter to enable efficient point-read or single-partition query execution.

Answer

BookingID

Answer

Destination

Answer

TravelDate

Question 12

You have applied the lifecycle management policy shown in the exhibit to an Azure Storage account. A blob named 'logs/error.log' was last modified 200 days ago. In which tier is the blob currently stored?

Accepted Answer

Archive tier. The policy moves blobs to Cool after 30 days and to Archive after 90 days. Since the blob was modified 200 days ago, it has already been moved to Archive after 90 days. The delete action occurs after 365 days, so it has not been deleted yet. Therefore, the blob is in the Archive tier.

Answer

Hot tier

Answer

The blob has been deleted

Answer

Cool tier

Question 13

A company stores customer support chat transcripts as plain text files in Azure Blob Storage. The files are accessed frequently for the first 30 days, then infrequently for the next 2 years, and after that must be retained for 7 years for compliance but are rarely accessed. The company wants to minimize storage costs by automatically moving data through appropriate access tiers. Which Azure Blob Storage lifecycle management policy should they implement?

Accepted Answer

Move blobs from Hot to Cool after 30 days, then to Archive after 2 years. The lifecycle management policy matches the access pattern: move blobs from Hot (frequent access for first 30 days) to Cool (infrequent access for next 2 years) after 30 days, then to Archive (rare access for 7-year compliance) after 2 years. This minimizes storage costs by using the cheapest tier for each phase while retaining data for the required 7-year compliance period.

Answer

Store all data in Hot tier for the full retention period

Answer

Move blobs from Hot to Archive after 30 days and delete after 2 years

Answer

Store all data in Cool tier for the first 30 days, then move to Archive

Question 14

A global social media application allows users to post updates and 'like' posts. The application is designed to prioritize availability and partition tolerance over strong consistency. As a result, when a user likes a post, the like count may not be immediately visible to all users, but it will eventually become consistent across all regions. Which consistency model does this application follow?

Accepted Answer

Eventual consistency. The application prioritizes availability and partition tolerance, which aligns with the eventual consistency model. In this model, updates (like a 'like' count) are propagated asynchronously across replicas, and while reads may return stale data temporarily, all replicas will converge to the same value over time. This is typical of NoSQL systems like Apache Cassandra or Amazon DynamoDB when configured with eventual consistency.

Answer

Strong consistency

Answer

Consistent prefix

Answer

Bounded staleness

Question 15

A mobile app stores user preferences as JSON documents in Azure Cosmos DB. The document includes userId, theme, language, and notification settings. The most common query retrieves the document for a specific userId. To minimize cost and ensure even distribution, which property should be chosen as the partition key?

Accepted Answer

userId. The userId property is the ideal partition key because it provides high cardinality (each user has a unique ID) and ensures even request distribution across physical partitions. Since the most common query retrieves a document by userId, using it as the partition key makes those queries point reads (single-partition queries), which are the most cost-efficient and fastest in Azure Cosmos DB.

Answer

theme

Answer

language

Answer

a concatenation of userId and language

Question 16

A retail company analyzes customer purchase patterns. Every night, they run a batch job that aggregates millions of transactions from the past day into summary tables for reporting. Which type of data processing workload best describes this nightly job?

Accepted Answer

Batch processing. This nightly job processes a large volume of transactions accumulated over the past day in a single, scheduled run, which is the defining characteristic of batch processing. In Azure, this workload would typically be implemented using Azure Synapse Analytics or Azure Data Factory to orchestrate the aggregation of millions of rows into summary tables for reporting, without requiring immediate output.

Answer

Real-time processing

Answer

Streaming processing

Answer

Transactional processing

Question 17

A gaming company stores player game scores in Azure Cosmos DB. Each document contains PlayerID, GameID, Score, Timestamp. The most common query is: 'Get all scores for a specific game ordered by score descending'. Which partition key should be chosen to minimize Request Unit (RU) consumption?

Accepted Answer

GameID. GameID is the correct partition key because the most common query filters on GameID, and Cosmos DB routes queries to the exact physical partition(s) containing that GameID. This avoids cross-partition fan-out, minimizing RU consumption. A partition key that matches the query filter ensures efficient index lookup and data retrieval.

Answer

PlayerID

Answer

Score

Answer

Timestamp

Question 18

Your company has a data lake in Azure Data Lake Storage Gen2 containing terabytes of parquet files. Data scientists need to explore and prepare this data using Python and SQL. They want to use a collaborative notebook environment that integrates with Git for version control. The solution should automatically scale compute resources based on workload demand and minimize management overhead. Which Azure service should you use?

Accepted Answer

Azure Databricks. Azure Databricks is the correct choice because it provides a collaborative notebook environment that natively supports Python and SQL, integrates with Git for version control, and offers auto-scaling clusters that dynamically adjust compute resources based on workload demand. It is purpose-built for big data analytics and data preparation on data lakes, minimizing management overhead through its serverless and managed Spark infrastructure.

Answer

Azure Machine Learning studio

Answer

Azure Data Studio

Answer

Azure Synapse Studio

Question 19

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.. It addresses the requirement to minimize costs by moving older data to Azure Blob Storage Cool tier, which is cheaper, while still allowing access within 24 hours via an Azure Data Factory pipeline to copy data back to Table Storage on demand. Option A is incorrect because Azure Table Storage does not support automatic lifecycle management policies like Blob Storage does. Option B is incorrect because Azure SQL Database is a relational database and not optimized for IoT sensor data; it would be more expensive and complex. Option C is incorrect because Azure Cosmos DB is generally more expensive than Table Storage and using TTL would delete data permanently, not provide a way to restore it within 24 hours.

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 20

A data analyst needs to create interactive reports from data stored in an Azure SQL Database. They want to use a self-service tool that requires minimal IT support. Which tool should they use?

Accepted Answer

Power BI Desktop. Power BI Desktop is a self-service business intelligence tool designed for creating interactive reports and dashboards with minimal IT support. It connects directly to Azure SQL Database, allowing analysts to import or query data using DirectQuery, and provides drag-and-drop visualizations without requiring database administration skills.

Answer

Azure Synapse Studio

Answer

SQL Server Management Studio

Answer

Azure Data Studio