Intro to Info Systems Ch.8 – Flashcards

Which of the following statements is true regarding customer information? A) Customer information in each operational system can be different B) Customer information can exist in several operational systems C) All of these D) Customer information in each operational system could change

Which of the following occurs during data cleansing? A) All of these B) Clean inaccurate data C) Clean missing records D) Clean redundant records

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

What is information that people use to support their decision-making efforts? A) Data mining B) Information cleansing and scrubbing C) Business intelligence D) Data-mining tools

What is the primary purpose of a data warehouse? A) To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities B) To aggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities C) To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities D) To disaggregate information throughout an organization into a single repository in such a way that employees can make decisions and undertake business analysis activities

A relational database contains information in a series of two-dimensional tables. How is data contained in a data warehouse and data mart? A) Information is multidimensional, meaning it contains a single layer of data in a table format B) Information is multidimensional, meaning it contains layers of columns and rows C) Information is two-dimensional, meaning it contains layers of columns and rows. D) Information is two-dimensional, meaning it contains a single layer of data in a table format

A dimension is a particular attribute of information. Each layer in a data warehouse or data mart represents information according to an additional dimension. What is the common term for the representation of multidimensional information? A) All of these B) Table C) Block D) Cube

Which of the following are the principle BI enablers? A) Technology, processes, and corporate culture B) Technology, people, and customer culture C) Technology, processes, and customer culture D) Technology, people, and corporate culture

What is data mining? A) A particular attribute of information B) The common term for the representation of multidimensional information C) Process of analyzing data to extract information not offered by the raw data alone D) A process that loads information into a data warehouse

Which of the following describes ETL? A) A process that loads information into a data warehouse B) A process that transforms information using a common set of enterprise definitions C) A process that extracts information from internal and external databases D) All of these