DP-900 Practice Test 23 — 15 Questions

Question 1

Match each data type to its category in Azure.

Question 2

Match each Azure Cosmos DB API to its supported data model.

Question 3

A company uses Azure SQL Database for a sales application. They need to replicate the database to a secondary region for disaster recovery. The secondary should be readable for reporting purposes and data should be synchronized within seconds. Which feature should they use?

Accepted Answer

Active Geo-Replication. Active Geo-Replication is the correct choice because it creates a readable secondary replica in a different Azure region, with data synchronized within seconds via asynchronous replication. This meets the requirement for both disaster recovery and read-only reporting access, as the secondary can be queried directly without impacting the primary database.

Answer

Auto-failover groups

Answer

Point-in-time restore

Answer

Long-term retention

Question 4

A global social media app uses Azure Cosmos DB (NoSQL API) to store user profile data. The app is read-heavy and requires the fastest possible read performance worldwide. The data is updated by users and eventual consistency is acceptable because immediate consistency is not critical for profile views. Which consistency level should they choose to minimize read latency?

Accepted Answer

Eventual. Eventual consistency offers the lowest read latency because it allows reads from any replica without waiting for confirmation that the data is the most recent version. Since the app is read-heavy and eventual consistency is acceptable, this consistency level minimizes latency by not requiring any synchronization or staleness bounds.

Answer

Strong

Answer

Bounded staleness

Answer

Session

Question 5

A SaaS provider hosts databases for hundreds of clients, each with light and sporadic usage. They notice that using separate single databases with provisioned DTUs is cost-inefficient. They need to consolidate the databases while optimizing cost and ensuring that a busy client does not monopolize resources. Which Azure SQL Database option should they use?

Accepted Answer

Elastic pool. An Azure SQL Database elastic pool is designed to optimize cost for multiple databases with light and sporadic usage by sharing a fixed set of resources (eDTUs) across all databases in the pool. This prevents a busy client from monopolizing resources through per-database resource limits (min and max DTU), ensuring performance isolation while consolidating costs.

Answer

Single database with provisioned DTU

Answer

Managed Instance

Answer

SQL Server on Azure VM

Question 6

A company stores large archives of legal documents in Azure Blob Storage. The documents must remain immutable; they cannot be modified or deleted for 7 years due to regulatory requirements. The data is accessed only for compliance audits, which occur less than once a year. The company wants to minimize storage costs while ensuring immutability and data durability. Which combination of features should they configure?

Accepted Answer

Archive access tier with a time-based retention policy. The Archive access tier provides the lowest storage cost for data that is rarely accessed, such as legal documents accessed less than once a year. A time-based retention policy enforces immutability for a fixed 7-year period, preventing modifications or deletions. This combination meets regulatory requirements while minimizing storage costs.

Answer

Cool access tier with a time-based retention policy

Answer

Hot access tier with versioning enabled

Answer

Archive access tier with legal hold

Question 7

A globally distributed online auction platform uses a replicated database system across multiple Azure regions. The system must continue accepting bids (writes) even if a network partition occurs between regions, because auctions cannot be interrupted. The business decides that during a partition, some users might see slightly outdated item prices (read inconsistency) but all bids must be recorded. According to the CAP theorem, which two properties is this system prioritizing?

Accepted Answer

Availability (A) and Partition Tolerance (P). The system must continue accepting bids (writes) even during a network partition, which means it prioritizes Availability (A) — every request receives a response, even if it's not the most recent data. It also must function across multiple Azure regions that can become disconnected, which requires Partition Tolerance (P) — the system continues to operate despite network splits. The trade-off is that Consistency (C) is sacrificed, as users may see slightly outdated item prices during a partition. This is a classic AP (Availability and Partition Tolerance) choice from the CAP theorem.

Answer

Consistency (C) and Partition Tolerance (P)

Answer

Consistency (C) and Availability (A)

Question 8

A data engineer needs to implement a solution that provides near real-time analytics on clickstream data. The data arrives as JSON events and must be queryable with sub-second latency using SQL-like queries. The solution should minimize operational overhead. Which Azure service should they use?

Accepted Answer

Azure Data Explorer. Azure Data Explorer (ADX) is designed for interactive analytics on large volumes of streaming and historical data with sub-second query latency using Kusto Query Language (KQL), which supports SQL-like syntax. It natively ingests JSON events, provides near real-time analytics, and minimizes operational overhead as a fully managed, serverless service.

