DP-900 Practice Test 19 — 15 Questions

Question 1

Drag and drop the steps to load data into Azure Synapse Analytics using PolyBase in the correct order.

Accepted Answer

Create external data source, then external file format, then external table, then use CTAS.. PolyBase loading involves defining external data source, file format, external table, then using CTAS to move data into the warehouse.

Answer

Create external file format, then external data source, then external table, then use CTAS.

Answer

Create external table, then external data source, then external file format, then use CTAS.

Answer

Use CTAS, then create external data source, then external file format, then external table.

Question 2

Drag and drop the steps to configure a geo-replication for Azure Cosmos DB in the correct order.

Accepted Answer

Step 1: Navigate to the Azure Cosmos DB account. Step 2: Under Settings, click 'Replicate data globally'. Step 3: Select the regions you want to add. Step 4: Enable multi-region writes (if desired). Step 5: Click Save.. Geo-replication is configured by selecting regions and enabling multi-region writes if needed, then saving to initiate replication.

Answer

Step 1: Navigate to the Azure Cosmos DB account. Step 2: Under Settings, click 'Replicate data globally'. Step 3: Enable multi-region writes (if desired). Step 4: Select the regions you want to add. Step 5: Click Save.

Answer

Step 1: Navigate to the Azure Cosmos DB account. Step 2: Enable multi-region writes (if desired). Step 3: Under Settings, click 'Replicate data globally'. Step 4: Select the regions you want to add. Step 5: Click Save.

Answer

Step 1: Navigate to the Azure Cosmos DB account. Step 2: Under Settings, click 'Replicate data globally'. Step 3: Select the regions you want to add. Step 4: Click Save. Step 5: Enable multi-region writes (if desired).

Question 3

Your organization uses Azure Purview to scan data sources. You need to set up a scan rule set that automatically classifies credit card numbers in Azure SQL Database. Which built-in classification rule should you enable?

Accepted Answer

Enable the 'Credit Card Number' classification.. Azure Purview includes a built-in 'Credit Card Number' classification rule that uses a predefined regular expression pattern to detect credit card numbers in data sources like Azure SQL Database. Enabling this rule automatically classifies the data without requiring custom development, aligning with the requirement to use a built-in classification.

Answer

Use a regular expression pattern matching.

Answer

Create a custom classification rule.

Answer

Enable the 'Personally Identifiable Information (PII)' classification.

Question 4

Refer to the exhibit. A data engineer needs to query the orders.csv file using Azure Synapse Serverless SQL. What is the most efficient way to access this data?

Accepted Answer

Use OPENROWSET in Serverless SQL. Azure Synapse Serverless SQL is designed for on-demand querying of data stored in data lakes without provisioning storage. The OPENROWSET function with the BULK option allows direct querying of CSV files using T-SQL, making it the most efficient method for ad-hoc analysis of the orders.csv file without data movement or schema management.

Answer

Use PolyBase to create external table

Answer

Copy data to Azure SQL Database using ADF

Answer

Load data into a dedicated SQL pool

Question 5

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

Accepted Answer

Cool. Options A (Cool) and E (Hot) are correct. Azure Blob Storage offers Hot, Cool, and Archive tiers for general-purpose v2 accounts. Option B (Frozen) and Option D (Cold) are not valid tier names. Option C (Standard) is an account type, not a tier.

Answer

Frozen

Answer

Standard

Answer

Cold

Question 6

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. Enabling the Azure Cosmos DB integrated cache caches frequently accessed data in memory, reducing the need to repeat queries against the backend and thus lowering RU consumption without changing application code. Option A is incorrect: switching to the Cassandra API does not inherently reduce RU consumption; it changes the data model and query interface. Option B is incorrect: while a composite index can improve query performance, it may increase RU consumption for writes and does not directly address read-heavy throttling. Option D is incorrect: increasing provisioned RU/s increases throughput capacity but does not reduce consumption; it may even encourage more usage and higher costs.

Answer

Switch to the Cassandra API

Answer

Create a composite index on frequently queried fields

Answer

Increase the provisioned RU/s

Question 7

A company stores customer data in a relational table with columns CustomerID, FullName, and Email. They also store product descriptions as JSON documents with varying fields, and product images as JPEG files. Which of the following correctly classifies these data types from most structured to least structured?

Accepted Answer

Structured, semi-structured, unstructured. The customer data in a relational table with fixed columns (CustomerID, FullName, Email) is structured because it has a rigid schema and defined data types. The JSON documents for product descriptions are semi-structured because they use key-value pairs with flexible fields but still have metadata (tags, keys) that provide organization. The JPEG product images are unstructured because they are binary blobs with no inherent schema or metadata that the database can query directly. This ordering from most to least structured matches option A.

Answer

Unstructured, semi-structured, structured

Answer

