DP-900 Free Practice Test

DP-900 Practice Test 1

DP-900 Practice Test - Skilltestpro

1 / 10

Which type of database is optimized for Online Transaction Processing (OLTP) workloads?

2 / 10

Which Power BI component is used to connect to various data sources, transform data, and create a centralized model that can be used for reports and dashboards?

3 / 10

What is the primary difference between batch processing and streaming data?

4 / 10

Which role is typically responsible for designing, building, and maintaining the data pipelines that move and transform data from various sources into analytical systems?

5 / 10

An organization needs to store product catalog information that has a flexible schema, where different products might have different attributes, and needs fast querying capabilities. Which Azure Cosmos DB API is most suitable for this scenario?

6 / 10

Which type of non-relational data store is optimized for storing large amounts of unstructured binary data, such as images, videos, documents, and backups?

7 / 10

Which Azure SQL family offering is a fully managed Platform as a Service (PaaS) database service that is ideal for modern cloud applications requiring high availability and scalability without managing the underlying infrastructure?

8 / 10

What is the primary purpose of normalization in a relational database?

9 / 10

A company needs to store a large volume of sensor data from IoT devices, which arrives continuously and needs immediate processing. Which type of data workload does this scenario represent?

10 / 10

Which type of data is stored in a fixed schema, typically in tables with rows and columns, and is well-suited for relational databases?

Your score is

The average score is 76%

0%