When data is classified as either security data or regulatory data, the result will be:
Structural Metadata describe srealtionships within and among resource and enables identification and retrieval.
When reviewing data access plans, sequential searching is slowing the database. One
way to fix this is:
In designing and building the database, the DBA should keep the following design principles in mind:
Access to data for Multidimensional databases use a variant of SQL called MDX or Multidimensional expression.
A weakness or defect in a system that allows it to be successfully attacked and
compromised is a:
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.
Data Warehouse describes the operational extract, cleansing, transformation, control and load processes that maintain the data in a data warehouse.
Lack of automated monitoring represents serious risks, including compliance risk.
An information maturity assessment provides a valuable input to Data Governance planning because it provides:
The accuracy dimension of data quality refers to the degree that data correctly respresents ‘real-life’ entities.
The purpose of data governance is to ensure that data is managed properly, according to policies and best practices. Data governance is focused on how decisions are made about data and how people and processes are expected to behave in relation to data.
All DMM and Data Governance assessments should identify its objectives and goals for improvement. This is important because:
A change management program supporting formal data governance should focus communication on:
Obtaining buy-in from all stakeholders
Malware refers to any infectious software created to damage, change or improperly access a computer or network.
Data governance requires control mechanisms and procedures for, but not limited to, assignment and tracking of action items.
The ISO 11179 Metadata registry, an international standard for representing Metadata in an organization, contains several sections related to data standards, including naming attributes and writing definitions.
Data flows map and document relationships between data and locations where global differences occur.
To push up the urgency level requires adding of the sources of complacency or increasing of their impact.
When assessing security risks it is required to evaluate each system for the following:
Please select correct term for the following sentence: Any collection of stored data regardless of structure or content. Some large databases refer to instances and schema.
Corrective actions are implemented after a problem has occurred and been detected.
What techniques should be used and taught to produce the required ethical data handling deliverables?
It is unwise to implement data quality checks to ensure that the copies of the attributes are correctly stored.
An organization can enhance its Data Governance program and thereby improve its approach to enterprise data management. This is important for the following reason:
In a SQL injection attack, a perpetrator inserts authorized database statements into a vulnerable SQL data channel, such as a stored procedure.
You are a reporting Data Analyst. A new Management Report has been requested. What is the most effective way to ensure you receive the appropriate data at the correct level of accuracy to meet the business need?
An advantage of a centralized repository include: High availability since it is independent of the source systems.
Drivers for data governance most often focus on reducing risk or improving processes. Please select the elements that relate to the improvement of processes:
How can the Data Governance process in an organisation best support the requirements of various Regulatory reporting needs?
Please select the answers that correctly describes the set of principles that recognizes salient features of data management and guide data management practice.
Your organization has many employees with official roles as data stewards and data custodians, but they don't seem to know exactly what they're supposed to be doing. Which of the following is most likely to be a root cause of this problem?
Different levels of policy are required to govern behavior to enterprise security. For example:
Quality Assurance Testing (QA) is used to test functionality against requirements.
Oversight for the appropriate handling of data falls under both Data Governance and Legal Counsel. What are they NOT required to do?
Which DMBok knowledge area is most likely responsible for a high percentage of
returned mail?
The database administrator (DBA) is the most established and the most widely adopted data professional role.
The first two steps of the Reference data Change request process, as prescribed DMBOk2, include:
Which of the following is not a step in the 'document and content management
lifecycle'?
There are numerous methods of implementing databases on the cloud. The most common are:
Factors that have shown to play a key role in the success in the success of effective data management organizations does not include:
When trying to integrate a large number of systems, the integration complexities can
be reduced by:
Primary deliverables of the Data Warehouse and Business Intelligence context diagram include:
Practitioners identify development of staff capability to be a primary concern of Data Governance. Why would this be a main concern?
The dependencies of enterprise technology architecture are that it acts on specified data according to business requirements.
Several global regulations have significant implications on data management practices. Examples include:
Information architecture is the process of creating structure for a body of information or content. It includes the following components:
Data Integration and Interoperability is dependent on these other areas of data management:
The number of entities in a relationship is the arity of the relationship. The most common are:
A goal of Data warehouse and business intelligence is to support and enable ineffective business analysis and decision making by knowledge workers.
Project that use personal data should have a disciplined approach to the use of that data. They should account for:
Data architect: A senior analyst responsible for data architecture and data integration.
It is recommended that organizations not print their business data glossaries for general use, why would you not want to print the glossary?
The flow of data in a data integration solution does not have to be designed and documented.
Please select the 2 frameworks that show high-level relationships that influence how an organization manages data.
A goal of metadata management is to manage data related business terminology in
order toc
Functionality-focused requirements associated with a comprehensive metadata solution, include:
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.
Content needs to be modular, structured, reusable and device and platform independent.
Data access control can be organized at an individual level or group level, depending on the need.
Decentralized informality can be made more formal through a documented series of connections and accountabilities via a RACI matrix.
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 data governance strategy defines the scope and approach to governance efforts. Deliverables include:
To build models, data modellers heavily rely on previous analysis and modelling work.
There are three basic approaches to implementing a Master Data hub environment, including:
Volume refers to the amount of data. Big Data often has thousands of entities or elements in billions of records.
The better an organization understands the lifecycle and lineage of its data, the better able it will be to manage its data. Please select correct implication of the focus of data management on the data lifecycle.
Governance ensures data is managed, but is not include the actual act of managing data.
Bias refers to an inclination of outlook. Please select the types of data bias:
Effective document management requires clear policies and procedures, especially regarding retention and disposal of records.
Communications are essential to the success of a DMM or Data Governance assessment. Communications are important because:
Architects seek to design in a way that brings value to an organisation. To reach these goals, data architects define and maintain specifications that:
Gathering and interpreting results from a DMM or Data Governance assessment are important because:
Please select the correct name for the PDM abbreviation when referring to modelling.
The categories of the Data Model Scorecard with the highest weightings include:
A deliverable in the data security context diagram is the data security architecture.
Organizations are legally required to protect privacy by identifying and protecting sensitive data. Who usually identifies the confidentiality schemes and identify which assets are confidential or restricted?
Data quality rules and standards are a critical form of Metadata. Ti be effective they need to be managed as Metadata. Rules include:
The load step of ETL is physically storing or presenting the results of the transformation in the target system.
Effective data management involves a set of complex, interrelated processes that enable an organisation to use its data to achieve strategic goals.
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].
The process of building architectural activities into projects also differ between methodologies. They include:
Data modelling tools are software that automate many of the tasks the data modeller performs.
Defining quality content requires understanding the context of its production and use, including:
Please select the answer that does not represent a machine learning algorithm:
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.
Product Master data can only focus on an organization’s internal product and services.
Data governance program must contribute to the organization by identifying and delivering on specific benefits.
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.
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.
Data Storage and Operations: The design, implementation and support of stored data to maximize its value.
An enterprise's organisation chart has multiple levels, each with a single reporting
line. This is an example of a:
Assessment capabilities are evaluated against a pre-determined scale with established criteria. This is important because:
In matching, false positives are three references that do not represent the same entity are linked with a single identifier.
Operational Metadata describes details of the processing and accessing of data. Which one is not an example:
A point to point interface architecture will, in general, have more or less interfa
formats than a service oriented architecture?
The data warehouse and marts differ from that in applications as the data is organized by subject rather than function.
The scope and focus of any data governance program depend on organizational needs, but most programs include:
The IT security policy provides categories for individual application, database roles, user groups and information sensitivity.
Every DMM and Data Governance assessment must define how the assessment team will interact with its subjects (after defining the subject/stakeholder list). This is important because:
Three classic implementation approaches that support Online Analytical Processing include:
Data Governance is at the centre if the data management activities, since governance is required for consistency within and balance between functions.
Data governance requires control mechanisms and procedures for, but not limited to, identifying, capturing, logging and updating actions.
Issue management is the process for identifying, quantifying, prioritizing and resolving data governance related issues, including:
Achieving security risk reduction in an organisation begins with developing what?
Development of goals, principles and policies derived from the data governance strategy will not guide the organization into the desired future state.
Please select the correct component pieces that form part of an Ethical Handling Strategy and Roadmap.
Data Integrity includes ideas associated with completeness, accuracy, and consistency.
Confidentiality classification schemas might include two or more of the five confidentiality classification levels. Three correct classifications levels are:
When recovering from multiple system failures, what is the biggest difficulty faced
by a DBA?
Confirming and documenting understanding of different perspectives facilitate:
ISO 8000 will describe the structure and the organization of data quality management, including:
Data governance requires control mechanisms and procedures for, but not limited to, facilitating subjective discussions where managers’ viewpoints are heard.
Business Intelligence, among other things, refer to the technology that supports this kind of analysis.
The advantage of a decentralised Data Governance model over a centralised model is:
The need to manage data movement efficiently is a primary driver for Data Integration and Interoperability.
Risk classifications describe the sensitivity of the data and the likelihood that it might be sought after for malicious purposes.
Integrating data security with document and content management knowledge areas.
guides the implementation of:
Data governance requires control mechanisms and procedures for, but not limited to, escalating issues to higher level of authority.
There are three recovery types that provide guidelines for how quickly recovery takes place and what it focuses on.
A database uses foreign keys from code tables for column values. This is a way of
implementing:
A goal of reference and master data is to provide authoritative source of reconciled and quality-assessed master and reference data.
Business rules describe why business should operate internally, in order to be successful and compliant with the outside world.
The load step of the ETL is physically storing or presenting the results of the transformation into the source system.
Field overloading: Unnecessary data duplication is often a result of poor data management.
Data security internal audits ensure data security and regulatory compliance policies are followed should be conducted regularly and consistently.
A goal of reference and master data management is for data to ensure shared data is:
CDMP | DMF-1220 Questions Answers | DMF-1220 Test Prep | Data Management Fundamentals Questions PDF | DMF-1220 Online Exam | DMF-1220 Practice Test | DMF-1220 PDF | DMF-1220 Test Questions | DMF-1220 Study Material | DMF-1220 Exam Preparation | DMF-1220 Valid Dumps | DMF-1220 Real Questions | CDMP DMF-1220 Exam Questions
TESTED 01 May 2025
