Question 1

Which of the following best illustrates the relationship between entities and attributes?

Accepted Answer

A) The entity CUSTOMER with the attribute PRODUCT 
B) The entity CUSTOMER with the attribute PURCHASE 
C) The entity PRODUCT with the attribute PURCHASE 
D) The entity PRODUCT with the attribute CUSTOMER 
E) The entity PURCHASE with the attribute CUSTOMER 
A) The entity CUSTOMER with the attribute PRODUCT 
B) The entity CUSTOMER with the attribute PURCHASE 
C) The entity PRODUCT with the attribute PURCHASE 
D) The entity PRODUCT with the attribute CUSTOMER 
E) The entity PURCHASE with the attribute CUSTOMER

Question 2

The term big data refers to all of the following except:

Accepted Answer

A) datasets with fewer than a billion records. 
B) datasets with unstructured data. 
C) machine-generated data (i.e.from sensors). 
D) data created by social media (i.e.tweets,Facebook Likes). 
E) data from Web traffic. 
A) datasets with fewer than a billion records. 
B) datasets with unstructured data. 
C) machine-generated data (i.e.from sensors). 
D) data created by social media (i.e.tweets,Facebook Likes). 
E) data from Web traffic.

Question 3

Which of the following is a DBMS for desktop computers?

Accepted Answer

A) DB2 
B) Oracle Database 
C) Microsoft SQL Server 
D) Microsoft Access 
E) Microsoft Exchange 
A) DB2 
B) Oracle Database 
C) Microsoft SQL Server 
D) Microsoft Access 
E) Microsoft Exchange

Question 4

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

A DBMS includes capabilities and tools f

Question 5

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

Question 6

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called:

Accepted Answer

A) data auditing. 
B) defragmentation. 
C) data scrubbing. 
D) data optimization. 
E) data normalization. 
A) data auditing. 
B) defragmentation. 
C) data scrubbing. 
D) data optimization. 
E) data normalization.

Question 7

In a large organization,which of the following functions would be responsible for physical database design and maintenance?

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 8

A physical view shows data as it is actually organized and structured on the data storage media.

Accepted Answer

A) True 
 B)False

Question 9

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

Accepted Answer

A) Data normalization 
B) Data accuracy 
C) Data redundancy 
D) Data inconsistency 
E) Data duplication 
A) Data normalization 
B) Data accuracy 
C) Data redundancy 
D) Data inconsistency 
E) Data duplication

Question 10

You are creating a database to store temperature and wind data from various airports.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

Question 11

What are the similarities and differences between a data warehouse and a data mart?

Accepted Answer

A data warehouse stores current and hist

Question 12

Which of the following enables a DBMS to reduce data redundancy and inconsistency?

Accepted Answer

A) Ability to enforce referential integrity 
B) Ability to couple program and data 
C) Use of a data dictionary 
D) Ability to create two-dimensional tables 
E) Ability to minimize isolated files with repeated data 
A) Ability to enforce referential integrity 
B) Ability to couple program and data 
C) Use of a data dictionary 
D) Ability to create two-dimensional tables 
E) Ability to minimize isolated files with repeated data

Question 13

An 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 14

Every record in a file should contain at least one key field.

Accepted Answer

A) True 
 B)False

Question 15

What is an information policy and why is it needed in a firm?

Accepted Answer

An information policy specifies the orga

Question 16

Legacy systems are used to populate and update data warehouses.

Accepted Answer

A) True 
 B)False

Question 17

NoSQL technologies are used to manage sets of data that require the flexibility of tables and relations.

Accepted Answer

A) True 
 B)False

Question 18

In a relational database,the three basic operations used to develop useful sets of data are:

Accepted Answer

A) select,project,and where. 
B) select,join,and where. 
C) select,project,and join. 
D) where,from,and join. 
E) where,find,and select. 
A) select,project,and where. 
B) select,join,and where. 
C) select,project,and join. 
D) where,from,and join. 
E) where,find,and select.

Question 19

DBMSs typically include report generating tools in order to:

Accepted Answer

A) retrieve and display data. 
B) display data in a more structured and polished format than would be possible just by querying. 
C) display data in graphs. 
D) perform predictive analysis. 
E) analyze the database's performance. 
A) retrieve and display data. 
B) display data in a more structured and polished format than would be possible just by querying. 
C) display data in graphs. 
D) perform predictive analysis. 
E) analyze the database's performance.

Question 20

A data lake is composed of:

Accepted Answer

A) historical data from legacy systems. 
B) unstructured and structured data that has not been analyzed. 
C) internal and external data sources. 
D) historic and current internal data. 
E) historic external data. 
A) historical data from legacy systems. 
B) unstructured and structured data that has not been analyzed. 
C) internal and external data sources. 
D) historic and current internal data. 
E) historic external data.

Which of the following best illustrates the relationship between entities and attributes?

The term big data refers to all of the following except:

Which of the following is a DBMS for desktop computers?

List and describe three main capabilities or tools of a DBMS.

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

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called:

In a large organization,which of the following functions would be responsible for physical database design and maintenance?

A physical view shows data as it is actually organized and structured on the data storage media.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

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

What are the similarities and differences between a data warehouse and a data mart?

Which of the following enables a DBMS to reduce data redundancy and inconsistency?

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

Every record in a file should contain at least one key field.

What is an information policy and why is it needed in a firm?

Legacy systems are used to populate and update data warehouses.

NoSQL technologies are used to manage sets of data that require the flexibility of tables and relations.

In a relational database,the three basic operations used to develop useful sets of data are:

DBMSs typically include report generating tools in order to:

A data lake is composed of:

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:

E-Commerce: Digital Markets, digital Goods

Managing Knowledge and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters

Exam 6: Foundations of Business Intelligence:

Which of the following best illustrates the relationship between entities and attributes?

The term big data refers to all of the following except:

Which of the following is a DBMS for desktop computers?

List and describe three main capabilities or tools of a DBMS.

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

Detecting and correcting data in a database or file that are incorrect,incomplete,improperly formatted,or redundant is called:

In a large organization,which of the following functions would be responsible for physical database design and maintenance?

A physical view shows data as it is actually organized and structured on the data storage media.

Which common database challenge is illustrated by a person receiving multiple copies of an L.L.Bean catalog,each addressed to a slightly different variation of his or her full name?

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

What are the similarities and differences between a data warehouse and a data mart?

Which of the following enables a DBMS to reduce data redundancy and inconsistency?

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

Every record in a file should contain at least one key field.

What is an information policy and why is it needed in a firm?

Legacy systems are used to populate and update data warehouses.

NoSQL technologies are used to manage sets of data that require the flexibility of tables and relations.

In a relational database,the three basic operations used to develop useful sets of data are:

DBMSs typically include report generating tools in order to:

A data lake is composed of:

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:

E-Commerce: Digital Markets, digital Goods

Managing Knowledge and Artificial Intelligence

Enhancing Decision Making

Building Information Systems

Managing Projects

Managing Global Systems

Filters