Month End Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

DAMA DMF-1220 Data Management Fundamentals Exam Practice Test

Demo: 199 questions
Total 666 questions

Data Management Fundamentals Questions and Answers

Question 1

Examples of the ‘Who’ entity category include: employee; patient; player; and suspect.

Options:

A.

TRUE

B.

FALSE

Question 2

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.

Options:

A.

FALSE

B.

TRUE

Question 3

The most common drivers for initiating a Mater Data Management Program are:

Options:

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

Question 4

Information gaps represent enterprise liabilities with potentially profound impacts on operational effectiveness and profitability.

Options:

A.

TRUE

B.

FALSE

Question 5

What are the three characteristics of effective Data Governance communication?

Options:

A.

It must be clear, unambiguous, and consistent

B.

It must be consistent, unambiguous, engaging

C.

It must be viral, vital, and have volume

D.

It must be colorful, engaging, using multi-media

E.

It must be clear, structured, repetitive

Question 6

SOA is an abbreviation for service orientated architecture.

Options:

A.

FALSE

B.

TRUE

Question 7

Location Master Data includes business party addresses and business party location, as well as facility addresses for locations owned by organizations.

Options:

A.

TRUE

B.

FALSE

Question 8

The difference between warehouses and operational systems do not include the following element:

Options:

A.

Time variant

B.

Database

C.

Subject-orientated

D.

Historical

Question 9

Considerations for whether to integrate two data stores should include all except

the:

Options:

A.

Maintaining of master data trust across the two data stores

B.

Privacy and access consideration for the data

C.

Complexity of data operations

D.

Ability to govern the data across both systems

E.

Capability of the systems to support the data natively

Question 10

An organization can enhance its Data Governance program and thereby improve its approach to enterprise data management. This is important for the following reason:

Options:

A.

Since most organizations start Data Governance in silos and not at the enterprise level, it is important to be able to assess current state and determine desired targeted state that supports the overall vision

B.

Often organizations have a data repository or dictionary that is just as good as Data Governance

C.

Data Governance programs are rarely enhanced once they are launched

D.

Assessing current state for Data Governance may not tell the organization the current state of other components

E.

Starting a Data Governance program does not require that the organization start a data management program

Question 11

Analytics models are associated with different depths of analysis, including:

Options:

A.

Quality testing

B.

Explanatory modeling

C.

Descriptive modeling

D.

Performance modeling

E.

All of the above

F.

None of the above

Question 12

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:

Options:

A.

Contract negotiations regarding data sharing & resolution of data quality issues

B.

Documenting accounting procedures

C.

Documenting physical assets

D.

Authority and decision rights Change management escalations Meeting Compliance requirements

E.

Conformance issues related to policies, standards and principles

Question 13

Data profiling examples include:

Options:

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

Question 14

The implementation of a Data Warehouse should follow guiding principles, including:

Options:

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

Question 15

The Data Warehouse has a set of storage areas, including:

Options:

A.

Staging areas

B.

Data marts

C.

Cubes

D.

Kubernetes

Question 16

Data handling ethics are concerned with how to procure, store, manage, use and dispose of data in ways that are aligned with ethical principles.

Options:

A.

TRUE

B.

FALSE

Question 17

Why is it important to create short-term wins when rolling out a Data Governance initiative?

Options:

A.

Staff turnover in most organisations makes longer term planning impossible

B.

Short term wins help ensure on-going political support

C.

Short term wins help to distract stakeholders from delayed delivery on bigger issues

D.

You need to align your deliverables with internal project budgeting cycles

E.

People find it hard to sustain commitment to change if they do not see compelling results within a relatively short time period

Question 18

The goals of Metadata management include:

Options:

A.

Managing performance of data assets

B.

Ensure metadata quality, consistency, currency and security

C.

Managing the availability of data throughout the data lifecycle

D.

Provide standard ways to make metadata accessible to metadata consumers

E.

Managing the performance of data transactions

F.

Establish or enforce the use of technical Metadata standards to enable data exchange

Question 19

Data Governance focuses exclusively on:

Options:

A.

The management of data assets and of data as an asset

B.

Alignment of IT strategies and investments with enterprise goals and strategies

C.

Decisions about IT investments

D.

Rules and regulations including GDPR

E.

The COBIT (Control Objectives for Information and Related Technology) framework

Question 20

During the intial scoping of a project, a data model can be used to:

Options:

A.

Identify detailed impact on all the tables in a database that must be changed

B.

Determine the security requirements for accessing the data

C.

Provide a clear definition of affected and non-affected data entities

D.

Determine the impact of business processes and customer lifecycles

E.

Plan the structure of the metadata repository

Question 21

An Operational Data Mart is a data mart focused on tactical decision support.

Options:

A.

TRUE

B.

FALSE

Question 22

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.

Options:

A.

TRUE

B.

FALSE

Question 23

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.

Options:

A.

TRUE

B.

FALSE

Question 24

Data governance and IT governance are the same thing.

Options:

A.

