Exam 1 - In Progress

Data Modelling and Design Q1 of 98

What is a factless fact table?

A. A fact table that has been archived and contains no data B. A fact table that records events or relationships without any numeric measures C. A dimension table that has been misnamed D. A staging table used during ETL processing E. A fact table with all null values

Data Governance Q2 of 98

What is a Data Governance Charter?

A. A software tool for managing data B. A document defining the scope, goals, roles, authority, and principles of the governance program C. A database schema diagram D. A legal contract between data providers and consumers E. A technical architecture document

Data Governance Q3 of 98

What distinguishes a data policy from a data standard in the governance policy hierarchy?

A. Policies are optional while standards are mandatory B. Policies state high-level mandates and intent while standards define specific measurable requirements for compliance C. Policies are technical documents while standards are business documents D. Policies apply only to IT while standards apply to the entire organization E. Policies are updated annually while standards never change

Data Modelling and Design Q4 of 98

A Slowly Changing Dimension Type 2 (SCD Type 2) tracks changes by doing what?

A. Overwriting the old value with the new value B. Adding a new column for each change C. Creating a new row with effective date range and flagging the old row as expired D. Storing the change in a separate history table unrelated to the dimension E. Maintaining only the original and the most current value in two fixed columns

Data Integration and Interoperability Q5 of 98

What is data virtualization?

A. The process of encrypting data in virtual machines B. A technology that provides a unified view of data from multiple sources without physically moving or replicating the data C. The creation of virtual databases that store copies of production data D. A method for compressing data to reduce storage costs E. The process of converting physical servers to virtual servers

Document and Content Management Q6 of 98

An organization is subject to a legal hold for an ongoing lawsuit. A records manager discovers that some relevant emails were automatically deleted by the retention policy before the hold was applied. What is the MOST serious consequence?

A. The organization will need to purchase more storage B. The organization may face spoliation sanctions, including adverse inference instructions, fines, or case dismissal C. The email system will need to be upgraded D. The records manager will need additional training E. The retention policy must be permanently suspended

Data Quality Q7 of 98

Which of the following is a direct cost associated with poor data quality?

A. The cost of electricity to power data centers B. Rework costs from correcting errors in customer shipments caused by incorrect address data C. The purchase price of database management software D. Employee salaries for all IT staff E. Annual office rent for the IT department

Data Ethics Q8 of 98

