Exam 6: Data: Business Intelligence

Which of the following refers to immediate,up-to-date information?

Which of the following is not an advantage to a data-driven website?

Broadly defined,a __________ maintains information about various types of objects,events,people,and places.

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

Integrity _________ are rules that help ensure the quality of information.

Dynamic website information is stored in a dynamic catalog,or an area of a website that stores information about products in a database.

__________ visualization tools can help uncover correlations and trends in data that would otherwise go unrecognized.

What is it called when each transaction,entity,and event is represented only once in the information?

Data ___________ are logical data structures that detail the relationships among data elements using graphics or pictures.

Which of the following is incorrect in reference to a database?

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Ben works at a top accounting firm in Salt Lake City and his responsibilities include developing reports for each salesperson,product,and part as well as departmental-wide sales reports by salesperson,product,and part.Ben's duties provide value-added to his company and would be categorized as occurring at the different _____________.

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

Data-driven websites offer several advantages as it is far easier to manage content and store large amounts of data.

Informing is accessing large amounts of data from different management information systems.

When discovering trends and seasonal variations in transactional information,use a _______-_________ forecast to change the transactional information by units of time,such as transforming weekly information into monthly or seasonal information or hourly information and into daily information.

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Which of the following occurs during data cleansing?

A ______________ is a collection of related data elements (in the MUSICIANS table these include)