Semi-structured, structured, unstructured

Answer

Structured, unstructured, semi-structured

Question 8

A company needs to store JSON documents that require flexible schema and low-latency access globally. Which Azure data service should they use?

Accepted Answer

Azure Cosmos DB. Azure Cosmos DB is the correct choice because it is a globally distributed, multi-model database service that natively supports JSON documents with flexible schema. It offers turnkey global distribution, single-digit-millisecond latency at the 99th percentile, and multiple consistency models, making it ideal for low-latency access worldwide.

Answer

Azure Table Storage

Answer

Azure SQL Database

Answer

Azure Blob Storage

Question 9

A data analyst needs to create interactive dashboards that display real-time data from Azure SQL Database. Which Microsoft tool should they use?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for creating interactive dashboards and reports, and it supports real-time data connectivity to Azure SQL Database through DirectQuery or streaming datasets. This allows the data analyst to visualize live data without manual refreshes, meeting the requirement for real-time dashboards.

Answer

Microsoft Excel

Answer

Microsoft Copilot

Answer

Azure Data Studio

Question 10

Your company wants to use Microsoft Fabric to create a unified analytics platform. Which component in Microsoft Fabric provides a lake-centric, collaborative, and governed data foundation?

Accepted Answer

OneLake. OneLake is the correct answer because it is the single, unified, lake-centric data foundation in Microsoft Fabric. It provides a multi-cloud, SaaS-based data lake that is automatically provisioned for every Fabric tenant, enabling collaborative and governed access to data without data duplication, while supporting open formats like Delta Parquet.

Answer

Power BI

Answer

Data Factory

Answer

Synapse Data Engineering

Question 11

A retail company stores product inventory data in a fixed-schema table with columns for ProductID, ProductName, QuantityInStock, and ReorderLevel. How should this data be classified?

Accepted Answer

Structured data. This data is classified as structured data because it conforms to a fixed schema with clearly defined columns (ProductID, ProductName, QuantityInStock, ReorderLevel) and data types, stored in a relational table. Structured data is highly organized, easily queryable via SQL, and follows a rigid schema, which matches the description of the inventory table.

Answer

Semi-structured data

Answer

Unstructured data

Answer

Streaming data

Question 12

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 correct because this configuration supports Azure Data Lake Storage Gen2. Option B is wrong because the network ACLs have default action 'Deny' and no rules, so access is denied by default. Option C is wrong because the encryption key source is Microsoft.Storage, not Azure Key Vault. Option D is wrong because the account kind is StorageV2, not general-purpose v1.

Answer

It allows all network traffic by default.

Answer

Encryption uses Azure Key Vault.

Answer

It is a general-purpose v1 storage account.

Question 13

A startup is migrating its on-premises SQL Server database to Azure. They want the least administrative overhead for patching and backups. Which Azure data service should they choose?

Accepted Answer

Azure SQL Database. Azure SQL Database is a fully managed platform-as-a-service (PaaS) that automates patching, backups, and high availability. Option A is wrong because Azure Database for PostgreSQL is a different database engine, not SQL Server. Option B is wrong because SQL Server on Azure Virtual Machines (IaaS) requires manual patching and backup management. Option D is wrong because Azure Cosmos DB is a NoSQL database, not relational.

Answer

Azure Database for PostgreSQL

Answer

SQL Server on Azure Virtual Machines

Answer

Azure Cosmos DB

Question 14

A multinational corporation is deploying a global application using Azure SQL Database. They need to ensure that users in different geographic regions experience low latency reads. The application can tolerate slightly stale data for reads, but writes must be strongly consistent and must occur in a single primary region. Which feature should they implement?

Accepted Answer

Active geo-replication. Active geo-replication (Option B) creates readable secondary databases in other Azure regions. Reads can be directed to the secondary for low latency, while writes always go to the primary and are strongly consistent. This matches the requirement for globally distributed users with low-latency reads and strong consistency for writes. Option A (Azure Cosmos DB with multi-master) is a NoSQL solution, not relational. Option C (Failover groups) manages geo-replication and provides automatic failover, but it still relies on active geo-replication to create the readable secondaries; it does not directly enable low-latency reads. Option D (Read scale-out) uses local read-only replicas within the same region, not globally.

Answer

Azure Cosmos DB with multi-master

Answer

Failover groups

Answer

Read scale-out

Question 15

A social media company stores user posts as JSON documents in Azure Cosmos DB. Each post may have a different number of fields and nested objects. Which type of data model does this represent?

Accepted Answer

Document. The scenario describes user posts stored as JSON documents with varying fields and nested objects. Azure Cosmos DB's Document data model (using the SQL API or MongoDB API) is designed for semi-structured, schema-agnostic data where each document can have a different structure, making it the correct choice.

Answer

Key-value

Answer

Column-family

Answer

Graph