DMF-1220 Data Management Fundamentals Questions and Answers
Subtype absorption: The subtype entity attributes are included as nullable columns into a table representing the supertype entity
Top down' and "bottom up' data analysis and profiling is best done in concert
because:
In an information management context, the short-term wins and goals often arise from the resolution of an identified problem.
The data-vault is an object-orientated, time-based and uniquely linked set of normalized tables that support one or more functional areas of business.
When assessing tools to implement master data management solutions, functionality
must include:
When assessing security risks it is required to evaluate each system for the following:
Logical abstraction entities become separate objects in the physical database design using one of two methods.
Please select the correct component pieces that form part of an Ethical Handling Strategy and Roadmap.
The most informal enterprise data model is the most detailed data architecture design document.
A goal of Data warehouse and business intelligence is to support and enable ineffective business analysis and decision making by knowledge workers.
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:
Please select the correct principles of the General Data Protection Regulation (GDPR) of the EU.
Those responsible for the data-sharing environment have an obligation to downstream data consumers to provide high quality data.
Structural Metadata describe srealtionships within and among resource and enables identification and retrieval.
A data warehouse deployment with multiple ETL, storage and querying tools often
suffers due to the lack of:
A weakness or defect in a system that allows it to be successfully attacked and
compromised is a:
When we consider the DMBoK2 definition of Data Governance, and the various practitioner definitions that exist in the literature, what are some of the key elements of Data Governance?
Access to data for Multidimensional databases use a variant of SQL called MDX or Multidimensional expression.
The implementation of a Data Warehouse should follow guiding principles, including:
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:
A hacker is a person who finds unknown operations and pathways within complex computer system. Hackers are only bad.
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 load step of the ETL is physically storing or presenting the results of the transformation into the source system.
When starting a Data Governance initiative it is important to understand what the Business cannot achieve due to data issues because:
The need to manage data movement efficiently is a primary driver for Data Integration and Interoperability.
What are some of the business drivers for the ethical handling of data that Data Governance should satisfy?
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.
If the target system has more transformation capability than either the source or the intermediary application system, the order of processes may be switched to ELT – Extract Load Tranform.
All data is of equal importance. Data quality management efforts should be spread between all the data in the organization.
An advantage of a centralized repository include: Quick metadata retrieval, since the repository and the query reside together.
Data handling ethics are concerned with how to procure, store, manage, use and dispose of data in ways that are aligned with ethical principles.
Data Integration and Interoperability (DII) describes processes related to the movement and consolidation of data within and between data stores, applications and organizations.
The advantage of a decentralized data governance model over a centralized model is:
Data governance can be understood in terms of political governance. It includes the following three function types:
Functionality-focused requirements associated with a comprehensive metadata solution, include:
Communications are essential to the success of a DMM or Data Governance assessment. Communications are important because:
Operationality and interoperability depends on the data quality. In order to measure the efficiency of a repository the data quality needs to be:
The European Commission Article 29 Data Protection Working Party provides a set of criteria to evaluate anonymization methods. What do they recommend?
The creation of overly complex enterprise integration over time is often a symptom
of:
The process of building architectural activities into projects also differ between methodologies. They include:
When establishing an Organizational Change Management team, what responsibilities and skills should they possess?
In the Information Management Lifecycle, the Data Governance Activity "Define the Data Governance Framework" is considered in which Lifecycle stage?
Domains can be identified in different ways including: data type; data format; list; range; and rule-based.
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:
The Belmont principles that may be adapted for Information Management disciplines, include:
Data governance requires control mechanisms and procedures for, but not limited to, assignment and tracking of action items.
An image processing system captures, transforms and manages images of paper and electronic documents.
Please select the correct definition of Data Management from the options below.
In the Data Warehousing and Business Intelligence Context Diagram, a primary deliverable is the DW and BI Architecture.
There are three basic approaches to implementing a Master Data hub environment, including:
Various Regulations require evidence of clear data lineage and accuracy. How can we as data managers best serve our enterprises in achieving this goal?
Business activity information is one of the types of data that can be modelled.
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.
The database administrator (DBA) is the most established and the most widely adopted data professional role.
There are several reasons to denormalize data. The first is to improve performance by:
Data Quality rules and standards are a form of data. To be effective, they need to be managed, as data and rules should be:
Where is the best place to find the following metadata: database table names,
column names and indexes?
Media monitoring and text analysis are automated methods for retrieving insights from large unstructured or semi-structured data, such as transaction data, social media, blogs, and web news sites.
The implementation of a Data Warehouse should follow these guiding principles:
Repositories facilitate the collection, publishing and distribution of data in a centralized and possibly standardized way. Data is most often used to:
According to the DMBoK2, by creating Data Management Services, IT involves the Data Governance Council:
Characteristics that minimise distractions and maximise useful information include, but not limited to, consistent object attributes
A goal of data architecture is to identify data storage and processing requirements.
Issue management is the process for identifying, quantifying, prioritizing, and resolving Data Governance issues. Which of the following are areas where that issues might arise:
A goal of a Reference and Master Data Management program include enabling master and reference data to be shared across enterprise functions and applications.
Which of these best describes the purpose of a Communications Plan in Data Governance?
An enterprise's organisation chart has multiple levels, each with a single reporting
line. This is an example of a:
GDPR came into affect in May. 2018. What organization is responsible for awarding compliance certificates for organizations?
Which DMBok knowledge area is most likely responsible for a high percentage of
returned mail?
In the context of big data the Three V’s refer to: Volume, Velocity and Validity
A roadmap for enterprise data architecture describes the architecture’s 3 to 5-year development path. The roadmap should be guided by a data management maturity assessment.
An application DBA leads the review and administration of procedural database objects.
The difference between warehouses and operational systems do not include the following element:
When trying to integrate a large number of systems, the integration complexities can
be reduced by:
Data Governance is at the centre if the data management activities, since governance is required for consistency within and balance between functions.
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 advantage of a decentralised Data Governance model over a centralised model is:
Periodic archiving of transaction data from a production CRM system is critical for:
Because Data Governance activities require coordination across functional areas, the DG program must establish an ___________ that defines accountabilities and intersections.
The first two steps of the Reference data Change request process, as prescribed DMBOk2, include:
An organization will create an uncover valuable Metadata during the process of developing Data Integration and Interoperability solutions.
Effective data management involves a set of complex, interrelated processes that enable an organisation to use its data to achieve strategic goals.
Change Data Capture is a method of reducing bandwidth by filtering to include only data that has been changed within a defined timeframe.
Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies.
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.
Metadata is essential to the management of unstructured data as it id to the management of structured data.
Industry is struggling to distinguish the accountabilities of CDO and CIO. The definition of their responsibilities may specify parts of:
Information architecture is the process of creating structure for a body of information or content. It includes the following components:
Data Management and Data Governance Maturity models require planning before implementation. Planning is important because:
When constructing an organization’s operating model cultural factors must be taken into consideration.
Architecture is the fundamental organization of a system, embodied in its components, their relationships to each other and the environment and the principles governing its design and evolution.
The Data Warehouse encompasses all components in the data staging and data presentation areas, including:
When developing a Data Governance operating framework, what areas should be considered?
Service accounts are convenient because they can tailor enhanced access for the processes that use them.
Which of the following is NOT required to effectively track data quality incidents?
In gathering requirements for DW/BI projects, begin with the data goals and strategies first.
Data Management Professionals only work with the technical aspects related to data.
A point to point interface architecture will, in general, have more or less interfa
formats than a service oriented architecture?
The CAP theorem states that at most two of the three properties: consistency, availability and partition tolerance can exist in any shared data system.
There are three recovery types that provide guidelines for how quickly recovery takes place and what it focuses on.
Bold means doing something that might cause short term pain, not just something that looks good in a marketing email.
What techniques should be used and taught to produce the required ethical data handling deliverables?
A Global ID is the MDM solution-assigned and maintained unique identifier attached to reconciled records.
Assessment capabilities are evaluated against a pre-determined scale with established criteria. This is important because:
Valuation information, as an example of data enrichment, is for asset valuation, inventory and sale.
Some document management systems have a module that may support different types of workflows such as:
Decentralized informality can be made more formal through a documented series of connections and accountabilities via a RACI matrix.
Effectiveness metrics for a data governance programme includes: achievement of goals and objectives; extend stewards are using the relevant tools; effectiveness of communication; and effectiveness of education.
Achieving security risk reduction in an organisation begins with developing what?
What position is responsible for the quality and use of their organization’s data assets?
To understand and evaluate ethical use of data within the organization what principles should we base our decisions on?
Normalisation is the process of applying rules in order to organise business complexity into stable data structures.
A catastrophic system failure due to processing attachments that are too large may
be solved 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.
Examples of concepts that can be standardized within the data architecture knowledge area include:
The best preventative action to prevent poor quality data from entering an organisation include:
There are numerous methods of implementing databases on the cloud. The most common are:
Examples of the ‘Who’ entity category include: employee; patient; player; and suspect.
What areas should you consider when constructing an organization's Data Governance operating model?
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.
Small reference data value sets in the logical data model can be implemented in a physical model in three common ways:
Business Intelligence, among other things, refer to the technology that supports this kind of analysis.
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 asset valuation is the process of understanding and calculating the economic value of data to an organisation. Value comes when the economic benefit of using data outweighs the costs of acquiring and storing it, as
Improving data quality requires a strategy that accounts for the work that needs to be done and the way people will execute it.
Data professional should not balance the short-term versus long-term business interests.
In a global organization which must operate under many local jurisdictions, each with their own legislative and compliance laws, which type of Data Governance Operating Model Type would best apply?
PDF + Testing Engine
Testing Engine
PDF (Q&A)
