Improving data quality requires a strategy that accounts for the work that needs to be done and the way people will execute it.
- A . TRUE
- B . FALSE
A data governance strategy defines the scope and approach to governance efforts. Deliverables include:
- A . Charter
- B . Operating framework and accountabilities
- C . Implementation roadmap
- D . Plan for operational success
- E . All of the above
- F . None of the above
Data stewardship is the least common label to describe accountability and responsibility for data and processes to ensure effective control and use of data assets.
- A . TRUE
- B . FALSE
A hacker is a person who finds unknown operations and pathways within complex computer system. Hackers are only bad.
- A . TRUE
- B . FALSE
Orchestration is the term used to describe how multiple processes are organized and executed in a system.
- A . TRUE
- B . FALSE
A dimensional physical data model is usually a star schema, meaning there is one structure for each dimension.
- A . FALSE
- B . TRUE
Many people assume that most data quality issues are caused by data entry errors. A more sophisticated understanding recognizes that gaps in or execution of business and technical processes cause many more problems that mis-keying.
- A . TRUE
- B . FALSE
Sample value metrics for a data governance program include:
- A . Reduction of risk
- B . Improved efficiency in operations
- C . Effectiveness of education
- D . Achievements of goals and objectives
- E . Contributions to business objectives
- F . Effectiveness of communication
RACI is an acronym that is made up of the following terms.
- A . Control
- B . Responsible
- C . Accountable
- D . Informed
- E . Reliable
- F . Consulted
SLA Stands for:
- A . Service Level Agreement
- B . System Lifecycle Audit
- C . System Latitude Audit
- D . Service Lifecycle Audit
Different types of product Master Data solutions include:
- A . People Lifecycle Product Management (PLPM)
- B . Product data in Manufacturing Execution Systems (MES)
- C . None of the above
- D . Product Data in Enterprise Resource Planning (ERP)
- E . Product Lifecycle Management (PLM)
A business driver for Master Data Management program is managing data quality.
- A . TRUE
- B . FALSE
Please select the transition phases in Bridges’ Transition process:
- A . The neutral zone
- B . The new beginning
- C . The ending
- D . The transition
- E . The translation
- F . The game
The business glossary should capture business terms attributes such as:
- A . Lineage
- B . Utilization
- C . Common misunderstanding in terms
- D . System development
- E . Algorithms to supporting definitions
- F . All of the above
Use business rules to support Data Integration and Interoperability at various points, to:
- A . Direct the flow of data in the organization
- B . Monitor the organization’s operational data
- C . Software alerts when events are triggered
- D . Direct when to automatically trigger events and alerts
- E . Consistency in allocation event resources
- F . None of the above
Data professional should not balance the short-term versus long-term business interests.
- A . TRUE
- B . FALSE
Most document programs have policies related to:
- A . Scope and compliance audits
- B . Proper destruction of records
- C . Proper construction of records
- D . Identification and protection of vital records
- E . Partition tolerance
- F . All of the above
The Data Warehouse (DW) is a combination of three primary components: An integrated decision support database, related software programs and business intelligence reports.
- A . FALSE
- B . TRUE
Data lineage is useful to the development of the data governance strategy.
- A . TRUE
- B . FALSE
DAMA International’s Certified Data Management Professional (CDMP) certification required that data management professionals subscribe to a formal code of ethics, including an obligation to handle data ethically for the sake of society beyond the organization that employs them.
- A . TRUE
- B . FALSE
Functionality-focused requirements associated with a comprehensive metadata solution, include:
- A . Synchronization
- B . Structure
- C . None of the above
- D . History
- E . Volatility
- F . Access rights
While the focus of data quality improvement efforts is often on the prevention of errors, data quality can also be improved through some forms of data processing.
- A . TRUE
- B . FALSE
Valuation information, as an example of data enrichment, is for asset valuation, inventory and sale.
- A . TRUE
- B . FALSE
All metadata management solutions include architectural layers including:
- A . Metadata Quality Assurance Testing
- B . Metadata integration
- C . Metadata usage
- D . Metadata delivery
- E . Metadata control and management
- F . None of the above
An input in the Metadata management context diagram does not include:
- A . Business requirements
- B . Business metadata
- C . Technical metadata
- D . Metadata standards
- E . Process Metadata
A deliverable in the data architecture context diagram includes an implementation roadmap.
- A . TRUE
- B . FALSE
Location Master Data includes business party addresses and business party location, as well as facility addresses for locations owned by organizations.
- A . TRUE
- B . FALSE
Some ways to measure value of data include:
- A . Replacement cost
- B . Market value
- C . Selling Data
- D . Risk cost
- E . Identified opportunities
- F . All of the above
Match rules for different scenarios require different workflows, including:
- A . Consistency rules
- B . Duplicate identification match rules
- C . Match-merge rules
- D . Match-split rules
- E . Match-link rules
- F . All of the above
The IT security policy provides categories for individual application, database roles, user groups and information sensitivity.
- A . TRUE
- B . FALSE
Data profiling examples include:
- A . Counts of null
- B . Max/Min value
- C . Max/Min length
- D . Frequency distribution
- E . Data type and format
- F . None of the above
Information gaps represent enterprise liabilities with potentially profound impacts on operational effectiveness and profitability.
- A . TRUE
- B . FALSE
When constructing an organization’s operating model cultural factors must be taken into consideration.
- A . TRUE
- B . FALSE
What model is the highest level model within the enterprise data model?
- A . Logical model
- B . Physical model
- C . Conceptual model
- D . Subject Area model
Data Integration and Interoperability (DII) describes processes related to the movement and consolidation of data within and between data stores, applications and organizations.
- A . TRUE
- B . FALSE
Examples of concepts that can be standardized within the data architecture knowledge area include:
- A . Enterprise data models
- B . System naming conventions
- C . None of the above
- D . Data security standards
- E . Data quality rules
- F . Tool standards
Business metadata focuses largely on the content and condition of the data and includes details related to data governance.
- A . TRUE
- B . FALSE
Reference and Master Data Management follow these guiding principles:
- A . Quality
- B . Stewardship
- C . Authority
- D . Ownership
- E . Exclusivity
- F . Inclusivity
Self-service is a fundamental delivery channel in the BI portfolio.
- A . TRUE
- B . FALSE
The Shewhart chart contains the following elements:
- A . Plan
- B . Utilization
- C . Do
- D . Check
- E . Act
- F . All of the above
The warehouse has a set of storage areas, including:
- A . Staging area
- B . Data marts
- C . Consistent object attributes
- D . Operational data store (ODS)
- E . Cubes
- F . Central warehouse
Data quality management is a key capability of a data management practice and organization.
- A . TRUE
- B . FALSE
Data and text mining use a range of techniques, including:
- A . Profiling
- B . Application reduction
- C . Association
- D . Data reduction
- E . Clustering
- F . All of the above
Examples of technical metadata include:
- A . Column Properties
- B . Access permissions
- C . Internal
- D . Conceptual
- E . ETL job details
CMDB provide the capability to manage and maintain Metdata specifically related to the IT assets, the relationships among them, and contractual details of the assets.
- A . TRUE
- B . FALSE
Data Warehouse describes the operational extract, cleansing, transformation, control and load processes that maintain the data in a data warehouse.
- A . FALSE
- B . TRUE
Improving an organization’s ethical behaviour requires an informal Organizational Change Management (OCM) process.
- A . TRUE
- B . FALSE
Veracity refers to how difficult the data is to use or to integrate.
- A . TRUE
- B . FALSE
Please select the correct General Accepted Information Principles:
- A . Asset Principle
- B . Audit Principle
- C . Due Diligence Principle D. Going Concern Principle
- D . Ethical Principle
- E . All of the above
Corporate Information Factory (CIF) components include:
- A . Data marts
- B . Objectives
- C . Operational Reports
- D . Reduction of risk
- E . Staging Area
- F . Contributions to business objectives
Inputs in the data quality context diagram include:
- A . Data stores
- B . Data lakes
- C . Business requirements
- D . Data quality expectations
The data warehouse and marts differ from that in applications as the data is organized by subject rather than function.
- A . TRUE
- B . FALSE
A data dictionary is necessary to support the use of a DW.
- A . TRUE
- B . FALSE
Architects seek to design in a way that brings value to an organisation. To reach these goals, data architects define and maintain specifications that:
- A . Align data architecture with enterprise strategy and business architecture
- B . Provide a standard business vocabulary for data and components
- C . Outline high-level integrated designs to meet these requirements.
- D . Integrate with overall enterprise architecture roadmap
- E . Define the current state of data in the organization.
- F . Express strategic data requirements
A limitation of the centralized metadata repository approach is it may be less expensive.
- A . TRUE
- B . FALSE
Big data primarily refers specifically to the volume of the data.
- A . TRUE
- B . FALSE
The accuracy dimension has to do with the precision of data values.
- A . TRUE
- B . FALSE
BI tool types include:
- A . BPM
- B . Operational reporting
- C . Data lake extraction
- D . Diagnostic, self-service analytics
- E . Descriptive, self-service analytics
- F . Reduction of risk
The goals of Data Integration and Interoperability include:
- A . Provide data securely, with regulatory compliance, in the format and timeframe needed.
- B . Lower cost and complexity of managing solutions by developing shared models and interfaces.
- C . Managing the availability of data throughout the data lifecycle
- D . Provide the starting point for customizations, integration or even replacement of an application
- E . Identify meaningful events and automatically trigger alerts and actions.
- F . Support business intelligence, analytics, master data management and operational efficiency efforts.
The Belmont principles that may be adapted for Information Management disciplines, include:
- A . Respect for Persons
- B . Respect for Machines
- C . Beneficence
- D . Criminality
- E . Justice
Elements that point to differences between warehouses and operational systems include:
- A . Historical
- B . Data security standards
- C . Subject-orientated
- D . Non-volatile
- E . Data quality
- F . Integrated
Please select the correct general cost and benefit categories that can be applied consistently within an organization.
- A . Cost of erasing data from servers
- B . Cost of improving data
- C . What the data could be sold for
- D . Benefit of higher quality data
- E . Cost of replacing data if it were lost
- F . What competitors would pay for data
Please select correct term for the following sentence: An organization shall assign a senior executive to appropriate individuals, adopt policies and processes to guide staff and ensure program audibility.
- A . Principle of integrity
- B . Principle of availability
- C . Principle of retention
- D . Principle of accountability
Please select the answers that correctly describes where the costs of poor quality data comes from.
- A . Scrap and rework
- B . Organizational conflict
- C . High job satisfaction
- D . High productivity
- E . Reputational costs
- F . Compliance costs
The implementation of a Data Warehouse should follow guiding principles, including:
- A . Data Efficiency
- B . One size does not fit all
- C . Contracts
- D . Focus on the business goals
- E . Start with the end in mind
- F . Collaborate
A ‘Golden Record’ means that it is always a 100% complete and accurate representation of all entities within the organization.
- A . TRUE
- B . FALSE
Data quality issues cannot emerge at any point in the data lifecycle.
- A . FALSE
- B . TRUE
SSD is the abbreviation for Solid State Dimension.
- A . TRUE
- B . FALSE
Please select valid modelling schemes or notations
- A . NoSQL
- B . Dimensional
- C . Relational
- D . Object-orientated
- E . Fact-based
- F . Matrix-based
Consistent input data reduces the chance of errors in associating records. Preparation processes include:
- A . Standardization
- B . Enrichment CValidation
- C . Database management
Confirming and documenting understanding of different perspectives facilitate:
- A . Formalization
- B . Normalization
- C . Scope definition
- D . Knowledge retention/documentation
The first two steps in the data science process are:
- A . Define Big Data data strategy & Business Need(s)
- B . Choose Data Sources
- C . Develop Data Science Hypotheses and Mehods
- D . Acquire & Ingest Data source(s)
DBAs and database architects combine their knowledge of available tools with the business requirements in order to suggest the best possible application of technology to meet organizational goals.
- A . FALSE
- B . TRUE
A synonym for transformation in ETL is mapping. Mapping is the process of developing the lookup matrix from source to target structures, but not the result of the process.
- A . TRUE
- B . FALSE
Temporal aspects usually include:
- A . Valid time
- B . Transmitting time
- C . Transaction time
- D . Value time
Three data governance operating models types include:
- A . Centralized
- B . Decentralized
- C . Feathered
- D . Federated
- E . Replicated
- F . Duplicated
CMA is an abbreviation for Capability Maturity Assessment.
- A . TRUE
- B . FALSE
Business people must be fully engaged in order to realize benefits from the advanced analytics.
- A . TRUE
- B . FALSE
As an often-overlooked aspects of basic data movement architecture, Process controls include:
- A . Consistency logging
- B . Exception logs
- C . Database activity logs
- D . Alerts
- E . Exception logs
- F . All of the above
There are several reasons to denormalize data. The first is to improve performance by:
- A . Creating smaller copies of fata to reduce costly run-time calculations and/or table scans of large tables.
- B . None of the above
- C . Pre-calculating and sorting costly data calculations to avoid runt-time system resource competition.
- D . Making tables more readable when no foreign key exists
- E . Combining data from multiple other tables in advance to avoid costly run-time joins
- F . All of the above
Vulnerability is defined as:
- A . a patch in a system that allows it to be successfully unpatched and compromised.
- B . being highly data risk rated
- C . a strength in a system that allows external stakeholders to view data records.
- D . a weakness or defect in a system that allows it to be successfully attacked and compromised.
Data security issues, breaches and unwarranted restrictions on employee access to data cannot directly impact operational success.
- A . TRUE
- B . FALSE
Some document management systems have a module that may support different types of workflows such as:
- A . Quality Assurance Testing (QA)
- B . Manual workflows that indicate where the user send the document
- C . User Acceptance Testing (UAT)
- D . Dynamic rules that allow for different workflows based on content
- E . All of the above
- F . None of the above
Within the Data Handling Ethics Context Diagram a key deliverable is the Ethical Data Handling Strategy.
- A . TRUE
- B . FALSE
With reliable Metadata an organization does not know what data it has, what the data represents and how it moves through the systems, who has access to it, or what it means for the data to be of high quality.
- A . TRUE
- B . FALSE
The deliverables in the data architecture context diagram include:
- A . Data flows
- B . Enterprise data
- C . Implementation roadmap
- D . Data Value Chains
- E . None of the above
- F . All of the above
The primary goal of data management capability assessment is to evaluate the current state of critical data management activities in order to plan for improvement.
- A . TRUE
- B . FALSE
Master data management includes several basic steps, which include: Develop rules for accurately matching and merging entity instances.
- A . TRUE
- B . FALSE
The four main types of NoSQL databases are:
- A . Document
- B . Row-orientated
- C . Graph
- D . Strategic
- E . Key-value
- F . Column-orientated
The most common drivers for initiating a Mater Data Management Program are:
- A . Metadata insecurity
- B . Managing data quality
- C . Reducing risk
- D . Managing the costs of data integration
- E . Meeting organizational data requirements
- F . Reducing latency
The implementation of a Data Warehouse should follow these guiding principles:
- A . Managing performance of data assets
- B . Focus on the business goals
- C . Managing the availability of data throughout the data lifecycle
- D . Start with the end in mind
- E . Managing the performance of data transactions
- F . Collaborate
Data architect: A senior analyst responsible for data architecture and data integration.
- A . TRUE
- B . FALSE
A Data Management Maturity Assessment (DMMA) can be used to evaluate data management overall, or it can be used to focus on a single Knowledge Area or even a single process.
- A . TRUE
- B . FALSE
Key processing steps for MDM include:
- A . Data model management
- B . Data acquisition
- C . Data validation, standardization and enrichment
- D . Entity resolution
- E . Data sharing and stewardship
- F . None of the above
The database administrator (DBA) is the most established and the most widely adopted data professional role.
- A . TRUE
- B . FALSE
The operational data quality management procedures depend on the ability to measure and monitor the applicability of data.
- A . FALSE
- B . TRUE
Advantages if a centralized metadata repository include:
- A . Quick metadata retrieval
- B . None of the above
- C . Combining data from multiple other tables in advance to avoid costly run-time joins
- D . All of the above
- E . High availability
- F . Low latency, since it is independent of the source systems
A goal of a Reference and Master Data Management program include enabling master and reference data to be shared across enterprise functions and applications.
- A . FALSE
- B . TRUE
Data professionals involved in Business Intelligence, analytics and Data Science are often responsible for data that describes: who people are; what people do; where people live; and how people are treated. The data can be misused and counteract the principles underlying data ethics.
- A . FALSE
- B . TRUE
Small reference data value sets in the logical data model can be implemented in a physical model in three common ways:
- A . Create a matching separate code table
- B . Create a master shared code table
- C . None of the above
- D . Program integration by joining tables
- E . Embed rules or valid codes into the appropriate object’s definition.
- F . Roadmap Development