Data Management Fundamentals DMF-1220 Actual Questions

dumps2022-03-07T01:46:27+08:00

Data Management Fundamentals DMF-1220 actual questions are the best material in the preparation. There are 100 multiple choice questions in real DAMA certification DMF-1220 exam, and you have 90 minutes to finish the test. All the Data Management Fundamentals DMF-1220 actual questions can help you study all the related skills. Free DAMA DMF-1220 exam actual questions are below.

Page 1 of 15

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

TRUE

FALSE

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

Charter

Operating framework and accountabilities

Implementation roadmap

Plan for operational success

All of the above

None of the above

3. Data stewardship is the least common label to describe accountability and responsibility for data and processes to ensure effective control and use of data assets.

TRUE

FALSE

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

TRUE

FALSE

5. Orchestration is the term used to describe how multiple processes are organized and executed in a system.

TRUE

FALSE

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

FALSE

TRUE

7. 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.

TRUE

FALSE

8. Sample value metrics for a data governance program include:

Reduction of risk

Improved efficiency in operations

Effectiveness of education

Achievements of goals and objectives

Contributions to business objectives

Effectiveness of communication

9. RACI is an acronym that is made up of the following terms.

Control

Responsible

Accountable

Informed

Reliable

Consulted

10. SLA Stands for:

Service Level Agreement

System Lifecycle Audit

System Latitude Audit

Service Lifecycle Audit

Page 2 of 15

11. Different types of product Master Data solutions include:

People Lifecycle Product Management (PLPM)

Product data in Manufacturing Execution Systems (MES)

None of the above

Product Data in Enterprise Resource Planning (ERP)

Product Lifecycle Management (PLM)

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

TRUE

FALSE

13. Please select the transition phases in Bridges’ Transition process:

The neutral zone

The new beginning

The ending

The transition

The translation

The game

14. The business glossary should capture business terms attributes such as:

Lineage

Utilization

Common misunderstanding in terms

System development

Algorithms to supporting definitions

All of the above

15. Use business rules to support Data Integration and Interoperability at various points, to:

Direct the flow of data in the organization

Monitor the organization’s operational data

Software alerts when events are triggered

Direct when to automatically trigger events and alerts

Consistency in allocation event resources

None of the above

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

TRUE

FALSE

17. Most document programs have policies related to:

Scope and compliance audits

Proper destruction of records

Proper construction of records

Identification and protection of vital records

Partition tolerance

All of the above

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

FALSE

TRUE

19. Data lineage is useful to the development of the data governance strategy.

TRUE

FALSE

20. 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.

TRUE

FALSE

Page 3 of 15

21. Functionality-focused requirements associated with a comprehensive metadata solution, include:

Synchronization

Structure

None of the above

History

Volatility

Access rights

22. While the focus of data quality improvement efforts is often on the prevention of errors, data quality can also be improved through some forms of data processing.

TRUE

FALSE

23. Valuation information, as an example of data enrichment, is for asset valuation, inventory and sale.

TRUE

FALSE

24. All metadata management solutions include architectural layers including:

Metadata Quality Assurance Testing

Metadata integration

Metadata usage

Metadata delivery

Metadata control and management

None of the above

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

Business requirements

Business metadata

Technical metadata

Metadata standards

Process Metadata

26. A deliverable in the data architecture context diagram includes an implementation roadmap.

TRUE

FALSE

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

TRUE

FALSE

28. Some ways to measure value of data include:

Replacement cost

Market value

Selling Data

Risk cost

Identified opportunities

All of the above

29. Match rules for different scenarios require different workflows, including:

Consistency rules

Duplicate identification match rules

Match-merge rules

Match-split rules

Match-link rules

All of the above

30. The IT security policy provides categories for individual application, database roles, user groups and information sensitivity.

TRUE

FALSE

Page 4 of 15

31. Data profiling examples include:

Counts of null

Max/Min value

Max/Min length

Frequency distribution

Data type and format

None of the above

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

TRUE

FALSE

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

TRUE

FALSE

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

Logical model

Physical model

Conceptual model

Subject Area model

35. Data Integration and Interoperability (DII) describes processes related to the movement and consolidation of data within and between data stores, applications and organizations.

TRUE

FALSE

36. Examples of concepts that can be standardized within the data architecture knowledge area include:

Enterprise data models

System naming conventions

None of the above

Data security standards

Data quality rules

Tool standards

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

TRUE

FALSE

38. Reference and Master Data Management follow these guiding principles:

Quality

Stewardship

Authority

Ownership

Exclusivity

Inclusivity

39. Self-service is a fundamental delivery channel in the BI portfolio.

TRUE

FALSE

40. The Shewhart chart contains the following elements:

Plan

Utilization

Check

Act

All of the above

Page 5 of 15

41. The warehouse has a set of storage areas, including:

Staging area

Data marts

Consistent object attributes

Operational data store (ODS)

Cubes

Central warehouse

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

TRUE

FALSE

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

Profiling

Application reduction

Association

Data reduction

Clustering

All of the above

44. Examples of technical metadata include:

Column Properties

Access permissions

Internal

Conceptual

ETL job details

45. CMDB provide the capability to manage and maintain Metdata specifically related to the IT assets, the relationships among them, and contractual details of the assets.

TRUE

FALSE

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

FALSE

TRUE

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

TRUE

FALSE

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

TRUE

FALSE

49. Please select the correct General Accepted Information Principles:

Asset Principle

Audit Principle

Due Diligence Principle

Going Concern Principle

Ethical Principle

All of the above

50. Corporate Information Factory (CIF) components include:

Data marts

Objectives

Operational Reports

Reduction of risk

Staging Area

Contributions to business objectives

Page 6 of 15

51. Inputs in the data quality context diagram include:

Data stores

Data lakes

Business requirements

Data quality expectations

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

TRUE

FALSE

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

TRUE

FALSE

54. Architects seek to design in a way that brings value to an organisation. To reach these goals, data architects define and maintain specifications that:

Align data architecture with enterprise strategy and business architecture

Provide a standard business vocabulary for data and components

Outline high-level integrated designs to meet these requirements.

Integrate with overall enterprise architecture roadmap

Define the current state of data in the organization.

Express strategic data requirements

55. A limitation of the centralized metadata repository approach is it may be less expensive.

TRUE

FALSE

56. Big data primarily refers specifically to the volume of the data.

TRUE

FALSE

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

TRUE

FALSE

58. BI tool types include:

BPM

Operational reporting

Data lake extraction

Diagnostic, self-service analytics

Descriptive, self-service analytics

Reduction of risk

59. The goals of Data Integration and Interoperability include:

Provide data securely, with regulatory compliance, in the format and timeframe needed.

Lower cost and complexity of managing solutions by developing shared models and interfaces.

Managing the availability of data throughout the data lifecycle

Provide the starting point for customizations, integration or even replacement of an application

Identify meaningful events and automatically trigger alerts and actions.

Support business intelligence, analytics, master data management and operational efficiency efforts.

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

Respect for Persons

Respect for Machines

Beneficence

Criminality

Justice

Page 7 of 15

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

Historical

Data security standards

Subject-orientated

Non-volatile

Data quality

Integrated

62. Please select the correct general cost and benefit categories that can be applied consistently within an organization.

Cost of erasing data from servers

Cost of improving data

What the data could be sold for

Benefit of higher quality data

Cost of replacing data if it were lost

What competitors would pay for data

63. Please select correct term for the following sentence: An organization shall assign a senior executive to appropriate individuals, adopt policies and processes to guide staff and ensure program audibility.

Principle of integrity

Principle of availability

Principle of retention

Principle of accountability

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

Scrap and rework

Organizational conflict

High job satisfaction

High productivity

Reputational costs

Compliance costs

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

Data Efficiency

One size does not fit all

Contracts

Focus on the business goals

Start with the end in mind

Collaborate

66. A ‘Golden Record’ means that it is always a 100% complete and accurate representation of all entities within the organization.

TRUE

FALSE

67. Data quality issues cannot emerge at any point in the data lifecycle.

FALSE

TRUE

68. SSD is the abbreviation for Solid State Dimension.

TRUE

FALSE

69. Please select valid modelling schemes or notations

NoSQL

Dimensional

Relational

Object-orientated

Fact-based

Matrix-based

70. Consistent input data reduces the chance of errors in associating records. Preparation processes include:

Standardization

Enrichment CValidation

Database management

Page 8 of 15

71. Confirming and documenting understanding of different perspectives facilitate:

Formalization

Normalization

Scope definition

Knowledge retention/documentation

72. The first two steps in the data science process are:

Define Big Data data strategy & Business Need(s)

Choose Data Sources

Develop Data Science Hypotheses and Mehods

Acquire & Ingest Data source(s)

73. 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.

FALSE

TRUE

74. A synonym for transformation in ETL is mapping. Mapping is the process of developing the lookup matrix from source to target structures, but not the result of the process.

TRUE

FALSE

75. Temporal aspects usually include:

Valid time

Transmitting time

Transaction time

Value time

76. Three data governance operating models types include:

Centralized

Decentralized

Feathered

Federated

Replicated

Duplicated

77. CMA is an abbreviation for Capability Maturity Assessment.

TRUE

FALSE

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

TRUE

FALSE

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

Consistency logging

Exception logs

Database activity logs

Alerts

Exception logs

All of the above

80. There are several reasons to denormalize data. The first is to improve performance by:

Creating smaller copies of fata to reduce costly run-time calculations and/or table scans of large tables.

None of the above

Pre-calculating and sorting costly data calculations to avoid runt-time system resource competition.

Making tables more readable when no foreign key exists

Combining data from multiple other tables in advance to avoid costly run-time joins

All of the above

Page 9 of 15

81. Vulnerability is defined as:

a patch in a system that allows it to be successfully unpatched and compromised.

being highly data risk rated

a strength in a system that allows external stakeholders to view data records.

a weakness or defect in a system that allows it to be successfully attacked and compromised.

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

TRUE

FALSE

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

Quality Assurance Testing (QA)

Manual workflows that indicate where the user send the document

User Acceptance Testing (UAT)

Dynamic rules that allow for different workflows based on content

All of the above

None of the above

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

TRUE

FALSE

85. With reliable Metadata an organization does not know what data it has, what the data represents and how it moves through the systems, who has access to it, or what it means for the data to be of high quality.

TRUE

FALSE

86. The deliverables in the data architecture context diagram include:

Data flows

Enterprise data

Implementation roadmap

Data Value Chains

None of the above

All of the above

87. 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.

TRUE

FALSE

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

TRUE

FALSE

89. The four main types of NoSQL databases are:

Document

Row-orientated

Graph

Strategic

Key-value

Column-orientated

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

Metadata insecurity

Managing data quality

Reducing risk

Managing the costs of data integration

Meeting organizational data requirements

Reducing latency

Page 10 of 15

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

Managing performance of data assets

Focus on the business goals

Managing the availability of data throughout the data lifecycle

Start with the end in mind

Managing the performance of data transactions

Collaborate

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

TRUE

FALSE

93. 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.

TRUE

FALSE

94. Key processing steps for MDM include:

Data model management

Data acquisition

Data validation, standardization and enrichment

Entity resolution

Data sharing and stewardship

None of the above

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

TRUE

FALSE

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

FALSE

TRUE

97. Advantages if a centralized metadata repository include:

Quick metadata retrieval

None of the above

Combining data from multiple other tables in advance to avoid costly run-time joins

All of the above

High availability

Low latency, since it is independent of the source systems

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

FALSE

TRUE

99. 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.

FALSE

TRUE

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

Create a matching separate code table

Create a master shared code table

None of the above

Program integration by joining tables

Embed rules or valid codes into the appropriate object’s definition.

Roadmap Development

Page 11 of 15

101. Metadata is described using three sets od categories, including:

Structural Metadata

Descriptive Metadata

Generic Metadata

Administrative metadata

Conceptual Metadata

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

FALSE

TRUE

103. Data Governance is at the centre if the data management activities, since governance is required for consistency within and balance between functions.

FALSE

TRUE

104. Control activities to manage metadata stores include:

Roadmap extrapolation

Load statistical analysis

Lineage

Missing metadata reports

Definitions resolutions improvement

Job scheduling and monitoring

105. Subtype absorption: The subtype entity attributes are included as nullable columns into a table representing the supertype entity

FALSE

TRUE

106. Data parsing is the process of analysing data using pre-determined rules to define its content or value.

FALSE

TRUE

107. Data warehouses are often loaded and serviced by a nightly batch window.

FALSE

TRUE

108. 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.

TRUE

FALSE

109. An input in the data architecture context diagram includes data governance.

TRUE

FALSE

110. Enterprise Architecture domains include:

Business Architecture

Data Architecture

Data Management Architecture

Systems Architecture

Application Architecture

Technology Architecture

Page 12 of 15

111. One of the deliverables in the Data Integration and Interoperability context diagram is:

Data Integration and Interoperability Strategy

Data hogging

Data access agreements

Data security plan

112. Please select the four domains of enterprise architecture:

Enterprise software architecture

Enterprise technology architecture

Enterprise business architecture

Enterprise data architecture

Enterprise hardware architecture

Enterprise application architecture

113. Reference data management entails the preventative maintenance of undefined domain values, definitions and the relationship within and across domain values.

TRUE

FALSE

114. 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.

FALSE

TRUE

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

TRUE

FALSE

116. Primary deliverables of the Data Warehouse and Business Intelligence context diagram include:

Data Products

Data Stewardship

Governance Activities

Release Plan

Load Tuning Activities

BI Activity Monitoring

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

TRUE

FALSE

118. The flow of data in a data integration solution does not have to be designed and documented.

TRUE

FALSE

119. Data replication has two dimensions of scaling: diagonal and lateral

FALSE

TRUE

120. Operational Metadata describes details of the processing and accessing of data.

Which one is not an example:

Error logs

Schedule anomalies

Purge criteria

Failure logs

Page 13 of 15

121. In Resource Description Framework (RDF) terminology, a triple store is composed of a subject that denotes a resource, the predicate that expresses a relationship between the subject and the object, and the object itself.

FALSE

TRUE

122. The list of V’s include:

Volatility

Volume

Veracity

Viscosity

Variety

Validity

123. To mitigate risks, implement a network-based audit appliance, which can address most of the weaknesses associated with the native audit tools. This kind of appliance has the following benefits:

Granular transaction tracking

High performance

Transaction time

Separation of duties

124. 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.

FALSE

TRUE

125. SOA stands for:

Service orchestrated architecture

Service orientated access

Service orientated architecture

Service overall architecture

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

TRUE

FALSE

127. If data is not integrated with care it presents risk for unethical data handling. These ethical risks intersect with fundamental problems in data management including: Limited knowledge of data’s origin and lineage; Data of poor quality; Unreliable Metadata; and Documentation of error remediation.

TRUE

FALSE

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

What activities analytics will focus on

How they select their populations for study

All of the above

How data will be captured

How results will be made accessible

129. Data modelling tools are software that automate many of the tasks the data modeller performs.

FALSE

TRUE

130. Possible application coupling designs include:

Relaxed coupling

Loose coupling

Value coupling

Tight coupling

Page 14 of 15

131. Data management organizational constructs include the following type of model.

Network operating model

Decentralized operating model

Centralized operating model

Federation operating model

Hybrid operating model

Integrated operating model

132. Data quality issues only emerge at initial stages of the data lifecycle.

TRUE

FALSE

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

Plan, Develop, Operate, Control

Plan, Do, Check, Act

Measure, Develop, Implement, Monitor, Improve

Planning, Analysis, Design, Implementation & Maintenance

134. The Data Model Scorecard provides 10 data model quality metrics

TRUE

FALSE

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

TRUE

FALSE

136. DBAs exclusively perform all the activities of data storage and operations.

TRUE

FALSE

137. Time-based patterns are used when data values must be associated in chronological order and with specific time values.

TRUE

FALSE

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

FALSE

TRUE

139. Data governance requires control mechanisms and procedures for, but not limited to, facilitating subjective discussions where managers’ viewpoints are heard.

TRUE

FALSE

140. There are three techniques for data-based change data capture, namely:

The source system populates specific data elements.

Application automated interfaces

The source system processes copy data that has changed into a separate object as part of the transaction, which is then used for the extract process.

The source systems send binary code through ASCI that makes the process rapid.

The source system processes add to a simple list of objects and identifiers when changing data, which is then used to control selection of data extraction.

None of the above

Page 15 of 15

141. Data warehousing describes the operational extract, cleaning, transformation, control and load processes that maintain the data in a data warehouse.

TRUE

FALSE

142. Quality Assurance Testing (QA) is used to test functionality against requirements.

TRUE

FALSE

143. A Global ID is the MDM solution-assigned and maintained unique identifier attached to reconciled records.

TRUE

FALSE

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

FALSE

TRUE

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

Compliance hub

Transaction hub

Consolidated hub

Emotions hub

Location hub

Registry

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

TRUE

FALSE

Data Management Fundamentals DMF-1220 Actual Questions

Data Management Fundamentals DMF-1220 Actual Questions

Share this post

Leave a Reply Cancel reply