SkillTestPro | DP-900 Latest Exam Questions

DP-900 Practice Test 9

DP-900 Practice Test - Skilltestpro

1 / 10

Which command in SQL is used to change existing data in a table?

INSERT INTO

DELETE FROM

ALTER TABLE

UPDATE

SELECT

2 / 10

What is the fundamental concept of a "column-family" (wide-column) non-relational database?

Data is stored in tables with fixed schemas.

Data is stored as documents with flexible schemas.

Data is stored as interconnected nodes and edges.

Data is stored as simple key-value pairs.

Data is organized into columns within rows, where columns can be dynamic and vary between rows.

3 / 10

You are developing an application that requires a database with extremely low-latency reads and writes, global distribution, and multi-model support. Which Azure service best fits these requirements?

Azure SQL Database

Azure Database for PostgreSQL

Azure Cosmos DB

Azure Synapse Analytics

Azure Data Lake Storage

4 / 10

Which Power BI feature allows you to clean, transform, and reshape your data before loading it into your data model?

Power BI Service

Power BI Desktop Report View

Power BI Mobile

Power BI Gateway

Power Query Editor

5 / 10

What is the core difference between "data integrity" and "data consistency"?

Data integrity focuses on data accuracy and validity, while data consistency focuses on data being uniform across systems.

Data integrity is only for relational databases, while data consistency is for all data types.

Data integrity is about security, while data consistency is about performance.

They are two terms for the exact same concept.

Data integrity ensures availability, while data consistency ensures durability.

6 / 10

Which Azure service is best for ingesting and processing events from millions of connected Internet of Things (IoT) devices in real time?

Azure Event Hubs

Azure Stream Analytics

Azure IoT Hub

Azure Data Factory

Azure Cosmos DB

7 / 10

Which SQL command is used to add new rows of data into a table?

UPDATE

DELETE

INSERT INTO

ALTER TABLE

CREATE TABLE

8 / 10

When designing a data warehouse, what is the primary purpose of a "dimension table"?

To store the main numerical measurements.

To describe the attributes of a business entity.

To link fact tables together.

To manage data access permissions.

To define ETL processes.

9 / 10

You have millions of tiny documents with varying schemas that need to be stored and queried with low latency for a mobile application. Which Azure Cosmos DB API is most suitable?

Gremlin API

Cassandra API

MongoDB API

Table API

SQL API

10 / 10

Which Azure service provides a unified analytics platform that brings together enterprise data warehousing, big data analytics, and data integration capabilities?

Azure SQL Database

Azure Databricks

Azure Data Lake Storage

Azure Synapse Analytics

Azure Stream Analytics

Your score is

The average score is 78%