Summer Special Flat 65% Limited Time Discount offer - Ends in 0d 00h 00m 00s - Coupon code: netdisc

DAMA DMF-1220 Data Management Fundamentals Exam Practice Test

Page: 1 / 73
Total 725 questions

Data Management Fundamentals Questions and Answers

Testing Engine

  • Product Type: Testing Engine
$43.75  $124.99

PDF Study Guide

  • Product Type: PDF Study Guide
$38.5  $109.99
Question 1

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 2

Examples of the ‘What’ entity category include the following nouns:

Options:

A.

Product

B.

Service

C.

Time

D.

Sales amount

E.

Payment quantity

F.

All of the above

Question 3

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 4

Databases are categorized in three general ways:

Options:

A.

Warped

B.

Non-relational

C.

Relational

D.

Accessible

E.

None of the above

F.

Hierarchical

Question 5

XML is the abbreviation for standard mark-up language.

Options:

A.

FALSE

B.

TRUE

Question 6

Type of Reference Data Changes include:

Options:

A.

Row level changes to internal Reference Data sets

B.

Row level changes to external Reference Data sets

C.

Creation of new Reference Data sets

D.

Business model changes on column level

E.

Structural changes to external Reference Data sets

F.

None of the above

Question 7

Input in the Big Data and data science context diagram include:

Options:

A.

IT standards

B.

Data sources

C.

Business strategy & goals

D.

Database standards

Question 8

CMA is an abbreviation for Capability Maturity Assessment.

Options:

A.

TRUE

B.

FALSE

Question 9

Data Fabric is:

Options:

A.

A superior star schema strategy

B.

A form of data lake that automates data acquisition and initial data qualityprocessing

C.

A metadata repository

D.

A way of sewing together different data concepts into a single data warehouse

E.

Just another data warehouse with no distinguishing features

Question 10

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 11

Malware types include:

Options:

A.

Trojan horse

B.

Worm

C.

Weasel

D.

Virus

E.

Adware

F.

Camware

Question 12

A data architecture team is best described as:

Options:

A.

A group of strong database administrators

B.

A strategic planning and compliance team

C.

An operational data provisioning group

D.

The authors of reference data

E.

A well-managed project of architectural development

Question 13

Disciplines within the enterprise architecture practice does not include:

Options:

A.

Technology architecture

B.

Application architecture

C.

Information architectureService Architecture

D.

Business architecture

Question 14

Data professionals involved in Business Intelligence, analytics and Data Science are often responsible for data that describes: who people are; what people do; where people live; and how people are treated. The data can be misused and counteract the principles underlying data ethics.

Options:

A.

FALSE

B.

TRUE

Question 15

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

Options:

A.

TRUE

B.

FALSE

Question 16

Enterprise Data Architects should support projects for potential:

Options:

A.

Non-compliance to data standards

B.

Legal reviews

C.

Incomplete data requests

D.

Data-focused security reviews

E.

Planning for metadata development

Question 17

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

Options:

A.

TRUE

B.

FALSE

Question 18

In Data Modelling, the generalization of the concept of person and organization into a party enables:

Options:

A.

The implementation of relationships between persons and organizations

B.

Single person organizations to be managed consistently

C.

Faster implementation into packages that use the same vocabulary

D.

Them to act in roles in agreements, shared address usages, and common interaction processes

E.

Greater security as users are unaware if this party is a person or an organization

Question 19

A DMZ is bordered by 2 firewalls. These are between the DMZ and the:

Options:

A.

Korean peninsula

B.

Internet, for added security

C.

Internet and extranet

D.

Internet and internal systems

E.

Internet and intranet

Question 20

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.

Options:

A.

FALSE

B.

TRUE

Question 21

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

Options:

A.

FALSE

B.

TRUE

Question 22

Well prepared records have characteristics such as:

Options:

A.

Context

B.

Content

C.

Compliance

D.

Timeliness

Question 23

Field overloading: Unnecessary data duplication is often a result of poor data management.

Options:

A.

TRUE

B.

FALSE

Question 24

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 25

Sustainable Data Governance depends on:

Options:

A.

Rapid response to critical data issues

B.

The maturity level of the organization

C.

Business leadership, sponsorship, and ownership

D.

Well-documented policies

E.

Definition of 10-11 principles

Question 26

Inputs in the data quality context diagram include:

Options:

A.

Data stores

B.

Data lakes

C.

Business requirements

D.

Data quality expectations

Question 27

Achieving security risk reduction in an organisation begins with developing what?

Options:

A.

A change management model, prioritising security changes and then updatingthe active directory

B.

An enterprise data model, rolling out data flow diagrams and enbedding securityinto the database

C.

A security model, classifying each organisational role and putting the physicaldata behind a firewall

D.

A classification model, classifying each data concept and locating the physicaldata

E.

