DS0-001 Practice Test 3 — 25 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

Question 11

Which document outlines the 'Data Owner' responsibilities in a data governance framework?

Accepted Answer

Data Governance Charter. A Data Governance Charter defines roles, responsibilities, and decision-making authority within the organization.

Answer

Server Inventory List

Answer

Database Schema

Answer

Network Topology Map

Question 12

Which TWO of the following are common issues encountered when integrating data from disparate sources?

Accepted Answer

Inconsistent data formats. Inconsistent data formats and conflicting identifiers are the most common barriers to effective data integration.

Answer

Excessive storage space

Answer

Fast network speeds

Answer

Over-documentation

Question 13

Which THREE elements are essential when configuring Database Activity Monitoring (DAM)?

Accepted Answer

Identifying sensitive data objects. DAM requires defining the scope (what to monitor), the sensitivity of the data, and the alerting rules for suspicious activity.

Answer

Upgrading the database server CPU

Answer

Installing extra network routers

Question 14

Which access control model should be implemented to ensure that a user can only access files based on their specific job role?

Accepted Answer

Role-Based Access Control (RBAC). Role-Based Access Control (RBAC) maps permissions to job functions rather than individual users.

Answer

Discretionary Access Control (DAC)

Answer

Mandatory Access Control (MAC)

Answer

Network Access Control (NAC)

Question 15

A company subject to GDPR needs to ensure that user data is deleted upon request across all distributed nodes in a NoSQL cluster. Which process is most critical to demonstrate compliance?

Accepted Answer

Automated Data Lineage and Lifecycle Tracking. Data lifecycle management, specifically mapping data lineage and retention policies, is required to prove that data was effectively purged from all replicas.

Answer

Snapshotting

Answer

Database Sharding

Answer

Cache clearing

Question 16

Which of the following is an example of an unstructured data source that a data analyst might need to ingest?

Accepted Answer

An email message body. Emails are considered unstructured because they contain free-form text that does not follow a strict relational schema.

Answer

An XML file with defined tags

Answer

A relational SQL table

Answer

A CSV file with fixed columns

Question 17

An organization is migrating sensitive financial records to a cloud environment. Which security control ensures that only authorized applications can decrypt the data?

Accepted Answer

Cloud Hardware Security Module (Cloud HSM). Hardware Security Modules (HSM) provide the root of trust for encryption keys required by applications to decrypt data.

Answer

Database Replication

Answer

Database Triggers

Answer

Shared Responsibility Model

Question 18

What is the benefit of using a 'Dashboard' over a static report?

Accepted Answer

Dynamic exploration and interactivity. Dashboards offer real-time or near-real-time interactivity, allowing users to explore data dynamically.

Answer

Simplified data security

Answer

Lower storage requirements

Answer

Easier to print

Question 19

An administrator needs to restrict a user's ability to see only rows where the 'Region' column is 'North'. What feature should be used?

Accepted Answer

Row-Level Security (RLS). Row-Level Security (RLS) allows for the definition of predicates that filter query results based on user metadata.

Answer

View creation

Answer

Stored Procedures

Answer

Column Masking

Question 20

A data analyst discovers that raw log files contain unmasked social security numbers. Which data governance practice should be implemented immediately to remediate the risk?

Accepted Answer

Dynamic Data Masking (DDM). Data masking at the ingestion layer prevents sensitive data from being written to logs in clear text.

Answer

Partitioning

Answer

Database Mirroring

Answer

Database Indexing