TRUE

B.

FALSE

Question 25

Data professional should not balance the short-term versus long-term business interests.

Options:

A.

TRUE

B.

FALSE

Question 26

The data warehouse and marts differ from that in applications as the data is organized by subject rather than function.

Options:

A.

TRUE

B.

FALSE

Question 27

Data science involves the iterative inclusion of data sources into models that develop insights. Dat science depends on:

Options:

A.

Consistency

B.

Rich data sources

C.

Information alignment and analysis

D.

Information delivery

E.

Presentation of findings and data insights

F.

All of the above

Question 28

Data flows map and document relationships between data and:

Options:

A.

Locations where local differences occur

B.

Situations where local differences occur

C.

Network segments

D.

Applications within a business process

E.

None of the above

F.

All of the above

Question 29

The goals of data security include:

Options:

A.

Managing performance of data assets

B.

Enable appropriate access to enterprise data assets

C.

Managing the availability of data throughout the data lifecycle

D.

Understand and comply with all relevant regulations and policies for privacy and confidentiality

E.

Managing the performance of data transactions

F.

Ensure that the privacy and confidentiality needs of all stakeholders are enforced and audited

Question 30

Emergency contact phone number would be found in which master data

management program?

Options:

A.

Location

B.

Asset

C.

Service

D.

Employee

E.

Product

Question 31

Data Storage and Operations: The design, implementation and support of stored data to maximize its value.

Options:

A.

TRUE

B.

FALSE

Question 32

A limitation of the centralized approach include: Maintenance of a decentralized repository is costly.

Options:

A.

TRUE

B.

FALSE

Question 33

Metadata management solutions include architectural layers including:

Options:

A.

Metadata control and management

B.

Metadata Marketing

C.

Metadata usage

D.

Metadata integration

E.

Metadata Sales

F.

Metadata delivery

Question 34

Practitioners identify development of staff capability to be a primary concern of Data Governance. Why would this be a main concern?

Options:

A.

Because we need to develop the next generation of Chief Data Officers

B.

Because it is important to have senior people, in order to dictate that the policy will be followed

C.

Because organizations expect quick results

D.

Because it is important to train staff to ensure application of appropriate methods

E.

Because it is a recognized benchmark standard

Question 35

Please select the answer that best fits the following description: Contains only real-time data.

Options:

A.

Batch layer

B.

Speed layer

C.

Serving layer

D.

Real-time layer

Question 36

SPARC published their three-schema approach to database management. The three key components were:

Options:

A.

Internal

B.

Logical

C.

Generic

D.

Conceptual

E.

External

Question 37

Inputs in the data quality context diagram include:

Options:

A.

Data stores

B.

Data lakes

C.

Business requirements

D.

Data quality expectations

Question 38

Different types of product Master Data solutions include:

Options:

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)

Question 39

All data is of equal importance. Data quality management efforts should be spread between all the data in the organization.

Options:

A.

TRUE

B.

FALSE

Question 40

Please select the transition phases in Bridges’ Transition process:

Options:

A.

The neutral zone

B.

The new beginning

C.

The ending

D.

The transition

E.

The translation

F.

The game

Question 41

The best way to validate that a database backup is working, is to:

Options:

A.

Periodically recover from the backup file

B.

Appoint a special DBA in charge of backups

C.

Check the size of the backup file

D.

Check the backup logs every day

E.

Check for the automatic email notification of backup success

Question 42

The standard for a strong password is set by the:

Options:

A.

Data security standard

B.

Data access standard

C.

Identity management standard

D.

Data modelling standard

E.

Data naming standard

Question 43

Data and enterprise architecture deal with complexity from two viewpoints:

Options:

A.

None of the above

B.

Implementation-orientated

C.

Quality-orientated

D.

Architecture-orientated

E.

Innovation-orientated

F.

Industry-orientated

Question 44

Types of metadata include:

Options:

A.

Strategic

B.

Business

C.

Column-orientated

D.

Operational

E.

Graph

F.

Technical

Question 45

SLA Stands for:

Options:

A.

Service Level Agreement

B.

System Lifecycle Audit

C.

System Latitude Audit

D.

Service Lifecycle Audit

Question 46

MPP is an abbreviation for Major Parallel Processing.

Options:

A.

TRUE

B.

FALSE

Question 47

Enterprise data architecture description must include both [1] as well as [2]

Options:

A.

[1] Data Flow Design [2] Data Context Diagram

B.

[1] Enterprise Data Model [2] Architecture Diagram

C.

[1] Enterprise Data Model [2] Data Flow Design

D.

[1] Enterprise Data Model [2] Data Context Diagram

Question 48

Over a decade an organisation has rationalised implementation of party concepts

from 48 systems to 3. This is a result of good:

Options:

A.

Data quality and data governance

B.

Data architecture and data warehousing

C.

Data operations and system rationalization

D.

System rationalization and metadata management

E.

Data architecture and data governance

Question 49

Data governance requires control mechanisms and procedures for, but not limited to, identifying, capturing, logging and updating actions.

Options:

A.

FALSE

B.

TRUE

Question 50

The target of organizational change is expedition.

Options:

A.

TRUE

B.

FALSE

Question 51

Basic profiling of data involves analysis of:

Options:

A.

Data sources, data visualisations, data latency and ownership

B.

Data clusters, data clouds, data repositories and metadata libraries

C.

Data lakes, data warehouses and operational data stores

D.

Data formats, data values, patterns and relationships

E.

Data criteria, data acquisition, data policy and procedures inside dataGovernance

Question 52

The database administrator (DBA) is the most established and the most widely adopted data professional role.

Options:

A.

TRUE

B.

FALSE

Question 53

Real-time data integration is usually triggered by batch processing, such as historic data.

Options:

A.

TRUE

B.

FALSE

Question 54

Examples of interaction models include:

Options:

A.

Hub-and-spoke

B.

Publish - subscribe

C.

Point-to-point

D.

Wheel-and-spike

Question 55

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:

Options:

A.

Level 2 In Development

B.

Level 4 Proactive

C.

Level 2 Sub-standard

D.

Level 4 Proactive

E.

Level 3 Transformational

F.

Level 3 Essential

Question 56

Which of the following is a Data Quality principle?

Options:

A.

Prevention

B.

Governance

C.

Criticality

D.

Standards Driven

E.

All of these

Question 57

Test environments serve many uses:

Options:

A.

Quality Assurance Testing (QA)

B.

Integration Testing

C.

User Acceptance Testing (UAT)

D.

Performance Testing

E.

All of the above

F.

None of the above

Question 58

Typically, DW/BI projects have three concurrent development tracks, including:

Options:

A.

Technology

B.

Trickle Feeds

C.

Data

D.

BI Tools

E.

Messaging

F.

Streaming

Question 59

The number of entities in a relationship is the arity of the relationship. The most common are:

Options:

A.

Unary

B.

Binary

C.

Trinary

D.

Ternary

Question 60

Implementing a BI portfolio is about identifying the right tools for the right user communities within or across business units.

Options:

A.

TRUE

B.

FALSE

Question 61

A data dictionary is necessary to support the use of a DW.

Options:

A.

TRUE

B.

FALSE

Question 62

A deliverable in the data security context diagram is the data security architecture.

Options:

A.

TRUE

B.

FALSE

Question 63

The four main types of NoSQL databases are:

Options:

A.

Document

B.

Row-orientated

C.

Graph

D.

Strategic

E.

Key-value

F.

Column-orientated

Question 64

Data access control can be organized at an individual level or group level, depending on the need.

Options:

A.

TRUE

B.

FALSE

Question 65

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.

Options:

A.

Data Quality must be managed throughout the data lifecycle

B.

Data Security must only be managed at the start of the data lifecycle

C.

Metadata Quality is the most important part of the management process

D.

Data Management efforts should focus on the most critical data last

Question 66

Examples of transformation in the ETL process onclude:

Options:

A.

De-duping

B.

Structure changes

C.

Hierarchical changes

D.

Re-ordering

E.

Semantic conversions

F.

None of the above

Question 67

A sandbox is an alternate environment that allows write-only connections to production data and can be managed by the administrator.

Options:

A.

TRUE

B.

FALSE

Question 68

The advantage of a decentralized data governance model over a centralized model is:

Options:

A.

The common metadata repository configurations

B.

Having a common approach to resolving data governance issues

C.

The easier implementation of industry data models

D.

An increased level of ownership from local decision making groups

E.

The cheaper execution of data governance operations

Question 69

Data Management Professionals only work with the technical aspects related to data.

Options:

A.

TRUE

B.

FALSE

Question 70

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:

Options:

A.

Each type of stakeholder may need a different form of interaction, and each process evaluation may lend itself to a different form of information gathering

B.

Data management and Data Governance assessments will have different types of stakeholders

C.

The definition of stakeholder interaction depends on the executive sponsor

D.

Assessment teams may not know what a stakeholder is

E.

Each type of stakeholder may need a different form of data and security

Question 71

The 'Data Governance Steering Committee' is best described as:

Options:

A.

The community of interest, focused on specific subject areas or projects

B.

A burden to the agile delivery in a modern enterprise

C.

The local or divisional council, working under auspices of the CDO

D.

The representatives of data use on project steering committees

E.

The primary and highest authority responsible for the oversight and support of Data Governance activities

Question 72

Class operations can be:

Options:

A.

General: Hidden

B.

Public: Externally visible

C.

Internally visible: Visible to children objects

D.

Private: Hidden

Question 73

Organizations conduct capability maturity assessments for a number of reasons, including:

Options:

A.

Organizational change

B.

Data management issues

C.

Regulation

D.

Data governance

E.

Data modeling

F.

New technology

Question 74

Please select the correct name for the PDM abbreviation when referring to modelling.

Options:

A.

Physical Dimension Model

B.

Photo Data Model

C.

None of the above

D.

Probabilistic Dimension Model

E.

Photo Dimensional Model

F.

Physical Data Model

Question 75

Structural Metadata describe srealtionships within and among resource and enables identification and retrieval.

Options:

A.

FALSE

B.

TRUE

Question 76

Record management starts with a vague definition of what constitutes a record.

Options:

A.

TRUE

B.

FALSE

Question 77

XML is the abbreviation for standard mark-up language.

Options:

A.

FALSE

B.

TRUE

Question 78

The four A’s in security processes include:

Options:

A.

Audit

B.

Authentication

C.

Access

D.

Authorization

E.

Aliment

F.

Applicable

Question 79

A e-discovery readiness assessment should examine and identify opportunities for the commercial response program.

Options:

A.

TRUE

B.

FALSE

Question 80

Data Stewards are most likely to be responsible for:

Options:

A.

Data Modelling and Data Security

B.

Data Integration and Interoperability

C.

Data Storage and Operations

D.

Content and Document Management

E.

Data Governance and Data Quality

Question 81

The operational data quality management procedures depend on the ability to measure and monitor the applicability of data.

Options:

A.

FALSE

B.

TRUE

Question 82

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?

Options:

A.

Data policies

B.

Data Governance

C.

Data audit principle

D.

Data asset valuation

E.

Data Management

Question 83

A design approach for managing the risk of errors in data marts is:

Options:

A.

Purge the data in the data marts and reload from the data warehouse

B.

Purge the data in the source system and reload the data warehouse

C.

Purge the data in the data warehouse and copy back to the data mart

D.

Purge the data in the data warehouse and reload from the source systems

E.

Purge the data generally and reload from the best system

Question 84

The goals of data storage and operations include:

Options:

A.

Managing performance of data assets

B.

Capture and document explicit knowledge about an organization’s data and systems

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.

Managing the performance of data transactions

F.

Make the integration between data management and data analytics possible

Question 85

Metrics tied to Reference and Master Data Quality include:

Options:

A.

Addressing all queries

B.

Data steward coverage

C.

Implementing data management training

D.

Data sharing volume and usage

E.

Data ingestion and consumption

F.

Service level agreements

Question 86

The minority of operational metadata is generated as data is processed.

Options:

A.

TRUE

B.

FALSE

Question 87

Hierarchical database model is the newest database model

Options:

A.

TRUE

B.

FALSE

Question 88

When trying to integrate a large number of systems, the integration complexities can

be reduced by:

Options:

A.

The use of 5QL

B.

Clear business specification and priorities

C.

The use of a common data model

D.

Tackling the largest systems first

E.

Using data quality measures and targets.

Question 89

Coupling describes the degree to which two systems are intertwined.

Options:

A.

FALSE

B.

TRUE

Question 90

One of the key differences between operational systems and data warehouses is:

Options:

A.

Operational systems focus on data quality: data warehouses focus on datasecurity

B.

Operational systems focus on historical data; data warehouses contain currentdata

C.

Operational systems are available 24x7; data warehouses are available duringbusiness hours

D.

Operational systems focus on current data; data warehouses contain historicaldata

E.

Operational systems focus on business processes: data warehouses focus onbusiness strategies

Question 91

There are several methods for masking data:

Options:

A.

Substitution

B.

Temporal variance

C.

Temporal stagnation

D.

Value stagnation

E.

Value variance

F.

All of the above

Question 92

A metadata repository is essential to assure the integrity and consistent use of an enterprise data model across business processes.

Options:

A.

TRUE

B.

FALSE

Question 93

The first two steps in the data science process are:

Options:

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)

Question 94

Companies do not rely on their information systems to run their operations.

Options:

A.

TRUE

B.

FALSE

Question 95

Development of goals, principles and policies derived from the data governance strategy will not guide the organization into the desired future state.

Options:

A.

FALSE

B.

TRUE

Question 96

Project that use personal data should have a disciplined approach to the use of that data. They should account for:

Options:

A.

What activities analytics will focus on

B.

How they select their populations for study

C.

All of the above

D.

How data will be captured

E.

How results will be made accessible

Question 97

Normalisation is the process of applying rules in order to organise business complexity into stable data structures.

Options:

A.

TRUE

B.

FALSE

Question 98

The Data Model Scorecard provides 10 data model quality metrics

Options:

A.

TRUE

B.

FALSE

Question 99

The ethics of data handling are complex, but is centred on several core concepts. Please select the correct answers.

Options:

A.

Impact on machines

B.

Impact on people

C.

Potential for data management

D.

Potential for misuse

E.

Economic value of ethics

F.

Economics value of data

Question 100

Governance ensures data is managed, but is not include the actual act of managing data.

Options:

A.

TRUE

B.

FALSE

Question 101

Data science merges data mining, statistical analysis, and machine learning with the integration and data modelling capabilities, to build predictive models that explore data content patterns.

Options:

A.

FALSE

B.

TRUE

Question 102

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?

Options:

A.

Data Integration and Interoperability

B.

Reference and Master Data

C.

Data Security

D.

Document and Content Management

E.

Data Govemance

Question 103

There are three recovery types that provide guidelines for how quickly recovery takes place and what it focuses on.

Options:

A.

Immediate recovery

B.

Intermittent recovery

C.

Critical recovery

D.

Translucent recovery

E.

BMT recovery

F.

Non-critical recovery

Question 104

There are numerous methods of implementing databases on the cloud. The most common are:

Options:

A.

Virtual machine image

B.

Distributed machine image

C.

DAAS

D.

Managed database hosting on the cloud

Question 105

Please select the 2 frameworks that show high-level relationships that influence how an organization manages data.

Options:

A.

Strategic Alignment Model

B.

DAMA DMBOK Hexagon

C.

DAMA Wheel

D.

Amsterdam Information Model

Question 106

The load step of the ETL is physically storing or presenting the results of the transformation into the source system.

Options:

A.

TRUE

B.

FALSE

Question 107

What are the components of a Data Governance Readiness Assessment?

Options:

A.

Assess best practices, data metrics, and data quality

B.

Compliance to internal standards, Data Security, Data Privacy rules

C.

Data Management Maturity, Capacity to Change, Collaborative Readiness and Business Alignment

D.

Capacity to change, Establish standards. Data Quality skills, Data Stewardship productivity

E.

Capacity to change, Establish Stewardship, Business Alignment and Metadata Repository

Question 108

The first two steps of the Reference data Change request process, as prescribed DMBOk2, include:

Options:

A.

Decide and Communicate

B.

Receive Change Request

C.

Update and Inform

D.

Identify Stakeholder

E.

Identify Impact

Question 109

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.

Options:

A.

FALSE

B.

TRUE

Question 110

Customer value comes when the economic benefit of using data outweighs the costs of acquiring and storing it, as well we managing risk related to usage. Which of these is not a way to measure value?

Options:

A.

Market value

B.

Identified opportunities

C.

Risk cost

D.

User perspective

E.

Replacement cost

Question 111

In an information management context, the short-term wins and goals often arise from the resolution of an identified problem.

Options:

A.

TRUE

B.

FALSE

Question 112

The implementation of a Data Warehouse should follow these guiding principles:

Options:

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

Question 113

What are the primary drivers of data security activities?

Options:

A.

Risk reduction

B.

Risk alleviation

C.

Business growth

D.

Business compliance

Question 114

The term data quality refers to both the characteristics associated with high quality data and to the processes used to measure or improve the quality of data.

Options:

A.

TRUE

B.

FALSE

Question 115

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.

Options:

A.

FALSE

B.

RRUE

Question 116

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.

Options:

A.

FALSE

B.

TRUE

Question 117

Business people must be fully engaged in order to realize benefits from the advanced analytics.

Options:

A.

TRUE

B.

FALSE

Question 118

Please select the correct definition of Data Management from the options below.

Options:

A.

Data Management is the strict control of all plans, policies, programs and practices that enable the business strategy to be successfully executed.

B.

Data Management is the development, execution and supervision of plans, policies, programs and practices that deliver, control, protect and enhance the value of data and information assets throughout their lifecycles.

C.

Data Management is the development, execution and supervision of plans, policies, programs and practices that deliver, control, protect and enhance the value of data assets throughout their lifecycles.

D.

Data Management is the development, execution and supervision of plans, policies, programs and practices that deliver, control, protect and enhance the value of information assets throughout their lifecycles.

Question 119

SOA stand for Service Orchestrated Architecture

Options:

A.

TRUE

B.

FALSE

Question 120

Volume refers to the amount of data. Big Data often has thousands of entities or elements in billions of records.

Options:

A.

TRUE

B.

FALSE

Question 121

Business glossary is not merely a list of terms. Each term will be associated with other valuable metadata such as synonyms, metrics, lineage, or:

Options:

A.

Sanctioned rules

B.

Archive Rules

C.

Business Rules

D.

Database Type

E.

Data Length

Question 122

What are some of the business drivers for the ethical handling of data that Data Governance should satisfy?

Options:

A.

Develop Employee Awareness of the organizational risks on unethical data handling

B.

All of these

C.

Define what ethical handling of data means to the organization

D.

Achieve the preferred culture and actions in handling data

E.

Monitor, Measure and adjust the organizations approach to data ethics

Question 123

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.

Options:

A.

TRUE

B.

FALSE

Question 124

What key components must be included in the Implementation Roadmap?

Options:

A.

Timeframes and resources for data quality requirements, policies and directives and testing standards

B.

Data metrics, physical data structures, and data model designs

C.

Timeframes and resources for Policies and Directives, a Business Glossary Architecture, Business and IT processes and role descriptions

D.

Testing requirements, risk assessment, data security and privacy policies and database design

E.

Timeframes and resources for policies and directives Architecture, Tools and Control Metrics

Question 125

A Business Glossary forces a business to adopt a single definition of a business term.

Options:

A.

