Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Cdmp > Metadata Management > Flashcards

Metadata Management Flashcards

1
Q

The definition of ___________ is the planning, implementation, and control activities to enable access to high quality, integrated metadata

A

metadata management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Describe the goals of metadata management (per the DMBoK).

A

Goals:
1. Provide organizational understanding of business terms and usage.
2. Collect and integrate metadata from diverse sources.
3. Provide a standard way to access metadata.
4. Ensure metadata quality and security.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

What type of metadata focuses largely on the content and condition of the data and includes details related to data governance?

A

Business metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Name 3 examples of business metadata

A
  • Definitions and descriptions of data sets, tables, and columns
  • Business rules, transformation rules, calculations, and derivations
  • Data models
  • Data quality rules and measurement results
  • Schedules by which data is updated
  • Data provenance and data lineage
  • Data standards
  • Designations of the system of record for data elements
  • Valid value constraints
  • Stakeholder contact information (e.g., data owners, data stewards)
  • Security/privacy level of data
  • Known issues with data
  • Data usage notes
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What type of metadata provides information about the technical details of data, the systems that store data, and the processes that move it within and between systems?

A

Technical metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Give 3 examples of technical metadata

A
  • Physical database table and column names
  • Column properties
  • Database object properties
  • Access permissions
  • Data CRUD (create, replace, update and delete) rules
  • Physical data models, including data table names, keys, and indexes
  • Documented relationships between the data models and the physical assets
  • ETL job details
  • File format schema definitions
  • Source-to-target mapping documentation
  • Data lineage documentation, including upstream and downstream change impact information
  • Program and application names and descriptions
  • Content update cycle job schedules and dependencies
  • Recovery and backup rules
  • Data access rights, groups, roles
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Which type of metadata describes details of the processing and accessing of data?

A

Operational

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Give 3 examples of operational metadata

A
  • Logs of job execution for batch programs
  • History of extracts and results
  • Schedule anomalies
  • Results of audit, balance, control measurements
  • Error Logs
  • Reports and query access patterns, frequency, and execution time
  • Patches and Version maintenance plan and execution, current patching level
  • Backup, retention, date created, disaster recovery provisions
  • SLA requirements and provisions
  • Volumetric and usage patterns
  • Data archiving and retention rules, related archives
  • Purge criteria
  • Data sharing rules and agreements
  • Technical roles and responsibilities, contacts
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

This ISO Metadata Registry Standard, provides a framework for defining a Metadata registry. It is designed to enable Metadata-driven data exchange, based on exact definitions of data, beginning with data elements.

A

ISO/IEC 11179

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

_______________ metadata is data that defines and describes the characteristics of other systems.

A

Process metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Give 3 examples of process metadata

A

Data stores and data involved
Government / Regulatory bodies
Organization owners and stakeholders
Process dependencies and decomposition
process feedback loop documentation
Process name
Process order and timing
Process variations due to input or timing
Roles and Responsibilities
Value chain activities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

_________ is data about the businesses subject matter experts, their processes, and responsibility assignments.

A

Data steward metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Give 3 examples of data stewardship metadata

A

Business drivers / goals
Data CRUD rules
Data definitions - business and technical
Data owners
Data Sharing rules and agreements / contracts
Data Stewards, roles and responsibilities
Data Stores and systems involved
Data subject areas
Data Users
Government / regulatory bodies
Government organization structure and responsibilities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

A metadata architecture that consists of a single metadata repository that contains copies of live metadata from various sources

A

Centralized Metadata Architecture

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

A metadata architecture that consists of a single access point. The metadata retrieval engine responds to user requests by retrieving data from source systems in real time; there is no persistent repository.

A

Distributed Metadata Architecture

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

A metadata architecture that is a combined alternative. Metadata still moves directly from the source systems in to the repository, however, repository design only accounts for the user-added metadata, the critical standardized items and the additions from manual sources.

A

Hybrid Metadata Architecture

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Why is data lineage important? Name 3 Reasons

A

*To show WHAT transformations have been made to the data as it passes from one process to another;
*To show WHICH business processes have been applied to the data; *To highlight WHAT type of actions those processes perform on the Data (Create, Read, Update, Delete);
*To provide an AUDIT TRAIL showing WHO has supplied, accessed, updated, approved and deleted the data and WHEN this occurred; *To trace back when IMPACT ANALYSIS need to be undertaken after a data issue is encountered downstream;
*To confirm that the CORRECT PROCESS has actually been undertaken;
*To affirm that the CORRECT MASTER AND REFERENCE DATA is used in the process;
*To COMPLY with certain aspects of REGULATORY ACTS (e.g. Sarbanes Oxley, HIPAA, Basel, BCBS239 …)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

