Exam 3: Databases and Data Warehouses: Supporting the Analytics-Driven Organization

Business intelligence is a component of the overall framework or field of analytics.

A(n)_____ helps you specify the logical organization for a database and access and use the information within a database.

There is only one logical view of information but there may be numerous knowledge workers who have different physical views of the information in a database.

Which data manipulation tool allows you to graphically design the answer to your business questions?

A(n)_____ represents how users see information to meet their particular business needs.

_____ are databases that support online transaction processing.

A(n)_____ is a field that uniquely describes each record in a relational database.

A relational database consists of _____ and the _____ structure of that information.

Which application supports the manipulation of information to support decision making?

Which type of constraint ensures the quality of information in a relational database?

_____ is the gathering of input information,processing that information,and updating existing information to reflect the gathered and processed information.

_____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.

A(n)_____ is a field or group of fields that uniquely describes each record.

If the file containing your student information appears in two different places with two different birth dates,your data would not be considered ____.

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

_____ is a standardized fourth-generation query language found in most DBMSs.

_____ is the collective information about your customers,your competitors,your business partners,your competitive environment,and your own internal operations.

A hypercube is:

Orco Corp.would like to determine advertising strategies for customers who buy high-priced products.It would use OLTP on its data warehouse to accomplish this task.

_____ are the software tools you use to query information in a data warehouse.