Question 1

The tool that enables users to view the same data in different ways using multiple dimensions is

Accepted Answer

A) predictive analysis. 
B) SQL. 
C) OLAP. 
D) data mining. 
E) Hadoop. 
A) predictive analysis. 
B) SQL. 
C) OLAP. 
D) data mining. 
E) Hadoop. C

Question 2

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

Accepted Answer

A) OLAP 
B) data warehouse 
C) data mart 
D) Hadoop 
E) DBMS 
A) OLAP 
B) data warehouse 
C) data mart 
D) Hadoop 
E) DBMS D

Question 3

You are creating a database to store temperature and wind data from national airport locations.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Accepted Answer

A) address 
B) city 
C) airport code 
D) state 
E) day 
A) address 
B) city 
C) airport code 
D) state 
E) day C

Question 4

Which of the following is not one of the techniques used in Web mining?

Accepted Answer

A) content mining 
B) structure mining 
C) server mining 
D) usage mining 
E) data mining 
A) content mining 
B) structure mining 
C) server mining 
D) usage mining 
E) data mining

Question 5

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is not a method for performing a data quality audit?

Accepted Answer

A) surveying entire data files 
B) surveying samples from data files 
C) surveying data definition and query files 
D) surveying end users about their perceptions of data quality 
E) surveying managers about their perceptions of data quality 
A) surveying entire data files 
B) surveying samples from data files 
C) surveying data definition and query files 
D) surveying end users about their perceptions of data quality 
E) surveying managers about their perceptions of data quality

Question 7

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with

Accepted Answer

A) one short mark. 
B) two short marks. 
C) three short marks. 
D) a crow's foot. 
E) a crow's foot topped by a short mark. 
A) one short mark. 
B) two short marks. 
C) three short marks. 
D) a crow's foot. 
E) a crow's foot topped by a short mark.

Question 8

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Accepted Answer

A) True 
 B)False

Question 9

When you design the new contracts database for the publishing house mentioned above,what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

Accepted Answer

Author first name,author last name,autho

Question 10

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 11

In terms of data relationships,associations refers to

Accepted Answer

A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings. 
E) relationships between different customers. 
A) events linked over time. 
B) patterns that describe a group to which an item belongs. 
C) occurrences linked to a single event. 
D) undiscovered groupings. 
E) relationships between different customers.

Question 12

In a table for customers,the information about a single customer would reside in a single

Accepted Answer

A) field. 
B) row. 
C) column. 
D) table. 
E) entity. 
A) field. 
B) row. 
C) column. 
D) table. 
E) entity.

Question 13

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Accepted Answer

A) True 
 B)False

Question 14

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

Accepted Answer

Product databases could be made availabl

Question 15

The organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information is called a(n)

Accepted Answer

A) information policy. 
B) data definition file. 
C) data quality audit. 
D) data governance policy. 
E) data policy. 
A) information policy. 
B) data definition file. 
C) data quality audit. 
D) data governance policy. 
E) data policy.

Question 16

Legacy systems are used to populate and update data warehouses.

Accepted Answer

A) True 
 B)False

Question 17

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 18

The special organizational function whose responsibilities include physical database design and maintenance is called

Accepted Answer

A) data administration. 
B) database administration. 
C) information policy administration. 
D) data auditing. 
E) database management. 
A) data administration. 
B) database administration. 
C) information policy administration. 
D) data auditing. 
E) database management.

Question 19

An attribute is a characteristic or quality used to describe a particular entity.

Accepted Answer

A) True 
 B)False

Question 20

All of the following are technologies used to analyze and manage big data except

Accepted Answer

A) cloud computing. 
B) noSQL. 
C) in-memory computing. 
D) analytic platforms. 
E) Hadoop. 
A) cloud computing. 
B) noSQL. 
C) in-memory computing. 
D) analytic platforms. 
E) Hadoop.

The tool that enables users to view the same data in different ways using multiple dimensions is

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

You are creating a database to store temperature and wind data from national airport locations.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Which of the following is not one of the techniques used in Web mining?

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

Which of the following is not a method for performing a data quality audit?

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

When you design the new contracts database for the publishing house mentioned above,what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

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

In terms of data relationships,associations refers to

In a table for customers,the information about a single customer would reside in a single

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

The organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information is called a(n)

Legacy systems are used to populate and update data warehouses.

A data warehouse is composed of

The special organizational function whose responsibilities include physical database design and maintenance is called

An attribute is a characteristic or quality used to describe a particular entity.

All of the following are technologies used to analyze and manage big data except

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

The tool that enables users to view the same data in different ways using multiple dimensions is

Which of the following technologies would you use to analyze the social media data collected by a major online retailer?

You are creating a database to store temperature and wind data from national airport locations.Which of the following fields is the most likely candidate to use as the basis for a primary key in the Airport table?

Which of the following is not one of the techniques used in Web mining?

Implementing a Web interface for an organization's internal database usually requires substantial changes to be made to the database.

Which of the following is not a method for performing a data quality audit?

A one-to-many relationship between two entities is symbolized in a diagram by a line that ends with

A database server is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

When you design the new contracts database for the publishing house mentioned above,what fields do you anticipate needing? Which of these fields might be in use in other databases used by the company?

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

In terms of data relationships,associations refers to

In a table for customers,the information about a single customer would reside in a single

Complicated groupings of data in a relational database need to be adjusted to eliminate awkward many-to-many relationships.

Describe the ways in which database technologies could be used by a toy manufacturer to achieve product differentiation.

The organization's rules for sharing,disseminating,acquiring,standardizing,classifying,and inventorying information is called a(n)

Legacy systems are used to populate and update data warehouses.

A data warehouse is composed of

The special organizational function whose responsibilities include physical database design and maintenance is called

An attribute is a characteristic or quality used to describe a particular entity.

All of the following are technologies used to analyze and manage big data except

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