FALSE

B.

TRUE

Question 126

Adoption of a Data Governance program is most likely to succeed:

Options:

A.

When the CDO is a charismatic leader

B.

In 1 or 2 months with a large consulting team

C.

When the entire enterprise is partaking at once

D.

When dictated by senior executives

E.

With an incremental rollout strategy

Question 127

The list of V’s include:

Options:

A.

Volatility

B.

Volume

C.

Veracity

D.

Viscosity

E.

Variety

F.

Validity

Question 128

Business Intelligence, among other things, refer to the technology that supports this kind of analysis.

Options:

A.

FALSE

B.

TRUE

Question 129

A goal of data architecture is to identify data storage and processing requirements.

Options:

A.

TRUE

B.

FALSE

Question 130

Data security internal audits ensure data security and regulatory compliance policies are followed should be conducted regularly and consistently.

Options:

A.

TRUE

B.

FALSE

Question 131

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.

Options:

A.

TRUE

B.

FALSE

Question 132

Logical abstraction entities become separate objects in the physical database design using one of two methods.

Options:

A.

The DAMA Wheel

B.

Supertype partition

C.

Subtype partition

D.

Subtype absorption

E.

Supertype absorption

Question 133

In the Information Management Lifecycle, the Data Governance Activity "Define the Data Governance Framework" is considered in which Lifecycle stage?

Options:

A.

Create & Acquire

B.

Maintain & Use

C.

Specify

D.

Enable

E.

Plan

Question 134

The categories of the Data Model Scorecard with the highest weightings include:

Options:

A.

How well does the model capture the requirements?

B.

None of the above

C.

How good are the definitions?

D.

How complete is the model?

E.

How structurally sound is the model?

F.

All of the above

Question 135

One common KPI of e-discovery is cost reduction.

Options:

A.

FALSE

B.

TRUE

Question 136

Vulnerability is defined as:

Options:

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.

Question 137

Improving an organization’s ethical behaviour requires an informal Organizational Change Management (OCM) process.

Options:

A.

TRUE

B.

FALSE

Question 138

Which of the following is an activity for defining a Data Governance strategy?

Options:

A.

Develop a Business Glossary

B.

Perform Readiness Assessment

C.

Develop Goals, Principles, and Policies

D.

Charter Data Governance Council

E.

Deliver a plan for mapping metadata

Question 139

What business function is best aligned to deliver oversight to data architecture ?

Options:

A.

Data Govemance

B.

Business Innovation

C.

Business Integration

D.

Chief Technology Office

E.

Enterprise Architecture

Question 140

Layers of data governance are often part of the solution. This means determining where accountability should reside for stewardship activities and who the owners of the data are.

Options:

A.

FALSE

B.

TRUE

Question 141

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.

Options:

A.

TRUE

B.

FALSE

Question 142

The neutral zone is one of the phases in the Bridges’ transition phases.

Options:

A.

TRUE

B.

FALSE

Question 143

Most document programs have policies related to:

Options:

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

Question 144

ETL is the basic process which is central to all areas in Data Integration and Interoperability. It is an abbreviation for extract, transition and load.

Options:

A.

TRUE

B.

FALSE

Question 145

Data quality management is a key capability of a data management practice and organization.

Options:

A.

TRUE

B.

FALSE

Question 146

Category information is one of the types of data that can be modelled.

Options:

A.

TRUE

B.

FALSE

Question 147

Effective data management involves a set of complex, interrelated processes that disable an organization to use its data to achieve strategic goals.

Options:

A.

FALSE

B.

TRUE

Question 148

Data modelling is most infrequently performed in the context of systems and maintenance efforts, known as SDLC.

Options:

A.

TRUE

B.

FALSE

Question 149

Match rules for different scenarios require different workflows, including:

Options:

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

Question 150

In a SQL injection attack, a perpetrator inserts authorized database statements into a vulnerable SQL data channel, such as a stored procedure.

Options:

A.

FALSE

B.

TRUE

Question 151

A data warehouse deployment with multiple ETL, storage and querying tools often

suffers due to the lack of:

Options:

A.

Integration of the dictionaries to achieve common understanding

B.

Conflict between software vendors

C.

Disk space on the big data platform

D.

Quality data modelers

E.

Common data types in the source datasets

Question 152

Deliverables in the document and content management context diagram include:

Options:

A.

Metadata and reference data

B.

Policy and procedure

C.

Data governance

D.

Content and records management strategy

E.

Audit trail and log

F.

Data storage and operations

Question 153

Assessment capabilities are evaluated against a pre-determined scale with established criteria. This is important because:

Options:

A.

Each process that is being evaluated must show some financial justification.

B.

It is difficult to be objective when using an internally developed assessment

C.

Each process under evaluation must be rated objectively against best practices found in many organizations and industries.

D.

Pre-determined scales give organizations a way to justify their weaknesses

E.

Established criteria in an industry make each organization more likely to want to use the industry's assessment.

Question 154

