Chapter 6 Data and Business Intelligence

Question 1

data granularity

Answer 1

how detailed the data is

Question 2

real time data

Answer 2

immediate up to date data

Question 3

real time system

Answer 3

provides real time data in response to requests.

Question 4

data steward

Answer 4

responsible for ensuring the policies and procedures are implemented across the org; liaison btwn mis dept and business

Question 5

data governance

Answer 5

overall management of the availability, usability, and integrity of the company data.

Question 6

blockchain

Answer 6

ledger, that consists of blocks of data that maintain a permanent tamper proof record of transactional data

Question 7

data mart

Answer 7

contains a subset of data warehouse information (comes from the data warehouse)

Question 8

data scrubbing

Answer 8

process that weeds out and fixes or discards inconsistent incorrect or incomplete data

Question 9

dbms/rbms

Answer 9

creates, reads, updates, and deletes data in a database while monitoring access and security

Question 10

entity & attribute

Answer 10

entity stores the data
attribute is the data associated with the entity

Question 11

primary key

Answer 11

a field that uniquely identifies a given record in a table

Question 12

foreign key

Answer 12

a primary key of one table that appears as an attribute in another

Question 13

data dictionary

Answer 13

compiles all of the metadata about the data elements in the data model

Question 14

metadata

Answer 14

details about data

Question 15

data lake

Answer 15

storage repository that holds a vast amount of raw data