Exam 5 - In Progress

Data Warehousing and Business Intelligence Q1 of 98

The staging area in a data warehouse architecture serves which PRIMARY purpose?

A. Presenting data to end users for reporting B. Permanently storing all historical data C. Hosting the BI dashboard application D. Managing user authentication and authorization E. Providing temporary storage where data is extracted from sources before being transformed and loaded into the warehouse

Data Modelling and Design Q2 of 98

Which normal form specifically addresses the elimination of transitive dependencies?

A. First Normal Form (1NF) B. Second Normal Form (2NF) C. Third Normal Form (3NF) D. Boyce-Codd Normal Form (BCNF) E. Fourth Normal Form (4NF)

Data Governance Q3 of 98

A coordinating data steward discovers conflicting data quality rules between the finance and marketing departments for the same customer data element. What is the appropriate governance action?

A. Allow both departments to maintain their own rules independently B. Escalate to the Data Governance Council to establish an authoritative enterprise rule and document the resolution in the business glossary C. Default to whichever department's rule was created first D. Remove the data quality rules from both departments until a future review E. Assign the IT department to choose the technically simpler rule

Data Architecture Q4 of 98

Which Zachman Framework column answers the question 'How?' and focuses on processes?

A. What (Data) B. How (Function) C. Where (Network) D. Who (People) E. When (Time)

Master and Reference Data Management Q5 of 98

When implementing MDM in a Service-Oriented Architecture (SOA), master data is typically made available to consuming applications through:

A. Direct database connections from each application to the MDM hub database B. Batch file exports delivered weekly via FTP C. Manual data entry in each consuming application D. Standardized services and APIs that provide controlled access to the golden record E. Email distribution of master data spreadsheets

Data Quality Q6 of 98

An organization wants to establish Data Quality Service Level Agreements (SLAs). Which element is essential in a DQ SLA?

A. The physical location of database servers B. Defined quality thresholds, measurement methods, reporting frequency, and remediation procedures when thresholds are not met C. The programming language used to build applications D. The vendor brand of the data quality tool E. The color scheme of the data quality dashboard

Data Quality Q7 of 98

When designing a data quality monitoring dashboard, which approach provides the most actionable information for data stewards?

A. Displaying only a single aggregate quality score for the entire organization B. Showing quality metrics broken down by data domain, dimension, and severity with drill-down capability to individual rules and records C. Listing every individual data record that has any quality issue D. Showing only the count of total records in each database E. Displaying quality metrics updated only once per year

Data Security Q8 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

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

Document and Content Management Q10 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 Q11 of 98

Which data quality dimension measures whether data values correctly represent the real-world entities they describe?

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

Metadata Management Q12 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 Integration and Interoperability Q13 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 Q14 of 98

Which data quality tool capability automatically identifies and groups records that potentially represent the same real-world entity?

A. Data encryption B. Data matching and deduplication C. Data compression D. Data partitioning E. Data replication

Document and Content Management Q15 of 98

What is the difference between structured and unstructured content?

A. Structured content is digital and unstructured content is physical paper B. Structured content follows a defined schema or format, while unstructured content lacks a predefined data model (e.g., emails, documents, images) C. Structured content is always larger in file size D. Unstructured content is always stored in databases E. There is no meaningful difference between them

Data Modelling and Design Q16 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 Storage and Operations Q17 of 98

According to the CAP theorem, a distributed system can guarantee at most two of three properties. What are those three properties?

A. Consistency, Availability, Performance B. Consistency, Availability, Partition tolerance C. Capacity, Accuracy, Performance D. Compression, Availability, Persistence E. Consistency, Authentication, Partition tolerance

Metadata Management Q18 of 98

Which of the following is a benefit of maintaining a comprehensive data catalog?

A. It eliminates the need for any data security measures B. It enables data users to discover, understand, and trust available data assets more quickly C. It replaces all ETL processes D. It guarantees zero data quality issues in all source systems E. It automatically migrates data between databases

Metadata Management Q19 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 Storage and Operations Q20 of 98

Which type of database is BEST suited for storing and querying highly connected data with complex relationships?

A. Relational database B. Key-value store C. Columnar database D. Graph database E. Time-series database

Data Governance Q21 of 98

