Exam 3 - In Progress

Data Modelling and Design Q1 of 98

In Data Vault modeling, what is the purpose of a Link table?

A. To store descriptive attributes that change over time B. To represent the unique business keys for core business concepts C. To capture the relationships and associations between two or more Hub tables D. To store aggregated summary data for reporting E. To define the loading schedule for ETL processes

Data Quality Q2 of 98

What is the PDCA cycle in the context of data quality management?

A. Profile, Design, Cleanse, Archive B. Plan, Do, Check, Act - a continuous improvement cycle C. Prepare, Develop, Configure, Activate D. Parse, Deduplicate, Consolidate, Analyze E. Prioritize, Define, Create, Approve

Data Security Q3 of 98

Which regulation specifically addresses the protection of personal data for individuals in the European Union?

A. HIPAA B. SOX C. GDPR D. PCI-DSS E. CCPA

Data Integration and Interoperability Q4 of 98

An organization needs to deliver data from a transactional system to a data warehouse with no more than a 5-minute delay. Which integration approach is MOST appropriate?

A. Nightly batch ETL jobs B. Weekly full data extracts C. Near-real-time integration using Change Data Capture (CDC) D. Manual file uploads by business users E. Annual data migration

Data Architecture Q5 of 98

An architect is evaluating whether to use a cloud data warehouse versus an on-premises solution. Which factor is LEAST relevant to this decision?

A. Total cost of ownership including scaling costs B. Data sovereignty and regulatory requirements C. The programming language used by the data engineering team D. Elasticity and ability to handle variable workloads E. Integration requirements with existing systems

Data Quality Q6 of 98

In the DMAIC methodology applied to data quality improvement, what occurs during the 'Analyze' phase?

A. Implementing data cleansing procedures B. Defining project scope and data quality objectives C. Identifying root causes of data quality problems through statistical and process analysis D. Establishing ongoing monitoring controls E. Measuring baseline data quality metrics

Data Ethics Q7 of 98

A social media company collects location data, browsing habits, and biometric data to monitor user behavior continuously. Which ethical concern does this practice PRIMARILY raise?

A. Data redundancy B. Poor data modeling C. Surveillance ethics and disproportionate monitoring D. Lack of database normalization E. Insufficient backup procedures

Data Storage and Operations Q8 of 98

What does RTO (Recovery Time Objective) measure?

A. The amount of data that can be lost B. The maximum acceptable downtime before a system must be restored to operational status C. The frequency of backup operations D. The speed of data replication E. The total storage capacity needed

Data Management Process Q9 of 98

A data management maturity model typically uses five levels. Which sequence correctly orders these levels from least to most mature?

A. Initial, Managed, Defined, Quantitatively Managed, Optimizing B. Ad hoc, Repeatable, Defined, Managed, Optimizing C. Chaotic, Reactive, Proactive, Managed, Optimizing D. Initial, Repeatable, Managed, Quantitatively Managed, Optimizing E. None, Basic, Standard, Advanced, Optimizing

Metadata Management Q10 of 98

Which metadata type includes information such as table structures, column data types, and database schemas?

A. Business metadata B. Operational metadata C. Strategic metadata D. Technical metadata E. Compliance metadata

Document and Content Management Q11 of 98

In the EDRM model, what happens during the 'Processing' phase?

A. Legal teams review documents for relevance and privilege B. Electronically stored information is reduced in volume through de-duplication, filtering, and conversion to reviewable formats C. Documents are presented to the court D. Records are identified for potential relevance E. Documents are preserved by suspending deletion policies

Master and Reference Data Management Q12 of 98

An organization's MDM system performs matching and identifies two customer records as a potential match with a confidence score of 72%. The auto-merge threshold is set at 85% and the auto-reject threshold is set at 40%. What should happen to this pair?

A. The records should be automatically merged into one golden record B. The records should be automatically rejected as non-matches C. The records should be placed in a review queue for manual steward resolution D. The records should be deleted from the system E. The matching algorithm should be re-run until a higher score is achieved

Data Integration and Interoperability Q13 of 98

HL7 is a data exchange standard used primarily in which industry?

A. Finance B. Retail C. Healthcare D. Manufacturing E. Education

Data Governance Q14 of 98

An organization's data governance steering committee must decide between centralized and decentralized governance models. Which factor most strongly favors a centralized approach?

A. Business units operate in highly diverse and unrelated industries B. The organization needs rapid, uniform enforcement of data policies for regulatory compliance C. Business units have mature, well-established local governance practices D. The organization values maximum agility and autonomy in each business unit E. Each business unit uses entirely different technology stacks with no shared data

Data Integration and Interoperability Q15 of 98

What does CDC stand for in data integration?

A. Core Data Classification B. Central Data Connector C. Change Data Capture D. Continuous Data Compression E. Critical Data Compliance

Data Governance Q16 of 98

In the DAMA-DMBOK framework (the DAMA Wheel), where is Data Governance positioned?

A. As one of the outer knowledge areas B. At the center of the wheel C. Outside the wheel as a separate function D. As the top knowledge area E. It is not represented in the DAMA Wheel

Data Architecture Q17 of 98

What is the PRIMARY purpose of enterprise data architecture?

A. To select specific database products B. To define the blueprint for managing data assets aligned with organizational strategy C. To write SQL queries for reporting D. To manage database backups E. To create data entry forms

Data Modelling and Design Q18 of 98

A retail company needs to track customer address changes over time for historical reporting. Which Slowly Changing Dimension (SCD) type is MOST appropriate?

A. Type 1 - Overwrite the old value with the new value B. Type 2 - Add a new row with effective dates to maintain full history C. Type 3 - Add a column for the previous value D. Type 0 - Never change the dimension E. Type 4 - Use a separate history table

Metadata Management Q19 of 98

Which of the following is TRUE about metadata management?

A. It is only relevant for data warehousing projects B. It supports all other data management disciplines C. It is exclusively an IT responsibility D. It only involves documenting database schemas E. It has no impact on data quality

Data Modelling and Design Q20 of 98

Which type of fact table captures data at defined regular intervals, such as daily account balances?

A. Transactional fact table B. Periodic snapshot fact table C. Accumulating snapshot fact table D. Factless fact table E. Consolidated fact table

Data Storage and Operations Q21 of 98

When planning database capacity, which factor is MOST important to project for ensuring future scalability?

A. The current number of database users B. Data growth rate combined with query volume trends and performance requirements over the planning horizon C. The brand of storage hardware currently in use D. The current size of the database backup files E. The color theme of the monitoring dashboard

Data Storage and Operations Q22 of 98

What is the correct order of the data lifecycle stages?

A. Storage -> Creation -> Usage -> Archival -> Destruction B. Creation/Acquisition -> Storage -> Usage -> Archival -> Purging/Destruction C. Usage -> Creation -> Storage -> Destruction -> Archival D. Archival -> Storage -> Usage -> Creation -> Destruction E. Creation -> Destruction -> Archival -> Storage -> Usage

Data Architecture Q23 of 98

In a hub-and-spoke data architecture, what is the role of the central hub?

A. It serves as the only data consumption layer for end users B. It acts as a centralized integration and transformation layer connecting multiple source and target systems C. It stores only unstructured documents and images D. It replaces all source systems with a single operational database E. It provides real-time streaming for IoT sensor data only

Metadata Management Q24 of 98

A business glossary is PRIMARILY a tool for managing which type of metadata?

A. Technical metadata B. Operational metadata C. Business metadata D. Structural metadata E. System metadata

Data Quality Q25 of 98

In the DMAIC framework for data quality improvement, what is accomplished during the 'Control' phase?

A. Defining the data quality problem and project scope B. Measuring baseline data quality metrics C. Analyzing root causes of data quality problems D. Implementing improvements to data quality processes E. Establishing ongoing monitoring, controls, and documentation to sustain the improvements achieved

Data Architecture Q26 of 98

An organization has dozens of point-to-point integrations creating a complex web. Which architectural approach would BEST simplify this?

A. Add more point-to-point connections B. Implement a hub-and-spoke or ESB architecture to centralize integration C. Eliminate all integrations D. Copy all data into a single database E. Only allow manual data transfer

Data Integration and Interoperability Q27 of 98

What is the primary difference between ETL and ELT?

A. ETL uses SQL while ELT uses Python B. In ETL, transformation occurs before loading; in ELT, data is loaded first and transformed in the target system C. ETL is for batch processing while ELT is for real-time only D. ETL is cloud-based while ELT is on-premises E. There is no difference; they are the same process

Document and Content Management Q28 of 98

A legal hold in records management means:

A. All records must be held in a legal department's office B. Normal retention and disposition schedules are suspended to preserve records relevant to litigation or investigation C. Only lawyers can access the records D. Records must be encrypted with legal-grade encryption E. Records can be destroyed faster than normal

Data Quality Q29 of 98

What is data profiling?

A. Creating data quality rules and business rules B. Examining data to collect statistics and information about its structure, content, and quality C. Removing duplicate records from a database D. Encrypting sensitive data fields E. Designing a data model for a new system

Data Storage and Operations Q30 of 98

What is the difference between horizontal and vertical partitioning?

A. Horizontal partitioning splits by rows, vertical partitioning splits by columns B. Horizontal partitioning splits by columns, vertical partitioning splits by rows C. Horizontal partitioning is for cloud, vertical is for on-premises D. They both split data the same way but use different algorithms E. Horizontal partitioning is for NoSQL, vertical is for relational databases

Master and Reference Data Management Q31 of 98

An MDM implementation team is evaluating whether to use a Commercial Off-The-Shelf (COTS) MDM platform or build a custom solution. Which factor MOST favors selecting a COTS platform?

A. The organization has extremely unique data models found nowhere else in any industry B. The organization has unlimited budget and development resources C. The organization only needs to manage data in a single system with no integration requirements D. The organization needs standard MDM capabilities including matching, merging, survivorship, hierarchy management, and workflow, and wants faster time to value E. The organization wants to avoid vendor dependency at all costs

Document and Content Management Q32 of 98

Which of the following is an example of unstructured data?

A. A row in a relational database table B. A spreadsheet with defined columns C. An email message, a PDF document, or a video file D. A CSV file with headers E. A JSON file with a defined schema

Data Security Q33 of 98

In a Mandatory Access Control (MAC) model, who determines the access permissions for data objects?

A. Individual data owners set permissions at their discretion B. Users can grant access to other users for objects they own C. A central authority assigns security labels, and the system enforces access based on the comparison of subject and object labels D. All users have equal access to all data E. A machine learning algorithm dynamically determines access

Data Quality Q34 of 98

An organization discovers that its data quality problems originate from three sources: manual data entry errors (40%), system integration mapping defects (35%), and data decay over time (25%). Which combination of controls best addresses all three sources?

A. Hiring more database administrators B. Implementing input validation with auto-suggest at entry points, automated integration testing with reconciliation checks, and scheduled data verification processes with external reference sources C. Purchasing additional data storage capacity D. Upgrading the operating system on all servers E. Conducting a single comprehensive data cleansing project

Data Modelling and Design Q35 of 98

What type of measures in a fact table can be summed across ALL dimensions?

A. Semi-additive measures B. Non-additive measures C. Additive measures D. Derived measures E. Calculated measures

Data Quality Q36 of 98

The customer service system shows a customer's address as '123 Main St, New York' while the billing system shows '456 Oak Ave, Boston' for the same customer. Which data quality dimension is violated?

A. Accuracy B. Completeness C. Consistency D. Timeliness E. Validity

Data Security Q37 of 98

Data classification levels typically range from:

A. Small, Medium, Large B. Public, Internal, Confidential, Restricted C. Red, Yellow, Green D. Level 1 through Level 10 E. Simple, Standard, Complex

Document and Content Management Q38 of 98

ISO 15489 is the international standard for what area of content management?

A. Data encryption B. Records management C. Web content publishing D. Digital image compression E. Database performance tuning

Data Architecture Q39 of 98

A data flow diagram (DFD) shows:

