DS0-001 Practice Test 4 — 10 Questions

Question 1

What does the 'P' in the acronym 'KPI' stand for?

Accepted Answer

Performance. KPI stands for Key Performance Indicator.

Answer

Product

Answer

Process

Answer

Planning

Question 2

When joining two tables in SQL where you need to return all records from the left table even if there is no match in the right table, which JOIN type is appropriate?

Accepted Answer

LEFT JOIN. A LEFT JOIN returns all rows from the left table and the matched rows from the right table, filling with NULL if no match exists.

Answer

CROSS JOIN

Answer

INNER JOIN

Answer

FULL OUTER JOIN

Question 3

To comply with CCPA, an organization must track the 'Right to Know' requests. Which component of a Data Governance Framework is most relevant?

Accepted Answer

Data Cataloging. Data Cataloging allows for the inventory and metadata management necessary to respond to data access requests.

Answer

Data Ingestion Pipeline

Answer

Load Balancing

Answer

Data Compression

Question 4

A database administrator needs to ensure that a query calculating running totals is performant. Which window function clause is essential to order the calculation sequence?

Accepted Answer

ORDER BY. The ORDER BY clause inside the OVER() function determines the sequence for running calculations.

Answer

GROUP BY

Answer

PARTITION BY

Answer

ROWS BETWEEN

Question 5

You are performing data transformation in Python using Pandas. You have a 'DataFrame' with missing values in the 'Revenue' column. Which method should be used to replace these missing values with the column mean?

Accepted Answer

fillna(). The fillna() method is the standard way to replace NaN values in a Pandas DataFrame.

Answer

replace()

Answer

dropna()

Answer

interpolate()

Answer

map()

Question 6

An administrator needs to restrict access to a specific S3 bucket so that only the Finance team can view files. Which configuration is the most effective approach?

Accepted Answer

Configure an S3 Bucket Policy. IAM policies attached to the specific bucket (Bucket Policies) are the primary control for S3 access management.

Answer

Update the VPC Route Table

Answer

Enable Public Access Block

Answer

Enable S3 Versioning

Question 7

In a multi-tenant cloud database, which mechanism ensures that tenant A cannot see data belonging to tenant B?

Accepted Answer

Row-Level Security (RLS). Row-Level Security (RLS) restricts rows in a table based on user or application context, effectively enforcing logical isolation.

Answer

Data Replication

Answer

Schema Versioning

Answer

Database Encryption

Question 8

A data analyst is writing a SQL query to retrieve unique department names from the 'Employees' table. Which keyword should be utilized to ensure the results do not contain duplicate entries?

Accepted Answer

DISTINCT. The DISTINCT keyword is used to return only unique values from a specific column.

Answer

GROUP BY

Answer

UNIQUE

Answer

FILTER

Question 9

When analyzing JSON data stored in a relational database using SQL, how do you typically access nested key-value pairs?

Accepted Answer

Using path-based operators. Modern SQL engines provide specific operators or functions (like the '->>' operator in PostgreSQL) to navigate JSON paths.

Answer

Converting to XML first

Answer

Using the SELECT * command

Answer

Using standard JOINs

Question 10

A security team is implementing an access management strategy. Which THREE of the following are considered essential components of an effective Identity and Access Management (IAM) framework?

Accepted Answer

Authentication mechanisms. IAM frameworks rely on Authentication (who you are), Authorization (what you can do), and Auditing (tracking what you did).

Answer

Network cabling standards

Answer

Database partitioning