Metadata Flashcards
1
Q
Most important use of metadata
A
lineage and impact analysis
2
Q
Tag big data
A
describe what the data really means
3
Q
Harvest
A
collecting data from various sources into a repository
4
Q
Metadata metrics
A
coverage, quality, usage, quantity, maturity
5
Q
Data Modellers both…
A
produce and consume metadata
6
Q
Metadata
A
Data that describes data, gives context
7
Q
Metadata can contain
A
definition, business rules, format, abbreviation, required etc
8
Q
Three types of metadata capture
A
automatic, manual, mixed
9
Q
user defined metadata
A
additional metadata for further data above what the system will store
10
Q
Metadata should cover…
A
the six interrogatives of Data: Who, What, Where, Why, When, How
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
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?
13
Q
Metadata Solution
A
- whats required
- what the sources are
- how will it be harvested
14
Q
Metadata sources
A
- BI
- business process models
- data models
- data transformation
- data quality tools
- ERP, CRM
- photos
- IoT
15
Q
ERP acronym
A
enterprise resource planning
16
Q
CRM acronym
A
customer relations management
17
Q
Format of metadata
A
key | metadata1, metadat2, metadata3 …
18
Q
Application code will…
A
collect metadata
19
Q
CMDB
A
configuration management database
20
Q
PREMIS
A
Preservation Metadata: Implementation Strategies Scheme
21
Q
COBOL copybooks
A
flat file that describes the layout of records and fields in a COBOL data file.
22
Q
Three categories of metadata
A
- business metadata
- technical metadata
- operational metadata
23
Q
Business Metadata
A
relates to the business perspective to the metadata user e.g., regulatory constraints, business rules, known issues with data
24
Q
Technical Metadata
A
technical details of the data in IT systems e.g, column names, DDL, access rights
25
Operational Metadata
targeted at IT operations users needs e.g., loading, archiving, purging, error logs
26
Information Science types of metadata
Descriptive e.g., author
Structural e.g., indexes
Administrative e.g., versions
27
Other real world types of metadata
process metadata (roles and responsibilities), data stewardship metadata (subject areas, owners)
28
Major data governance aspects held in metadata include
- business glossary
- data dictionary
- data stewardship
- data standards
- privacy and security
- traceability and audit
29
Business Glossary
defining the business metadata definitions for business data elements
30
Data Dictionary
Defining the technical metadata definitions for data objects e.g., fields, files, tables
31
Data Stewardship
Aligning data stewardship or ownership roles to key data objects
32
Data standards
provide governance and rules for current and future development based on both business and IT input
33
Privacy & Security
Identification of privacy and security levels for business data
34
Traceability and Audit
Understanding of how data is used across the organisation
35
Data Values Standards (ISO)
- Country codes
- currency codes
- date / time
- language codes
- units of measurement
- classification of disease
36
Alternative standards codes
FIPS, IOC
37
ISO 8601
Date time standards YYYY-MM-DD
38
Metadata container standards
So that metadata gets shipped with the rest of the file
EXIF (image) ID3 (audio)
39
EDID
Metadata standard for monitor communications
40
CWM acronym
Common Warehouse Metadata
41
ISO / IEC 11179
Metadata Registry Standard
42
DCMI
Dublin Core metadata intitiative
43
XMI
XML metadata interchange
44
Role of physics data model in a meta data repository
To describe how and where our data is stored in our systems applications or packages
45
Updating the metadata repository is a recommended activity during project close out in the SDLC
TRUE
46
What type of metadata provides developers and administrators with knowledge and information about systems
techincal & operational metadata
47
Examples of process meta data
data stores, data involved, government / regulatory bodies, roles and responsibilities, process dependencies and decomposition
48
Which metadata scheme focusses specifically on documents?
Preservation metadata
49
Metrics associated with meta data management
Steward representation coverage
metadata repository availability
metadata management maturity
50
Example of preservation metadata (focussed on documents)
PREMIS
51
ISO/IEC 1179
standard for framework for defining a metadata repository
52
Which metadata architecture cannot support user defined entries
Distributed metadata architecture
53
Which level of a metamodel describes the relationships between systems?
High level conceptual model
54
A metadata repository scanning process uses and produces all of these files
Control, backup, log, reuse
55
What levels of granularity should be checked for data quality
Data element value, data instance/record, dataset
56
types of metadata (unstructured)
Descriptive
Structural
Administrative
Business
Process
Technical/operational
data Stewardship
57
Descriptive metadata
This provides information about the content of a resource such as its title, author and keywords.
58
Structural metadata
provides information about the organization and relationships between different components of a resource
59
Administrative metadata
provides information about the creation management and usage of resources such as rights restrictions and technical specifications.
60
Business metadata
provides context and meaning to data in terms of business rules, definitions and requirements that business users can understand.
61
Process metadata
provides information about the processes used to create, transform and manipulate data, including workflows, algorithms and data lineage.
62
Technical/Operational Metadata
describes the technical aspects of data storage, processing and management, such as database schemas, data models and API specifications.
63
Data Stewardship Metadata
describes the data governance operating model and expectations.
64
Electronic Data Interchange (EDI)
concept of businesses electronically communicating information that was traditionally communicated on paper, such as purchase orders and invoices.
65
Preservation metadata
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
Examples of process metadat
data stores and data involved
government/regulatory bodies
roles and responsibilities
process dependencies and decomposition
67
Which level of a metamodel describes the relationships between systems?
High level conceptual model
68
Business Drivers for metadata management
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
What does a data dictionary capture?
The structure and contents of data sets, e.g. for a single application
70
Which metadata architecture delivers metadata that is as current and as valid as possible, but cannot support user-defined metadata entries?
Distributed Metadata Architecture
71
Which Metadata scheme focuses specifically on documents?
Preservation Metadata
72
What belongs in a metadata repository
- data requirements
- data lineage diagrams
- data models
- data dictionary
73
What is the difference between an Industry and a Consensus Metadata Standard?
The terms are used interchangeably to describe the same concept
74
What type of Metadata is used by developers and administrators to understand what's happening inside systems?
Technical operational metadata
75
During a business change project, how many artifacts must be searched for in the Metadata repository?
There is no minimum number, but it is highly recommended that the library is examined
76
Which of the following initiatives relied upon an industry Metadata Standard?
EDI
77
Master data architechtures
Hybrid, Registry, Virtualised, Repository
78
A RACI matrix is a useful tool to support the ________ in an outsourced arrangement
Segregation of duties
79
These are examples of which type of Meta-Data: Data Stores & Data Involved, Government/ Regulatory Bodies; Roles & Responsibilities; Process Dependencies and Decomposition
Process meta data
80
Who has primary responsibility for data capture and usage design within programs
Software Architects & Developers
