Metadata Flashcards

1
Q

Most important use of metadata

A

lineage and impact analysis

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

Tag big data

A

describe what the data really means

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

Harvest

A

collecting data from various sources into a repository

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

Metadata metrics

A

coverage, quality, usage, quantity, maturity

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

Data Modellers both…

A

produce and consume metadata

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

Metadata

A

Data that describes data, gives context

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

Metadata can contain

A

definition, business rules, format, abbreviation, required etc

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

Three types of metadata capture

A

automatic, manual, mixed

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

user defined metadata

A

additional metadata for further data above what the system will store

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

Metadata should cover…

A

the six interrogatives of Data: Who, What, Where, Why, When, How

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

Automatic capture

A

by product of using the tool e.g., when was it created, when was it last updated, who created the data

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

Manual capture

A

Data which isn’t collected automatically E.g., Why are we storing this data? Who owns the data? What are the business rules? Who is the steward of this data?

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

Metadata Solution

A
  • whats required
  • what the sources are
  • how will it be harvested
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Metadata sources

A
  • BI
  • business process models
  • data models
  • data transformation
  • data quality tools
  • ERP, CRM
  • photos
  • IoT
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

ERP acronym

A

enterprise resource planning

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

CRM acronym

A

customer relations management

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

Format of metadata

A

key | metadata1, metadat2, metadata3 …

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

Application code will…

A

collect metadata

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

CMDB

A

configuration management database

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

PREMIS

A

Preservation Metadata: Implementation Strategies Scheme

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

COBOL copybooks

A

flat file that describes the layout of records and fields in a COBOL data file.

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

Three categories of metadata

A
  1. business metadata
  2. technical metadata
  3. operational metadata
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Business Metadata

A

relates to the business perspective to the metadata user e.g., regulatory constraints, business rules, known issues with data

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

Technical Metadata

A

technical details of the data in IT systems e.g, column names, DDL, access rights

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

Operational Metadata

A

targeted at IT operations users needs e.g., loading, archiving, purging, error logs

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

Information Science types of metadata

A

Descriptive e.g., author
Structural e.g., indexes
Administrative e.g., versions

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

Other real world types of metadata

A

process metadata (roles and responsibilities), data stewardship metadata (subject areas, owners)

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

Major data governance aspects held in metadata include

A
  • business glossary
  • data dictionary
  • data stewardship
  • data standards
  • privacy and security
  • traceability and audit
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
29
Q

Business Glossary

A

defining the business metadata definitions for business data elements

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

Data Dictionary

A

Defining the technical metadata definitions for data objects e.g., fields, files, tables

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

Data Stewardship

A

Aligning data stewardship or ownership roles to key data objects

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

Data standards

A

provide governance and rules for current and future development based on both business and IT input

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

Privacy & Security

A

Identification of privacy and security levels for business data

34
Q

Traceability and Audit

A

Understanding of how data is used across the organisation

35
Q

Data Values Standards (ISO)

A
  • Country codes
  • currency codes
  • date / time
  • language codes
  • units of measurement
  • classification of disease
36
Q

Alternative standards codes

A

FIPS, IOC

37
Q

ISO 8601

A

Date time standards YYYY-MM-DD

38
Q

Metadata container standards

A

So that metadata gets shipped with the rest of the file
EXIF (image) ID3 (audio)

39
Q

EDID

A

Metadata standard for monitor communications

40
Q

CWM acronym

A

Common Warehouse Metadata

41
Q

ISO / IEC 11179

A

Metadata Registry Standard

42
Q

DCMI

A

Dublin Core metadata intitiative

43
Q

XMI

A

XML metadata interchange

44
Q

Role of physics data model in a meta data repository

A

To describe how and where our data is stored in our systems applications or packages

45
Q

Updating the metadata repository is a recommended activity during project close out in the SDLC

A

TRUE

46
Q

What type of metadata provides developers and administrators with knowledge and information about systems

A

techincal & operational metadata

47
Q

Examples of process meta data

