DS0-001 Practice Test 4 — 25 Questions

Question 1

Which regulatory act specifically governs the protection of healthcare-related data?

Accepted Answer

HIPAA. HIPAA sets the standard for protecting sensitive patient health information in the United States.

Answer

SOX

Answer

PCI DSS

Answer

GDPR

Question 2

Which of the following is a 'categorical' variable?

Accepted Answer

Product category. A categorical variable represents qualitative information, such as department, color, or gender.

Answer

Time taken to complete a task

Answer

Temperature in Celsius

Answer

Price in dollars

Question 3

Which THREE of the following are components of a standard SQL SELECT statement?

Accepted Answer

WHERE. The FROM, WHERE, and GROUP BY clauses are fundamental components used to define the source, filter criteria, and aggregation groups.

Answer

DROP

Answer

GRANT

Question 4

A data engineer is configuring an S3 bucket to comply with GDPR requirements regarding the 'Right to be Forgotten.' Which combination of configuration settings best automates the lifecycle of user-specific data objects that have reached the end of their retention period?

Accepted Answer

S3 Lifecycle configuration with expiration rules. S3 Lifecycle policies allow for the automated deletion of objects based on expiration rules after a specific time period.

Answer

S3 Object Lock with legal hold

Answer

Cross-Region Replication (CRR)

Answer

Bucket policies with IAM conditions

Answer

S3 Inventory reports

Question 5

In data visualization, what is the 'Data-Ink Ratio' intended to improve?

Accepted Answer

Chart readability and clarity. The Data-Ink Ratio, a concept by Edward Tufte, aims to maximize the information-carrying ink while minimizing non-essential decorations.

Answer

Chart rendering speed

Answer

Color palette selection

Answer

Data compression

Question 6

A company needs to implement centralized identity management for all database administrators. Which service is appropriate?

Accepted Answer

LDAP/Active Directory Integration. LDAP or Active Directory integration allows for centralized management of authentication and authorization across multiple database instances.

Answer

Snapshotting

Answer

Database Aliases

Answer

Local Database Users

Question 7

When normalizing a database, what is the primary goal of moving data into a third normal form (3NF)?

Accepted Answer

Remove transitive dependencies. 3NF removes transitive dependencies to ensure that every non-key attribute depends only on the primary key.

Answer

Enable multi-dimensional analysis

Answer

Increase data redundancy

Answer

Increase read speed

Answer

Combine multiple tables

Question 8

An organization uses a 'bring your own key' (BYOK) model for database encryption. What is the primary benefit?

Accepted Answer

Increased control over encryption keys. BYOK allows the organization to retain full control over the encryption keys, preventing the cloud provider from accessing the data.

Answer

Easier database installation

Answer

Improved query performance

Answer

Lower storage costs

Question 9

Which THREE of the following are examples of descriptive statistics?

Accepted Answer

Standard deviation. Mean, median, and standard deviation describe the central tendency and spread of a dataset.

Answer

Machine learning

Answer

Linear regression

Question 10

Which THREE of the following are valid methods to improve database performance for read-heavy workloads?

Accepted Answer

Create read-only replicas. Adding read-replicas, implementing caching, and creating appropriate indexes are all standard methods to offload and accelerate read operations.

Answer

Increase the number of write threads

Answer

Enable synchronous replication

Question 11

Which THREE of the following are valid SQL Server authentication modes?

Accepted Answer

SQL Server Authentication. SQL Server supports Windows Authentication, SQL Server Authentication, and Mixed Mode (which enables both).

Answer

LDAP Authentication

Answer

OAuth Authentication

Question 12

In PostgreSQL, you need to monitor the performance of your long-running queries. Which view is the most appropriate to inspect the query execution statistics for all active sessions?

Accepted Answer

pg_stat_activity. pg_stat_activity provides information about the current state of each backend process, including the query being executed.

Answer

pg_stat_database

Answer

pg_locks

Answer

pg_stat_user_tables

Question 13

Which protocol should be enforced for all data-in-transit between application servers and database instances?

Accepted Answer

TLS (Transport Layer Security). TLS (Transport Layer Security) is the industry standard for encrypting data while it travels over the network.

Answer

HTTP

Answer

SNMP

Answer

FTP

Question 14

Which action represents a 'Data Lifecycle' phase where data is safely removed?

Accepted Answer

Data Disposition. The 'Disposition' or 'Destruction' phase involves securely deleting data that is no longer required.

Answer

Data Profiling

Answer

Data Integration

Answer

Data Ingestion

Question 15

Which of the following is a common symptom of a broken access control mechanism in a database?

Accepted Answer

Insecure Direct Object Reference (IDOR). Insecure Direct Object References (IDOR) allow users to access resources they should not, indicating broken access control.

Answer

High CPU usage

Answer

Database fragmentation

Answer

Slow network speed

Question 16

In the context of data quality, what does 'Completeness' refer to?

Accepted Answer

The absence of missing values. Completeness measures whether all required data is present in the dataset without missing values.

Answer

The consistency of data across sources

Answer

The timeliness of the data

Answer

The accuracy of values

Question 17

Which TWO of the following are common types of data visualizations used to represent trends over time?

Accepted Answer

Line Chart. Line charts and area charts are the most effective visual representations for showing changes over continuous time intervals.

Answer

Histogram

Answer

Scatter Plot

Answer

Pie Chart

Question 18

Which THREE of the following are types of data joins in SQL?

Accepted Answer

INNER JOIN. INNER, LEFT, and RIGHT joins are all standard SQL join types.

Answer

UPPER JOIN

Answer

FAST JOIN

Question 19

You need to change the collation of a database. What is the impact of performing this operation?

Accepted Answer

It requires rebuilding the database or recreating tables. Changing a database collation is a destructive operation. It requires re-creating the database or recreating all tables, as column-level collations are not automatically updated for existing data.

Answer

It can be done instantly with an ALTER command

Answer

It is a metadata-only change

Answer

It only impacts system tables

Question 20

A developer needs to ensure that a 'Customer_ID' field in a 'Orders' table always references a valid ID in the 'Customers' table. Which constraint should be applied?

Accepted Answer

FOREIGN KEY. A foreign key constraint ensures referential integrity between two tables by requiring that the value in the child table exists in the parent table.

Answer

PRIMARY KEY

Answer

UNIQUE

Answer

CHECK