How does data lineage provide a view of data flow from origin to destination? Names 3 ways.

A

*Rules and transformation for each flow *Enables “what-if analysis” for change in an ETL flow (Extract Transform & Load)
*Helps identify right source and optimum data flow for any new requirement * Provides meaning of specific field in a report *Eliminates data redundancy and ensure completeness
* Provides information on report usage
* Identifies data quality associated with a data element, thus increasing trust * Provides operational metadata

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

What program in data management benefits from the two items below?

  • An end-to-end view eases identification of business rules discrepancy and data incompleteness
  • An end-to-end view improves this program’s response to regulations like Sarbanes-Oxley, HIPAA, Basel II
A

Data Governance

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What are some tools that are used to store metadata?
Name 3-4

A

—Metadata repo
—Business glossary
—Business intelligence
—Configuration management database (CMDB) for IT assets
—Data dictionary
—Data integration tools
—Database management / system catalogs
—Data mapping mgmt tools
—Data Quality tools
—Event messaging tools: move data between diverse systems
—Modeling tools
—MDM and Reference Data repos
—Service registries – service-oriented architecture (SOA) perspective

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

When preparing to implement metadata, a _____________ should be conducted via objective inspection of existing Metadata, along with interviews with key stakeholders.

A

Metadata assessment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Implementation of an enterprise data governance strategy needs senior management support and engagement to help drive _________.

A

Organization and Cultural Change Management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Organizations should determine their specific requirements for the management of the Metadata lifecycle and establish __________ processes to enable those requirements.

A

governance

24
Q

__________ involves the creation, storage, and maintenance of metadata, ensuring that it is accurate, consistent, and easily discoverable.

A

Metadata governance

25
Q
A

Process Controls
Documentation of Metadata Solutions
Metadata Standards and Guidelines
Metrics

26
Q

A __________ of Metadata will include the sources and targets currently in scope. This is a resource for IT and business users and can be published out to the user community as a guide to ‘what is where’ and to set expectations on what they will find:

  • Metadata implementation status
  • Source and the target Metadata store
  • Schedule information for updates
  • Retention and versions kept
  • Contents
  • Quality statements or warnings (e.g., missing values)
  • System of record and other data source statuses (e.g., data contents history coverage, retiring or
    replacing flags)
  • Tools, architectures, and people involved
  • Sensitive information and removal or masking strategy for the source
A

master catalog

27
Q

____________ include templates and associated examples and training on expected inputs and updates including such rules as ‘do not define a term by using the term’ and completeness statements.

A

Metadata Guidelines

28
Q

_________ is a metadata metric to compare ideal coverage of the enterprise Metadata (all artifacts and all instances within scope) to actual coverage.

A

Metadata repository completeness

29
Q

_________ is a metadata metric developed to judge the Metadata maturity of the enterprise, based on the Capability Maturity Model (CMM-DMM) approach to maturity assessment

A

Metadata Management Maturity

30
Q

_________ is a metadata metric to gauge Organizational commitment to Metadata as assessed by the appointment of stewards, coverage across the enterprise for stewardship, and documentation of the roles in job descriptions.

A

Steward representation

31
Q

_________ is a metadata metric that can be measured by repository login counts. Reference to Metadata by users in business practice is a more difficult measure to track. Anecdotal measures on qualitative surveys may be required to capture this measure.

A

Metadata usage

32
Q

_________ is a metadata metric to assess the quality of Metadata documentation through both automatic and manual methods.

A

Metadata documentation quality

33
Q

_________ is a metadata metric to show the reuse of data in SOA solutions. Metadata on the data services assists developers in deciding when new development could use an existing service.

A

Master Data service data compliance

34
Q

_________ is a metadata metric to

A
35
Q

A(n) ___________ is a list of business terms and their definitions that organizations use to ensure the same definitions are used company-wide when analyzing data.

A

business glossary

36
Q

A _____________ defines the structure and contents of data sets, often for a single database, application, or warehouse. It can be used to manage the names, descriptions, structure, characteristics, storage
requirements, default values, relationships, uniqueness, and other attributes of every data element in a model.

A

data dictionary, or metadata repository

37
Q

___________ tools are software solutions that help organizations assess, cleanse, and improve the quality of their data by identifying and rectifying errors, inconsistencies, and inaccuracies.

A

Data quality

38
Q

_________are software applications that allow data analysts and architects to create visual representations, such as entity-relationship diagrams, flowcharts, or data models, to describe and analyze data structures and processes.

A

Modeling Tools

39
Q

_________are systems that centralize and manage core data elements, such as customer information, product data, and reference data, to ensure consistency and accuracy across an organization.

A

Master Data Management (MDM) repositories and reference data repositories

40
Q