A metadata model, locating the data and moving it into the metadata repository

Question 28

Data governance can be understood in terms of political governance. It includes the following three function types:

Options:

A.

Legislative-like functions

B.

Judicial-like functions

C.

Ethical-like functions

D.

Executive functions

E.

Data-like functions

F.

Morality-like functions

Question 29

An advantage of a centralized repository include: Quick metadata retrieval, since the repository and the query reside together.

Options:

A.

TRUE

B.

FALSE

Question 30

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

Options:

A.

FALSE

B.

TRUE

Question 31

Integration of ETL data flows will usually be developed within tools specialised to manage those flows in a proprietary way.

Options:

A.

TRUE

B.

FALSE

Question 32

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 33

Examples of concepts that can be standardized within the data quality knowledge area include:

Options:

A.

Standard measurement methodologies

B.

Data security standards

C.

Data remediation standards and procedures

D.

None of the above

E.

Data quality rules

F.

Data quality rules

Question 34

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 35

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

Options:

A.

TRUE

B.

FALSE

Question 36

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 37

In data modelling practice, entities are linked by:

Options:

A.

Relationships

B.

Processes

C.

Cardinality

D.

Indexes

E.

Triggers

Question 38

Within the Data Handling Ethics Context Diagram a key deliverable is the Ethical Data Handling Strategy.

Options:

A.

TRUE

B.

FALSE

Question 39

Please select the four domains of enterprise architecture:

Options:

A.

Enterprise software architecture

B.

Enterprise technology architecture

C.

Enterprise business architecture

D.

Enterprise data architecture

E.

Enterprise hardware architecture

F.

Enterprise application architecture

Question 40

Data mining is a sub-field of supervised learning where users attempt to model data elements and predict future outcomes through the evaluation of probability estimates.

Options:

A.

TRUE

B.

FALSE

Question 41

Taxonomies can have different structures, including:

Options:

A.

Polyhierarchy

B.

Application

C.

Facet taxonomy

D.

Network taxonomy

E.

Flat taxonomy

F.

All of the above

Question 42

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 43

Data governance program must contribute to the organization by identifying and delivering on specific benefits.

Options:

A.

TRUE

B.

FALSE

Question 44

Examples of technical metadata include:

Options:

A.

Access permission

B.

Recovery and backup rules

C.

Colum properties

D.

Data subject properties

Question 45

Data governance and IT governance are the same thing.

Options:

A.

TRUE

B.

FALSE

Question 46

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 47

Options:

A.

FALSE

B.

TRUE

Question 48

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 49

Who should write the main content for a security policy for an organisation?

Options:

A.

A security knowledge area specialist

B.

A data governance knowledge area specialist

C.

The data warehouse developer

D.

The database administrator

E.

The data steward associated with the data

Question 50

Please select the three types of data models:

Options:

A.

Innovative Data Model

B.

Logical Data Model

C.

Dimensional Data model

D.

Conceptual Data Model

E.

Idea Data Model

F.

Physical Data Model

Question 51

The disclosure of sensitive addresses may occur through:

Options:

A.

Inappropriate use of photocopier toner

B.

Ineffective implementation of data architecture

C.

Cloud-based databases

D.

Stored procedures being called directly

E.

Software ignoring privacy tags on the data.

Question 52

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 53

What types of data are considered Technical Data?

Options:

A.

Data standards; ETL job details; source-to-target mappings

B.

Valid value constraints; File format schemas; data models; data access rights

C.

Attributes that are only used for status reporting; data quality rules; data usage, database table names

D.

Physical database and column names; ETL job details; recovery and backup rules; data access rights

E.

Physical data models; calculations and algorithms; program and application names

Question 54

An implemented warehouse and its customer-facing BI tools is a technology product.

Options:

A.

TRUE

B.

FALSE

Question 55

It is unwise to implement data quality checks to ensure that the copies of the attributes are correctly stored.

Options:

A.

FALSE

B.

TRUE

Question 56

What area do you not consider when developing a 'Data Governance operating model?

Options:

A.

Impact of regulation

B.

Cultural factors - such as acceptance of discipline and adaptability to change

C.

The availability of industry data models

D.

The business model - decentralised versus centralised

E.

The value of data to the organization

Question 57

Data Integration and Interoperability is dependent on these other areas of data management:

Options:

A.

Metadata

B.

Data architecture

C.

Data governance

D.

Data security

E.

Data modelling and design

F.

Data storage and operations

Question 58

Some document management systems have a module that may support different types of workflows such as:

Options:

A.

Quality Assurance Testing (QA)

B.

Manual workflows that indicate where the user send the document

C.

User Acceptance Testing (UAT)

D.

Dynamic rules that allow for different workflows based on content

E.

All of the above

F.

None of the above

Question 59

The target of organizational change is expedition.

Options:

A.

