Deck 7: Accessing Organizational Informationdata Warehouses

Question 1

Gender can be referred to in many ways (Male, Female, M/F, 1/0) in a data warehouse. Ensuring gender is referenced the same way is an example of ________.

A) Information scaling
B) Streamlining data points
C) Standardizing information
D) Standardizing protocols

Answer 1

C

Question 2

What is the ultimate outcome of a data warehouse?

A) Data goals
B) Data relationships
C) Data marketing
D) Data marts

Answer 2

D

Question 3

Which of the following describes ETL?

A) A process that extracts information from internal and external databases
B) A process that transforms information using a common set of enterprise definitions
C) A process that loads information into a data warehouse
D) All of the choices are correct

Answer 3

D

Question 4

What is another term for information cleansing?

A) Information mining
B) Information scrubbing
C) Information scrapping
D) Information marts

Question 5

A data warehouse is a ________ collection of information, gathered from many different ________ databases, that supports business analysis activities and decision-making tasks.

A) Logical, operational
B) Physical, operational
C) Logical, transactional
D) Physical, transactional

Question 6

What do data warehouses support?

A) OLAP
B) Analytical processing
C) OLTP
D) OLAP and analytical processing

Question 7

Which of the following occurs during data cleansing?

A) Clean data marts
B) Clean redundant customer data
C) Clean accurate data
D) Clean correct data

Question 8

What is extraction, transformation, and loading?

A) It is a process of entering data, tracking data, and loading it into a database
B) It is a process that extracts information from internal and external databases, transforms it using a common set of enterprise definitions, and loads it into a data warehouse
C) It is a process that is performed at the end of the data warehouse model prior to putting the information in a cube
D) It is a process that is performed at the beginning of the data mining model

Question 9

Which of the below questions can be answered using business intelligence?

A) Where has the business been?
B) Where is the business now?
C) Where is the business going?
D) All of the choices are correct.

Question 10

Which of the following statements is true?

A) The more complete an organization wants to get its information, the less it costs
B) The more accurate an organization wants to get its information, the less it costs
C) The less accurate an organization wants to get its information, the more it costs
D) The more complete and accurate an organization wants to get its information, the more it costs

Question 11

Which of the following contains a subset of data warehouse information?

A) Data miner
B) Data mart
C) Data pool
D) Data analyzing tool

Question 12

What is information that people use to support their decision-making efforts?

A) Information cleansing and scrubbing
B) Data-mining tools
C) Data mining
D) Business intelligence

Question 13

Which of the following is incorrect in terms of data warehousing and business intelligence?

A) Does not include information from other operational applications
B) Operational systems are integrated
C) Operational information is mainly current
D) Operational information frequently has quality issues

Question 14

Which of the following is not an information cleansing activity?

A) Identifies redundant records
B) Identifies inaccurate or incomplete data
C) Identifies missing records or attributes
D) Identifies sales trends

Question 15

Why were data warehouses created?

A) Numbers and types of operational databases increased as businesses grew
B) Many companies had information scattered across multiple systems with different formats
C) Completing reporting requests from numerous operational systems took days or weeks
D) All of the choices are correct

Question 16

The primary purpose of a data warehouse is to ________.

A) Combine strategic information
B) Organize departments
C) Interface between the computer and employees
D) All of the choices are correct

Question 17

Which of the following occurs during data cleansing?

A) Clean missing records
B) Clean redundant records
C) Clean inaccurate data
D) All of the choices are correct

Question 18

Which of the following statements is true regarding customer information?

A) Customer information can exist in several operational systems
B) Customer information in each operational system could change
C) Customer information in each operational system can be different
D) All of the choices are correct

Question 19

What is it called when a manager has so much data and information that they cannot make a decision?

A) Data rich, information poor
B) Data rich, content poor
C) Data rich, communication poor
D) Data rich, intelligence

Question 20

What determines the accuracy and completeness of organizational data?

A) Data quantity audit
B) Data quality audit
C) Data intelligence audit
D) Data accuracy audit

Question 21

A repository is a central location in which data is stored and managed.

Question 22

Which of the following is a problem associated with dirty data?

A) Inaccurate data
B) Misleading data
C) Non-formatted data
D) All of the choices are correct

Question 23

Which of the following is a problem associated with dirty data?

A) Duplicate data
B) Incorrect data
C) Violates business rules
D) All of the choices are correct

Question 24

The primary purpose of a data warehouse is to perform transactional processes.

Question 25

Dirty data is erroneous or flawed data.

Question 26

Which of the following is a problem associated with dirty data?

A) Duplicate data
B) Correct data
C) Accurate data
D) All of the choices are correct

Question 27

The complete removal of dirty data from a source is practical and possible.

Question 28

Which of the following is a problem associated with dirty data?

A) Formatted data
B) Misleading data
C) Correct data
D) All of the choices are correct

Question 29

A data mart contains a subset of data warehouse information.

Question 30

ETL, within a data warehouse model, stands for exit, track, and load.

Question 31

One example of a data aggregation is to gather information about particular groups based on specific variables such as age, profession, or income.

Question 32

A data warehouse is a logical collection of information, gathered from many different operational databases, that supports business analysis activities and decision-making tasks.

Question 33

A data miner contains a subset of data warehouse information.

Question 34

A data warehouse is a central location in which data is stored and managed.

Question 35

According to Gartner Inc., dirty data is an MIS problem, not a business problem.

Question 36

A central location in which data is stored and managed is called a data mart.

Question 37

Data aggregation is the collection of data from various sources for the purpose of data processing.

Question 38

The primary purpose of a data warehouse is to combine information.

Question 39

Within the data warehouse model, the internal databases could include marketing, sales, inventory, and billing.

Question 40

Which of the following is a problem associated with dirty data?

A) Non-formatted data
B) Misleading data
C) Incorrect data
D) All of the choices are correct

Question 41

A data broker is an individual item on a graph or a chart.

Question 42

Within the data warehouse model, the external databases could include competitor information, industry information, mailing lists, and stock market analysis.

Question 43

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Question 44

A data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.

Question 45

Many organizations find themselves in the position of being data rich and information poor. Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Question 46

Many firms complete data quality audits to determine the accuracy and completeness of its data.

Question 47

Source data identifies the primary location where data is collected. It can include invoices, spreadsheets, timesheets, transactions, and electronic sources such as other databases.

Question 48

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Question 49

While a traditional data warehouse stores data in files or folders, a data lake uses a flat architecture to store data.

Question 50

In a data warehouse, information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Question 51

Duplicate data, inaccurate data, misleading data, and incorrect data are all problems associated with dirty data.

Question 52

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

Question 53

ETL stands for extraction, transformation, and loading.

Question 54

Comparative analysis can help managers with competitive monitoring where a company keeps tabs of its competitor's activities on the web using software that automatically tracks all competitor website activities such as discounts and new products.

Question 55

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Question 56

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Question 57

A data set is an organized collection of data.

Question 58

A comparative analysis can compare two or more data sets to identify patterns and trends.

Question 59

The financial industry uses business intelligence to predict hardware failures.

Question 60

Business intelligence is an approach to business governance that values decisions that can be backed up with verifiable data.

Question 61

Which of the following is a problem associated with dirty data?

A) Inaccurate data
B) Non-integrated data
C) Violates business rules data
D) All of these

Question 62

Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases?

A) Marketing, sales, inventory, and billing
B) Data mart 1, data mart 2, data mart 3
C) Competitor and industry information, mailing lists, and stock market analysis
D) Marketing information, and stock market analysis numbers

Question 63

A data map is a technique for establishing a match, or balance, between the source data and the target data warehouse.

Question 64

Effective data-driven decision management is reliant upon the quality of the data gathered and the effectiveness of its analysis and interpretation.

Question 65

Which of the following are examples of external databases in the data warehouse model?

A) Marketing, sales, inventory, and billing
B) Data mart 1, data mart 2, and data mart 3
C) Competitor and industry information, mailing lists, and stock market analysis
D) Marketing information, sales information, and stock market analysis

Question 66

Organizational data includes simple structured data elements in a database.

Question 67

Business analysis is difficult from operational databases. Which of the following is a reason why?

A) Every department has its own method for recording data.
B) Data standards do not apply across departments.
C) The data, if available, were often incorrect or incomplete.
D) All of these.

Question 68

Which of the following is not a dirty data problem?

A) Duplicate data.
B) Inaccurate data.
C) Specific data.
D) Non-integrated data.

Question 69

What is erroneous or flawed data?

A) Dirty data
B) Information cleansing
C) Information Scrubbing
D) ETL

Question 70

A data point is an individual item on a graph or chart.

Question 71

Companies can choose information cleansing software from several vendors. Which of the following is not a vendor mentioned in your text?

A) Oracle.
B) SAS.
C) Ascential Software.
D) McAffee.

Question 72

What is erroneous or flawed data?

A) Data set
B) Dirty data
C) Data map
D) Data point

Question 73

Which of the following questions can be answered using business intelligence?

A) Where has the business been?
B) Where is the business now?
C) Where is the business going?
D) All of these.

Question 74

What are the primary differences between a data warehouse and a data mart?

A) Data warehouses make quick decisions; data marts make slow decisions
B) Data warehouse tackle ethical issues; data marts tackle hypothetical issues
C) Data warehouses have a more organization wide focus; data marts have functional focus
D) Data warehouses have a physical focus; data marts have logical focus.

Question 75

Which of the following is an example of an external database in the data warehouse model?

A) Marketing information
B) Sales information
C) Competitor information
D) All of these

Question 76

Business analysis is difficult to achieve from operational databases. Which of the following is not a reason why?

A) Inconsistent data definitions
B) Lack of data standards
C) Effective direct data access
D) Poor data quality

Question 77

What is an organized collection of data?

A) Data set.
B) Dirty data.
C) Data map.
D) Data point.

Question 78

How would the banking industry use business intelligence?

A) Analyze popular vacation locations with current flight listings
B) Understand customer credit card usage and nonpayment rates
C) Compare the demographics of patients with critical illnesses
D) Predict claim amounts and medical coverage costs

Question 79

A data set is an individual item on a graph or chart.

Question 80

Which of the following is a problem associated with dirty data?

A) Accurate data
B) Integrated data
C) Violates business rules data
D) All of these