In a federated data governance model, what is the role of central governance in relation to business unit governance teams?

A. Central governance makes all decisions and business units simply execute B. Central governance has no authority and serves only as an advisory body C. Central governance sets enterprise standards, policies, and frameworks while business units implement and adapt them within their domains D. Central governance manages only technical data while business units manage business data E. Central governance operates independently with no interaction with business units

Metadata Management Q22 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

Data Ethics Q23 of 98

A company's AI hiring tool consistently ranks candidates from certain demographic groups lower. This is MOST likely an example of:

A. Data integration failure B. Algorithmic bias resulting from biased training data reflecting historical hiring discrimination C. Database performance issues D. Metadata management failure E. Normal statistical variation

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

Master and Reference Data Management Q25 of 98

Hierarchy management in MDM is important because:

A. It defines database table structures B. It manages parent-child relationships between entities, enabling roll-up reporting and organizational structuring C. It determines the order of ETL job execution D. It controls user access permissions E. It manages backup schedules

Document and Content Management Q26 of 98

What is a records retention policy?

A. A technical specification for database storage B. A policy defining how long different types of records must be kept and when they should be disposed of C. A method for encrypting confidential documents D. A process for backing up files to tape E. A user interface design guideline for document systems

Master and Reference Data Management Q27 of 98

In an MDM Coexistence architecture style, what happens when the golden record is updated in the hub?

A. Source systems are never updated; they remain independent B. All source systems are immediately replaced by the hub C. The hub is discarded and rebuilt from scratch D. Only the data warehouse receives the updated record E. The golden record is shared back to source systems through bidirectional synchronization

Data Quality Q28 of 98

Which approach to data quality focuses on preventing defects at the source rather than detecting and correcting them downstream?

A. Reactive data cleansing B. Post-hoc data correction C. Proactive data quality management with upstream controls and process improvements D. Periodic batch data repair E. End-of-month data reconciliation

Data Storage and Operations Q29 of 98

A database query that previously ran in 2 seconds now takes 45 seconds after the table grew from 1 million to 50 million rows. The query filters on a non-indexed column. What is the MOST likely cause and solution?

A. Network latency increased; upgrade the network B. The query requires a full table scan on 50 million rows; create an appropriate index on the filter column C. The database server needs more RAM; add memory D. The query syntax is incorrect; rewrite the SQL E. The table needs to be converted from relational to NoSQL

Master and Reference Data Management Q30 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 Q31 of 98

A metadata maturity model typically assesses an organization across which progression?

A. From on-premises infrastructure to fully cloud-based infrastructure B. From ad-hoc, siloed metadata practices to integrated, governed, and actively managed enterprise metadata C. From small data volumes to big data volumes D. From batch processing to real-time streaming exclusively E. From using open-source tools to using only commercial tools

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

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

Master and Reference Data Management Q34 of 98

When evaluating MDM data quality, which metric measures the extent to which master records are free from duplicate representations of the same real-world entity?

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

Master and Reference Data Management Q35 of 98

Survivorship rules in MDM determine:

A. How long data is retained before deletion B. Which source system's values 'win' when creating a golden record from multiple matched records C. Which users can access master data D. How records are backed up E. The order of data migration

Data Modelling and Design Q36 of 98

In Data Vault 2.0, what is the role of a Satellite table?

A. To store the unique business keys that identify each core business concept B. To capture the many-to-many relationships between Hub entities C. To hold descriptive attributes and their change history with load-date-based versioning D. To aggregate facts from multiple source systems for reporting E. To define the mapping between source system schemas and the vault schema

Document and Content Management Q37 of 98

What framework was established by AIIM (Association for Intelligent Information Management) that evolved the concept of ECM toward intelligent information management?

A. ITIL framework for IT service management B. The Intelligent Information Management (IIM) framework focusing on automating, digitizing, and transforming information processes C. The TOGAF framework for enterprise architecture D. The COBIT framework for IT governance E. The Six Sigma framework for process improvement

Metadata Management Q38 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

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

Document and Content Management Q40 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 Management Process Q41 of 98

According to DAMA-DMBOK2, which environmental factor has the GREATEST influence on an organization's data management practices?

A. The programming languages used by the IT department B. The organization's culture and readiness for change C. The number of database administrators on staff D. The vendor of the organization's ERP system E. The geographic location of the data center

Data Quality Q42 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 Warehousing and Business Intelligence Q43 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 Integration and Interoperability Q44 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

Data Warehousing and Business Intelligence Q45 of 98

Self-service BI enables:

A. Only IT staff to create and modify reports B. Automated replacement of all data analysts C. Business users to independently create reports, dashboards, and perform ad-hoc analysis without relying on IT for each request D. Elimination of data governance requirements E. Automatic data warehouse design without human input

Document and Content Management Q46 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 Architecture Q47 of 98

What is architecture governance in the context of data management?

A. The process of selecting database vendors B. The practice of monitoring, controlling, and ensuring compliance with architecture standards and principles C. A software tool for generating architecture diagrams D. The process of migrating data between systems E. A method for encrypting sensitive data at rest

Data Management Process Q48 of 98

In a typical data management maturity model, what characterizes the 'Defined' level (Level 3)?

A. Processes are ad-hoc and chaotic B. Basic processes exist but are not standardized C. Processes are documented, standardized, and integrated into standard business practices D. Processes are measured and controlled using metrics E. Processes are continuously optimized through innovation

Data Modelling and Design Q49 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 Governance Q50 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

Metadata Management Q51 of 98

The Common Warehouse Metamodel (CWM) is a standard primarily concerned with what?

A. Defining user interface standards for data catalog applications B. Providing a standardized metamodel for metadata interchange between data warehousing and business intelligence tools C. Specifying physical hardware requirements for metadata repositories D. Defining encryption standards for metadata at rest E. Establishing project management methodologies for metadata initiatives

Data Governance Q52 of 98

Which governance metric most directly measures the adoption and effectiveness of data governance policies across business units?

A. Number of databases in production B. IT infrastructure uptime percentage C. Percentage of data domains with assigned stewards and documented policies D. Total number of employees trained in cybersecurity E. Annual IT budget allocation

Data Modelling and Design Q53 of 98

Which data model level is most concerned with how data will be physically stored in a database management system?

A. Conceptual data model B. Logical data model C. Physical data model D. Enterprise data model E. External data model

Data Quality Q54 of 98

Which of the following is an example of a data quality SLA (Service Level Agreement)?

A. The database must be available 99.9% of the time B. Customer email addresses must be valid for at least 98% of records C. ETL jobs must complete within 4 hours D. Backup must be taken every 24 hours E. Reports must be generated within 10 seconds

Data Ethics Q55 of 98

An insurance company uses a predictive model to set premiums. The model does not directly use race as an input, but uses zip code and education level, which are strongly correlated with race. This results in systematically higher premiums for minority communities. Which ethical concept BEST describes this problem?

A. Direct discrimination B. Proxy discrimination and disparate impact C. Regulatory non-compliance D. Data breach E. Consent violation

Data Architecture Q56 of 98

A financial services company has strict data residency requirements, real-time analytics needs, and multiple business units with autonomous data teams. Which combination of architecture patterns would BEST address these requirements?

A. Single centralized data lake with batch ETL B. Data mesh with federated governance and region-specific data products C. Point-to-point integrations between all business units D. A single on-premises data warehouse with nightly loads E. An operational data store with no analytical capability

Data Security Q57 of 98

Which type of insider threat is the MOST difficult to detect and prevent using traditional security controls?

A. A terminated employee whose access was not revoked B. A malicious insider with legitimate access who intentionally exfiltrates data within normal usage patterns C. An employee who accidentally emails sensitive data to the wrong recipient D. A contractor who uses a shared password E. An employee who installs unauthorized software

Data Integration and Interoperability Q58 of 98

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

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

Metadata Management Q59 of 98

What is the primary purpose of a business glossary?

A. To list all database tables and their column-level technical specifications B. To provide standardized business term definitions that promote a common understanding across the organization C. To document ETL job schedules and dependencies D. To track data quality scores for each data element E. To store the physical deployment topology of data systems

Master and Reference Data Management Q60 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 Security Q61 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

Data Governance Q62 of 98

A data governance program needs to manage the escalation of data-related issues. Which escalation path is considered a best practice?

A. All issues go directly to the CEO for resolution B. Issues are escalated from data stewards to domain leads, then to the Data Governance Council, and finally to executive leadership C. Issues are only escalated if they involve financial loss exceeding a set threshold D. Data stewards resolve all issues independently without escalation E. Issues are escalated only through the IT help desk

Data Governance Q63 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

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

Data Modelling and Design Q65 of 98

Anchor Modeling differs from traditional dimensional modeling primarily by providing what characteristic?

A. It eliminates the need for any surrogate keys B. It uses a highly normalized, decomposed structure where each attribute is stored in its own table to support non-destructive schema evolution C. It requires all data to be stored in a single denormalized wide table D. It mandates the use of graph databases for all implementations E. It stores only aggregate-level data and discards transactional detail

Data Integration and Interoperability Q66 of 98

When implementing CDC using log-based capture, what is the primary advantage over trigger-based CDC?

A. Log-based CDC is simpler to configure B. Log-based CDC has minimal impact on source system performance because it reads from transaction logs without modifying the source database C. Log-based CDC captures more data types D. Log-based CDC does not require network connectivity E. Log-based CDC works only with NoSQL databases

Data Modelling and Design Q67 of 98

What are the three levels of data modelling in the three-schema architecture?

A. Abstract, Detailed, Implemented B. Conceptual, Logical, Physical C. High-level, Mid-level, Low-level D. Business, Application, Database E. Strategic, Tactical, Operational

Data Modelling and Design Q68 of 98

What is a junk dimension in Kimball dimensional modeling?

A. A dimension that stores orphaned foreign key values B. A single dimension table that combines miscellaneous low-cardinality flags and indicators C. A dimension that holds invalid or rejected data records D. A temporary dimension used only during initial data warehouse loading E. A dimension containing only default or placeholder values

Data Storage and Operations Q69 of 98

The CAP theorem states that a distributed database system can guarantee at most TWO of which three properties?

A. Consistency, Availability, Partition tolerance B. Cost, Accuracy, Performance C. Capacity, Automation, Parallelism D. Compression, Authentication, Processing E. Caching, Archival, Provisioning

Master and Reference Data Management Q70 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 Modelling and Design Q71 of 98

A junk dimension is BEST described as:

A. A dimension containing obsolete or deleted data B. A dimension that combines miscellaneous, low-cardinality flags and indicators into a single table C. A dimension table with poor data quality D. A temporary dimension used during ETL processing E. A dimension that is no longer used in any queries

Data Modelling and Design Q72 of 98

In the Kimball dimensional modeling approach, what does a fact table primarily contain?

A. Descriptive attributes about business entities B. Hierarchical organizational structures C. Quantitative measurements of business processes D. Reference data and lookup values E. Metadata about the data warehouse schema

Data Governance Q73 of 98

In a data governance organizational structure, what is the primary function of a Data Governance Office (DGO)?

A. To develop application software B. To serve as the operational arm that coordinates and supports governance activities across the enterprise C. To perform hardware maintenance D. To conduct financial audits E. To manage external vendor relationships exclusively

Metadata Management Q74 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 Storage and Operations Q75 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 Architecture Q76 of 98

In TOGAF ADM, what is the key deliverable of the data architecture portion of Phase C that serves as the foundation for subsequent phases?

A. A complete physical database schema B. A data architecture document including data entity/data component catalog, data dissemination diagrams, and conceptual/logical data diagrams C. A list of all database vendors evaluated D. An ETL job specification for data warehouse loading E. A project budget for data infrastructure

Metadata Management Q77 of 98

Which type of metadata describes data in business terms, such as definitions, rules, and policies?

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

Data Governance Q78 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

Master and Reference Data Management Q79 of 98

ISO 3166 (country codes) and ISO 4217 (currency codes) are examples of standards that govern which type of data?

A. Master data B. Transactional data C. Metadata D. Unstructured data E. Reference data

Data Warehousing and Business Intelligence Q80 of 98

A data lakehouse architecture combines characteristics of data lakes and data warehouses. Which combination of features BEST describes a lakehouse?

A. File-based storage with no query capabilities B. Traditional relational database with added support for image files C. A cloud-only OLTP system with real-time transaction processing D. Open file formats and low-cost storage of a data lake combined with ACID transactions, schema enforcement, and SQL query performance of a data warehouse E. A data lake with a separate data warehouse that share no common components

Data Warehousing and Business Intelligence Q81 of 98

In the Inmon approach to data warehousing, the Enterprise Data Warehouse (EDW) is designed using which modeling technique?

A. Star schema with denormalized dimensions B. Flat files with no relational structure C. Object-oriented models D. Graph database models E. Third Normal Form (3NF) with normalized, entity-relationship models

Data Architecture Q82 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

Data Security Q83 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 Architecture Q84 of 98

Which integration pattern BEST reduces coupling between systems while enabling data exchange?

A. Point-to-point integration B. Shared database C. Event-driven architecture with a message bus D. File transfer via shared folders E. Direct database links

Metadata Management Q85 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 Governance Q86 of 98

Which of the following best describes the role of an executive sponsor in a data governance program?

A. Writing data quality rules and validation scripts B. Providing senior leadership support, funding, and organizational authority for the program C. Performing daily data stewardship tasks D. Managing database administration activities E. Conducting data profiling and analysis

Data Governance Q87 of 98

A Chief Data Officer discovers that multiple departments define 'customer' differently, causing inconsistent reporting. What governance mechanism should be prioritized to resolve this?

A. Purchasing a new reporting tool B. Establishing canonical data definitions in an enterprise business glossary C. Restricting access to customer data D. Hiring additional database administrators E. Outsourcing data management to a third party

Data Security Q88 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 Integration and Interoperability Q89 of 98

In a Service-Oriented Architecture (SOA), what is the purpose of an Enterprise Service Bus (ESB)?

A. To store all enterprise data in a central database B. To provide a communication backbone that routes, transforms, and mediates messages between services C. To replace all web servers with a single application D. To manage user authentication exclusively E. To serve as the organization's primary data warehouse

Data Quality Q90 of 98

An organization estimates that poor data quality costs them $5 million annually in operational inefficiencies, customer churn, and regulatory penalties. This measurement is best described as which concept?

A. Data governance maturity score B. Cost of poor data quality (COPDQ) C. Total cost of ownership for data infrastructure D. Data storage cost per gigabyte E. Information technology depreciation expense

Data Governance Q91 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

Data Warehousing and Business Intelligence Q92 of 98

In a dimensional model, the grain of a fact table defines:

A. The physical storage size of the table B. The number of columns in the table C. The data retention period D. The compression algorithm used E. The level of detail represented by each row in the fact table, specifying exactly what a single fact row measures

Data Quality Q93 of 98

What is the primary purpose of data profiling in a data quality program?

A. To permanently delete duplicate records B. To examine data and collect statistics to understand its structure, content, quality, and relationships C. To encrypt sensitive data fields D. To migrate data to a new database platform E. To create backup copies of production data

Data Integration and Interoperability Q94 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 Security Q95 of 98

What does IAM stand for in data security, and what is its primary function?

A. Internet Application Management - managing web applications B. Identity and Access Management - managing user identities, authentication, and authorization C. Integrated Audit Monitoring - tracking system changes D. Information Architecture Mapping - designing data structures E. Incident Alert Management - handling security incidents

Data Modelling and Design Q96 of 98

What is the key characteristic of an accumulating snapshot fact table?

A. It records one row per individual business transaction B. It takes a periodic snapshot at regular intervals and never updates rows C. It tracks a process with a defined beginning and end, updating the same row as milestones are reached D. It contains no measurable facts, only foreign keys E. It aggregates data from multiple transactional fact tables

Data Warehousing and Business Intelligence Q97 of 98

A Slowly Changing Dimension Type 2 (SCD Type 2) preserves history by:

A. Overwriting the old value with the new value B. Storing the change in a separate audit log table only C. Adding a new row with the new values and marking the old row as expired using effective dates or a current flag D. Deleting the old row and inserting a new row with no link between them E. Appending the new value to the existing row in a delimited field

Master and Reference Data Management Q98 of 98

An organization wants to implement MDM but cannot modify existing source systems. Which MDM architecture style is MOST appropriate?

A. Centralized (Transaction Hub) - all CRUD through the hub B. Registry - maintain an index/pointers to records in source systems C. Coexistence - bidirectional synchronization between hub and sources D. Consolidation - copy all data to a central hub E. Replace all source systems with a single system