TRUE

B.

FALSE

Question 60

The DW encompasses all components in the data staging and data presentation areas, including:

Options:

A.

Operational source system

B.

Data access tools

C.

Data presentation area

D.

Data staging area

E.

All of the above

F.

Technology source system

Question 61

How does the DMBOK refer to an organization that values data as an asset and manages data through all phases of its lifecycle?

Options:

A.

A Data integration organization

B.

A Data support organization

C.

A Data-driven organization

D.

A Data-centric organization

E.

A Data management organization

Question 62

The goals of implementing best practices around document and content management include:

Options:

A.

Ensuring effective and efficient retrieval and use of data and information in unstructured formats

B.

Ensuring integration capabilities between structured and unstructured data

C.

Complying with legal obligations and customer expectations

D.

Enduring integration competencies between semi-structured systems

E.

Managing the performance of data transactions

F.

Make the integration between data management and data analytics possible

Question 63

The repeated implementation of different CRM technologies with different data

structures is mostly a failure of:

Options:

A.

Data security

B.

Data modelling

C.

Data architecture

D.

Data warehousing

E.

Data quality

Question 64

Top down' and "bottom up' data analysis and profiling is best done in concert

because:

Options:

A.

It gets everyone involved

B.

It balances business relevance and the actual state of the data

C.

Data quality tools are more productive when they are effectively configured

D.

It gives something for the architects to do while the profilers get on with thework

E.

It allows the profiler to show the business the true state of the data

Question 65

Technical Metadata provides data about the technical data, the systems that store data, and the processes that move between systems.

Options:

A.

TRUE

B.

FALSE

Question 66

Controlling data availability requires management of user entitlements and of structures that technically control access based on entitlements.

Options:

A.

FALSE

B.

TRUE

Question 67

To push up the urgency level requires adding of the sources of complacency or increasing of their impact.

Options:

A.

TRUE

B.

FALSE

Question 68

CIF stands for:

Options:

A.

Company Information Factory

B.

Corporate Information Floor

C.

Corporate Information Factories

D.

Corporate Information Factory

Question 69

Technical metadata describes details of the processing and accessing of data.

Options:

A.

FALSE

B.

TRUE

Question 70

Which of these best describes the purpose of a Communications Plan in Data Governance?

Options:

A.

A Communications plan is required to schedule the email updates to stakeholders

B.

Implementing Data Governance requires you to know who to communicate issues and incidents via social media

C.

Implementing Data Governance requires you to engage with external suppliers to tell them what standards have changed

D.

Implementing Data Governance is a change management activity, and planned communications are essential for successful change

E.

Implementing Data Governance is a great brand development opportunity for your organization, so you need to engage media in a planned way

Question 71

Operational Metadata describes details of the processing and accessing of data. Which one is not an example:

Options:

A.

Error logs

B.

Schedule anomalies

C.

Purge criteria

D.

Failure logs

Question 72

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:

Options:

A.

Choosing a maturity model for an organization is expensive

B.

Vendors may go out of business so organizations need to choose wisely

C.

Performing an assessment without evaluating multiple models does not provide the organization with the ability to use the easiest model

D.

Each maturity model is flawed and the organization must find the flaws and work around them

E.

Each DMMM is based on a specific approach and needs to align with an organization's needs

Question 73

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 74

Two risks with the Matching process are:

Options:

A.

False positives

B.

False Certainties

C.

False Negatives

D.

False Uncertainties

Question 75

The best DW/BI architects will design a mechanism to connect back to transactional level and operational level reports in an atomic DW.

Options:

A.

FALSE

B.

TRUE

Question 76

The failure to gain acceptance of a business glossary may be due to ineffective:

Options:

A.

Metadata Management

B.

Business Architecture

C.

Content and Document Management

D.

Data Governance

E.

Data Security

Question 77

All organizations have the same Master Data Management Drivers and obstacles.

Options:

A.

TRUE

B.

FALSE

Question 78

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 79

The impact of the changes from new volatile data must be isolated from the bulk of the historical, non-volatile DW data. There are three main approaches, including:

Options:

A.

All of the above

B.

Streaming

C.

Messaging

D.

Technology

E.

Data

F.

Trickle Feeds

Question 80

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

Options:

A.

TRUE

B.

FALSE

Question 81

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?

Options:

A.

There has been too much investment in Data Governance and data management tools without improving the data

B.

The people who were new to the organization were assigned to Data Governance

C.

People were assigned roles based on a somewhat random connection to the data, and without a clear purpose

D.

The Data Governance initiative leaders are using outdated vocabulary

E.

The data standards are too general and high level for proper enforcement

Question 82

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 83

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

Options:

A.

TRUE

B.

FALSE

Question 84

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 85

The accuracy dimension has to do with the precision of data values.

Options:

A.

TRUE

B.

FALSE

