Filters
Question type

Study Flashcards

What does the Data Warehousing Institute estimate that low-quality information costs U.S.businesses annually?


A) $500 million.
B) $60 billion.
C) $600 billion.
D) It is impossible to determine.

Correct Answer

verifed

verified

Which of the following occurs during data cleansing?


A) Clean missing records.
B) Clean redundant records.
C) Clean inaccurate data.
D) All of these.

Correct Answer

verifed

verified

When does information cleansing occur in the data warehouse?


A) During the ETL process.
B) On the information, once it is in the data warehouse.
C) During the ETL process and once it is in the data warehouse.
D) During the ETL process and before it is in the data warehouse.

Correct Answer

verifed

verified

Data warehousing is about extending the transformation of data into _________.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

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 these.

Correct Answer

verifed

verified

Why is Noodles & Company using business intelligence?


A) To improve financial analysis.
B) To improve corporate processes.
C) To track store quality.
D) To change the corporate culture.

Correct Answer

verifed

verified

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

Correct Answer

verifed

verified

Which of the following are the principle BI enablers?


A) Technology, processes, and customer culture
B) Technology, people, and customer culture
C) Technology, processes, and corporate culture
D) Technology, people, and corporate culture

Correct Answer

verifed

verified

Explain the relationship between business intelligence and a data warehouse.

Correct Answer

verifed

verified

A data warehouse is an enabler of busine...

View Answer

The data warehouse is a location for all of a business's information.

Correct Answer

verifed

verified

A dimension is a particular attribute of information.

Correct Answer

verifed

verified

Why is Ben & Jerry's using business intelligence?


A) To improve quality.
B) To create new flavors of ice cream.
C) To improve financials.
D) To manage distribution.

Correct Answer

verifed

verified

Explain the multidimensional nature of data warehouses (and data marts)and the business value gained from multidimensional analysis.

Correct Answer

verifed

verified

Databases contain information in a serie...

View Answer

What is the primary purpose of a data warehouse?


A) To aggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
B) To disaggregate information throughout an organization into multiple repositories in such a way that employees can make decisions and undertake business analysis activities.
C) To aggregate information throughout an organization into a single repository 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.

Correct Answer

verifed

verified

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.

Correct Answer

verifed

verified

Achieving perfect information is almost impossible.The more complete and accurate an organization wants its information to be,the more it costs.Which two variables are used to determine the trade-off for perfect information?


A) Accuracy versus completeness.
B) Accessibility versus completeness.
C) Accuracy versus complexity.
D) Accessibility versus complexity.

Correct Answer

verifed

verified

A data __________ contains a subset of data warehouse information.

Correct Answer

verifed

verified

What is data mining?


A) The common term for the representation of multidimensional information.
B) A particular attribute of information.
C) Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making.
D) Process of analyzing data to extract information not offered by the raw data alone.

Correct Answer

verifed

verified

All of the following are reasons why operational systems are not appropriate for business analysis except:


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.

Correct Answer

verifed

verified

Showing 21 - 40 of 41

Related Exams

Show Answer