Characteristics that minimise distractions and maximise useful information include, but not limited to, consistent object attributes

Options:

A.

TRUE

B.

FALSE

Question 155

What are the business objectives for building a business glossary?

Options:

A.

To have a place to store physical schemas for the DBAs

B.

Make sure that the data stewards have valid work to perform, & justify that the budget for Data Governance

C.

Take all the core data elements from the data models and store them in the glossary

D.

Establish a common understanding of core business concepts and terminology & enable access to documented institutional knowledge

E.

Create a place to manage metadata and lineage

Question 156

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?

Options:

A.

Better corporate compliance with legal and regulatory demands, especially in relation to data protection, security and privacy

B.

Lower operational costs resulting from better data quality and a reduced need for cost of failure and rework activities

C.

The current corporate information policy states that company data must be managed and effectively governed

D.

Enhanced customer perceptions of your company's brand and enhanced customer acquisition, retention and loyalty

E.

New sales and revenue opportunities that better managed data will enable

Question 157

Please select the two classifications of database types:

Options:

A.

Centralized

B.

Generic

C.

Distributed

D.

MapReduce

Question 158

Lack of automated monitoring represents serious risks, including compliance risk.

Options:

A.

TRUE

B.

FALSE

Question 159

Control activities to manage metadata stores include:

Options:

A.

Roadmap extrapolation

B.

Load statistical analysis

C.

Lineage

D.

Missing metadata reports

E.

Definitions resolutions improvement

F.

Job scheduling and monitoring

Question 160

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.

Options:

A.

Schema

B.

Database

C.

Node

D.

Instance

Question 161

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.

Options:

A.

TRUE

B.

FALSE

Question 162

Which DMBok knowledge area is most likely responsible for a high percentage of

returned mail?

Options:

A.

Data Quality

B.

Reference and Master Data

C.

Data Warchousing and Business Intelligence

D.

Data Integration and Interoperability

E.

Metadata Management

Question 163

The biggest business driver for developing organizational capabilities around Big Data and Data Science is the desire to find and act on business opportunities that may be discovered through data sets generated through a diversified range of processes.

Options:

A.

TRUE

B.

FALSE

Question 164

In the Data Warehousing and Business Intelligence Context Diagram, a primary deliverable is the DW and BI Architecture.

Options:

A.

FALSE

B.

TRUE

Question 165

An input in the Metadata management context diagram does not include:

Options:

A.

Business requirements

B.

Business metadata

C.

Technical metadata

D.

Metadata standards

E.

Process Metadata

Question 166

Data Warehouse describes the operational extract, cleansing, transformation, control and load processes that maintain the data in a data warehouse.

Options:

A.

FALSE

B.

TRUE

Question 167

A complexity in documenting data lineage is:

Options:

A.

Establishing data quality metrics

B.

Conflicting application requirements from data owners

C.

Choosing which content management software to use

D.

Identifying source databases

E.

Different data element names and formats

Question 168

Business requirements is an input in the Data Warehouse and Business Intelligence context diagram.

Options:

A.

TRUE

B.

FALSE

Question 169

A goal of metadata management is to manage data related business terminology in

order toc

Options:

A.

Successfully size the database

B.

Ensure accurate data requirements are gathered for reporting

C.

Ensure people understand data content and can use data consistently

D.

Ensure people understand data definition in Bl systems

E.

Ensure the business processes align to the data model

Question 170

Tools required to manage and communicate changes in data governance programs include

Options:

A.

Ongoing business case for data governance

B.

Obtaining buy-in from all stakeholders

C.

Data governance roadmap

D.

Monitoring the resistance

E.

Business/Data Governance strategy map

F.

Data governance metrics

Question 171

Please select the answers that correctly describes the set of principles that recognizes salient features of data management and guide data management practice.

Options:

A.

Data is an asset with unique properties.

B.

It takes Metadata to manage data.

C.

The most important part of data management is security.

D.

Data management is lifecycle management.

E.

Effective data management requires leadership commitment.

F.

Efficient data management requires a team of IT professionals only.

Question 172

The second stage of Kotter’s eight stage process is:

Options:

A.

Developing a vision and a strategy

B.

Establishing a sense of urgency

C.

Creating short term wins

D.

Creating the guiding coalition

Question 173

What techniques should be used and taught to produce the required ethical data handling deliverables?

Options:

A.

Change, Communication and training techniques need to be established

B.

A privacy impact assessment (PIA) is critical to ensuring that we are adhering to ethical data management

C.

Do an ethical impact assessment framework for all projects and activities involved in data management

D.

Due to fact that ethics are constantly changing we need to constantly affirm the organizations ethic statements on an annual basis

E.

Data Governance should define the set of ethical practices that are good for the organization

Question 174

A goal of reference and master data is to provide authoritative source of reconciled and quality-assessed master and reference data.

Options:

A.

TRUE

B.

FALSE

Question 175

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.

Options:

A.

TRUE

B.

FALSE

Question 176

Metadata is essential to the management of unstructured data as it id to the management of structured data.