Question 86

A pensioner who usually receives a quarterly bill of around $300 was sent a

$100,000,000 electricity bill. They were a victim of poor data quality checks in

which dimension?

Options:

A.

Currency

B.

Integrity

C.

Accuracy

D.

Reasonableness

E.

Timeliness

Question 87

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 88

An organization will create an uncover valuable Metadata during the process of developing Data Integration and Interoperability solutions.

Options:

A.

TRUE

B.

FALSE

Question 89

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?

Options:

A.

You did not secure appropriate budget or resources for the engagement and did not properly define the project charter

B.

You failed to correctly scope the analysis project and did not secure resources to deliver a fully executed solution to address root causes

C.

You failed to communicate to your team the importance of achieving a workable solution to the issues identified

D.

You failed to correctly manage expectations about the roles, responsibilities, and accountabilities for Data Governance in the organisation and are dependent on other areas to execute your recommendations

E.

You adopted an incorrect methodology to your Data Governance and have failed to execute necessary information management tasks

Question 90

All assessments should include a roadmap for phased implementation of the recommendations. This is important because:

Options:

A.

The roadmap shows how to implement the important assessment results, and when to do so

B.

A roadmap will highlight items in an implementation sequence and on other considerations (budget, resources, other programs, etc.)

C.

A roadmap is just another way of saying you should have a plan

D.

A roadmap is the only way for the organization to understand the results of the assessment

E.

A roadmap includes a project plan, which gives the stakeholders information on how each recommendation will be implemented

Question 91

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 92

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

Options:

A.

TRUE

B.

FALSE

Question 93

How can the Data Governance process best support Regulatory reporting requirements?

Options:

A.

By providing a look up service for definitions

B.

By ensuring that data is properly owned, understood, defined, documented and controlled

C.

By performing a data audit

D.

By creating a map of the enterprise data stores where copies of information may be found

E.

By highlighting challenges of multiple definitions within the enterprise

Question 94

What result(s) is/are Data Handling Ethics trying to avoid?

Options:

A.

Loss of reputation for the organization and loss of customers

B.

Unethical use of information by staff to achieve business outcomes; customers trust so they are willing to pay more

C.

Increased Risk for people whose data is exposed and criminal proceedings

D.

Ensure that Data Governance is in line with Corporate Governance and ethic business statements

E.

Ensure that organizations are adhering to ethical standards set by industry and bodies such as the World Economic Forum

Question 95

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 96

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

Options:

A.

TRUE

B.

FALSE

Question 97

Metadata is described using a different set of categories, not including:

Options:

A.

Descriptive metadata

B.

Database metadata

C.

Structural metadata

D.

Administrative metadata

Question 98

Critical success factors throughout the BI/DW lifecycle include:

Options:

A.

Business readiness

B.

A clear and consistent focus

C.

Vision alignment

D.

Business sponsorship

E.

Linear symmetry

F.

A consistent line across display methods

Question 99

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

Options:

A.

TRUE

B.

FALSE

Question 100

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 101

Business rules describe why business should operate internally, in order to be successful and compliant with the outside world.

Options:

A.

FALSE

B.

TRUE

Question 102

A Metadata repository contains information about the data in an organization, including:

Options:

A.

Hierarchical

B.

Data structure

C.

Warped

D.

Business rules for managing data

E.

Content

F.

None of the above

Question 103

Data security issues, breaches and unwarranted restrictions on employee access to data cannot directly impact operational success.

Options:

A.

TRUE

B.

FALSE

Question 104

Malware refers to any infectious software created to damage, change or improperly access a computer or network.

Options:

A.

TRUE

B.

FALSE

Question 105

The impact of the changes from new volatile data must be isolated from the bulk of the historical, non-volatile DW data. There are three main approaches, including:

Options:

A.

Streaming

B.

Messaging

C.

DAAS

D.

Trickle Feeds

Question 106

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 107

What model is the highest level model within the enterprise data model?

Options:

A.

Logical model

B.

Physical model

C.

Conceptual model

D.

Subject Area model

Question 108

A staff member has been detected inappropriately accessing client records from

usage logs. The security mechanism being used is an:

Options:

A.

Access

B.

Audit

C.

Entitlement

D.

Authorisation

E.

Authentication

Question 109

SOR Stands for:

Options:

A.

Service of Record

B.

System of Record

C.

System on Record

D.

Service over Record

Question 110

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 111

The Data Warehouse encompasses all components in the data staging and data presentation areas, including:

Options:

A.

Data Access Tool

B.

Application Tool

C.

Operational source systems

D.

Data staging area

E.

Data presentation area

F.

All of the above

Question 112

Examples of technical metadata include:

Options:

A.

Column Properties

B.

Access permissions

C.

Internal

D.

Conceptual

E.

ETL job details

Question 113

Business Intelligence tool types include:

Options:

A.

Technology reporting

B.

Operational reporting

C.

Descriptive, self-service analytics

D.

Operations performance management (OPM)

E.

Business performance management (BPM)

F.

Predictive, self-service analytics

Question 114

Examples of data enhancement includes:

Options:

A.

All of the above

B.

Audit data

C.

Contextual information

D.

Incorporate Enterprise Technology

E.

Reference vocabularies

F.

Select Notation

Question 115

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

Options:

A.

TRUE

B.

FALSE

Question 116

A business driver for Master Data Management program is managing data quality.

Options:

A.

TRUE

B.

FALSE

Question 117

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.

Options:

A.

TRUE

B.

FALSE

Question 118

A data governance strategy defines the scope and approach to governance efforts. Deliverables include:

Options:

A.

Charter

B.

Operating framework and accountabilities

C.

Implementation roadmap

D.

Plan for operational success

E.

All of the above

F.

None of the above

Question 119

A dimensional physical data model is usually a star schema, meaning there is one structure for each dimension.

Options:

A.

FALSE

B.

TRUE

Question 120

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.

Options:

A.

FALSE

B.

TRUE

Question 121

Open by default' document control will assist data sharing by:

Options:

A.

Allocating more metadata to each document

B.

Automatically opening the document when it is selected on the desktop

C.

Keeping the documents open on the desktop ready for use

D.

Setting the security to shared unless overwritten

E.

Automatically moving the data to the warehouse where everybody can access it

Question 122

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.

Options:

A.

TRUE

B.

FALSE

Question 123

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 124

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 125

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 126

SDLC stands for:

Options:

A.

System development leverage cycle

B.

System design lifecycle

C.

System and design long cycle

D.

System development lifecycle

Question 127

Snowflaking is the term given to normalizing the flat, single-table, dimensional structure in a star schema into the respective component hierarchical or network structures.

Options:

A.

TRUE

B.

FALSE

Question 128

Please select the incorrect item that does not represent a dimension in the Data Values category in Data Quality for the Information age.

Options:

A.

Currency

B.

Timeliness

C.

Consistency

D.

Completeness

Question 129

Coupling describes the degree to which two systems are intertwined.

Options:

A.

FALSE

B.

TRUE

Question 130

Big data is often defined by three characteristics. They are:

Options:

A.

Size, Speed and Sensitivity

B.

Volume, Variety and Velocity

C.

Direction, Depth and Details

D.

Expansive, Engaged and Enormous

E.

Complexity, Compliance and Completeness

Question 131

The IBM Data Governance Council model is organized around four key categories. Select the answer that is not a category.

Options:

A.

Outcomes

B.

System Lifecycles

C.

Enablers

D.

Core disciplines

E.

Supporting disciplines

Question 132

Corrective actions are implemented after a problem has occurred and been detected.

Options:

A.

FALSE

B.

TRUE

Question 133

Factors that have shown to play a key role in the success in the success of effective data management organizations does not include:

Options:

A.

Clear vision

B.

Orientation and training

C.

Leadership alignment

D.

IT sponsorship

Question 134

Modeling Bid data is a non-technical challenge but critical if an organization that want to describe and govern its data.

Options:

A.

TRUE

B.

FALSE

Question 135

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 136

Wat data architecture designs represent should be clearly documented. Examples include:

Options:

A.

Priority

B.

Retirement

C.

Preferred

D.

All of the above

E.

Current

F.

Emerging

Question 137

Content refers to the data and information inside a file, document or website.

Options:

A.

TRUE

B.

FALSE

Question 138

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?

Options:

A.

Agreed models for data design and definition, decision rights regarding standards and controls, delegation of accountability

B.

Agreed models for decision making and decision rights, defined authority and escalation paths, structures for assigning accountability and delegating responsibility, alignment with business objectives

C.

Agreed architectures, transparent policies, shared language, effective tools, delegated authority, stewardship

D.

Exercise of authority, formalization of reporting lines, implementation of supporting technology, definition of common glossaries

E.

Alignment of Business and Technology strategies, definition of data standards, implementation of supporting metadata and process tools, management of responsibility

Question 139

Inputs in the data modelling and design context diagram include:

Options:

A.

Data standards

B.

Data sets

C.

Data Management Architecture

D.

Systems Architecture

E.

Data architecture

F.

Enterprise taxonomy

Question 140

When constructing an organization’s operating model cultural factors must be taken into consideration.

Options:

A.

TRUE

B.

FALSE

Question 141

An application DBA leads the review and administration of procedural database objects.

Options:

A.

TRUE

B.

FALSE

Question 142

The acronym CMDB stands for:

Options:

A.

Customization management tools or databases

B.

Classic management technologies or databases

C.

Cached management technologies or databases

D.

Configuration management tools or databases

E.

Cached management tools or databases

F.

Classic monitoring technologies or databases

Question 143

As an often-overlooked aspects of basic data movement architecture, Process controls include:

Options:

A.

Consistency logging

B.

Exception logs

C.

Database activity logs

D.

Alerts

E.

Exception logs

F.

All of the above

Question 144

Traditional tool sin data visualtization have both a data and a graphical component. Advanced visualization and discovery tools use in-memory architecture to allow users to interact with the data.

Options:

A.

TRUE

B.

FALSE

Question 145

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

Options:

A.

TRUE

B.

FALSE

Question 146

Please select the answers that correctly describes where the costs of poor quality data comes from.

Options:

A.

Scrap and rework

B.

Organizational conflict

C.

High job satisfaction

D.

High productivity

E.

Reputational costs

F.

Compliance costs

Question 147

A goal of a Reference and Master Data Management program include enabling master and reference data to be shared across enterprise functions and applications.

Options:

A.

FALSE

B.

TRUE

Question 148

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 149

Please select valid modelling schemes or notations

Options:

A.

NoSQL

B.

Dimensional

C.

Relational

D.

Object-orientated

E.

Fact-based

F.

Matrix-based

Question 150

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?

Options:

A.

Oversight of a particular resource

B.

Agreed models for risk management over the particular resource

C.

Oversight of a resource that represents other resources, therefore supporting other resource governance

D.

Ensuring compliance with regulation for the particular resource

E.

Agreed models for decision making and decision rights, defined authority, and escalation paths for the resource

Question 151

Please select the user that best describes the following description: Uses the business glossary to make architecture, systems design, and development decisions, and to conduct the impact analysis.

Options:

A.

Business user

B.

Technical user

C.

Analytical user

D.

None of the above

E.

Advanced user

Question 152

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:

Options:

A.

Metadata Management

B.

Data Storage

C.

Data Modelling

D.

Master Data

E.

Reference data

Question 153

What are the three characteristics of effective Data Governance communication?

Options:

A.

It must be clear, unambiguous, and consistent

B.

It must be clear, structured, repetitive

C.

It must be viral, vital, and have volume

D.

It must be colorful, engaging, using multi-media

E.

It must be consistent, unambiguous, engaging

Question 154

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.

Options:

A.

TRUE

B.

FALSE

Question 155

DMMA ratings represent a snapshot of the organization’s capability level.

Options:

A.

TRUE

B.

FALSE

Question 156

An advantage of a centralized repository include: High availability since it is independent of the source systems.

Options:

A.

TRUE

B.

FALSE

Question 157

When assessing security risks it is required to evaluate each system for the following:

Options:

A.

The current security protections in place

B.

The requirements to protect the data

C.

None of the above

D.

All of the above

E.

The complexity of the data stored or in transit

F.

The sensitivity of the data stored or in transit

Question 158

Data architect: A senior analyst responsible for data architecture and data integration.

Options:

A.

TRUE

B.

FALSE

Question 159

The Belmont principles that may be adapted for Information Management disciplines, include:

Options:

A.

Respect for Persons

B.

Respect for Machines

C.

Beneficence

D.

Criminality

E.

Justice

Question 160

Decentralized informality can be made more formal through a documented series of connections and accountabilities via a RACI matrix.

Options:

A.

TRUE

B.

FALSE

Question 161

All DMM and Data Governance assessments should identify its objectives and goals for improvement. This is important because:

Options:

A.

There is always room for improvement

B.

An assessment without goals and objectives will not have a conclusion

C.

The assessment team has to be aware of the objectives to be successful

D.

Data management and Data Governance assessments have different goals and objectives

E.

Assessment objectives start at the business drivers (for funding), goals to describe focus, and objectives to provide specific expectations and criteria for evaluation for success

Question 162

Value is the difference between the cost of a thing and the benefit derived from that thing.

Options:

A.

TRUE

B.

FALSE

Question 163

Industry is struggling to distinguish the accountabilities of CDO and CIO. The definition of their responsibilities may specify parts of:

Options:

A.

Financial management functions

B.

Metadata functions

C.

Data security functions

D.

Data architecture functions

E.

Business intelligence functions

Question 164

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.

Options:

A.

TRUE

B.

FALSE

Question 165

A controlled vocabulary is a defined list of explicitly allowed terms used to index, categorize, tag, sort and retrieve content through browsing and searching.

Options:

A.

TRUE

B.

FALSE

Question 166

Elements that point to differences between warehouses and operational systems include:

Options:

A.

Historical

B.

Data security standards

C.

Subject-orientated

D.

Non-volatile

E.

Data quality

F.

Integrated

Question 167

What is the best definition of Crowdsourced data collection?

Options:

A.

Crowdsourcing should not be used to gather data because there will be too many opinions and not enough facts

B.

Crowdsourcing is the process of obtaining needed data by soliciting contributions from a large group of people, and especially from an online community, rather than from traditional employees or suppliers  

C.

Crowdsourced data is the best way of finding data because so many people are contributing their definitions

D.

Crowdsourced data is the data that comes from using a company wiki to gather data because anyone in the crowd can contribute

E.

Crowdsourced data collection is only used by researchers to answer research, survey or feedback questions

Question 168

For each subject area logical model: Decrease detail by adding attributes and less-significant entities and relationships.

Options:

A.

TRUE

B.

FALSE

Question 169

Business metadata focuses largely on the content and condition of the data and includes details related to data governance.

Options:

A.

TRUE

B.

FALSE

Question 170

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 171

Access to data for Multidimensional databases use a variant of SQL called MDX or Multidimensional expression.

Options:

A.

FALSE

B.

TRUE

Question 172

Resource Description Framework (RDF), a common framework used to describe information about any Web resource, is a standard model for data interchange in the Web.

Options:

A.

FALSE

B.

TRUE

Question 173

A sandbox environment can either be a sub-set of the production system, walled off from production processing or a completely separate environment.

Options:

A.

TRUE

B.

FALSE

Question 174

The acronym BASE is made up of:

Options:

A.

Basically available

B.

Basically not available

C.

Software state

D.

Soft state

E.

Eventual consistency

F.

Everything considered

Question 175

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?

Options:

A.

Data Security

B.

Record Retention Department

C.

Data Owners

D.

Regulations/Laws

E.

Business Analysts

Question 176

The steps followed in managing data issues include:

Options:

A.

Standardization, Allocation, Assignment, and Correction

B.

Standardization, Explanation, Ownership, and Completion

C.

Read, Guess, Code, Release

D.

Standardization, Assignment, Escalation, and Completion

E.

Escalation, Review, Allocation and Completion

Question 177

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 178

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 179

The Data Governance Council (DGC) manages data governance initiatives, issues, and escalations.

Options:

A.

TRUE

B.

FALSE

Question 180

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 181

Data flows map and document relationships between data and locations where global differences occur.

Options:

A.

TRUE

B.

FALSE

Question 182

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 183

Data Governance requires which of the following?

Options:

A.

Culture Change

B.

Data Reference Model

C.

Data Governance Tools

D.

Master Data Management

E.

Data Dictionary

Question 184

Data profiling is a form of data analysis used to inspect data and assess quality.

Options:

A.

TRUE

B.

FALSE

Question 185

What are the three qualities of an effective Data Governance function?

Options:

A.

Optimism, objective, sustainable

B.

Sustainable, embedded, measured

C.

Measured, objective, embedded

D.

Embedded, systematic, sustainable

E.

Sustainable, realistic, embedded

Question 186

The data in Data warehouses and marts differ. Data is organized by subject rather than function

Options:

A.

TRUE

B.

FALSE

Question 187

A change management program supporting Data Governance should focus communication on what?

Options:

A.

Promoting the value of its data assets, monitor and act on feedback about Data Governance activities & implement data management training programs.

B.

Promote the value of its data assets

C.

Show the value of data stewardship & implement data management training program

D.

How many errors are in each of the various department's data

E.

Implement a data management training program and create a data dictionary

Question 188

The purpose for adding redundancy to a data model (denormalisation) is to:

Options:

A.

Make it easier for developers to join tables

B.

Avoid the loss of data by storing key values more than once

C.

Improve aggregate database performance across read requests

D.

Fully utilize all the indexes

E.

Ensure surrogate keys are retaining their unique values in all satellite tables

Question 189

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

Options:

A.

TRUE

B.

FALSE

Question 190

Which of the following are must-do for any successful Data Governance programme?

Options:

A.

Create a communications plan to inform to all stakeholders what you are doing.

B.

Ensure there is a Data Governance Policy with which everyone in the organization is required to comply.

C.

Create a training programme for all for data owners and data stewards.

D.

Set up a wiki for incorrect data definitions.

E.

Allocate Data Ownership responsibilities according to their role in the organization.

Question 191

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 192

When it comes to Data Governance, what does the Operations Plan include?

Options:

A.

The list of events required to implement and operate Data Governance activities

B.

A risk assessment for the enterprise

C.

The types of enterprise operations that need Data Governance

D.

The metrics needed for each department within the organization

E.

The list of activities the Data Stewards will follow to define the data

Question 193

A key feature of Bill Inmon’s approach to data warehousing is:

Options:

A.

A tight management of data dimensions

B.

An exclusive focus on star schemas and cubes

C.

A normalized relational model to store and manage data

D.

A preference for supporting operational reporting

E.

Its ability to operate on open-source platforms

Question 194

Naming standards for data domains should:

Options:

A.

Contain acronyms that are relevant to the organization because everyone should know them

B.

Be approved by the database administrators