COPPA (Children's Online Privacy Protection Act) specifically protects the data of children under what age?

A. 12 years old B. 13 years old C. 16 years old D. 18 years old E. 21 years old

Data Governance Q9 of 98

An organization at CMMI Level 2 wants to advance to Level 4 for data governance maturity. Which capability must they develop beyond Level 3?

A. Documenting governance processes B. Establishing a data governance council C. Using quantitative techniques to measure and control governance process performance D. Creating a business glossary E. Assigning data stewards to business domains

Master and Reference Data Management Q10 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 Warehousing and Business Intelligence Q11 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 Q12 of 98

An organization is selecting a data governance operating model. They have autonomous business units with distinct data domains, but need enterprise-wide consistency for regulatory reporting. Which model best fits this scenario?

A. Fully centralized model with a single governance authority B. Decentralized model with no enterprise coordination C. Federated model with central standards and distributed execution D. Outsourced model managed by a third-party vendor E. Ad hoc model allowing each unit complete autonomy

Data Modelling and Design Q13 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

Document and Content Management Q14 of 98

What is document imaging in content management?

A. Creating artistic visualizations of document data B. The process of converting physical paper documents into digital images through scanning C. Generating thumbnail previews of web pages D. Compressing digital photos for storage E. Printing digital documents to physical paper

Data Security Q15 of 98

During a data breach response, what is the CORRECT order of the incident response phases?

A. Eradication, Identification, Containment, Recovery, Lessons Learned B. Identification, Containment, Eradication, Recovery, Lessons Learned C. Containment, Recovery, Identification, Eradication, Lessons Learned D. Recovery, Identification, Containment, Eradication, Lessons Learned E. Lessons Learned, Identification, Containment, Eradication, Recovery

Data Storage and Operations Q16 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

Master and Reference Data Management Q17 of 98

Which of the following best describes the role of data matching in the MDM lifecycle?

A. Data matching creates new records that did not previously exist B. Data matching identifies records across or within source systems that likely refer to the same real-world entity so they can be linked or merged C. Data matching deletes all records that are not perfectly identical D. Data matching converts unstructured data into structured format E. Data matching generates synthetic test data for the MDM system

Data Architecture Q18 of 98

What is the logical data architecture primarily concerned with?

A. Defining specific database products and server configurations B. Defining data entities, attributes, relationships, and domains independent of specific technology C. Mapping data to physical storage devices and disk partitions D. Creating ETL job schedules and processing windows E. Specifying network protocols for data transmission

Data Governance Q19 of 98

A technical data steward's responsibilities differ from a business data steward primarily in which area?

A. Technical data stewards focus on the physical implementation and technical aspects of data management B. Technical data stewards define business rules and data requirements C. Technical data stewards report directly to the CEO D. Technical data stewards are responsible for setting data governance strategy E. Technical data stewards handle vendor contract negotiations

Data Governance Q20 of 98

What is the primary purpose of a data governance framework?

A. To specify database schema designs B. To provide a structured approach encompassing principles, policies, processes, roles, and tools for managing data as an enterprise asset C. To define network security protocols D. To create a project management methodology E. To establish software development coding standards

Master and Reference Data Management Q21 of 98

Employee records, supplier records, and product records are all commonly classified as:

A. Transaction data B. Metadata C. Master data D. Reference data E. Operational log data

Data Security Q22 of 98

What is tokenization?

A. A method of compressing data for storage B. Replacing sensitive data with non-sensitive substitute tokens that can be mapped back to the original C. Converting data into XML format D. Breaking data into smaller packets for transmission E. A type of database indexing

Data Modelling and Design Q23 of 98

A conceptual data model typically includes which of the following?

A. Table names, column data types, and indexes B. Major entities, key relationships, and high-level attributes C. Physical storage parameters and partitioning schemes D. ETL transformation rules E. SQL DDL statements

Metadata Management Q24 of 98

What is the difference between active metadata management and passive metadata management?

A. Active metadata is encrypted while passive metadata is not B. Active metadata management uses metadata to drive and automate processes in real time, while passive metadata management simply stores metadata for reference C. Active metadata is stored in the cloud while passive metadata is on-premises D. Active metadata is created by business users while passive metadata is created by IT E. There is no meaningful difference between the two approaches

Master and Reference Data Management Q25 of 98

Which of the following is TRUE about the relationship between data quality and MDM?

A. MDM eliminates the need for any data quality activities B. Data quality only matters for transactional data, not master data C. Data quality processes such as profiling, cleansing, standardization, and matching are fundamental to MDM success D. MDM tools always produce perfect quality data without any configuration E. Data quality should only be addressed after the MDM system is fully deployed

Data Warehousing and Business Intelligence Q26 of 98

A data warehouse is described as 'non-volatile.' This means:

A. The warehouse never stores any data permanently B. The warehouse can only store data for 24 hours C. Once data is loaded into the warehouse, it is stable and not frequently updated or deleted; new data is appended D. The warehouse automatically deletes data after each query E. The warehouse requires constant power to retain data

Metadata Management Q27 of 98

Which of the following is a characteristic of a well-designed metadata architecture?

A. It stores all metadata in unstructured text files with no indexing B. It supports multiple ingestion methods, provides a unified access layer, scales with the organization, and integrates with existing tools C. It requires all users to query metadata using raw SQL statements D. It operates independently with no connection to data governance processes E. It is designed to be rebuilt from scratch every fiscal year

Data Quality Q28 of 98

How does operational data quality differ from analytical data quality?

A. Operational DQ applies to transactional systems where data must be correct at the point of use, while analytical DQ applies to data warehouses and reporting where historical accuracy and consistency are paramount B. There is no meaningful difference between the two C. Operational DQ only applies to financial data while analytical DQ only applies to marketing data D. Operational DQ is measured quarterly while analytical DQ is measured in real-time E. Operational DQ focuses on data volume while analytical DQ focuses on data velocity

Data Modelling and Design Q29 of 98

In a graph data model, what are the fundamental building blocks?

A. Tables, columns, and rows B. Documents, collections, and indexes C. Nodes, edges, and properties D. Hubs, links, and satellites E. Dimensions, facts, and measures

Data Security Q30 of 98

An organization discovers a data breach affecting personal data of EU residents. Under GDPR, within what timeframe must they notify the supervisory authority?

A. Within 24 hours of discovery B. Within 72 hours of becoming aware of the breach C. Within 7 business days D. Within 30 calendar days E. Only if more than 1000 records are affected

Data Modelling and Design Q31 of 98

SCD Type 1 handles dimension changes by performing which action?

A. Inserting a new row with versioning metadata B. Overwriting the old value with the new value, losing history C. Adding a new column to hold the previous value D. Storing old and new values in a JSON array within the same column E. Moving the old record to an archive table before inserting the new one

Data Integration and Interoperability Q32 of 98

A message queue implementation guarantees that each message is delivered at least once. What additional consideration must the consuming application handle?

A. Message encryption B. Idempotent processing to handle potential duplicate messages C. Converting messages from XML to JSON D. Increasing network bandwidth E. Database schema changes

Data Modelling and Design Q33 of 98

In a graph data model, which traversal pattern is most efficient compared to a relational database approach?

A. Full table scans across a single large table B. Aggregations across millions of rows in a fact table C. Multi-hop relationship traversals such as finding friends-of-friends or shortest paths D. Batch loading of large volumes of flat-file data E. Running window functions over time-series data

Master and Reference Data Management Q34 of 98

An organization needs to map its internal industry classification codes to the NAICS (North American Industry Classification System) standard. This activity is BEST described as:

A. Master data deduplication B. Data warehouse dimensional modeling C. ETL pipeline development D. Reference data mapping and crosswalking between internal and external code sets E. Database schema normalization

Metadata Management Q35 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 Warehousing and Business Intelligence Q36 of 98

An organization wants to track how customer addresses change over time for regulatory reporting while also needing to easily identify each customer's current address for operational queries. Which SCD approach is MOST suitable?

A. SCD Type 0 (fixed, never changed) B. SCD Type 1 (overwrite only) C. SCD Type 3 (previous and current columns only, losing earlier history) D. SCD Type 2 (new rows with effective dates) combined with a current-record flag or view to simplify current-state queries E. Storing addresses only in the fact table as degenerate dimensions

Data Modelling and Design Q37 of 98

What is the difference between a star schema and a snowflake schema?

A. Star schemas use fact tables; snowflake schemas do not B. In a star schema, dimensions are denormalized; in a snowflake, dimensions are normalized C. Star schemas are for OLTP; snowflake schemas are for OLAP D. There is no structural difference; the terms are interchangeable E. Star schemas have more joins than snowflake schemas

Data Security Q38 of 98

What is the difference between data anonymization and pseudonymization?

A. They are the same technique with different names B. Anonymization irreversibly removes identifying information, while pseudonymization replaces identifiers with artificial ones that can potentially be re-linked C. Anonymization is for structured data only, pseudonymization is for unstructured data D. Pseudonymization provides stronger protection than anonymization E. Anonymization applies to databases, pseudonymization applies to files

Data Management Process Q39 of 98

The DAMA-DMBOK framework identifies how many knowledge areas (including Data Governance at the center)?

A. 7 B. 9 C. 11 D. 14 E. 15

Master and Reference Data Management Q40 of 98

An organization uses a survivorship rule that selects the most recently updated value from any source system for the customer email address field. This rule is an example of:

A. Source-priority survivorship B. Frequency-based survivorship C. Completeness-based survivorship D. Recency-based survivorship E. Manual override survivorship

Data Warehousing and Business Intelligence Q41 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

Document and Content Management Q42 of 98

An organization must migrate 5 million documents from a legacy ECM system to a new platform. Which aspect of the migration plan is MOST critical to address first?

A. Selecting the color scheme for the new platform's user interface B. Mapping and transforming content metadata, taxonomy structures, and security permissions to ensure completeness and compatibility C. Training end users on the new system before migration begins D. Archiving all documents to PDF before migration E. Purchasing the maximum storage capacity available

Data Quality Q43 of 98

What is the difference between data Accuracy and data Validity?

A. They are the same thing B. Accuracy means data conforms to format rules; Validity means data is correct in the real world C. Accuracy means data is correct in the real world; Validity means data conforms to defined formats and rules D. Accuracy applies only to numeric data; Validity applies only to text data E. Accuracy is a business concept; Validity is a technical concept

Metadata Management Q44 of 98

What is the difference between a metadata repository and a data catalog?

A. They are identical tools with different names B. A repository stores metadata models and instances; a catalog is a user-friendly discovery and search tool C. A catalog stores data; a repository stores metadata D. A repository is for business users; a catalog is for IT E. A catalog is always cloud-based; a repository is on-premises

Document and Content Management Q45 of 98

What distinguishes a controlled vocabulary from a thesaurus in content management?

A. A controlled vocabulary is digital while a thesaurus is physical B. A controlled vocabulary provides a predefined list of authorized terms, while a thesaurus adds relationships between terms such as broader, narrower, and related terms C. A thesaurus is simpler and less structured than a controlled vocabulary D. A controlled vocabulary is used for images and a thesaurus is used for text E. They are identical concepts with different names

Data Warehousing and Business Intelligence Q46 of 98

SCD Type 6 (also called Hybrid SCD) combines elements of which SCD types?

A. Type 0 and Type 1 B. Type 2 and Type 4 C. Type 1 and Type 4 D. Type 3 and Type 5 E. Type 1, Type 2, and Type 3

Master and Reference Data Management Q47 of 98

Which of the following characteristics BEST describes master data?

A. It is generated during business transactions and has a short lifecycle B. It changes every time a new transaction is processed C. It is only stored in a single application and never shared D. It is non-transactional, shared across the enterprise, and relatively stable over time E. It consists exclusively of external reference codes

Metadata Management Q48 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 Architecture Q49 of 98

What distinguishes a data lakehouse from a traditional data warehouse?

A. A lakehouse can only store structured data B. A lakehouse combines the flexibility of data lakes with the management and performance features of data warehouses C. A lakehouse requires all data to be pre-modeled before ingestion D. A lakehouse does not support ACID transactions E. A lakehouse is limited to batch processing only

Data Governance Q50 of 98

Which governance KPI best measures the effectiveness of data stewardship activities?

A. Total number of servers in the data center B. Percentage of identified data quality issues resolved within defined SLAs by data stewards C. Annual revenue of the organization D. Number of software licenses purchased E. Total data storage capacity utilized

Data Modelling and Design Q51 of 98

What is the primary advantage of using a surrogate key instead of a natural key?

A. Surrogate keys carry inherent business meaning B. Surrogate keys are system-generated, providing stability and independence from business changes C. Surrogate keys always require less storage than natural keys D. Surrogate keys eliminate the need for indexes E. Surrogate keys are only applicable in NoSQL databases

Data Integration and Interoperability Q52 of 98

Which data exchange format is MOST commonly used in modern REST APIs?

A. XML B. CSV C. JSON D. EDI E. EBCDIC

Data Quality Q53 of 98

What is column profiling?

A. Creating new columns in a database table B. Analyzing individual columns to understand data types, value distributions, patterns, null rates, and uniqueness statistics C. Renaming columns for better readability D. Dropping unused columns from a table E. Encrypting column values for security

Data Integration and Interoperability Q54 of 98

Change Data Capture (CDC) is a technique for:

A. Capturing all data from a source system on every load B. Identifying and capturing only the data that has changed since the last extraction C. Encrypting data during transfer D. Validating data quality during integration E. Managing database schema changes

Data Architecture Q55 of 98

Which level of data architecture defines entities and relationships without concern for technology or implementation?

A. Physical architecture B. Deployment architecture C. Conceptual architecture D. Logical architecture E. Infrastructure architecture

Metadata Management Q56 of 98

What is the key difference between a business glossary and a data dictionary?

A. A business glossary is only for IT staff while a data dictionary is for business users B. A business glossary defines business terms and concepts in natural language, while a data dictionary documents technical data element specifications such as data types and constraints C. A data dictionary contains no definitions, only data type information D. A business glossary can only be maintained in printed format E. A data dictionary replaces the need for a business glossary entirely

Metadata Management Q57 of 98

What is the primary distinction between a data catalog and a data dictionary?

A. A data catalog is only for unstructured data while a data dictionary is for structured data B. A data catalog provides a searchable inventory of data assets across an organization, while a data dictionary details the structure and definitions of specific data elements C. A data dictionary supports self-service discovery while a data catalog does not D. There is no distinction; the terms are always interchangeable E. A data catalog is a physical database, while a data dictionary is a logical document

Data Ethics Q58 of 98

What is the key distinction between data privacy and data ethics?

A. Privacy is about technology; ethics is about business strategy B. Privacy focuses on legal compliance with regulations; ethics considers broader moral principles beyond legal requirements C. Privacy applies only to healthcare data; ethics applies to all data D. There is no distinction; privacy and ethics are the same concept E. Privacy is a technical concern; ethics is a marketing concern

Data Modelling and Design Q59 of 98

What is a surrogate key?

A. A business-meaningful identifier like Social Security Number B. A system-generated, meaningless unique identifier (typically an integer sequence) C. A foreign key referencing another table D. A composite key made of multiple columns E. A key used only during data migration

Metadata Management Q60 of 98

Metadata interoperability across heterogeneous systems is best achieved through which approach?

A. Mandating that all systems use the same proprietary metadata format B. Adopting open metadata standards, common metamodels, and metadata exchange APIs to enable cross-platform integration C. Storing all metadata in a single monolithic relational database D. Restricting metadata access to only one team in the organization E. Eliminating metadata from legacy systems entirely

Data Warehousing and Business Intelligence Q61 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)

Data Architecture Q62 of 98

TOGAF stands for:

A. The Open Group Architecture Framework B. Technical Operations Governance and Framework C. Total Online Governance Architecture Format D. Technology Organization Growth and Function E. The Original General Architecture Format

Data Quality Q63 of 98

In Total Data Quality Management (TDQM), which principle distinguishes it from traditional data quality approaches?

A. It focuses exclusively on technical data validation rules B. It treats data as a product manufactured through an information production process, applying manufacturing quality principles to data management C. It eliminates the need for data profiling D. It relies solely on automated tools without human involvement E. It applies only to unstructured data

Master and Reference Data Management Q64 of 98

Probabilistic matching in MDM uses which approach to identify duplicate records?

A. Exact field-by-field comparison only B. Statistical similarity scoring to determine likelihood that records refer to the same entity C. Manual review of every record pair D. Timestamp comparison only E. Random sampling of records

Data Modelling and Design Q65 of 98

Which data modelling notation uses 'crow's foot' symbols to represent relationship cardinality?

A. Chen notation B. Information Engineering (IE) notation C. UML notation D. IDEF1X notation E. Barker notation

Data Architecture Q66 of 98

When designing a cloud data architecture, which pattern distributes data processing across multiple nodes to handle large-scale workloads?

A. Monolithic processing B. Single-threaded batch C. Massively parallel processing (MPP) D. Serial sequential processing E. Manual data partitioning

Document and Content Management Q67 of 98

What is content metadata, and why is it important?

A. The physical file size of a document B. Descriptive, structural, and administrative data about content that enables organization, discovery, management, and preservation C. The content itself in a different file format D. A security classification label only E. The URL where content is published

Document and Content Management Q68 of 98

What is a taxonomy in the context of content management?

A. A tax imposed on digital content B. A hierarchical classification scheme used to organize and categorize content C. A database query language D. A method for compressing documents E. A security protocol for document access

Master and Reference Data Management Q69 of 98

Party data in MDM typically encompasses which of the following?

A. Only customer records B. Only supplier and vendor records C. Transaction records between business partners D. Internal IT system configuration records E. Individuals and organizations that play roles in business relationships, including customers, suppliers, employees, and partners

Data Storage and Operations Q70 of 98

Which type of database index is MOST appropriate for columns frequently used in equality and range queries?

A. Full-text index B. B-tree index C. Bitmap index D. Spatial index E. Hash index

Data Warehousing and Business Intelligence Q71 of 98

In the context of BI tools, what is the purpose of a semantic layer?

A. To encrypt data in transit between the database and the BI tool B. To replace the data warehouse entirely C. To provide a business-friendly abstraction over the physical data model, mapping technical table and column names to business terms and predefined metrics D. To manage user authentication for the BI platform E. To schedule automated report distribution

