Updated Mar 08, 2026 Certification Exam DP-900 Dumps – Practice Test Questions [Q98-Q116]

08Mar 2026 by admin No Comments

4/5 - (2 votes)

Updated Mar 08, 2026 Certification Exam DP-900 Dumps – Practice Test Questions

Updated Verified DP-900 dumps Q&As – Pass Guarantee or Full Refund

Microsoft DP-900 certification exam is a great way to showcase your skills and knowledge in data-related concepts and technologies on the Azure platform, and to validate your expertise to potential employers. By earning this certification, you can demonstrate your proficiency in using Azure data services to store, process, and analyze data, which can help you stand out in a competitive job market and advance your career in data analytics or database administration.

The DP-900 certification exam is designed to test the candidate’s knowledge of various Azure data services, including Azure SQL Database, Azure Cosmos DB, Azure Data Factory, Azure Stream Analytics, and Azure Blob Storage. It also covers topics such as data security, data privacy, and compliance. DP-900 exam is intended for individuals who have a basic understanding of data concepts and are looking to gain a deeper understanding of Azure data services and technologies.

NEW QUESTION 98
Match the Azure services to appropriate requirements.
To answer, drag the appropriate services from the column on the left to its requirement on the right. Each service may be used once. more than once, or not at all.
NOTE: Each correct match is worth one point.

NEW QUESTION 99
To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-workload-management

NEW QUESTION 100
You have a SQL query that combines customer data and order data. The query includes calculated columns.
You need to persist the SQL query so that other users can use the query.
What should you create?

an index

a view

a scalar function

a table

Section: Describe core data concepts
Explanation:
A view is a virtual table whose contents are defined by a query. A view acts as a filter on the underlying tables referenced in the view. The query that defines the view can be from one or more tables or from other views in the current or other databases.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/views/views

NEW QUESTION 101
To complete the sentence, select the appropriate option in the answer area.

Explanation:

Azure Cosmos DB SQL API accounts provide support for querying items using the Structured Query Language (SQL) syntax.
Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/choose-api

NEW QUESTION 102
Hotspot Question
To complete the sentence, select the appropriate option in the answer area.

Explanation:
Box 1: simple lookups
A key/value store associates each data value with a unique key. Most key/value stores only support simple query, insert, and delete operations. To modify a value (either partially or completely), an application must overwrite the existing data for the entire value. In most implementations, reading or writing a single value is an atomic operation.
An application can store arbitrary data as a set of values. Any schema information must be provided by the application. The key/value store simply retrieves or stores the value by key.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store- overview

NEW QUESTION 103
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE:Each correct selection is worth one point.

Explanation
Graphical user interface, text, application Description automatically generated

Box 1: No
You can duplicate a dashboard. The duplicate ends up in the same Power BI workspace.
There is no current functionality that allows you to move reports from one workspace to another.
Box 2: No
Box 3: Yes

NEW QUESTION 104
A bank has a system that manages financial transactions.
When transferring money between accounts, the system must never retrieve a value for the source account that reflects the balance before the transfer and a value for the destination account that reflects the balance after the transfer.
Of which ACID semantic is this an example?

atomicity

isolation

durability

consistency

Isolation. See course material:
o concurrent transactions cannot interfere with one another, and must result in a consistent database state.
o For example, while the transaction to transfer funds from one account to another is in-process, another transaction that checks the balance of these accounts must return consistent results – the balance-checking transaction can’t retrieve a value for one account that reflects the balance before the transfer, and a value for the other account that reflects the balance after the transfer.

NEW QUESTION 105
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview

NEW QUESTION 106
match the Azure data factory components to the appropriate descriptions.
To answer, drag the appropriate component from the column on the left to its description on the right. Each component may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.

Explanation:

Box 1: Dataset
Datasets must be created from paths in Azure datastores or public web URLs, for the data to be accessible by Azure Machine Learning.
Box 2: Linked service
Linked services are much like connection strings, which define the connection information needed for Data Factory to connect to external resources.
Box 3: Pipeline
A pipeline is a logical grouping of activities that together perform a task.

NEW QUESTION 107
Hotspot Question
To complete the sentence, select the appropriate option in the answer area.

Explanation:
https://docs.microsoft.com/en-us/azure/cosmos-db/create-graph-gremlin-console

NEW QUESTION 108
To complete the sentence, select the appropriate option in the answer area.

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-namespace

NEW QUESTION 109
A team of developers has computers that run Windows 10 and Ubuntu Desktop.
The developers need to connect to and query an Azure SQL database from each of their computers.
The developers require code assistance features such as IntelliSense.
What should the developers use?

sqlcmd

Azure Data Explorer

Azure Data Studio

Microsoft SQL Server Management Studio (SSMS)

NEW QUESTION 110
You have an application that runs on Windows and requires access to a mapped drive.
Which Azure service should you use?

Azure Files

Azure Blob storage

Azure Cosmos DB

Azure Table storage

Explanation
Azure Files is Microsoft’s easy-to-use cloud file system. Azure file shares can be seamlessly used in Windows and Windows Server.
To use an Azure file share with Windows, you must either mount it, which means assigning it a drive letter or mount point path, or access it via its UNC path.

NEW QUESTION 111
For each of the following statements, select yes if the statement is true, Otherwise, select No.
Note: Each correct selection is worth one point.

Explanation:
YES, NO, YES Normalizing decreases throughput for reading (need to make joins), but increases for writing (Less to write, since there are no duplicates)

NEW QUESTION 112
To complement the sentence, select the appropriate option in the answer area.

NEW QUESTION 113
To complete the sentence, select the appropriate option in the answer area.

Explanation

Note: The data warehouse workload encompasses:
* The entire process of loading data into the warehouse
* Performing data warehouse analysis and reporting
* Managing data in the data warehouse
* Exporting data from the data warehouse

NEW QUESTION 114
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/azure/databricks/data/data-sources/sql-databases-azure
https://docs.microsoft.com/en-us/azure/databricks/scenarios/databricks-stream-from-eventhubs

NEW QUESTION 115
Select the answer that correctly completes the sentence.