Answer

Azure Stream Analytics

Answer

Azure Analysis Services

Answer

Azure Synapse Analytics

Question 9

A company is designing a data solution for their e-commerce platform. They need to store product catalogs with varying attributes, support high-throughput read/write operations, and ensure low-latency access globally. Which Azure data store is most appropriate?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the most appropriate choice because it is a globally distributed, multi-model database service that supports schema-agnostic storage of product catalogs with varying attributes. It offers guaranteed single-digit-millisecond latency for reads and writes at any scale, and its turnkey global distribution enables low-latency access from multiple regions, meeting the e-commerce platform's high-throughput and global requirements.

Answer

Azure SQL Database

Answer

Azure Redis Cache

Answer

Azure Data Lake Storage

Question 10

Refer to the exhibit. You are reviewing an ARM template for an Azure SQL Database deployment. The database must support a read-only workload that requires low latency. The current configuration uses General Purpose tier with 4 vCores. What is the most significant performance improvement you can make without changing the tier?

Accepted Answer

Enable read scale-out by adding 'readScale' property. Enabling read scale-out by adding the 'readScale' property allows the database to use a read-only replica, offloading read workloads from the primary and providing low-latency reads. This is the most significant performance improvement within the General Purpose tier because it directly addresses the read-only workload requirement without changing the tier or incurring additional compute costs.

Answer

Increase maxSizeBytes to 1 TB

Answer

Set the edition to 'Serverless'

Answer

Change requestedBackupStorageRedundancy to 'Local'

Question 11

You are designing a data solution for a healthcare application that requires ACID transactions for patient records and needs to run complex analytics queries. Which combination of Azure services should you recommend?

Accepted Answer

Azure SQL Database for transactions, Azure Synapse Analytics for analytics. Azure SQL Database provides full ACID (Atomicity, Consistency, Isolation, Durability) transaction support, which is essential for healthcare patient records where data integrity is critical. Azure Synapse Analytics is a cloud-based analytics service that can run complex queries against large datasets, including those from Azure SQL Database, using its massively parallel processing (MPP) architecture. This combination allows transactional and analytical workloads to coexist without compromising performance or consistency.

Answer

Azure Cosmos DB for transactions, Power BI for analytics

Answer

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

Answer

Azure Blob Storage for transactions, Azure Machine Learning for analytics

Question 12

Which TWO of the following are valid Azure data storage services for storing unstructured data?

Accepted Answer

Azure Blob Storage. Azure Blob Storage is a fully managed, massively scalable object storage service designed for unstructured data such as text, binary data, images, videos, and backups. It supports REST-based access and can store any type of file or binary object without requiring a schema, making it a core service for unstructured data workloads.

Answer

Azure SQL Database

Answer

Azure Table Storage

Answer

Azure Cosmos DB

Question 13

Refer to the exhibit. The JSON shows an Azure Policy definition. Which effect should be used to proactively prevent creation of storage accounts without encryption?

Accepted Answer

Deny. The 'Deny' effect is correct because it proactively blocks the creation or update of a storage account that does not meet the encryption requirement, preventing non-compliant resources from being provisioned. This aligns with Azure Policy's ability to enforce compliance at resource creation time, rather than auditing or remediating after the fact.

Answer

AuditIfNotExists

Answer

Disabled

Answer

Append

Question 14

A company wants to provide self-service analytics to business users who need to create reports and dashboards from data in Azure Synapse Analytics. Which tool should you recommend?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for self-service analytics, enabling business users to create interactive reports and dashboards from data stored in Azure Synapse Analytics. Power BI connects directly to Synapse via its built-in connector, allowing users to build visualizations without writing code or relying on IT. This aligns with the requirement for business users to perform ad-hoc analysis and reporting.

Answer

Microsoft Excel

Answer

Azure Synapse Studio

Answer

Azure Data Studio

Question 15

You need to choose a data store for a mobile app that requires real-time synchronization of user preferences across devices. The data is small per user and key-value oriented. Which Azure service is most appropriate?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the most appropriate choice because it provides global distribution, low-latency reads and writes, and automatic conflict resolution, which are essential for real-time synchronization of user preferences across devices. Its key-value API (e.g., Table API or Core SQL API with a simple partition key) efficiently handles small, per-user data with a key-value orientation, ensuring that changes made on one device are quickly reflected on others.

Answer

Azure Cache for Redis

Answer

Azure Blob Storage

Answer

Azure SQL Database