OA Exam | New Questions and Answers | 100% Correct
Answers | Latest Update | Pass Guaranteed - A+ Graded
Domain 1: Data Governance and Quality (12 Questions)
Q1: A healthcare organization is implementing a data governance framework to ensure
HIPAA compliance while enabling data-driven research. Which component of data
governance should be prioritized to balance patient privacy with legitimate research
access?
A. Data cataloging and metadata management only
B. Data quality monitoring dashboards
C. Data access controls and classification policies [CORRECT]
D. Master data management implementation
Correct Answer: C
Rationale: Data access controls and classification policies are fundamental for HIPAA
compliance because they establish who can access protected health information (PHI)
and under what circumstances. This component directly addresses the privacy-security
balance by implementing role-based access, data masking for research datasets, and
audit trails. While data cataloging (A) improves discoverability and quality monitoring
(B) ensures accuracy, neither directly manages access permissions. Master data
management (D) focuses on consistency across systems but doesn't inherently
address privacy compliance. The scenario specifically requires balancing privacy with
access, making classification and access controls the primary mechanism for achieving
this equilibrium while maintaining regulatory compliance.
,Q2: A financial services firm discovers that 15% of customer records contain
inconsistent address formats, duplicate entries, and missing phone numbers. Which
data quality dimension is MOST affected by these issues?
A. Data timeliness
B. Data completeness and consistency [CORRECT]
C. Data uniqueness only
D. Data validity
Correct Answer: B
Rationale: The scenario describes multiple data quality issues: missing phone numbers
indicate incompleteness, inconsistent address formats indicate lack of consistency, and
duplicate entries suggest compromised uniqueness. However, the combination of
missing data (completeness) and format variations (consistency) represents the
broadest impact. While uniqueness is affected by duplicates, and validity could be
questioned by format issues, the primary dimensions compromised are completeness
(missing phone numbers) and consistency (varying address formats). Data timeliness
(A) isn't mentioned as an issue, and focusing solely on uniqueness (C) ignores the
completeness and consistency problems. Data validity (D) is partially relevant but less
comprehensive than the completeness-consistency combination.
Q3: Which of the following are essential elements of a comprehensive data governance
framework? (Select all that apply)
A. Data stewardship roles and responsibilities [CORRECT]
B. Data quality standards and metrics [CORRECT]
C. Business intelligence reporting tools
D. Data lifecycle management policies [CORRECT]
E. Data privacy and compliance procedures [CORRECT]
F. Database performance optimization scripts
,Correct Answer: A, B, D, E
Rationale: A comprehensive data governance framework requires clear accountability
through data stewardship (A), measurable quality objectives through standards and
metrics (B), management of data from creation to archival through lifecycle policies (D),
and regulatory adherence through privacy and compliance procedures (E). These
elements establish the organizational structure, quality benchmarks, temporal
management, and legal boundaries for data assets. Business intelligence tools (C) are
consumption mechanisms that utilize governed data but aren't governance components
themselves. Database performance scripts (F) are technical operational tasks managed
by DBAs, not governance framework elements. Governance focuses on policies,
standards, and accountability rather than technical implementation tools.
Q4: A multinational corporation must comply with both GDPR (EU) and CCPA
(California) regulations. Which data governance strategy BEST addresses the
conflicting requirements between these regulations?
A. Implement the strictest requirements of both regulations across all global operations
[CORRECT]
B. Maintain separate data handling processes for EU and California residents only
C. Apply GDPR standards exclusively to ensure comprehensive coverage
D. Create regional exceptions for data deletion requests
Correct Answer: A
Rationale: Implementing the strictest requirements across all operations (A) ensures
comprehensive compliance while simplifying operational complexity. This approach,
known as the "highest common denominator" strategy, prevents compliance gaps and
reduces the risk of violations when data crosses jurisdictional boundaries. GDPR
generally has stricter requirements than CCPA regarding consent, data portability, and
processing limitations, while CCPA has specific disclosure requirements. Option B
, creates operational fragmentation and risks non-compliance when EU residents travel
or when data is transferred. Option C might miss CCPA-specific requirements like the
"Do Not Sell My Personal Information" provisions. Option D directly violates both
regulations' core principles. The strictest-standard approach future-proofs against
regulatory changes and demonstrates good faith compliance efforts to regulators.
Q5: A data quality assessment reveals that customer birthdates in the CRM system
show 23% of records with future dates, impossible ages (>120 years), and inconsistent
formats (MM/DD/YYYY vs. DD-MM-YYYY). Which data quality rule type should be
implemented FIRST to address these issues?
A. Referential integrity constraints
B. Domain constraints and validation rules [CORRECT]
C. Entity integrity rules
D. Temporal consistency checks only
Correct Answer: B
Rationale: Domain constraints and validation rules (B) are the immediate solution
because they restrict attribute values to valid ranges and formats. The scenario
describes domain violations: future dates violate reasonable date domains, impossible
ages exceed biological reality domains, and format inconsistencies violate
standardization domains. Domain constraints would implement range checks (e.g.,
birthdate must be between 1900 and current date), format standardization (consistent
YYYY-MM-DD structure), and logical validation (age calculations). Referential integrity
(A) ensures relationships between tables exist, which isn't the described problem. Entity
integrity (C) ensures primary keys are unique and not null, unrelated to birthdate validity.
Temporal consistency checks (D) are too narrow, addressing only the date sequence
aspect while missing format and range issues.