SkillTestPro | DP-900 Quiz With Answers

DP-900 Practice Test 7

DP-900 Practice Test - Skilltestpro

1 / 10

What does "referential integrity" ensure in a relational database?

That data is sorted correctly.

That all data is unique.

That data is encrypted.

That relationships between tables are maintained, preventing invalid data entry.

That the database can recover from failures.

2 / 10

Which Azure service provides a fully managed, scalable Apache Kafka-compatible service, ideal for building real-time streaming applications?

Azure Event Hubs

Azure Stream Analytics

Azure Service Bus

Azure Databricks

Azure IoT Hub

3 / 10

You are loading historical sales data from multiple CSV files into Azure Synapse Analytics for reporting. Which type of data processing is this an example of?

Real-time processing

Batch processing

Streaming processing

Transactional processing

Event processing

4 / 10

What is the primary role of a "data scientist"?

To manage and maintain databases.

To design and build data pipelines.

To create visual reports for business users.

To administer network infrastructure.

To extract insights from data, build predictive models, and use advanced analytical techniques.

5 / 10

Which Azure service is optimized for storing massive amounts of data for big data analytics, supporting both hierarchical namespaces and data lakes?

Azure Files

Azure Table Storage

Azure Blob storage (Hot tier)

Azure Data Lake Storage Gen2

Azure Queue storage

6 / 10

When using Azure Cosmos DB, which consistency model provides the highest data consistency but might have higher latency for writes across globally distributed regions?

Eventual Consistency

Consistent Prefix

Session Consistency

Bounded Staleness

Strong Consistency

7 / 10

What is the primary function of a "view" in a relational database?

To store data physically on disk.

To enforce data integrity rules.

To provide a virtual table based on the result-set of a SQL query, simplifying complex queries or restricting access.

To speed up data insertion.

To manage user permissions.

8 / 10

Which type of non-relational database is best suited for storing information where relationships between entities are paramount, such as social networks, fraud detection, or recommendation engines?

Document database

Key-value database

Column-family database

Object database

Graph database

9 / 10

Which Azure relational database offering gives you the most control over the underlying operating system and SQL Server instance, similar to an on-premises deployment?

Azure SQL Database

Azure SQL Managed Instance

SQL Server on Azure Virtual Machines

Azure Database for MySQL

Azure Synapse Analytics

10 / 10

What is a "dashboard" in Power BI primarily used for?

To transform and clean data.

To create detailed, multi-page reports for printing.

To write complex SQL queries.

To manage data sources.

To provide a single-page overview of key metrics and visualizations for quick insights.

Your score is

The average score is 80%