DP-900 Practice Questions

DP-900 Practice Test 6

DP-900 Practice Test - Skilltestpro

1 / 10

You need to ensure that database transactions either completely succeed or completely fail, preventing partial updates. Which ACID property addresses this?

2 / 10

Which Power BI component is a cloud-based service where users can publish, share, and consume reports and dashboards?

3 / 10

What is the primary benefit of using "indexing" in a database?

4 / 10

Which Azure analytics component in Azure Synapse Analytics allows you to query data directly from data lake storage (like Parquet, CSV, JSON files) using T-SQL without provisioning dedicated resources?

5 / 10

An organization is moving an on-premises Oracle database to Azure. Which Azure relational database service provides high compatibility for open-source database engines?

6 / 10

Which non-relational database type is designed for fast read and write operations, storing data as key-value pairs, and is often used for caching or session management?

7 / 10

Which type of join in SQL returns only the rows that have matching values in both tables?

8 / 10

You have a large collection of photos and videos that you need to store in Azure. Which Azure storage solution is the most cost-effective for this type of data, especially if it's accessed infrequently?

9 / 10

Which characteristic of a database ensures that once a transaction is committed, it remains permanently recorded, even in the event of system failures?

10 / 10

What does the "C" in ACID properties (Atomicity, Consistency, Isolation, Durability) primarily refer to in the context of database transactions?

Your score is

The average score is 66%

0%