Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

A)  Legitimate 
B)  Correct 
C)  Clean 
D)  Acceptable

Question 3

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

Accepted Answer

The answer of _____ help users apply various mathematical models...

Question 4

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

Accepted Answer

A)  External information 
B)  Trends 
C)  Competitive intelligence 
D)  Competitor knowledge

Question 5

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

Accepted Answer

The answer of A(n) _____ allows you to specify the...

Question 6

What is a hypercube?

Accepted Answer

A)  A hyper text link stored in a database 
B)  Data definitions that are linked to other related, but external, attributes or fields 
C)  Database that is built on Internet technology 
D)  Multidimensional representation of information

Question 7

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

Accepted Answer

A)  Query-by-example 
B)  Business intelligence 
C)  Information analysis 
D)  SQL

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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?

Accepted Answer

A)  Logical view 
B)  High-level view 
C)  User view 
D)  Physical view

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

The answer of A(n) _____ is a primary key from...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A)  Libraries 
B)  Data compilations 
C)  Data collections 
D)  Databases

Question 14

Business intelligences encompasses both _____ and _____ information.

Accepted Answer

The answer of Business intelligences encompasses both _____ and _____...

Question 15

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

Accepted Answer

A)  Query-by-example 
B)  Query-and-reporting 
C)  Hypercube 
D)  Intelligent agent

Question 16

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

Accepted Answer

A)  Database management systems 
B)  Database 
C)  Spreadsheets 
D)  Business intelligence

Question 17

What is a digital dashboard?

Accepted Answer

A)  A new type of electronic dashboard for high-priced cars that displays GPS information alongside of traditional information 
B)  A learning environment for online educational courses 
C)  A computer tool that provides competitive information from external sources 
D)  A computer screen that provides tailored, current snapshots of information and trends

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

The answer of In an organization, _____ is responsible for...

Question 20

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

Accepted Answer

The answer of Because data warehouses are not transaction-oriented, they...

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 _____.