DS0-001 Practice Test 6 — 10 Questions

Question 1

When assessing data privacy compliance, which THREE categories of data are typically protected under laws like CCPA or GDPR?

Accepted Answer

Biometric data. PII, sensitive biometric data, and financial account information are primary targets for privacy regulation.

Answer

Publicly listed company stock prices

Answer

Internal server IP addresses

Question 2

A developer wants to use a subset of production data for testing. Which method ensures the test data retains its structure while protecting privacy?

Accepted Answer

Data Masking/De-identification. Data masking or de-identification replaces real values with realistic but fake values, maintaining schema integrity.

Answer

Database Snapshotting

Answer

Database Migration

Answer

Full Database Clone

Question 3

A database administrator needs to perform a schema-only export of a database. Which tool parameter is typically used for this purpose in mysqldump?

Accepted Answer

--no-data. The '--no-data' flag instructs mysqldump to export the schema (CREATE statements) without including the table content.

Answer

--quick

Answer

--add-drop-table

Answer

--all-databases

Question 4

Which THREE of the following are indicators of significant index fragmentation in a database?

Accepted Answer

Low page density. High scan latency, decreased query performance, and low page density are all common signs that indexes need maintenance.

Answer

Increased memory usage

Answer

Increased server uptime

Question 5

Which database backup strategy is recommended to ensure that you can restore a database to a specific point in time?

Accepted Answer

Full and Transaction Log backups. Transaction log backups, when used in conjunction with full backups and the Full recovery model, allow for point-in-time recovery.

Answer

Differential backups only

Answer

Full backups only

Answer

Copy-only backups

Question 6

Which TWO of the following are potential issues when denormalizing a database?

Accepted Answer

Data anomalies. Denormalization can lead to data anomalies (inconsistencies) and increased storage usage due to redundancy.

Answer

Simplified data entry

Answer

Improved schema flexibility

Answer

Slower join performance

Question 7

Which THREE factors should be considered when choosing between a traditional RDBMS and a NoSQL database for a new project?

Accepted Answer

Consistency requirements (ACID vs BASE). Data structure, scalability requirements, and ACID transaction needs are the primary drivers in this architectural decision.

Answer

The developer's preferred operating system

Answer

The color of the database console UI

Question 8

Which THREE factors are critical to consider when configuring a database for disaster recovery (DR)?

Accepted Answer

Geographic distance between primary and DR sites. RPO, RTO, and geographic location are the three pillars of a comprehensive disaster recovery strategy.

Answer

The brand of the server hardware

Answer

The database developer's IDE preference

Question 9

In Power BI, which visualization component is best suited to show the relationship between two numerical variables and identify potential trends or clusters?

Accepted Answer

Scatter Plot. A Scatter Plot is specifically designed to plot two numerical variables to show correlations.

Answer

Gauge Chart

Answer

Pie Chart

Answer

Clustered Column Chart

Question 10

You are debugging a SQL query that uses an aggregate function. You receive an error stating that a column in your SELECT list is not part of an aggregate or a GROUP BY clause. What is the cause?

Accepted Answer

Missing column in GROUP BY. Standard SQL requires every non-aggregated column in the SELECT clause to be included in the GROUP BY clause to ensure deterministic results.

Answer

Missing WHERE clause

Answer

Incorrect join type

Answer

Using an alias in WHERE