DS0-001 Practice Exam 4 — 20 Questions

Question 1

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 2

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 3

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 4

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 5

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 6

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 7

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 8

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 9

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 10

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

Question 11

Which dashboarding practice helps prevent users from being overwhelmed by too much data at once?

Accepted Answer

Using interactive filters. Progressive disclosure or the use of filters allows users to drill down into details only as needed.

Answer

Removing all tooltips

Answer

Adding more charts per page

Answer

Increasing font size

Question 12

Which type of data is defined as 'sensitive' and usually requires enhanced protection?

Accepted Answer

Personally Identifiable Information (PII). Personally Identifiable Information (PII) is subject to strict regulatory requirements and must be protected.

Answer

Temporary cache files

Answer

Publicly available news data

Answer

Static CSS files

Question 13

Which TWO technologies or methods are most effective at protecting sensitive data against insider threats?

Accepted Answer

Deploying Database DLP tools. Separation of duties and Data Loss Prevention (DLP) tools are the most effective ways to mitigate the risk posed by users with elevated privileges.

Answer

Using a custom UI theme

Answer

Increasing server RAM

Answer

Enabling database mirroring

Question 14

A database administrator needs to implement column-level encryption for sensitive PII in a SQL Server environment. Which tool should be used to ensure the encryption keys are managed outside the database engine?

Accepted Answer

SQL Server Always Encrypted with Azure Key Vault. Azure Key Vault is the industry-standard service for managing encryption keys independently of the database engine, ensuring separation of duties.

Answer

Database File Stream

Answer

Transparent Data Encryption (TDE)

Answer

SQL Server Data Masking

Question 15

An analyst notices that a database query is performing full table scans even though a WHERE clause is present on a indexed column. What is a likely reason for this?

Accepted Answer

Using a function on the indexed column. Applying a function (like UPPER() or YEAR()) to an indexed column in the WHERE clause prevents the database from using the index effectively.

Answer

Too many rows match the criteria

Answer

The table is too small

Answer

The index is fragmented

Question 16

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 17

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 18

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 19

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 20

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