FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 6: Data: Business Intelligence

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 121

Multiple Choice

Review LaterAdd Note

Review Later

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

E) B) and C)
F) B) and D)

Correct Answer

verified

Show Answer

Question 122

Essay

Review LaterAdd Note

Review Later

Define a data warehouse,and provide a few reasons it can make a manager more effective.

Correct Answer

verified

A data warehouse is a logical collection...

View Answer

Show Answer

Question 123

True/False

Review LaterAdd Note

Relational databases offer many advantages over using a text document or a spreadsheet,which include decreased flexibility and decreased scalability and performance.

If a manager identifies numerous information integrity issues he should consider the reports generated from that data as invalid and not use them when making decisions.

Infographics can present the results of large data analysis looking for patterns and relationships that monitor changes in variables over time.

Informing dashboards track corporate metrics such as critical success factors and key performance indicators and include advanced capabilities such as interactive controls allowing users to manipulate data for analysis.

Enter physical or logical in the space below: The __________ view of information deals with the physical storage of information on a storage device.

Which of the following illustrates the primary concepts of the relational database model?

Text mining analyzes structured data to find trends and patterns in words and sentences.

Which of the following occurs when a system produces incorrect,inconsistent,or duplicate data?

Static information includes fixed data incapable of change in the event of a user action.

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

Relational _____________ constraints are rules that enforce basic and fundamental information-based constraints.

MMSDB creates,reads,updates,and deletes data in a database while controlling access and security.

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Unstructured data analyzes data to find trends and patterns in words and sentences.

Data _____________ tools move beyond Excel graphs and charts into sophisticated analysis techniques such as pie charts,controls,instruments,maps,time-series graphs,and more.

Data mining occurs on structured data that are already in a database or a spreadsheet.

Which of the following creates,reads,updates,and deletes data in a database while controlling access and security?