____________ are repositories or directories where information about available services, their descriptions, and their locations are stored. This information is essential for service discovery and integration in a service-oriented environment.

A

Service Registries (SOA Perspective):

41
Q

_____________tools enable the real-time exchange of messages and data between diverse systems and applications, often using messaging protocols or middleware to ensure reliable communication.

A

Event messaging

42
Q

____________refers to the processes, technologies, and tools used to collect, analyze, and present business data and information to support decision-making in an organization.

A

Business Intelligence (BI)

43
Q

A ______________is a database used in IT service management to store information about hardware and software assets, their configurations, and their relationships. It helps IT professionals manage and maintain an organization’s IT infrastructure.

A

Configuration Management Database (CMDB) for IT Assets:

44
Q

__________tools are software applications or platforms that facilitate the process of combining and harmonizing data from multiple sources to create a unified view of data for analysis and reporting.

A

Data integration

45
Q

______________are repositories within a database system that store information about the database’s structure, including tables, columns, indexes, and constraints.

A

Database Management/System Catalogs

46
Q

___________tools are used to define, document, and manage the relationships between data elements in different data sources during the process of data integration.

A

Data mapping management

47
Q

This assessment aims to determine whether the organization has the necessary resources, capabilities, and preparedness to embark on data-related projects.

A

Readiness / risk assessment

48
Q

When implementing data management initiatives, this process involves understanding and managing the cultural dynamics, attitudes, and behaviors within an organization related to data, as well as preparing the organization for the changes that data management practices may bring.

A

Cultural analysis and change management

49
Q

The activity of ________ in data management involves the development and implementation of a structured framework and set of practices to effectively manage metadata within an organization. This activity is a critical aspect and is focused on ensuring that metadata is captured, organized, and used in a consistent and controlled manner.

A

The activity of “Create metadata governance”

50
Q

__________ is the process of capturing and displaying information about the origins, transformations, and destinations of data as it moves through the organization’s systems, applications, and processes.

A

Data lineage

51
Q

___________ is the process of assessing and understanding the potential effects and consequences of changes to metadata, such as data definitions, data structures, or data elements. It helps organizations evaluate how alterations to metadata may affect data-related processes, applications, reports, and data quality. This process is crucial for making informed decisions and managing metadata changes effectively in data management initiatives.

A

Impact Analysis

52
Q

____________ when ingesting data into a data lake is the process of attaching descriptive labels or metadata tags to incoming data.

A

Applying tags

53
Q

Why is it important to standardize access to metadata

A

Consistency: Ensures consistent access to metadata.
Efficiency: Streamlines access and saves time.
Interoperability: Supports data integration and collaboration.
Data Quality: Reduces inaccuracies in data usage.
Data Governance: Facilitates governance practices.
Compliance: Aids regulatory compliance.
Search and Discovery: Eases data asset exploration.
Collaboration: Promotes shared understanding.
Scalability: Adaptable to organizational growth.
Error Reduction: Minimizes mistakes and misinterpretations.

54
Q

What are the business drivers of metadata management?

A

Provide Confidence: Metadata Management provides context that increases confidence in data.
Identify Redundancy: It makes it easier to identify redundant data and processes.
Prevent Errors: Prevents the use of out-of-date or improper data.
Reduce Research Time: Reduces data-oriented research time.
Improve Communication: Enhances communications between data consumers and IT.
Accurate Impact Analysis: Enables the creation of accurate impact analysis.
Reduce Training Costs: Reduces training costs associated with data use by improving documentation.
Regulatory Compliance: Supports regulatory compliance.

55
Q

What are the benefits of metadata management?

A

Confidence & Trust: Metadata Management instills confidence and trust in data.
Efficiency: Identifies redundancy and streamlines processes.
Data Quality: Ensures data accuracy and relevancy.
Productivity: Saves time and reduces research efforts.
Communication: Improves communication between data users and IT.
Impact Analysis: Facilitates accurate impact analysis.
Cost Reduction: Reduces training costs and improves documentation.
Compliance: Supports regulatory compliance efforts.

56
Q

Which of the following are key activities involved in Metadata Management, as outlined by the DMBoK? (Choose all that apply)

a) Data cleansing and transformation
b) Ensure metadata quality and security
c) Collect and integrate from diverse sources
d) Software development and programming
e) Human resources management
f) Provide standard way to access
g) Data storage and backup

A

B, C, F

57
Q

According to the DMBoK, what is the role of metadata in data management?

a) Metadata supports hardware and software maintenance.
b) Metadata guides the use of data assets, supporting business intelligence, business decisions, and business semantics.
c) Metadata is primarily responsible for data integration and data mapping.
d) Metadata primarily focuses on data storage and backup.

A

B

Cdmp (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions