DA Data Ethics and Governance 3

Question 1

Which regulation primarily governs the privacy of student education records in the United States?

Accepted Answer

FERPA

Answer

HIPAA

Answer

CCPA

Answer

SOX

Question 2

A data analyst is building a dashboard that will display individual employee performance scores to managers. What ethical consideration is most important?

Accepted Answer

Ensuring role-based access so only authorized managers see relevant scores

Answer

Choosing the most visually appealing chart type

Answer

Using the fastest query to retrieve the data

Answer

Storing the scores in a NoSQL database for scalability

Question 3

What is the main goal of differential privacy?

Accepted Answer

To add mathematical noise to datasets so individual records cannot be identified while preserving statistical utility

Answer

To encrypt data at rest and in transit simultaneously

Answer

To separate data into private and public schemas

Answer

To synchronize privacy policies across multiple databases

Question 4

Which Sarbanes-Oxley (SOX) requirement most directly affects data analysts working with financial data?

Accepted Answer

Financial data must be accurate, auditable, and access must be controlled and logged

Answer

Data must be stored using columnar compression

Answer

All financial reports must use OLAP cubes

Answer

Data analysts must hold a CPA certification

Question 5

What is a data catalog's primary function in a data governance program?

Accepted Answer

Providing a searchable inventory of data assets with metadata, lineage, and ownership information

Answer

Storing raw data before it is processed

Answer

Running scheduled data quality checks on production tables

Answer

Automating the deployment of data pipelines

Question 6

An analyst publishes a report showing that a neighborhood's average income is high, masking the fact that a small number of extremely wealthy residents skew the figure. This is an ethical concern related to:

Accepted Answer

Misleading aggregation

Answer

Data leakage

Answer

Selection bias

Answer

Survivorship bias

Question 7

Which of the following best describes the principle of 'purpose limitation' in data privacy?

Accepted Answer

Data collected for one specific purpose should not be used for unrelated purposes without consent

Answer

Data should be limited to the smallest possible file size

Answer

Only a limited number of analysts should have access to raw data

Answer

Data retention periods must be limited to 90 days