Question 1

Data scrubbing is a more intensive corrective process than data cleansing.

Accepted Answer

A) True 
 B)False

Question 2

The select operation

Accepted Answer

A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria. 
E)  creates a subset consisting of rows in a table. 
A)  combines relational tables to provide the user with more information than is otherwise available. 
B)  creates a subset consisting of columns in a table. 
C)  identifies the table from which the columns will be selected. 
D)  creates a subset consisting of all records in the file that meet stated criteria. 
E)  creates a subset consisting of rows in a table.

Question 3

Microsoft SQL Server is a(n)

Accepted Answer

A)  DBMS for both desktops and mobile devices. 
B)  Internet DBMS. 
C)  desktop relational DBMS. 
D)  DBMS for midrange computers. 
E)  DBMS for mobile devices. 
A)  DBMS for both desktops and mobile devices. 
B)  Internet DBMS. 
C)  desktop relational DBMS. 
D)  DBMS for midrange computers. 
E)  DBMS for mobile devices.

Question 4

A data warehouse is composed of

Accepted Answer

A)  historical data from legacy systems. 
B)  current data. 
C)  internal and external data sources. 
D)  historic and current internal data. 
E)  historic external data. 
A)  historical data from legacy systems. 
B)  current data. 
C)  internal and external data sources. 
D)  historic and current internal data. 
E)  historic external data.

Question 5

OLAP is unable to manage and handle queries with very large sets of data.

Accepted Answer

A) True 
 B)False

Question 6

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Accepted Answer

A) True 
 B)False

Question 7

Databases record information about general categories of information referred to as entities.

Accepted Answer

A) True 
 B)False

Question 8

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Accepted Answer

A)  identifying associations. 
B)  identifying clusters. 
C)  identifying sequences. 
D)  classification. 
E)  forecasting. 
A)  identifying associations. 
B)  identifying clusters. 
C)  identifying sequences. 
D)  classification. 
E)  forecasting.

Question 9

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

Accepted Answer

A) True 
 B)False

Question 10

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

Accepted Answer

A) True 
 B)False

Data scrubbing is a more intensive corrective process than data cleansing.

The select operation

Microsoft SQL Server is a(n)

A data warehouse is composed of

OLAP is unable to manage and handle queries with very large sets of data.

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Databases record information about general categories of information referred to as entities.

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence: Databases and Information Management

Data scrubbing is a more intensive corrective process than data cleansing.

The select operation

Microsoft SQL Server is a(n)

A data warehouse is composed of

OLAP is unable to manage and handle queries with very large sets of data.

High-speed analytic platforms use both relational and non-relational tools to analyze large datasets.

Databases record information about general categories of information referred to as entities.

You work for a national car rental agency and want to determine what characteristics are shared among your most loyal customers. To do this, you will want to use data mining software that is capable of

Relational DBMSs use key field rules to ensure that relationships between coupled tables remain consistent.

An application that transfers information from an organization's internal database to a Web server for delivery as part of a Web page to the user is called middleware.

Information Systems in Global Business Today

Global E-Business and Collaboration

Information Systems, Organizations, and Strategy

Ethical and Social Issues in Information Systems

It Infrastructure and Emerging Technologies

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Managing Knowledge

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters