DP-900 Practice Test 31 — 15 Questions

Question 1

A healthcare organization stores patient records in Azure Blob Storage and must comply with data retention policies that require deleting records after 7 years. They also need to prevent any modification or deletion of records before the retention period ends. Which Azure feature should they use?

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

Accepted Answer

Immutable storage with time-based retention policy. Immutable storage with a time-based retention policy (WORM – Write Once, Read Many) ensures that blobs cannot be modified or deleted until the retention period expires. This directly meets the dual requirement of preventing premature deletion while enforcing a 7-year retention, as the policy locks the data for the specified duration.

Answer

Azure Backup for Blob Storage

Answer

Soft delete for Blob Storage

Answer

Azure Blob Storage lifecycle management

Question 2

Refer to the exhibit. You are analyzing a Kusto query in Azure Data Explorer. The query is intended to return the top 5 event types that caused the most property damage in Florida. However, the query returns an error. What is the most likely cause?

Accepted Answer

The table or column names are incorrect.. The query returns an error because the table or column names referenced in the query do not match the actual schema in Azure Data Explorer. In Kusto Query Language (KQL), if a table name like 'Events' or a column like 'PropertyDamage' does not exist in the database, the query will fail with a 'semantic error' indicating an unknown table or column. This is the most likely cause given that the query logic (where, summarize, top) is syntactically correct.

Answer

The where clause must specify a numeric value.

Answer

The summarize operator cannot use sum aggregation.

Answer

The top operator requires an order by clause.

Question 3

A company wants to provide self-service analytics to business users, allowing them to create reports and dashboards from data stored in Azure Data Lake Storage. Which tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool because it provides self-service analytics capabilities, allowing business users to connect to data stored in Azure Data Lake Storage, create interactive reports and dashboards, and share insights without requiring deep technical skills. Options A, B, and D are incorrect: Azure Synapse Studio is a big data and data warehousing tool, not designed for self-service business user dashboard creation; Azure Machine Learning studio is for building, training, and deploying machine learning models, not for creating reports; Azure Data Studio is a database management and query tool, not a reporting tool.

Answer

Azure Synapse Studio

Answer

Azure Machine Learning studio

Answer

Azure Data Studio

Question 4

You design a data solution for an e-commerce platform. Transactional data must be stored with ACID compliance for order processing, while clickstream data from the website will be used for analytics. Which combination of Azure data services best meets these needs?

Accepted Answer

Azure SQL Database for transactions; Azure Synapse Analytics for analytics. Azure SQL Database provides full ACID compliance for transactional workloads like order processing, ensuring data integrity. Azure Synapse Analytics is optimized for large-scale analytics on clickstream data, offering massively parallel processing (MPP) and integration with data lakes. This combination separates OLTP and OLAP workloads efficiently.

Answer

Azure Cosmos DB for transactions; Azure SQL Database for analytics

Answer

Azure Blob Storage for transactions; Azure Data Lake Storage for analytics

Answer

Azure Database for MySQL for transactions; Azure Analysis Services for analytics

Question 5

A company uses Azure Stream Analytics to process IoT data from thousands of devices. The output is written to Azure SQL Database for reporting. Recently, the job latency increased significantly. The company suspects that the SQL Database is throttling writes. Which action should the company take to reduce latency?

Accepted Answer

Switch the output to Azure Cosmos DB with sufficient RU/s and use change feed to sync to SQL Database.. The latency is caused by Azure SQL Database throttling writes due to its row-based storage and limited write throughput. By switching the output to Azure Cosmos DB with sufficient Request Units per second (RU/s), the Stream Analytics job can write at high speed without throttling, and the change feed can then asynchronously sync data to Azure SQL Database for reporting, decoupling the write bottleneck.

Answer

Change the input serialization from JSON to Avro.

Answer

Increase the batch size of writes to Azure SQL Database.

Answer

Increase the number of Streaming Units for the Stream Analytics job.

Question 6

The exhibit shows a KQL query in Azure Data Explorer. What is the output of this query?

Accepted Answer

Top 5 states by total property damage. The KQL query uses `summarize` to aggregate total property damage by state, then `top 5 by total_property_damage` to return the five states with the highest total damage. The `desc` argument (default) orders the results in descending order, making option B correct.

Answer

Bottom 5 states by total property damage

Answer

All states with total property damage

Answer

All storm events after 2024-01-01

Question 7

A multinational corporation needs to store archival data for 10 years with the lowest possible storage cost, while still being able to retrieve it within 24 hours if needed. Which Azure storage tier should they use?

Accepted Answer

Archive Blob Storage. Archive Blob Storage is the correct choice because it is designed for long-term retention of data that is rarely accessed, offering the lowest storage cost among Azure blob tiers. The 10-year retention requirement and 24-hour retrieval window align perfectly with Archive's capabilities, as data can be rehydrated to a hot or cool tier within hours (typically up to 15 hours for standard priority rehydration).

Answer

Cool Blob Storage

Answer

Premium Blob Storage

Answer

Hot Blob Storage

Question 8

A startup is building a web application with a relational database backend. They expect variable traffic and want to minimize costs by scaling the database automatically based on demand. Which Azure service should they use?

Accepted Answer