C.

Minimize name changes across environments

D.

Should reflect their specific environment such as QA, Pre-Prod and Production

E.

Be short for ease of use

Question 195

When recovering from multiple system failures, what is the biggest difficulty faced

by a DBA?

Options:

A.

Determining where the corrupt pages exist in the database file system

B.

Determining what point to recover to using backups taken at different points intime

C.

Reseting active directory to reapply the security policies

D.

Organising for the tapes to be delivered to the main data center

E.

Determining what version of the DBMS to recover - considering incrementalPatches

Question 196

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

Options:

A.

TRUE

B.

FALSE

Question 197

The need to manage data movement efficiently is a primary driver for Data Integration and Interoperability.

Options:

A.

TRUE

B.

FALSE

Question 198

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 199

Within each area of consideration mentioned in question 13, they should address morale adversity as per Ethical Risk Model for Sampling Projects.

Options:

A.

FALSE

B.

TRUE

Question 200

Gathering and interpreting results from a DMM or Data Governance assessment are important because:

Options:

A.

Lack of results gathered can indicate a lack of assessment performance

B.

The assessments are done by different teams within the organization and may have different results

C.

Interpreting these results is difficult

D.

Data Management and Data Governance results are gathered and interpreted differently, depending on the organization being evaluated

E.

Performing these activities objectively can ensure the success of the assessment and affect the acceptance and implementation of the data management and/or Data Governance program

Question 201

Operationality and interoperability depends on the data quality. In order to measure the efficiency of a repository the data quality needs to be:

Options:

A.

Stored in a Cloud for easy access

B.

Quantified by some type of metrics

C.

Be certified by a Data Governance team

D.

Have complete definitions

E.

Verified by the organization's legal department

Question 202

A node is a group of computers hosting either processing or data as part of a distributed database.

Options:

A.

TRUE

B.

FALSE

Question 203

Content management includes the systems for organizing information resources so that they can specially be stored.

Options:

A.

TRUE

B.

FALSE

Question 204

The TOGAF framework does NOT include a(n):

Options:

A.

Business focus

B.

Enterprise continuum approach

C.

Metamodel

D.

Methods

E.

Maturity model

Question 205

When constructing models and diagrams during formalisation of data architecture there are certain characteristics that minimise distractions and maximize useful information. Characteristics include:

Options:

A.

Linear symmetry

B.

A match between all diagram objects and the legend

C.

A clear and consistent legend

D.

A consistent line across display methods

E.

Consistent object attributes

F.

A clear and consistent line direction

Question 206

Confirming and documenting understanding of different perspectives facilitate:

Options:

A.

Formalization

B.

Normalization

C.

Scope definition

D.

Knowledge retention/documentation

Question 207

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 208

The Data Warehouse (DW) is a combination of three primary components: An integrated decision support database, related software programs and business intelligence reports.

Options:

A.

FALSE

B.

TRUE

Question 209

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

Options:

A.

TRUE

B.

FALSE

Question 210

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

Options:

A.

Staging areas

B.

Data marts

C.

Cubes

D.

Kubernetes

Question 211

Regulations including the Sarbanes-Oxley Act require evidence of data lineage and accuracy. How can Data Governance aid organisations in achieving this goal?

Options:

A.

Capture and document all metrics and store in a central repository

B.

Undertake an audit of current process and produce a report

C.

Create a new data store for regulator required metrics

D.

Perform an 'as-is' review of data quality

E.

Provide the framework and guidance to enable a business led ongoing Data Governance process

Question 212

What is a steward?

Options:

A.

A sponsor

B.

A stakeholder

C.

A person whose job it is to manage the property of another person

D.

A person responsible to follow trends

E.

An employer

Question 213

XML provides a language for representing both structures and unstructured data and information.

Options:

A.

TRUE

B.

FALSE

Question 214

Veracity refers to how difficult the data is to use or to integrate.

Options:

A.

TRUE

B.

FALSE

Question 215

Improving data quality requires a strategy that accounts for the work that needs to be done and the way people will execute it.

Options:

A.

TRUE

B.

FALSE

Question 216

Drivers for data governance most often focus on reducing risk or improving processes. Please select the elements that relate to the reduction in risk:

Options:

A.

Specific risk management

B.

General risk management

C.

Data ethics

D.

Data security

E.

Publicity

F.

Privacy

Question 217

Which of the following would NOT be an interest of Data Governance?

Options:

A.

Inconsistent definitions

B.

Competing versions of source data

C.

Metadata

D.

Database development

E.

Redundant data

Question 218

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 219

Which Data Architecture Artifact describes how data transforms into business

assets?

Options:

A.

Implementation Roadmap

B.

Data Value Chain

C.

Master Data Models

D.

Business Value Chains

E.

Data Flows

Page: 1 / 73
Total 725 questions