A. The physical layout of servers and networks B. How data moves between processes, data stores, and external entities C. The database table relationships D. The project timeline and milestones E. User interface wireframes

Master and Reference Data Management Q40 of 98

An organization's MDM program uses source-priority survivorship rules, where the CRM system is the most trusted source for customer contact information. However, a data quality assessment reveals that the CRM has a 40% error rate in phone numbers. What is the BEST course of action?

A. Continue using the CRM as the trusted source because the survivorship rule says so B. Immediately switch to a different source system without analysis C. Review and adjust the trust framework scores, considering supplementing CRM phone data with a more reliable source or adding validation rules before survivorship is applied D. Delete all phone numbers from the golden record E. Abandon the MDM program entirely

Master and Reference Data Management Q41 of 98

An organization discovers that its product hierarchy is managed independently by three different business units, resulting in conflicting category structures. According to MDM best practices, what is the MOST appropriate solution?

A. Allow each business unit to keep its own hierarchy and avoid integration B. Establish an enterprise-wide product hierarchy governance process with cross-functional stewardship to define and maintain a canonical hierarchy C. Delete all hierarchies and start from scratch with a flat product list D. Choose the largest business unit's hierarchy and force others to adopt it without review E. Outsource product categorization to a third-party vendor

Data Warehousing and Business Intelligence Q42 of 98

An organization has a fact table recording insurance claim processing with milestones: Claim Filed, Claim Reviewed, Claim Approved, Payment Issued. Each row tracks a single claim through all milestones with separate date columns for each. This is an example of:

A. A transactional fact table B. A periodic snapshot fact table C. A factless fact table D. An aggregate fact table E. An accumulating snapshot fact table

Master and Reference Data Management Q43 of 98

In the context of MDM, data stewardship responsibilities include all of the following EXCEPT:

A. Defining business rules for master data attributes B. Resolving data quality issues in master records C. Approving changes to reference data values D. Designing the physical network infrastructure for data replication E. Ensuring compliance with data standards for the assigned data domain

Data Quality Q44 of 98

A data quality team discovers that 30% of product records have inconsistent category classifications between the ERP and e-commerce systems. Which sequence of activities represents the best approach to resolve this?

A. Immediately overwrite ERP values with e-commerce values B. Profile both systems to understand the inconsistencies, perform root cause analysis to determine why divergence occurs, establish an authoritative source, implement synchronization rules, and deploy ongoing monitoring C. Delete all inconsistent records from both systems D. Create a third system to store a separate version of the classifications E. Ignore the inconsistency since both systems still function independently

Metadata Management Q45 of 98

Metadata integration challenges most commonly arise from which factor?

A. Using too few data sources across the organization B. Inconsistent metadata formats, naming conventions, and definitions across different tools and platforms C. Having too many metadata stewards assigned to a single domain D. Storing all metadata in a single standardized format from the beginning E. Using exclusively open-source tools for all metadata management

Data Modelling and Design Q46 of 98

Which NoSQL data modeling pattern involves duplicating data across multiple tables, each optimized for a specific query pattern?

A. Normalization pattern B. Materialized view / query-first pattern C. Star schema pattern D. Master-detail pattern E. Temporal versioning pattern

Data Integration and Interoperability Q47 of 98

What is data federation?

A. The process of merging all databases into a single system B. An approach that provides a virtual database layer allowing queries across multiple heterogeneous data sources as if they were one C. A government regulation for data sharing between countries D. The process of splitting a database into regional segments E. A backup strategy using distributed storage

Master and Reference Data Management Q48 of 98

In an MDM Consolidation architecture, the central hub serves as the:

A. Only system where data can be created, read, updated, and deleted B. Authoritative source for reading the golden record, while source systems remain the systems of record for data entry C. Backup system for disaster recovery D. Temporary staging area for data migration E. System used only for reporting purposes

Data Warehousing and Business Intelligence Q49 of 98

In the modern data stack, a transformation tool like dbt (data build tool) operates by:

A. Extracting data from source systems via API connectors B. Defining transformations as SQL SELECT statements that run inside the cloud data warehouse, following an ELT pattern C. Loading data into the warehouse from flat files D. Creating data visualizations and dashboards E. Managing physical database server infrastructure

Data Warehousing and Business Intelligence Q50 of 98

An organization's data warehouse has severe query performance issues on reports that aggregate millions of sales records by month and region. The underlying fact table is at the daily transaction grain. Which approach is MOST effective to improve performance without changing the base table?

A. Delete historical data to reduce table size B. Add more indexes to the daily fact table C. Build aggregate tables at the monthly-region grain and configure the BI tool or OLAP engine to use aggregate navigation to route queries to the appropriate table D. Increase network bandwidth between the server and client E. Switch from SQL to a NoSQL database

Data Security Q51 of 98

A company stores test data in its QA environment using production customer data. This practice is problematic because:

A. QA environments are typically slower than production B. It exposes real customer data to a broader set of users with potentially weaker security controls C. Test data requires more storage space D. QA environments do not support data analytics E. Production data is too large for QA environments

Data Warehousing and Business Intelligence Q52 of 98

Which of the following is a characteristic of OLAP as opposed to OLTP?

A. OLAP systems are optimized for complex analytical queries involving aggregations, comparisons, and trend analysis over large volumes of historical data B. OLAP systems are optimized for high-volume transactional inserts and updates C. OLAP systems process one record at a time D. OLAP systems require fully normalized schemas for optimal performance E. OLAP systems do not support any form of data aggregation

Data Governance Q53 of 98

What is the primary purpose of Data Governance?

A. To implement database security controls B. To exercise authority, control, and shared decision-making over data assets C. To build data warehouses for reporting D. To manage the physical storage of data E. To create data models for applications

Data Management Process Q54 of 98

In the context of the data lifecycle, which phase introduces the greatest risk if data management controls are not properly implemented?

A. Data archival and purging B. Data creation and acquisition C. Data reporting and visualization D. Data storage and maintenance E. Data distribution and delivery

Data Warehousing and Business Intelligence Q55 of 98

In the data warehouse architecture, the presentation layer is responsible for:

A. Extracting data from source systems B. Storing raw data in staging tables C. Managing ETL job scheduling D. Encrypting data for security compliance E. Providing organized, query-ready data structures (such as dimensional models) that end users and BI tools access for reporting and analysis

Data Security Q56 of 98

What is the 'defense in depth' strategy in data security?

A. Using a single, very strong firewall to protect all data B. Implementing multiple layers of security controls so that if one layer fails, others continue to provide protection C. Storing all data in the deepest part of the network D. Backing up data to multiple locations E. Using only the most expensive security products

Data Governance Q57 of 98

Which of the following is the CORRECT hierarchy for governance directives?

A. Guidelines -> Procedures -> Standards -> Policies B. Standards -> Policies -> Procedures -> Guidelines C. Policies -> Standards -> Procedures -> Guidelines D. Procedures -> Standards -> Guidelines -> Policies E. Policies -> Guidelines -> Standards -> Procedures

Master and Reference Data Management Q58 of 98

Internal reference data differs from external reference data in that:

A. Internal reference data is defined and managed within the organization, while external reference data comes from outside standards bodies or regulatory agencies B. Internal reference data is always more accurate C. External reference data never changes D. Internal reference data is stored in a data lake, while external data is stored in a warehouse E. There is no meaningful distinction between internal and external reference data

Data Storage and Operations Q59 of 98

What is the primary role of a Database Administrator (DBA)?

A. Writing business requirements documents B. Managing, maintaining, and ensuring the performance, security, and availability of databases C. Designing user interface screens D. Conducting market research E. Writing application source code

Data Governance Q60 of 98

In a data governance policy hierarchy, which artifact provides the most detailed, step-by-step instructions for carrying out a specific data management task?

A. Data policy B. Data standard C. Data procedure D. Data guideline E. Data principle

Data Warehousing and Business Intelligence Q61 of 98

Which statement about conformed dimensions is TRUE?