Metadata Management Q72 of 98

What is operational metadata?

A. Metadata about database schema structures B. Metadata about business definitions and rules C. Metadata about data processing, including job schedules, run times, data freshness, and error logs D. Metadata about data security classifications E. Metadata about data model versions

Data Warehousing and Business Intelligence Q73 of 98

A role-playing dimension occurs when:

A. A single physical dimension table is referenced multiple times by the same fact table, each reference representing a different business role B. A dimension table is split across multiple databases C. A dimension is used in only one fact table D. Multiple unrelated dimension tables are merged into one E. A dimension table has no primary key

Data Storage and Operations Q74 of 98

What is the primary advantage of columnar databases over row-oriented databases for analytical workloads?

A. Columnar databases support more concurrent users B. Columnar databases read only the columns needed for a query and achieve better compression, making analytical aggregations significantly faster C. Columnar databases have better transaction processing capabilities D. Columnar databases require less disk space for OLTP workloads E. Columnar databases eliminate the need for indexing

Data Security Q75 of 98

What is the purpose of data classification in data security?

A. To determine the physical storage location of data B. To categorize data based on sensitivity level to apply appropriate security controls C. To organize data into alphabetical order D. To measure data quality metrics E. To assign data to specific database tables

Metadata Management Q76 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 Governance Q77 of 98

