SkillTestPro | DP-900 Certification Questions

DP-900 Practice Test 4

DP-900 Practice Test - Skilltestpro

1 / 10

What is a "foreign key" in a relational database?

A column that uniquely identifies each row in a table.

A column that links two tables together by referencing the primary key of another table.

A column that stores encrypted data.

A column that stores large binary objects.

A column that can only contain numeric values.

2 / 10

Which Azure service offers a high-performance, massively parallel processing (MPP) analytical data warehouse specifically designed for large-scale data warehousing and big data analytics?

Azure SQL Database

Azure Databricks

Azure Data Factory

Azure Stream Analytics

Azure Synapse Analytics

3 / 10

A company needs to run a SQL Server database on Azure but requires full control over the operating system for specific configurations and third-party software installations. Which Azure SQL deployment option would meet this requirement?

Azure SQL Database

Azure SQL Managed Instance

SQL Server on Azure Virtual Machines

Azure Database for MySQL

Azure Cosmos DB

4 / 10

What is the role of an "index" in a relational database?

To speed up data retrieval operations.

To define the data types of columns.

To enforce data integrity rules.

To store data in a compressed format.

To automatically back up the database.

5 / 10

Which file format is commonly used for storing large datasets in a columnar fashion, optimized for analytical queries and typically found in data lakes?

CSV

JSON

XML

TXT

Parquet

6 / 10

What is the fundamental concept of a "schema-on-read" approach in data management?

Data must conform to a predefined schema before being stored.

The schema is applied to the data during the query or reading process, rather than at the time of data ingestion.

Data is stored in a fixed schema for fast writes.

The schema is automatically generated by the database.

Data can only be read by authorized users.

7 / 10

Which Azure service is designed for real-time stream processing, allowing you to ingest, process, and analyze data from various sources (like Event Hubs or IoT Hub) as it arrives?

Azure Data Factory

Azure Databricks

Azure Synapse Analytics

Azure Stream Analytics

Azure HDInsight

8 / 10

Which Azure Cosmos DB API is used for key-value pairs and wide-column store data, offering high throughput and low latency for operations on large datasets?

SQL (Core) API

Cassandra API

MongoDB API

Gremlin API

Table API

9 / 10

What is a "database administrator" (DBA) primarily responsible for?

Writing business reports.

Developing software applications.

Designing and maintaining the database infrastructure, ensuring its performance, security, and availability.

Cleaning and transforming data.

Creating machine learning models.

10 / 10

What is the main characteristic of a "cold path" in a modern data warehouse architecture?

It processes data immediately as it arrives.

It is used for real-time dashboards.

It stores data that is constantly changing.

It involves high-performance compute for complex queries.

It handles historical data that is accessed infrequently.

Your score is

The average score is 76%