A. Conformed dimensions are used in only one data mart and never shared B. Conformed dimensions must always be snowflaked C. Conformed dimensions cannot be used with SCD Type 2 D. Conformed dimensions are only relevant in Inmon's approach, not Kimball's E. Conformed dimensions have identical structure and content or are a strict mathematical subset when shared across multiple fact tables, enabling cross-process analysis

Data Governance Q62 of 98

An organization's Data Governance Council has been meeting for six months but has made little progress. Business leaders are disengaged and data quality issues persist. What is the MOST LIKELY root cause?

A. The wrong database technology was selected B. Lack of executive sponsorship and unclear accountability C. Too many data stewards were appointed D. The organization chose a federated model instead of centralized E. Data quality tools were not purchased

Master and Reference Data Management Q63 of 98

A data quality rule in the MDM system requires that every customer record must have a valid email address format. This is an example of which type of data quality dimension?

A. Completeness B. Timeliness C. Uniqueness D. Consistency E. Validity (conformity)

Data Modelling and Design Q64 of 98

SCD Type 3 handles slowly changing dimensions by doing what?

A. Creating a new row for each change with version numbering B. Adding a new column (e.g., 'previous_value') to store the prior value alongside the current value C. Overwriting the old value and logging the change in a separate audit table D. Partitioning the dimension table by effective date ranges E. Storing all historical values in a single JSON column

Data Modelling and Design Q65 of 98

Which notation uses rectangles for entities, diamonds for relationships, and ovals for attributes?

A. Crow's foot notation B. UML class diagram notation C. Chen notation D. Barker notation E. IDEF1X notation

Data Quality Q66 of 98

An organization discovers that 15% of customer address records have missing postal codes. Which data quality dimension is primarily affected?

A. Accuracy B. Completeness C. Consistency D. Uniqueness E. Validity

Data Warehousing and Business Intelligence Q67 of 98

OLAP operations include all of the following EXCEPT:

A. Drill-down (viewing more detail) B. Roll-up (aggregating to a higher level) C. Slice and dice (filtering dimensions) D. Normalization (removing data redundancy) E. Pivot (rotating the data view)

Metadata Management Q68 of 98

An organization discovers that its metadata is maintained manually and is frequently out of date. What is the BEST approach to improve metadata currency?

A. Hire more staff to update metadata manually B. Implement automated metadata harvesting from source systems and ETL processes C. Reduce the amount of metadata being captured D. Only update metadata during annual reviews E. Stop maintaining metadata altogether

Data Governance Q69 of 98

What is the recommended first step when launching a new data governance program?

A. Purchase data governance software tools B. Secure executive sponsorship and define the program vision and scope C. Hire a full team of data stewards immediately D. Create a complete metadata repository E. Conduct a full enterprise data audit

Data Quality Q70 of 98

Which activity involves examining data across multiple related tables to verify that foreign key relationships and cross-system references are valid?

A. Column profiling B. Cross-column profiling C. Cross-table profiling D. Data masking E. Data archiving

Data Governance Q71 of 98

In the DAMA-DMBOK framework, what is the primary distinction between a data owner and a data steward?

A. Data owners manage databases while data stewards manage applications B. Data owners are accountable for data assets while data stewards are responsible for day-to-day data management activities C. Data owners work in IT while data stewards work in business units D. Data owners define technical standards while data stewards enforce them E. Data owners handle external data while data stewards handle internal data

Data Warehousing and Business Intelligence Q72 of 98

Which of the following is an advantage of ELT over traditional ETL in modern cloud data warehouse architectures?

A. ELT always produces higher quality data B. ELT does not require any source system connectivity C. ELT leverages the scalable compute power of the cloud target system for transformations, eliminating the need for a separate transformation engine D. ELT eliminates the need for data governance E. ELT only works with unstructured data

Data Modelling and Design Q73 of 98

What is a factless fact table?

A. A fact table that stores only null values for all measures B. A fact table that captures events or conditions with no associated numeric measures C. A fact table with no foreign keys to dimension tables D. A temporary staging table used during ETL processing E. A fact table that stores only aggregated summary data

Data Ethics Q74 of 98

An organization wants to monetize its customer data ethically. Which combination of practices BEST supports ethical data monetization?

A. Anonymizing all data and selling it without notification since anonymized data is no longer personal B. Obtaining explicit consent, providing opt-out mechanisms, ensuring transparency about revenue sharing, and implementing robust de-identification C. Donating a portion of data monetization revenue to charity to offset ethical concerns D. Limiting data sales to trusted partners who agree not to re-identify individuals E. Only monetizing data from customers who have not opted out of the default data-sharing setting

Data Modelling and Design Q75 of 98

Which SCD type combines Type 1 (overwrite) and Type 2 (new row) to maintain both a current-value column and a historical record?

A. SCD Type 0 B. SCD Type 3 C. SCD Type 4 D. SCD Type 6 (Hybrid) E. SCD Type 5

Metadata Management Q76 of 98

Which of the following best describes the role of metadata in data mesh architecture?

A. Metadata is centralized in a single monolithic repository owned by the IT department B. Metadata is embedded as part of each domain's data product, with a federated computational governance layer ensuring interoperability across domains C. Metadata is eliminated to reduce overhead and increase domain autonomy D. Metadata is managed exclusively by a dedicated metadata team with no domain involvement E. Metadata is only relevant for the infrastructure platform team, not for domain teams

Metadata Management Q77 of 98

What is a controlled vocabulary in the context of metadata management?

A. A security mechanism that restricts who can create metadata B. A predefined, authorized list of terms used consistently for tagging, classifying, or describing data assets C. A programming language specifically designed for metadata applications D. A backup and recovery procedure for metadata repositories E. A performance tuning technique for metadata queries

Data Modelling and Design Q78 of 98

What characterizes First Normal Form (1NF)?

A. No transitive dependencies exist B. All non-key attributes depend on the entire primary key C. Each column contains atomic (indivisible) values and there are no repeating groups D. Every determinant is a candidate key E. All attributes are dependent on the primary key

Data Warehousing and Business Intelligence Q79 of 98

Which of the following is NOT one of the four properties of a data warehouse as defined by Bill Inmon?

A. Subject-oriented B. Real-time C. Integrated D. Time-variant E. Non-volatile

Data Warehousing and Business Intelligence Q80 of 98

SCD Type 1 handles dimension changes by:

A. Adding a new row and preserving history B. Creating a new dimension table for each change C. Storing both old and new values in the same row in separate columns D. Rejecting the change and keeping only the original value E. Overwriting the old value with the new value, losing all history of the previous value

Document and Content Management Q81 of 98

A government agency must ensure that digital records remain authentic, reliable, and accessible for 50 years or more. Which preservation strategy is MOST essential?

A. Storing documents on the highest-capacity hard drives available today B. Implementing format migration to current standards, maintaining comprehensive metadata, and conducting regular integrity checks with technology-independent archival formats C. Printing all digital records and storing the paper copies D. Relying on the original software vendor to maintain compatibility E. Compressing all records into a single archive file

Data Storage and Operations Q82 of 98

An SLA specifies 99.99% availability. How much maximum downtime does this allow per year?

A. Approximately 8.76 hours B. Approximately 52.6 minutes C. Approximately 5.26 minutes D. Approximately 5.26 hours E. Approximately 36.5 hours

Master and Reference Data Management Q83 of 98

What is a 'golden record' in MDM?

A. The oldest record in the database B. The single, authoritative, best version of a master data entity created by merging data from multiple sources C. A record that has been approved by management D. A backup copy of a master record E. A record flagged for deletion

Data Integration and Interoperability Q84 of 98

Which interoperability level is achieved when two systems can exchange data using the same format but may not agree on the meaning of the data?

A. Semantic interoperability B. Organizational interoperability C. Syntactic interoperability D. Full interoperability E. Process interoperability

Document and Content Management Q85 of 98

What is an ontology in the context of content and knowledge management?

A. A simple list of document file types B. A formal representation of knowledge that defines concepts, their properties, and the relationships between them in a machine-interpretable way C. A backup strategy for content repositories D. A physical filing system for paper documents E. A type of database index

Data Governance Q86 of 98

Which role is primarily responsible for implementing the technical infrastructure that supports data governance policies?

A. Business data steward B. Executive sponsor C. Data custodian D. Chief Data Officer E. Data governance coordinator

Data Quality Q87 of 98

An organization applies data quality rules at multiple points in their data pipeline. Where should the most stringent quality checks be placed to maximize their effectiveness?

A. Only at the final reporting layer B. Only at the data warehouse loading stage C. At the point of data creation or initial capture, with additional checks at major integration and transformation points D. Only during the annual data quality audit E. Only when users manually request a quality check

Master and Reference Data Management Q88 of 98

In the context of MDM, what is a 'data domain owner'?

A. The database administrator who manages physical storage B. The vendor who sold the MDM software C. A senior business stakeholder who is accountable for the quality and governance of a specific master data domain such as Customer or Product D. The IT architect who designed the data model E. The network administrator who controls data transfer speeds

Data Governance Q89 of 98

What is the primary purpose of a business glossary in a data governance program?

A. To store physical database schemas B. To provide agreed-upon definitions of business terms used across the organization C. To document application source code D. To track data governance project budgets E. To list all vendor contracts related to data

Metadata Management Q90 of 98

Which of the following is an example of technical metadata?

A. The business definition of 'Revenue' B. The data owner for Customer data C. The column data type, length, and nullable property in a database schema D. The business rule for calculating profit margin E. The data steward responsible for data quality

Data Security Q91 of 98

An organization is implementing data classification with four levels: Public, Internal, Confidential, and Restricted. Customer PII that includes financial data falls into which classification?

A. Public - because customers share this data voluntarily B. Internal - because it is used for internal business operations C. Confidential - because it contains personal information D. Restricted - because it contains both PII and financial data requiring the highest level of protection E. The classification depends on the file format

Data Governance Q92 of 98

When implementing a data governance framework for a global organization subject to GDPR, CCPA, and local privacy regulations, which approach best addresses regulatory compliance?

A. Apply the strictest regulation universally to all data regardless of jurisdiction B. Allow each region to independently manage compliance with no central coordination C. Implement a layered governance framework with global baseline policies and jurisdiction-specific extensions D. Focus only on the regulation that covers the largest customer base E. Delay governance implementation until all regulatory requirements are fully harmonized

Data Modelling and Design Q93 of 98

What does optionality in an entity-relationship model indicate?

A. The data type assigned to an attribute B. Whether participation in a relationship is mandatory or optional for an entity C. The indexing strategy for a table D. The order in which entities are created E. Whether an attribute is part of the primary key

Data Quality Q94 of 98

An e-commerce company wants to measure the cost of poor data quality (COPDQ). Which of the following would be the MOST significant cost category?

A. Cost of data profiling tools B. Cost of database storage for duplicate records C. Revenue lost from incorrect customer addresses causing failed deliveries D. Cost of training data stewards E. Cost of data governance council meetings

Metadata Management Q95 of 98

ISO 11179 is an international standard focused on which aspect of metadata?

A. Data warehouse performance benchmarking B. Registration and management of metadata data elements in a registry C. Network security protocols for metadata exchange D. Physical storage optimization for metadata repositories E. Machine learning model metadata tracking

Metadata Management Q96 of 98

Metadata lineage is best described as what?

A. The encryption method used to secure metadata in transit B. The tracking of data's origin, movement, and transformations as it flows through systems C. The access control list defining who can view metadata D. The version history of a metadata repository's software releases E. The organizational hierarchy of metadata stewards

Metadata Management Q97 of 98

Data lineage tracks which of the following?

A. Only where data is currently stored B. The complete path of data from origin through transformations to consumption points C. Only who has accessed the data D. Only the size and growth of data over time E. Only the quality score of data

Data Architecture Q98 of 98

What is a data flow diagram (DFD) primarily used to represent?

A. The physical network topology of servers B. How data moves between processes, data stores, and external entities C. The organizational hierarchy of data stewards D. Database table relationships and foreign keys E. Project timelines and milestones