Exam 3: Databases and Data Warehouses

Business intelligence is knowledge about your customers, your competitors, your partners, your competitive environment, and your own internal operations.

If your student information had two different birth dates for you, your data would not be considered _____.

_____ help users apply various mathematical models to information stored in a data warehouse in order to discover new information.

When business intelligence is focused on the external competitive environment, it is known as _____.

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

What is a hypercube?

To succeed in business and to enable your organization to extract meaningful information from its information repositories, you need which type of application?

Data marts focus on the entire organization, while data warehouses focus on specific needs.

If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view would you see?

The data administration subsystem is used to create the data dictionary.

A(n) _____ is a primary key from one table placed within a second table to establish a relationship between the two tables.

Data administration is the function in an organization that plans for, oversees the development of, and monitors the information resources.

Which of the following are large electronic repositories of very detailed information?

Business intelligences encompasses both _____ and _____ information.

In a data warehouse, which artificial intelligence tool allows you to discover information and build intelligence?

Which type of application requires that you know the physical location of information before you are able to access it?

What is a digital dashboard?

Recovery is the process of reinstalling the backup information in the event the information was lost.

In an organization, _____ is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories.

Because data warehouses are not transaction-oriented, they only support _____.