clapgeek logo
Once the most critical business needs and the data that supports them have been identified, the most important part of the data quality assessment is actually looking data, querying it to understand data content and relationships, and comparing actual data to rules and expectations.
Data Governance includes developing alignment of the data management approach with organizational touchpoints outside of the direct authority of the Chief Data Officer. Select the example of such a touchpoint.
The CAP theorem asserts that the distributed system cannot comply with all the parts of the ACID. A distributed system must instead trade-off between the following properties:
Following the rollout of a data issue process, there have been no issues recorded in the first month. The reason for this might be:
Please select the user that best describes the following description: Uses the business glossary to make architecture, systems design, and development decisions, and to conduct the impact analysis.
An image processing system captures, transforms and manages images of paper and electronic documents.
Data handling ethics are concerned with how to procure, store, manage, use and dispose of data in ways that are aligned with ethical principles.
Elements that point to differences between warehouses and operational systems include:
Data warehousing describes the operational extract, cleaning, transformation, control and load processes that maintain the data in a data warehouse.
A data warehouse deployment with multiple ETL, storage and querying tools often
suffers due to the lack of:
Gathering and interpreting results from a DMM or Data Governance assessment are important because:
Because Data Governance activities require coordination across functional areas, the DG program must establish an ___________ that defines accountabilities and intersections.
Data governance requires control mechanisms and procedures for, but not limited to, facilitating subjective discussions where managers’ viewpoints are heard.
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.
Uniqueness, as a dimension of data quality, states no entity exists more than once within the data set.
Corrective actions are implemented after a problem has occurred and been detected.
Data management professionals who understand formal change management will be more successful in bringing about changes that will help their organizations get more value from their data. To do so, it is important to understand:
Data flows map and document relationships between data and locations where global differences occur.
Changes to reference data do not need to be management, only metadata should be managed.
Effective document management requires clear policies and procedures, especially regarding retention and disposal of records.
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.
The term data quality refers to only the characteristics associated with high quality data.
Functionality-focused requirements associated with a comprehensive metadata solution, include:
Enterprise service buses (ESB) are the data integration solution for near real-time sharing of data between many systems, where the hub is a virtual concept of the standard format or the canonical model for sharing data in the organization.
Communications are essential to the success of a DMM or Data Governance assessment. Communications are important because:
Measuring the effects of change management on in five key areas including: Awareness of the need to change; Desire to participate and support the change; Knowledge about how to change; Ability to implement new skills and behaviors; and Reinforcement to keep the change in place.
The implementation of a Data Warehouse should follow guiding principles, including:
An advantage of a centralized repository include: High availability since it is independent of the source systems.
What techniques should be used and taught to produce the required ethical data handling deliverables?
Where does the ethical responsibility lie with respect to managing data to reduce risks of misrepresentation, misuse, or misunderstanding?
Business rules describe why business should operate internally, in order to be successful and compliant with the outside world.
Data architect: A senior analyst responsible for data architecture and data integration.
One of the deliverables in the Data Integration and Interoperability context diagram is:
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.
Data quality management is a key capability of a data management practice and organization.
In matching, false positives are three references that do not represent the same entity are linked with a single identifier.
Which of these best describes the purpose of a Communications Plan in Data Governance?
Practitioners identify development of staff capability to be a primary concern of Data Governance. Why would this be a main concern?
The independent updating of data into a system of reference is likely to cause:
The percentage of enterprise computers having the most recent security patch
installed is a metric of which knowledge area?
Reference and Master data definition: Managing shared data to meet organizational goals, reduce risks associated with data redundancy, ensure higher quality, and reduce the costs of data integration.
One of the percentages to measure success of a records management system implantation is the percentage of the identified corporate records declared as such and put under records control.
Data Management and Data Governance Maturity models require planning before implementation. Planning is important because:
Improving an organization’s ethical behaviour requires an informal Organizational Change Management (OCM) process.
Activities that drive the goals in the context diagram are classified into the following phases:
Data governance program must contribute to the organization by identifying and delivering on specific benefits.
Technical Metadata provides data about the technical data, the systems that store data, and the processes that move between systems.
Through similarity analysis, slight variation in data can be recognized and data values can be consolidated. Two basic approaches, which can be used together, are:
What are some of the business drivers for the ethical handling of data that Data Governance should satisfy?
What ISO standard defines characteristics that can be tested by any organisation in the data supply chain to objectively determine conformance of the data to this ISO standard.
Poorly managed Metadata leads to, among other, redundant data and data management processes.
An organization has a legitimate interest in commercializing data. So why is the economic value of data a core concept of data handling ethics?
The process of building architectural activities into projects also differ between methodologies. They include:
The library of Alexandria was one of the largest collection of books in the ancient
world. Which DMBoK knowledge area is most aligned with managing the collection?
The operational data quality management procedures depend on the ability to measure and monitor the applicability of data.
Product Master data can only focus on an organization’s internal product and services.
The CAP theorem states that at most two of the three properties: consistency, availability and partition tolerance can exist in any shared data system.
The process of identifying how different records may relate to a single entity is called:
Integrating data security with document and content management knowledge areas.
guides the implementation of:
A ‘Content Distribution Network’ supporting a multi-national website is likely to use:
When reviewing data access plans, sequential searching is slowing the database. One
way to fix this is:
You have completed analysis of a Data Governance issue in your organisation and have presented your findings to the executive management team. However, your findings are not greeted warmly and you find yourself being blamed for the continued existence of the issue. What is the most likely root cause for this?
Enterprise data architects in an application migration project are primarily concerned with:
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.
The most informal enterprise data model is the most detailed data architecture design document.
Release management is critical to batch development processes that grows new capabilities.
In an information management context, the short-term wins and goals often arise from the resolution of an identified problem.
Which of the following provides the strongest tangible reason for driving initiation of a Data Governance process in an enterprise?
Those responsible for the data-sharing environment have an obligation to downstream data consumers to provide high quality data.
The database administrator (DBA) is the most established and the most widely adopted data professional role.
Which statement best describes the relationship between documents and records?
Where is the best place to find the following metadata: database table names,
column names and indexes?
As part of its transformation, the organization must identify and respond to different kinds of roadblocks. Please select the answer that is not a roadblock:
Data governance requires control mechanisms and procedures for, but not limited to, assignment and tracking of action items.
To mitigate risks, implement a network-based audit appliance, which can address most of the weaknesses associated with the native audit tools. This kind of appliance has the following benefits:
An application DBA leads the review and administration of procedural database objects.
A content strategy should end with an inventory of current state and a gap assessment.
Characteristics that minimise distractions and maximise useful information include, but not limited to, consistent object attributes
Within the Data Handling Ethics Context Diagram a key deliverable is the Ethical Data Handling Strategy.
The most important reason to implement operational data quality measurements is to inform data consumers about levels of data effectiveness.
ISO 8000 will describe the structure and organization of data quality management, including:
A node is a group of computers hosting either processing or data as part of a distributed database.
Drivers for data governance most often focus on reducing risk or improving processes. Please select the elements that relate to the reduction in risk:
Normalisation is the process of applying rules in order to organise business complexity into stable data structures.
A project scope requires the collection, exchange, and reporting of data from multiple in-house custom systems. Documents gathered include business concepts, existing database schemas, XSDs, and reporting layouts. How many models of each layer of abstraction can be expected?
Data management organizational constructs include the following type of model.
Within each area of consideration mentioned in question 13, they should address morale adversity as per Ethical Risk Model for Sampling Projects.
Field overloading: Unnecessary data duplication is often a result of poor data management.
When trying to integrate a large number of systems, the integration complexities can
be reduced by:
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.
Considerations for whether to integrate two data stores should include all except
the:
Differentiating between data and information. Please select the correct answers based on the sentence below: Here is a marketing report for the last month [1]. It is based on data from our data warehouse[2]. Next month these results [3] will be used to generate our month-over-month performance measure [4].
Data security includes the planning, development and execution of security policies and procedures to provide authentication, authorisation, access and auditing of data and information assets.
Data Management maturity has many goals for accomplishment including having a positive effect on culture. This is important to a Data Governance program for the following reason:
Please select the correct definition of Data Management from the options below.
The flow of data in a data integration solution does not have to be designed and documented.
Data for Big Data ingestion can also be called the data lake. This needs to be carefully managed, or the data lake will become:
All data is of equal importance. Data quality management efforts should be spread between all the data in the organization.
The data warehouse and marts differ from that in applications as the data is organized by subject rather than function.
How can the Data Governance process best support Regulatory reporting requirements?
It is recommended that organizations not print their business data glossaries for general use, why would you not want to print the glossary?
The Data Warehouse (DW) is a combination of three primary components: An integrated decision support database, related software programs and business intelligence reports.
The Data Governance Council (DGC) manages data governance initiatives, issues, and escalations.
Change Data Capture is a method of reducing bandwidth by filtering to include only data that has been changed within a defined timeframe.
Business Intelligence, among other things, refer to the technology that supports this kind of analysis.
Most people who work with data know that it is possible to use data to misrepresent facts. Which of the following is NOT a way in which data is used to misrepresent facts?
Data Integration and Interoperability is dependent on these other areas of data management:
Data Integration and Interoperability (DII) describes processes related to the movement and consolidation of data within and between data stores, applications and organizations.
According to the DMBoK, Data Governance is central to Data Management. In practical terms, what other functions of Data Management are required to ensure that your Data Governance programme is successful?
Which Data Architecture artefact contains the names of key business entities, their
relationships, critical guiding business rules and critical attributes?
A goal of data governance is to enable an organisation to manage its data as a liability.
Master data management includes several basic steps, which include: Develop rules for accurately matching and merging entity instances.
The Zachman Framweork’s communication interrogative columns provides guidance on defining enterprise architecture. Please select answer(s) that is(are) coupled correctly:
Archiving is the process of moving data off immediately accessible storage media and onto media with lower retrieval performance.
Business people must be fully engaged in order to realize benefits from the advanced analytics.
Organizations should evaluate several maturity assessment models for data management, and for Data Governance, before adopting one or before developing a custom maturity assessment model because:
A catastrophic system failure due to processing attachments that are too large may
be solved by:
ISO 8000 will describe the structure and the organization of data quality management, including:
A goal of reference and master data management is for data to ensure shared data is:
A System of Reference is an authoritative system where data consumers can obtain reliable data to support transactions and analysis, even if the information did not originate in the system reference.
Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies.
The goal of Data Governance is to enable an organization to manage data as an asset. To achieve this overall goal, a DG program must be:
Issue management is the process for identifying, quantifying, prioritizing and resolving data governance related issues, including:
All DMM and Data Governance assessments should identify its objectives and goals for improvement. This is important because:
Communication should start later in the process as too many inputs will distort the vision.
Part of alignment includes developing organizational touchpoints for data governance work. Some examples of touchpoints include: Procurement and Contracts; Budget and Funding; Regulatory Compliance; and the SDLC framework.
Operational Metadata describes details of the processing and accessing of data. Which one is not an example:
Data governance requires control mechanisms and procedures for, but not limited to, identifying, capturing, logging and updating actions.
In gathering requirements for DW/BI projects, begin with the data goals and strategies first.
TESTED 16 Jun 2025