Options:

A.

TRUE

B.

FALSE

Question 177

Small reference data value sets in the logical data model can be implemented in a physical model in three common ways:

Options:

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

Question 178

The term data quality refers to only the characteristics associated with high quality data.

Options:

A.

TRUE

B.

FALSE

Question 179

Data and text mining use a range of techniques, including:

Options:

A.

Profiling

B.

Application reduction

C.

Association

D.

Data reduction

E.

Clustering

F.

All of the above

Question 180

Triplestores can be classified into these categories:

Options:

A.

Native triplestores

B.

All of the above

C.

None of the above

D.

RDMS-backed triplestores

E.

NoSQL triplestores

F.

MapReduce triplestores

Question 181

Data Standards used by the enterprise must:

Options:

A.

Promote consistent results but periodically reviewed and updated

B.

Be a guideline for the organization but open to interpretation

C.

Promote consistent results so only written once and never updated

D.

Only be necessary for the Data Governance team

E.

Set by an standards organization and not by the enterprise

Question 182

Enterprise Architecture domains include:

Options:

A.

Business Architecture

B.

Data Architecture

C.

Data Management Architecture

D.

Systems Architecture

E.

Application Architecture

F.

Technology Architecture

Question 183

There are three basic approaches to implementing a Master Data hub environment, including:

Options:

A.

Transaction hub

B.

Distributed hub

C.

Registry

D.

Consolidated approach

E.

Eventual consistency

F.

Transparent hub

Question 184

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.

Options:

A.

ISO 9000

B.

ISO 7000

C.

ISO 8000

D.

ISO 9001

Question 185

Bias refers to an inclination of outlook. Please select the types of data bias:

Options:

A.

Data collection for pre-defined results

B.

Hunch and search

C.

Positive reinforcement

D.

Context and Emotion

E.

Biased use of data collected

F.

Biased sampling methodology

Question 186

Activities that drive the goals in the context diagram are classified into the following phases:

Options:

A.

Plan, Develop, Operate, Control

B.

Plan, Do, Check, Act

C.

Measure, Develop, Implement, Monitor, Improve

D.

Planning, Analysis, Design, Implementation & Maintenance

Question 187

Three classic implementation approaches that support Online Analytical Processing include:

Options:

A.

QOLAP

B.

ROLAP

C.

OLAP2

D.

HOLAP

E.

MOLAP

F.

None of the above

Question 188

Managing business party Master Data poses these unique challenges:

Options:

A.

Difficulties in unique dimensions

B.

Difficulties in unique identification

C.

Reference data anomaly detection

D.

The number of data sources and the differences between them

Question 189

When selecting a DMM framework one should consider of it is repeatable.

Options:

A.

TRUE

B.

FALSE

Question 190

A hacker is a person who finds unknown operations and pathways within complex computer system. Hackers are only bad.

Options:

A.

TRUE

B.

FALSE

Question 191

Examples of transformation include:

Options:

A.

Format changes, structure changes, replication conversion, re-duplication anddata ordering

B.

Application changes, infrastructure changes, software conversion, de-duplicationand re-ordering

C.

Data modelling changes, structure changes, metric conversion, de-duplicationand reordering

D.

Format changes, structure changes, semantic conversion, de-duplication and re-ordering

E.

Organisation changes, location changes, business strategy conversion, down-sizing and outsourcing

Question 192

If two data stores are able to be inconsistent during normal operations, then the

integration approach is:

Options:

A.

Asynchronous

B.

Uncontrolled

C.

Synchronous

D.

Streaming

E.

Faulty

Question 193

ANSI standard 859 has three levels of control of data, based on the criticality of the data and the perceived harm that would occur if data were corrupt or otherwise unavailable, including:

Options:

A.

Basic

B.

Formal

C.

Informal

D.

Custody

E.

Revision

F.

None of the above

Question 194

Issue management is the process for identifying, quantifying, prioritizing and resolving data governance related issues, including:

Options:

A.

Contracts

B.

Authority

C.

Compliance

D.

All of the above

E.

Conflicts

F.

Data Efficiency

Question 195

Master data management includes several basic steps, which include: Develop rules for accurately matching and merging entity instances.

Options:

A.

TRUE

B.

FALSE

Question 196

The goal of data architecture is to:

Options:

A.

Serve as a platform to enable data governance and management

B.

Bridge between business strategy and technology execution

C.

Provide the organisation with clear system of the architecture

D.

Make the integration between data management and data analytics possible

Question 197

Data governance requires control mechanisms and procedures for, but not limited to, escalating issues to higher level of authority.

Options:

A.

FALSE

B.

TRUE

Question 198

Change only requires change agents in special circumstances, especially when there is little to no adoption.

Options:

A.

TRUE

B.

FALSE

Question 199

A completely distributed architecture maintains a single access point. The metadata retrieval engine responds to user requests by retrieving data from source systems in real time.

Options:

A.

FALSE

B.

TRUE

Demo: 199 questions
Total 666 questions