Azure SQL Database serverless. Azure SQL Database serverless is the correct choice because it automatically scales compute resources based on demand and pauses the database during idle periods, charging only for storage and minimal compute. This aligns with the startup's need for variable traffic and cost minimization, as it eliminates the need to provision for peak capacity manually.

Answer

Azure SQL Managed Instance

Answer

SQL Server on Azure Virtual Machines

Answer

Azure Database for MariaDB

Question 9

Refer to the exhibit. You are deploying an Azure Storage account. The JSON snippet represents a template parameter. What does the 'isHnsEnabled' property enable?

Accepted Answer

Hierarchical namespace for the storage account. The 'isHnsEnabled' property enables the hierarchical namespace for the storage account, which is a core feature of Azure Data Lake Storage Gen2. When set to true, it allows the storage account to organize blobs into a directory hierarchy, enabling POSIX-like access control lists (ACLs) and file system semantics. This is essential for big data analytics workloads that require a file system structure rather than a flat blob storage model.

Answer

Blob versioning

Answer

Soft delete for blobs

Answer

Geo-redundant storage

Question 10

A company is designing a data solution for a retail application. The solution must support real-time analytics on streaming sales data, and also provide historical reports for business intelligence. Which TWO data processing models should be combined to meet these requirements?

Accepted Answer

Batch processing. Batch processing (B) is correct because it is used to process large volumes of historical sales data at scheduled intervals, enabling the generation of comprehensive business intelligence reports. Stream processing (E) is correct because it handles real-time data ingestion and analytics on streaming sales data, allowing the application to react instantly to sales events. Combining these two models (often called a Lambda architecture) meets both the real-time and historical reporting requirements.

Answer

Distributed processing

Answer

Data lake storage

Answer

Transactional database

Question 11

A company uses Azure SQL Database with geo-replication for disaster recovery. During a regional outage, they manually failover to the secondary region. After the primary region is restored, they need to re-establish geo-replication with minimal downtime. What should they do?

Accepted Answer

Initiate a planned failover to switch back to the original region. After a manual failover to the secondary region, the original primary becomes a secondary database. To re-establish geo-replication with minimal downtime, you should initiate a planned failover (also called a graceful failover) to switch back to the original region. This operation reverses the roles without data loss and avoids the need to reseed the database, keeping downtime to seconds.

Answer

Drop the secondary database and create a new one

Answer

Delete the geo-replication link and create a new one

Answer

Manually swap the roles of the primary and secondary

Question 12

A marketing team needs to analyze customer sentiment from social media posts in real time. The solution must ingest a stream of tweets, perform sentiment analysis using a pre-built AI model, and store the results in a dashboard for immediate visualization. The team has limited coding experience and prefers a low-code/no-code approach. Which combination of Azure services should you recommend?

Accepted Answer

Azure Event Hubs, Azure Stream Analytics, and Power BI. Azure Event Hubs ingests the real-time tweet stream, Azure Stream Analytics performs sentiment analysis using its built-in machine learning functions (a low-code/no-code approach), and Power BI provides the dashboard for immediate visualization. This combination meets the real-time, low-code requirement without custom coding.

Answer

Azure Event Hubs, Azure Functions, and Azure Cosmos DB

Answer

Azure IoT Hub, Azure Data Factory, and Power BI

Answer

Azure Event Hubs, Azure HDInsight, and Power BI

Question 13

Your company is implementing a data governance solution using Microsoft Purview. The data catalog must automatically scan and classify sensitive data in Azure SQL Database, Azure Synapse Analytics, and Amazon S3. The company uses Microsoft Entra ID for identity management. You need to ensure that the Purview managed identity can authenticate to these data sources. Which authentication method should you configure for the Amazon S3 connection?

Accepted Answer

AWS IAM authentication. Amazon S3 is an external cloud storage service that does not support Microsoft Entra ID, SQL Authentication, or Windows Authentication. To authenticate Purview's managed identity to S3, you must configure AWS IAM authentication, which allows Purview to assume an IAM role with permissions to read the S3 bucket metadata and data for scanning and classification.

Answer

SQL Authentication

Answer

Windows Authentication

Answer

Microsoft Entra ID authentication

Question 14

A financial services company needs to run ad-hoc SQL queries on petabytes of data stored in Azure Data Lake Storage without provisioning a dedicated data warehouse. Which Azure service should they use?

Accepted Answer

Azure Synapse Analytics serverless SQL pool. Azure Synapse Analytics serverless SQL pool is the correct choice because it allows you to run ad-hoc SQL queries directly against data in Azure Data Lake Storage without provisioning any dedicated compute resources. It uses a pay-per-query model, automatically scaling compute to handle petabytes of data, making it ideal for intermittent, exploratory workloads.

Answer

Azure Analysis Services

Answer

Azure SQL Database

Answer

Azure Data Lake Storage

Question 15

A company needs to migrate a large on-premises SQL Server database to Azure. The migration must have minimal downtime and support ongoing replication. Which Azure service should they use?

Accepted Answer

Azure Database Migration Service. Azure Database Migration Service (DMS) is designed for online migrations with minimal downtime, supporting ongoing replication from SQL Server to Azure SQL Database. It uses the Data Migration Assistant (DMA) for assessment and the Azure DMS for continuous sync, enabling near-zero downtime during cutover.

Answer

Azure Data Box

Answer

Azure Data Factory

Answer

Azure SQL Database