DP-900 Mock Test Free – 50 Realistic Questions to Prepare with Confidence.
Getting ready for your DP-900 certification exam? Start your preparation the smart way with our DP-900 Mock Test Free – a carefully crafted set of 50 realistic, exam-style questions to help you practice effectively and boost your confidence.
Using a mock test free for DP-900 exam is one of the best ways to:
Familiarize yourself with the actual exam format and question style
Identify areas where you need more review
Strengthen your time management and test-taking strategy
Below, you will find 50 free questions from our DP-900 Mock Test Free resource. These questions are structured to reflect the real exam’s difficulty and content areas, helping you assess your readiness accurately.
HOTSPOT -
Select the answer that correctly completes the sentence.
Hot Area:
Suggested Answer:
A Power BI dashboard is a single page, often called a canvas, that tells a story through visualizations. Because it’s limited to one page, a well-designed dashboard contains only the highlights of that story. Readers can view related reports for the details.
Reference: https://docs.microsoft.com/en-us/power-bi/create-reports/service-dashboards
HOTSPOT
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
DRAG DROP
-
Match the cloud service model to the appropriate Azure relational database service.
To answer, drag the appropriate cloud service model from the column on the left to its service on the right. Each model may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
DRAG DROP -
Your company plans to load data from a customer relationship management (CRM) system to a data warehouse by using an extract, load, and transform (ELT) process.
Where does data processing occur for each stage of the ELT process? To answer, drag the appropriate locations to the correct stages. Each location may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Suggested Answer:
Box 1: The CRM system –
Data is extracted from the CRM system.
Box 2: The data warehouse –
Data is loaded to the data warehouse.
Box 3: A standalone data analysis tool
The data transformation that takes place usually involves various operations, such as filtering, sorting, aggregating, joining data, cleaning data, deduplicating, and validating data.
Reference: alt=”Reference Image” />
Reference: https://docs.microsoft.com/en-us/azure/architecture/data-guide/relational-data/etl
Your company is designing a database that will contain session data for a website. The data will include notifications, personalization attributes, and products that are added to a shopping cart.
Which type of data store will provide the lowest latency to retrieve the data?
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
You need to perform hybrid transactional and analytical processing (HTAP) queries against Azure Cosmos DB data sources by using Azure Synapse Analytics.
What should you use?
DRAG DROP -
Match the types of workloads to the appropriate scenarios.
To answer, drag the appropriate workload type from the column on the left to its scenario on the right. Each workload type may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
Suggested Answer:
Box 1: Batch –
The batch processing model requires a set of data that is collected over time while the stream processing model requires data to be fed into an analytics tool, often in micro-batches, and in real-time.
The batch Processing model handles a large batch of data while the Stream processing model handles individual records or micro-batches of few records.
In Batch Processing, it processes over all or most of the data but in Stream Processing, it processes over data on a rolling window or most recent record.
Box 2: Batch –
Box 3: Streaming –
Reference: https://k21academy.com/microsoft-azure/dp-200/batch-processing-vs-stream-processing
DRAG DROP
-
Match the job roles to the appropriate tasks.
To answer, drag the appropriate role from the column on the left to its task on the right. Each role may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
DRAG DROP -
Match the tools to the appropriate descriptions.
To answer, drag the appropriate tool from the column on the left to its description on the right. Each tool may be used once, more than once, or not at all.
Select and Place:
Suggested Answer:
Box 1: Microsoft SQL Server Management Studio (SSMS)
SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database.
Box 2: Azure Data Studio –
Azure Data Studio offers a modern, keyboard-focused SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience.
Box 3: Microsoft SQL Server Data Tools (SSDT)
SQL Server Data Tools (SSDT) is a modern development tool for building SQL Server relational databases, databases in Azure SQL, Analysis Services (AS) data models, Integration Services (IS) packages, and Reporting Services (RS) reports. With SSDT, you can design and deploy any SQL Server content type with the same ease as you would develop an application in Visual Studio.
Reference: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms https://code.visualstudio.com/docs/supporting/FAQ https://docs.microsoft.com/en-us/sql/azure-data-studio/what-is-azure-data-studio https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
Which property of a transactional workload guarantees that each transaction is treated as a single unit that either succeeds completely or fails completely?
A. atomicity
B. isolation
C. durability
D. consistency
Suggested Answer: A
The purpose of making transactions atomic is to prevent different transactions from interfering with one another. This can only happen if more than one user process is trying to access the database at the same time, as when a server allows several clients to use it concurrently. The simplest way to enforce atomicity is for the DBMS to refuse to start any transaction until the previous one has committed.
Reference: https://www.sciencedirect.com/topics/computer-science/atomic-transaction
You need to recommend a non-relational data store that is optimized for storing and retrieving text files, videos, audio streams, and virtual disk images. The data store must store data, some metadata, and a unique ID for each file.
Which type of data store should you recommend?
A. key/value
B. columnar
C. object
D. document
Suggested Answer: C
Object storage is optimized for storing and retrieving large binary objects (images, files, video and audio streams, large application data objects and documents, virtual machine disk images). Large data files are also popularly used in this model, for example, delimiter file (CSV), parquet, and ORC. Object stores can manage extremely large amounts of unstructured data.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
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?
A graph database stores two types of information, nodes and edges. Edges specify relationships between nodes. Nodes and edges can have properties that provide information about that node or edge, similar to columns in a table. Edges can also have a direction indicating the nature of the relationship.
Reference: https://docs.microsoft.com/en-us/azure/architecture/guide/technology-choices/data-store-overview
What are three characteristics of an Online Transaction Processing (OLTP) workload? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. denormalized data
B. heavy writes and moderate reads
C. light writes and heavy reads
D. schema defined in a database
E. schema defined when reading unstructured data from a database
HOTSPOT
-
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Which statement is an example of Data Definition Language (DDL)?
A. SELECT
B. INSERT
C. DELETE
D. DROP
Suggested Answer: D
Data Definition Language (DDL) statements defines data structures. Use these statements to create, alter, or drop data structures in a database. These statements include:
✑ ALTER
✑ Collations
✑ CREATE
✑ DROP
✑ DISABLE TRIGGER
✑ ENABLE TRIGGER
✑ RENAME
✑ UPDATE STATISTICS
✑ TRUNCATE TABLE
✑ UPDATE
Reference: https://docs.microsoft.com/en-us/sql/t-sql/statements/statements
DRAG DROP -
Match the processes to the appropriate scenarios.
To answer, drag the appropriate process from the column on the left to its scenario on the right. Each process may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
HOTSPOT -
To complete the sentence, select the appropriate option in the answer area.
Hot Area:
Suggested Answer:
Disadvantages of non-relational databases include: Data Consistency ג€” non-relational databases do not perform ACID transactions.
Note: Relational databases are optimized for writes. They are optimized for consistency and availability. Advantages of relational databases include simplicity, ease of data retrieval, data integrity, and flexibility.
Incorrect Answers:
Use a relational database when data that you work with is structured, and the structure is not subject to frequent changes.
Use Cloud storage (no relational database) for geographically distributed writes.
Reference: https://towardsdatascience.com/choosing-the-right-database-c45cd3a28f77
DRAG DROP
-
Match the Azure Data Lake Storage Gen 2 terms to the appropriate levels in the hierarchy.
To answer, drag the appropriate term from the column on the left to its level on the right. Each term may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
What are two characteristics of real-time data processing? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: No –
The API determines the type of account to create. Azure Cosmos DB provides five APIs: Core (SQL) and MongoDB for document data, Gremlin for graph data,
Azure Table, and Cassandra. Currently, you must create a separate account for each API.
Box 2: Yes –
Azure Cosmos DB uses partitioning to scale individual containers in a database to meet the performance needs of your application. In partitioning, the items in a container are divided into distinct subsets called logical partitions. Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
Box 3: No –
Logical partitions are formed based on the value of a partition key that is associated with each item in a container.
Reference: https://docs.microsoft.com/en-us/azure/cosmos-db/partitioning-overview
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Suggested Answer:
Box 1: Yes –
Compute is separate from storage, which enables you to scale compute independently of the data in your system.
Box 2: Yes –
You can use the Azure portal to pause and resume the dedicated SQL pool compute resources.
Pausing the data warehouse pauses compute. If your data warehouse was paused for the entire hour, you will not be charged compute during that hour.
Box 3: No –
Storage is sold in 1 TB allocations. If you grow beyond 1 TB of storage, your storage account will automatically grow to 2 TBs.
Reference: https://azure.microsoft.com/en-us/pricing/details/synapse-analytics/
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?
A. sqlcmd
B. Microsoft SQL Server Management Studio (SSMS)
C. Azure Data Studio
D. Azure Data Explorer
Suggested Answer: C
Azure Data Studio is a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, macOS, and Linux.
Azure Data Studio offers a modern editor experience with IntelliSense, code snippets, source control integration, and an integrated terminal.
Reference: https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio
DRAG DROP -
Match the Azure services to the appropriate locations in the architecture.
To answer, drag the appropriate service from the column on the left to its location on the right. Each service may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Select and Place:
HOTSPOT -
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
DRAG DROP
-
Match the data storage options to the appropriate types of data.
To answer, drag the appropriate data storage option from the column on the left to its data type on the right. Each data storage option may be used once, more than once, or not at all.
NOTE: Each correct match is worth one point.
Want a full-length mock test experience? Click here to unlock the complete DP-900 Mock Test Free set and get access to hundreds of additional practice questions covering all key topics.
We regularly update our question sets to stay aligned with the latest exam objectives—so check back often for fresh content!
Start practicing with our DP-900 mock test free today—and take a major step toward exam success!
Which format was used?
Which format was used?
