TOpic 3

Question 1

What are common challenges in managing data?

Answer 1

• data increases exponentially with time
• data is scattered throughout organizations
• multiple sources of data
• new sources of data
• data becomes outdated
• data media rots
• high volumes –> complex
• may be compromised (security, quality, integrity)
• redundancy or inconsistancy

Question 2

How is data governance used to address common challenges in managing data? (4)

Answer 2

• provides a planned approach to data management for all types of data
• includes a formal set of business processes and policies for data handling
• requires well-defined, unambiguous rules to avoid functional inconsistency
• rules address creating, collecting, handling, and protecting data

Question 3

What is Big Data?

Answer 3

high-variety, high-volume, high-velocity information assets that require new forms of processing to enable enhanced decision making, insight discovery, and process optimization

Question 4

What are data warehouses?

Answer 4

a repository of historical data organized by subject to support decision makers in the organization

Question 5

What are the necessary elements to successfully implement and maintain data warehouses?

Answer 5

• link source systems that provide data to the warehouse or mart

Question 6

What are knowledge management systems?

Answer 6

The use of modern information technologies to systematize, enhance, and expedite intrafirm and interfirm knowledge management

Question 7

What are the benefits of implementing knowledge management systems?

Question 8

What are the challenges of implementing knowledge management systems?

Question 9

What is the process of querying a relational database, entity relationship modelling, and normalization and joins?

Question 10

What is the relational database model?

Answer 10

based on two dimensional tables that are related. Their records are listed in rows and attributes listed in columns. Users retrieve, analyze, and understand data from the model.

Question 11

What is entity-relationship modelling?

Question 12

What is normalization and joins?

Answer 12

a method for analyzing and reducing a relational database to its nost streanlined form

Question 13

What are types of sources of data?

Answer 13

1. internal sources
2. personal sources
3. external sources
4. news sources

Question 14

What is the main objective of data governance?

Answer 14

to enable available, transparent, and useful data, “a single version of the truth”

Question 15

Data governance is a subset of which of the following?
1. IT governance
2. data management
3. Big Data
4. IT management

Answer 15

!. IT governance

Question 16

What are the 5 data governance areas?

Answer 16

1. master data management
2. meta data management
3. data quality
4. data catalogue
5. data lineage

Question 17

What is transactional data?

Answer 17

represents activities or events, such as a payroll cheque or customer invoice; stored in transaction files or as tables as part of a database

Question 18

What is master data?

Answer 18

a set of core data, such as employee name, address, customer name, or customer credit limit that are applied to multiple transactions; stored in a master file or as tables as part of a database

Question 19

What is a database management system (DBMS)?

Answer 19

a set of programs with tools to create and manage databases

Question 20

What do DBMSs mimimize (3) and maximize (3)?

Answer 20

Min:
redundancy, isolation, inconsistancy
Max:
security, integrity, independence

Question 21

What are the 4 things big data generally consists of?

Answer 21

1. traditional enterprise data
2. machine-generated/sensor data
3. social data
4. images captured by billions of devices around the world

Question 22

What’s a data mart?

Answer 22

a low-cost, scaled-down version of a data warehouse designed fro end-user needs

Question 23

What are data lakes?

Answer 23

stores current and historical data in its raw form for the purpose of analyzing the data

Question 24

What is knowledge management (KM)?

Answer 24

a process that helps manipulate important knowledge that comprises part of the organization’s memory, usually in an unstructured format

Question 25

What is explicit vs. tacit knowledge?

Answer 25

explicit: objective, rational, technical
tacit: subjective or experiential