Within projects, conceptual data modelling and logical data modelling are part of requirements planning and analysis activities, while physical data modelling is a design activity.
Data Standards used by the enterprise must:
Which of the following is a directive that codifies principles and management intent
into fundamental rules governing the creation, acquisition, integrity, security, quality,
and use of data and information?
Bias refers to an inclination of outlook. Please select the types of data bias:
Sustainable Data Governance depends on:
What are the three characteristics of effective Data Governance communication?
Two risks with the Matching process are:
The most important reason to implement operational data quality measurements is to inform data consumers about levels of data effectiveness.
Business rules describe why business should operate internally, in order to be successful and compliant with the outside world.
Integration of ETL data flows will usually be developed within tools specialised to manage those flows in a proprietary way.
What type of key is used in physical and sometimes logical relational data modelling schemes to represent a relationship?
'Planning, implementation and control activities for lifecycle management of data and
information, found in any form or medium', pertains to which knowledge area?
Deliverables in the data quality context diagram include:
Which of the following provides the strongest tangible reason for driving initiation of a Data Governance process in an enterprise?
What is the best definition of Crowdsourced data collection?
Drivers for data governance most often focus on reducing risk or improving processes. Please select the elements that relate to the improvement of processes:
Common OLAP operations include:
Confidentiality classification schemas might include two or more of the five confidentiality classification levels. Three correct classifications levels are:
Which of the following is not a step in the 'document and content management
lifecycle'?
A goal of data governance is to enable an organisation to manage its data as a liability.
A data architecture team is best described as:
Value is the difference between the cost of a thing and the benefit derived from that thing.
Data Governance is at the centre if the data management activities, since governance is required for consistency within and balance between functions.
Control activities to manage metadata stores include:
Type of Reference Data Changes include:
Big Data and Data Science Governance should address such data questions as:
CMA is an abbreviation for Capability Maturity Assessment.
The acronym BASE is made up of:
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.
SDLC stands for:
The operational data quality management procedures depend on the ability to measure and monitor the applicability of data.
The Belmont principles that may be adapted for Information Management disciplines, include:
Data Governance deliverables commonly include:
Data Fabric is:
Those responsible for the data-sharing environment have an obligation to downstream data consumers to provide high quality data.
Naming standards for data domains should:
Record management starts with a vague definition of what constitutes a record.
Please select the correct general cost and benefit categories that can be applied consistently within an organization.
The four main types of NoSQL databases are:
An implemented warehouse and its customer-facing BI tools is a technology product.
What are the primary drivers of data security activities?
Instant Messaging (IM) allows a user to message each other in real-time.
Which of the following answers best describes an Active Data Dictionary?
Malware types include:
Examples of data enhancement includes:
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.
SOA stands for:
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:
Controlling data availability requires management of user entitlements and of structures that technically control access based on entitlements.
Test environments serve many uses:
Examples of transformation in the ETL process onclude:
Characteristics that minimise distractions and maximise useful information include, but not limited to, consistent object attributes
Enterprise data architects in an application migration project are primarily concerned with:
An effective Data Governance communication program should include the following:
Service accounts are convenient because they can tailor enhanced access for the processes that use them.
Please select the two concepts that drive security restrictions:
The process of identifying how different records may relate to a single entity is called:
The target of organizational change is expedition.
In the Information Management Lifecycle, the Data Governance Activity "Define the Data Governance Framework" is considered in which Lifecycle stage?
Business people must be fully engaged in order to realize benefits from the advanced analytics.
Over a decade an organisation has rationalised implementation of party concepts
from 48 systems to 3. This is a result of good:
Veracity refers to how difficult the data is to use or to integrate.
Reduced risk is a benefit of high quality data.
Examples of business metadata include:
One of the first steps in a master data management program is to:
GDPR and PIPEDA are examples of:
Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies.
To build models, data modellers heavily rely on previous analysis and modelling work.
XML is the abbreviation for standard mark-up language.
What is the main purpose of developing a Data Architecture Roadmap?
Data Quality rules and standards are a form of data. To be effective, they need to be managed, as data and rules should be:
Data Warehouse describes the operational extract, cleansing, transformation, control and load processes that maintain the data in a data warehouse.
When assessing security risks it is required to evaluate each system for the following:
Consistent input data reduces the chance of errors in associating records. Preparation processes include:
Please select the types of DBA specializations:
Adoption of a Data Governance program is most likely to succeed:
An advantage of a centralized repository include: Quick metadata retrieval, since the repository and the query reside together.
The TOGAF framework does NOT include a(n):
E-discovery is the process of finding electronic records that might serve as evidence in a legal action.
A change management program supporting Data Governance should focus communication on what?
The dependencies of enterprise technology architecture are that it acts on specified data according to business requirements.
Assessment capabilities are evaluated against a pre-determined scale with established criteria. This is important because:
Big data primarily refers specifically to the volume of the data.
Data can be assessed based on whether it is required by:
Data Governance Office (DGO) focuses on enterprise-level data definitions and data management standards across all DAMA-DMBOK knowledge areas. Consists of coordinating data management roles.
Assessment criteria are broken into levels, and most capability maturity models use five (5) levels. This is important since:
Validity, as a dimension of data quality, refers to whether data values are consistent with a defined domain of values.
Business requirements is an input in the Data Warehouse and Business Intelligence context diagram.
Changes to reference data do not need to be management, only metadata should be managed.
Enterprise data architecture description must include both [1] as well as [2]
A goal of metadata management is to manage data related business terminology in
order toc
What is the final step in the development of a business-data-driven roadmap?
When assessing tools to implement master data management solutions, functionality
must include:
Security Risks include elements that can compromise a network and/or database.
Why is it so important to conduct a Data Governance Readiness Assessment?
Business Intelligence tool types include:
The number of entities in a relationship is the arity of the relationship. The most common are:
Change only requires change agents in special circumstances, especially when there is little to no adoption.
In a data warehouse, where the classification lists for organisation type are
inconsistent in different source systems, there is an indication that there is a lack of
focus on:
Please select the correct principles of the General Data Protection Regulation (GDPR) of the EU.
The Data Governance Council (DGC) manages data governance initiatives, issues, and escalations.
Data Storage and Operations: The design, implementation and support of stored data to maximize its value.
Which of the following is NOT a type of Data Steward?
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.
How can the Data Governance process best support Regulatory reporting requirements?
Data professional should not balance the short-term versus long-term business interests.
An input in the Metadata management context diagram does not include:
The standard for a strong password is set by the:
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?
Critical Data is most often used in
If data is a governed resource, like other resources (e.g., human resources, finance, property), how is Data Governance different from other types of Governance?
Data architect: A senior analyst responsible for data architecture and data integration.
The disclosure of sensitive addresses may occur through:
When constructing models and diagrams during formalisation of data architecture there are certain characteristics that minimise distractions and maximize useful information. Characteristics include:
When data is classified as either security data or regulatory data, the result will be:
Device security standard include:
Which of the following is NOT an objective of a business (data) glossary?
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.
What position should be responsible for leading the Data Governance Council (DGC)?
Key processing steps for MDM include:
Taxonomies can have different structures, including:
SBA is an abbreviation for service-based architecture.
ISO 8000 will describe the structure and organization of data quality management, including:
Within each area of consideration mentioned in question 13, they should address morale adversity as per Ethical Risk Model for Sampling Projects.
The business case for enterprise warehousing is:
An Operational Data Mart is a data mart focused on tactical decision support.
In matching, false positives are three references that do not represent the same entity are linked with a single identifier.
Content refers to the data and information inside a file, document or website.
Inputs in the data quality context diagram include:
Which model has one Data Governance organization coordinate with multiple Business Units to maintain consistent definitions and standards?
Data replication has two dimensions of scaling: diagonal and lateral
Deliverables in the Metadata Management context diagram include:
Data quality issues only emerge at initial stages of the data lifecycle.
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:
Examples of interaction models include:
Different types of product Master Data solutions include:
Examples of business processes when constructing data flow diagrams include:
Which Data Architecture Artifact describes how data transforms into business
assets?
The DW encompasses all components in the data staging and data presentation areas, including:
MPP is an abbreviation for Major Parallel Processing.
When doing reference data management, there many organizations that have standardized data sets that are incredibly valuable and should be subscribed to. Which of these organizations would be least useful?
Data models comprise and contain metadata essential to data consumers.
Data handling ethics are concerned with how to procure, store, manage, use and dispose of data in ways that are aligned with ethical principles.
Content management includes the systems for organizing information resources so that they can specially be stored.
Well prepared records have characteristics such as:
Data profiling examples include:
The need to manage data movement efficiently is a primary driver for Data Integration and Interoperability.
Why is the GDPR called the most important change in data and data privacy regulation in 20 years?
Access to data for Multidimensional databases use a variant of SQL called MDX or Multidimensional expression.
ANSI 859 recommends taking into account the following criteria when determining which control level applies to a data asset:
Volume refers to the amount of data. Big Data often has thousands of entities or elements in billions of records.
Organizations conduct capability maturity assessments for a number of reasons, including:
The deliverables in the data architecture context diagram include:
The flow of data in a data integration solution does not have to be designed and documented.
Which of these best describes the purpose of a Communications Plan in Data Governance?
All metadata management solutions include architectural layers including:
An application DBA leads the review and administration of procedural database objects.
On example of a transformation process in ETL is:
It is recommended that organizations not print their business data glossaries for general use, why would you not want to print the glossary?
Select three correct attributes a data governance programme must be:
Different types of metadata include:
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.
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.
Class operations can be:
Issues caused by data entry processes include:
The accuracy dimension has to do with the precision of data values.
Please select valid modelling schemes or notations
Big data management requires:
Reference and Master Data Management follow these guiding principles:
The independent updating of data into a system of reference is likely to cause:
There are three recovery types that provide guidelines for how quickly recovery takes place and what it focuses on.
Deliverables in the document and content management context diagram include:
Elements that point to differences between warehouses and operational systems include:
Barriers to effective management of data quality include:
An information maturity assessment provides a valuable input to Data Governance planning because it provides:
A database that is growing at 100% per annum compound will be:
In defining a Data Security Policy, what role should Data Governance play?
Real-time data integration is usually triggered by batch processing, such as historic data.
Which of the following is NOT required to effectively track data quality incidents?
A complexity in documenting data lineage is:
The difference between warehouses and operational systems do not include the following element:
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.
Change Data Capture is a method of reducing bandwidth by filtering to include only data that has been changed within a defined timeframe.
Reference and Master Data Management follow these guiding principles:
Data access control can be organized at an individual level or group level, depending on the need.
Achieving near-real-time data replication, using a source accumulation technique,
triggers on:
Data and text mining use a range of techniques, including:
A Global ID is the MDM solution-assigned and maintained unique identifier attached to reconciled records.
According to the DMBoK2, by creating Data Management Services, IT involves the Data Governance Council:
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.
A change management program supporting formal data governance should focus communication on:
Obtaining buy-in from all stakeholders
Please select the answer that does not represent a machine learning algorithm:
Data Fabric is:
Which of the following is NOT a goal of Data Quality?
Please select the correct name for the LDM abbreviation
Document and content management is defined as planning, implementation and control activities for storage management of data and information found in any form or medium.
Referential Integrity (RI) is often used to update tables without human intervention. Would this be a good idea for reference tables?
SPARC published their three-schema approach to database management. The three key components were:
The roles associated with enterprise data architecture are data architect, data modellers and data stewards.
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.
How can the Data Governance process in an organisation best support the requirements of various Regulatory reporting needs?
The Data Warehouse encompasses all components in the data staging and data presentation areas, including:
Emergency contact phone number would be found in which master data
management program?
When presenting a case for an organization wide Data Governance program to your Senior Executive Board, which of these potential benefits would be of LEAST importance?
There are several reasons to denormalize data. The first is to improve performance by:
Gathering and interpreting results from a DMM or Data Governance assessment are important because:
Which of the following is a Data Quality principle?
A primary business driver of data storage and operations is:
Time-based patterns are used when data values must be associated in chronological order and with specific time values.
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:
When developing a Data Governance operating framework, what areas should be considered?
High quality data definition exhibit three characteristics:
Please select the correct General Accepted Information Principles:
The purpose of enterprise application architecture is to describe the structure and functionality of applications in an enterprise.
Types of metadata include:
Data governance requires control mechanisms and procedures for, but not limited to, identifying, capturing, logging and updating actions.
Domains can be identified in different ways including: data type; data format; list; range; and rule-based.
Select the areas to consider when constructing an organization’s operating model:
The information governance maturity model describes the characteristics of the information governance and recordkeeping environment at five levels of maturity for each of the eight GARP principles. Please select the correct level descriptions:
Copyright © 2021-2025 CertsTopics. All Rights Reserved
