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