Exam 6: Data: Business Intelligence

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.

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

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

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

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

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

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

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

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

When does information cleansing occur in the data warehouse?

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

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

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

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

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

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

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

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

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.

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