Week 4 Quiz PREP

Question 1

Tell me what are the 3 layers of data requirements??

Answer 1

1) OrganisatiOnal
2) OperatiOnal
3) Technical

Question 2

What is a stakeholder BARRIER to obtaining requirements?

Answer 2

• LIMITED participation (stakeholders too busy for focus groups/workshops -> need senior managers for incentivising/prioritising participation)

Question 3

What is metadata mannn

Answer 3

dAtA about DaTa // data dicTIONARY, e.g.

• datatype & size
• which apps produce & use the data
• what business rules are imposed on it
• has it been transformed from source system
• last time it was loaded into data warehouse

Question 4

What is MASTER data?

Answer 4

“REAL” data like LiSt of customers/products (names, contact deets, job, age, demographic info / IDs, dimensions, colour, cost, country of origin etc.

Question 5

WHEN is metadata created?

Answer 5

whenever we WORK with data (build, store, clean, share, use data)

Question 6

What is a conflict BARRIER to obtaining requirements?

Answer 6

• Politics that prevent consensus (department conflict with each other, hard to reach agreement of shared objectives for analytics systems)

Question 7

What is a system BARRIER to obtaining requirements?

Answer 7

New analytics system = employees being unsure what data/analysis they can ask for or may receive
= resist using new system

Question 8

Tell me what are the 3 DIMENSIONS of data requirements??

Answer 8

1) Functional
2) Corporate Governance
3) MeasureMent

Question 9

Can you list the types of data there are?

Answer 9

• unstructured
• transactional (data related to (non)monetary interactions)
• metadata
• hierarchal (stores relationships between other data)
• master (four groupings: people, things, places, concepts - sub-categorised: subject areas, domain areas, entity types)

Question 10

Why, oh why, would an organisation use EXTERNAL memory instead of INTERNAL memory?

Answer 10

ex extends in memory

Question 11

steps in ETL process, pls

Answer 11

• extract (pull data from existing systems, ongoing process, time consuming/complex)
• transform (standardise data - make it consistent/change formats)
• load (archival - historical data loaded once, current - data from current systems, ongoing - continual revision with operations)

Question 12

What’s a data mart yo

Answer 12

• local SINGLE-subject database used to create a smALLER database than data warehouse for specific needs of group of analysts
• often used in tiered/federated data warehouse

Question 13

role of people in a DATA MANAGEMENT system??

Answer 13

• create
• maintain
• evolve
• use
  organisational memory

Question 14

what are some desirable ATTRIBUTES of data in orgs.

Answer 14

shareable
transportable
secure
accurate
timely
relevant

Question 15

what does SOP stand for

Answer 15

Standard Operating Procedures - ways to perform ROUTINE activities

Question 16

probs with data management systems

Answer 16

redundancy (same data in many systems)
lack of data control (poorly managed)
poor interface
delays 
lack of reality
lack of data integration (multiple data formats)

Question 17

What is DATA?$?$?

Answer 17

raw, unsummarised, unanalysed facts

Question 18

What is INFORMATION??

Answer 18

data processed into MEANINGful form

Question 19

What is KnOwLEdGe??

Answer 19

capacity to use information

Question 20

DATA WAREHOUSE??

Answer 20

repository (?) of organisational data (in one collection), measured in petabytes

Question 21

What’s the process of managing the data warehouse my dude

Answer 21

ETCLSM

extraction, transformation, cleaning, loading (archival, current, ongoing), scheduling, metadata

Question 22

types of data warehouses?

Answer 22

centralised, federated, tiered

Question 23

examples of functional dimension

Answer 23

strategy, finance, hr, marketing, sales etc.

Question 24

examples of governance dimension

Answer 24

policy, compliance, risk, audit

Question 25

examples of measurement dimension

Answer 25

measures, metrics, indicators, indices, references, trends

Question 26

tell meee why metadata is important

Answer 26

- gives context to data in warehouse - corrects errors/misunderstandings - allows changes to be traced

Question 27

three types of metadata??

Answer 27

1) business 2) technical 3) process

Question 28

what's the master data life cycle ??

Answer 28

CRUD | created, read, updated, deleted, searched

Question 29

what is MDM

Answer 29

``` tools and processes to help - gather - identify - classify relevant data to be used as MASTER data throughout an entire organisation ```

Question 30

challenges of mdm??

Answer 30

1) is it valuable (provide timely, accurate, consistent info) 2) effort+structure = complicated+costly 3) good project management skills to overcome HESITATION at effort needed

Question 31

how has the move to CLOUD COMPUTING affected data management

Answer 31

- SECURITY (physical, access control, data transport encryption, firewalls, storage encryption) - SLAs, QoS (quality of service), national laws

Question 32

what is a database?

Answer 32

highly STRUCTURED data file that allows data input, retrieval, organisation

Question 33

flat files??

Answer 33

- two dimensional tables usually stored as DELIMITED text files (csv, tsv)

Question 34

hierarchical databases

Answer 34

parent-child relationships between tables (each child can only have one parent)

Question 35

relational databases

Answer 35

no limit on number of parent/child connections

Question 36

what is blob

Answer 36

binary large OBject | - data format for storing images, pdfs, audio or other multimedia objects, executable code.