A

data stores, data involved, government / regulatory bodies, roles and responsibilities, process dependencies and decomposition

48
Q

Which metadata scheme focusses specifically on documents?

A

Preservation metadata

49
Q

Metrics associated with meta data management

A

Steward representation coverage
metadata repository availability
metadata management maturity

50
Q

Example of preservation metadata (focussed on documents)

A

PREMIS

51
Q

ISO/IEC 1179

A

standard for framework for defining a metadata repository

52
Q

Which metadata architecture cannot support user defined entries

A

Distributed metadata architecture

53
Q

Which level of a metamodel describes the relationships between systems?

A

High level conceptual model

54
Q

A metadata repository scanning process uses and produces all of these files

A

Control, backup, log, reuse

55
Q

What levels of granularity should be checked for data quality

A

Data element value, data instance/record, dataset

56
Q

types of metadata (unstructured)

A

Descriptive
Structural
Administrative
Business
Process
Technical/operational
data Stewardship

57
Q

Descriptive metadata

A

This provides information about the content of a resource such as its title, author and keywords.

58
Q

Structural metadata

A

provides information about the organization and relationships between different components of a resource

59
Q

Administrative metadata

A

provides information about the creation management and usage of resources such as rights restrictions and technical specifications.

60
Q

Business metadata

A

provides context and meaning to data in terms of business rules, definitions and requirements that business users can understand.

61
Q

Process metadata

A

provides information about the processes used to create, transform and manipulate data, including workflows, algorithms and data lineage.

62
Q

Technical/Operational Metadata

A

describes the technical aspects of data storage, processing and management, such as database schemas, data models and API specifications.

63
Q

Data Stewardship Metadata

A

describes the data governance operating model and expectations.

64
Q

Electronic Data Interchange (EDI)

A

concept of businesses electronically communicating information that was traditionally communicated on paper, such as purchase orders and invoices.

65
Q

Preservation metadata

A

a subset of administrative metadata, preservation metadata is information describing the context of unstructured data such as documents e.g. information to preserve and save a resource.

66
Q

Examples of process metadat

A

data stores and data involved
government/regulatory bodies
roles and responsibilities
process dependencies and decomposition

67
Q

Which level of a metamodel describes the relationships between systems?

A

High level conceptual model

68
Q

Business Drivers for metadata management

A

It helps organisations meet regulatory compliance
It helps improve communication between the IT team and the data consumers
It provides context to the data and data quality measurements thereby creating more trust in the data
It allows for impact analysis hence reducing the risk of project failure

69
Q

What does a data dictionary capture?

A

The structure and contents of data sets, e.g. for a single application

70
Q

Which metadata architecture delivers metadata that is as current and as valid as possible, but cannot support user-defined metadata entries?

A

Distributed Metadata Architecture

71
Q

Which Metadata scheme focuses specifically on documents?

A

Preservation Metadata

72
Q

What belongs in a metadata repository

A
  • data requirements
  • data lineage diagrams
  • data models
  • data dictionary
73
Q

What is the difference between an Industry and a Consensus Metadata Standard?

A

The terms are used interchangeably to describe the same concept

74
Q

What type of Metadata is used by developers and administrators to understand what’s happening inside systems?

A

Technical operational metadata

75
Q

During a business change project, how many artifacts must be searched for in the Metadata repository?

A

There is no minimum number, but it is highly recommended that the library is examined

76
Q

Which of the following initiatives relied upon an industry Metadata Standard?

A

EDI

77
Q

Master data architechtures

A

Hybrid, Registry, Virtualised, Repository

78
Q

A RACI matrix is a useful tool to support the ________ in an outsourced arrangement

A

Segregation of duties

79
Q

These are examples of which type of Meta-Data: Data Stores & Data Involved, Government/ Regulatory Bodies; Roles & Responsibilities; Process Dependencies and Decomposition

A

Process meta data

80
Q

Who has primary responsibility for data capture and usage design within programs

A

Software Architects & Developers