What is the relationship between data governance and data privacy?

A. They are completely unrelated disciplines B. Data governance provides the framework, policies, and controls within which data privacy requirements are implemented and enforced C. Data privacy replaces the need for data governance D. Data governance applies only to non-personal data E. Data privacy is managed exclusively by legal teams without governance involvement

Data Management Process Q78 of 98

In the DAMA Wheel diagram, which knowledge area is positioned at the center?

A. Data Architecture B. Data Quality C. Data Security D. Data Governance E. Metadata Management

Data Quality Q79 of 98

What does the data quality dimension of integrity measure?

A. Whether data values are encrypted B. Whether relationships between data elements are maintained correctly, including referential integrity between related datasets C. Whether data is stored on reliable hardware D. Whether data access is restricted to authorized users E. Whether data is backed up regularly

Data Storage and Operations Q80 of 98

Which type of backup captures only changes since the last FULL backup?

A. Full backup B. Incremental backup C. Differential backup D. Snapshot backup E. Mirror backup

Data Governance Q81 of 98

A large multinational organization wants to implement data governance. Business units operate autonomously but need to share data. Which operating model is MOST appropriate?

A. Centralized governance with a single authority B. Decentralized governance where each unit governs independently C. Federated governance with central standards and distributed execution D. No formal governance - let units self-manage E. Outsourced governance to a third-party vendor

Data Quality Q82 of 98

What is a data quality firewall?

A. A network security device that protects databases from hackers B. A set of data quality checks applied at data entry points or integration points to prevent poor-quality data from entering a system C. An encryption tool for protecting data at rest D. A data backup mechanism that preserves data quality states E. A physical barrier that separates production and test databases

Data Governance Q83 of 98

A Data Governance Council (DGC) is typically responsible for all of the following EXCEPT:

A. Approving data governance policies B. Resolving cross-domain data issues C. Writing ETL code for data integration D. Prioritizing governance initiatives E. Providing funding for data management programs

Data Integration and Interoperability Q84 of 98

What is a canonical data model?

A. A data model specific to one application B. A standard, common data model used as an intermediate format to reduce point-to-point mappings C. A model of canonical (religious) data D. A temporary model used only during data migration E. A model for unstructured data only

Data Warehousing and Business Intelligence Q85 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 Warehousing and Business Intelligence Q86 of 98

What is a conformed dimension?

A. A dimension that is shared and consistent across multiple fact tables or data marts B. A dimension that has been validated for data quality C. A dimension that has been compressed to save storage D. A dimension created specifically for one fact table only E. A dimension that contains only numeric values

Data Architecture Q87 of 98

An organization stores raw data in its original format for future analytics use cases that are not yet defined. Which architectural pattern does this BEST describe?

A. Data warehouse B. Data mart C. Data lake D. Operational data store E. Master data hub

Data Quality Q88 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

Metadata Management Q89 of 98

Which of the following best describes metadata search and discovery?

A. The process of encrypting metadata before it is stored B. The capability for users to find, explore, and understand available data assets through searchable metadata C. The deletion of orphaned metadata records D. The process of migrating metadata between different repositories E. The technique of compressing metadata for efficient storage

Data Integration and Interoperability Q90 of 98

A healthcare organization must integrate patient data from hospitals using HL7 FHIR and insurance claims data using X12 EDI. They need both syntactic and semantic interoperability. What approach is MOST effective?

A. Converting all data to CSV files for exchange B. Implementing a canonical data model with standard terminology mappings and transformation rules for each source format C. Allowing each system to use its own format and hoping users reconcile differences D. Replacing all systems with a single vendor solution E. Using only batch file transfers between systems

Data Quality Q91 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 Storage and Operations Q92 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

Data Quality Q93 of 98

When applying Six Sigma principles to data quality, what does a 'six sigma' level of quality correspond to in terms of defects?

A. No more than 50% defects B. No more than 10,000 defects per million opportunities C. No more than 3.4 defects per million opportunities D. No more than 1,000 defects per million opportunities E. Zero defects per million opportunities

Data Storage and Operations Q94 of 98

What is data archiving, and why is it performed?

A. Permanently deleting old data to free storage B. Moving infrequently accessed data to lower-cost storage while retaining it for compliance or historical reference C. Encrypting all data for security purposes D. Creating real-time replicas of production data E. Compressing data within the primary database

Data Quality Q95 of 98

When conducting a root cause analysis for a recurring data quality issue where customer names are frequently misspelled, which root cause category is most likely?

A. Hardware failure in the storage subsystem B. Process-related root causes such as lack of input validation, inadequate training, or absence of standardized data entry procedures C. Network latency between application servers D. Insufficient disk space on the database server E. Incompatible operating system versions

Master and Reference Data Management Q96 of 98

What is the difference between master data and reference data?

A. Master data is internal; reference data is always external B. Master data represents core business entities; reference data is standard sets of allowed values used for classification C. Master data changes frequently; reference data never changes D. They are the same thing with different names E. Master data is structured; reference data is unstructured

Data Governance Q97 of 98

When a data governance program encounters organizational resistance, which strategy is most effective for gaining buy-in?

A. Mandating compliance through punitive measures as the first action B. Demonstrating quick wins that show tangible business value from governance activities C. Ignoring resistance and proceeding with full implementation D. Eliminating all existing data management practices to start fresh E. Limiting governance to the IT department where resistance is typically lower

Data Security Q98 of 98

Which compliance standard specifically addresses the protection of credit card and payment data?

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