Question 1

Common data quality problems include all of the following except:

Accepted Answer

A)  misspelled names. 
B)  transposed numbers. 
C)  incorrect codes. 
D)  missing codes. 
E)  Internet connectivity problems. 
A)  misspelled names. 
B)  transposed numbers. 
C)  incorrect codes. 
D)  missing codes. 
E)  Internet connectivity problems.

Question 2

Non-relational databases:

Accepted Answer

A)  store information in an unstructured format. 
B)  use rows and columns to organize data. 
C)  are used to store structured and unstructured data. 
D)  are used to store low volumes of transactional data. 
E)  use database-mapping to normalize relations. 
A)  store information in an unstructured format. 
B)  use rows and columns to organize data. 
C)  are used to store structured and unstructured data. 
D)  are used to store low volumes of transactional data. 
E)  use database-mapping to normalize relations.

Question 3

The select operation in a relational database joins records from different tables.

Accepted Answer

A) True 
 B)False

Question 4

Hadoop is an open source software framework for processing large quantities of any type of data, including video and Twitter feeds.

Accepted Answer

A) True 
 B)False

Question 5

Text mining is the discovery of useful patterns on the web.

Accepted Answer

A) True 
 B)False

Question 6

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Accepted Answer

Text mining and web mining techniques wo

Question 7

Capabilities and tools to manage and analyze large quantities and different types of data from multiple sources are collectively known as:

Accepted Answer

A)  DSS. 
B)  business intelligence infrastructure. 
C)  OLAP. 
D)  data mining. 
E)  in-memory computing. 
A)  DSS. 
B)  business intelligence infrastructure. 
C)  OLAP. 
D)  data mining. 
E)  in-memory computing.

Question 8

A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed.

Accepted Answer

A)  data mart 
B)  data warehouse 
C)  dashboard 
D)  data lake 
E)  relational DBMS 
A)  data mart 
B)  data warehouse 
C)  dashboard 
D)  data lake 
E)  relational DBMS

Question 9

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

Accepted Answer

A) True 
 B)False

Question 10

A foreign key is a field that links to a separate table.

Accepted Answer

A) True 
 B)False

Question 11

Data mining is a tool for allowing users to:

Accepted Answer

A)  quickly compare transaction data gathered over many years. 
B)  perform multidimensional data analysis. 
C)  obtain online answers to ad hoc questions in a rapid amount of time. 
D)  summarize massive amounts of data into much smaller, traditional reports. 
E)  find hidden relationships in data. 
A)  quickly compare transaction data gathered over many years. 
B)  perform multidimensional data analysis. 
C)  obtain online answers to ad hoc questions in a rapid amount of time. 
D)  summarize massive amounts of data into much smaller, traditional reports. 
E)  find hidden relationships in data.

Question 12

OLAP is a tool that enables users to:

Accepted Answer

A)  obtain online answers to ad hoc questions in a rapid amount of time. 
B)  view both logical and physical views of data. 
C)  quickly diagram data relationships. 
D)  normalize data. 
E)  find hidden patterns in large databases. 
A)  obtain online answers to ad hoc questions in a rapid amount of time. 
B)  view both logical and physical views of data. 
C)  quickly diagram data relationships. 
D)  normalize data. 
E)  find hidden patterns in large databases.

Question 13

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A data warehouse stores current and hist

Question 15

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Accepted Answer

A)  Gartner 
B)  Fortune 
C)  IBM 
D)  Microsoft 
E)  Facebook 
A)  Gartner 
B)  Fortune 
C)  IBM 
D)  Microsoft 
E)  Facebook

Question 16

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

Accepted Answer

Big data are datasets with volumes so hu

Question 17

What types of relationships are possible in a relational database? Describe and give an example of each.

Accepted Answer

There are three types of relationships:

Question 18

Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function.

Accepted Answer

A)  data management 
B)  data administration 
C)  server administration 
D)  data modeling 
E)  database administration 
A)  data management 
B)  data administration 
C)  server administration 
D)  data modeling 
E)  database administration

Question 19

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

Accepted Answer

A) True 
 B)False

Question 20

A logical view of data shows data as it is organized on the storage media.

Accepted Answer

A) True 
 B)False

Common data quality problems include all of the following except:

Non-relational databases:

The select operation in a relational database joins records from different tables.

Hadoop is an open source software framework for processing large quantities of any type of data, including video and Twitter feeds.

Text mining is the discovery of useful patterns on the web.

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Capabilities and tools to manage and analyze large quantities and different types of data from multiple sources are collectively known as:

A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed.

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

A foreign key is a field that links to a separate table.

Data mining is a tool for allowing users to:

OLAP is a tool that enables users to:

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems.

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

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

What types of relationships are possible in a relational database? Describe and give an example of each.

Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function.

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

A logical view of data shows data as it is organized on the storage media.

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters

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

Common data quality problems include all of the following except:

Non-relational databases:

The select operation in a relational database joins records from different tables.

Hadoop is an open source software framework for processing large quantities of any type of data, including video and Twitter feeds.

Text mining is the discovery of useful patterns on the web.

Imagine you are running a growing business with an active presence on social media. How would you better understand what your customers think about your business using these platforms?

Capabilities and tools to manage and analyze large quantities and different types of data from multiple sources are collectively known as:

A ________ is a repository for raw unstructured data or structured data that for the most part have not yet been analyzed.

A firm's information policy lays out who is responsible for updating and maintaining the information in a database system.

A foreign key is a field that links to a separate table.

Data mining is a tool for allowing users to:

OLAP is a tool that enables users to:

Redundant data often stems from the use of different codes to identify the same data in a firm's various information systems.

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

Which of the following is an example of a company whose business model is based on access to large databases through the web?

Explain what big data refers to. What benefits does it have, and what challenges does it pose?

What types of relationships are possible in a relational database? Describe and give an example of each.

Within a corporate information services department, the task of establishing the physical database and its logical relations are responsibilities of the ________ function.

Both Oracle and Microsoft Access use SQL to retrieve information from a database.

A logical view of data shows data as it is organized on the storage media.

Business Information Systems in Your Career

Global E-Business and Collaboration

Achieving Competitive Advantage With Information Systems

Ethical and Social Issues in Information Systems

It Infrastructure: Hardware and Software

Telecommunications, the Internet, and Wireless Technology

Securing Information Systems

Achieving Operational Excellence and Customer Intimacy: Enterprise Applications

E-Commerce: Digital Markets, Digital Goods

Improving Decision Making and Managing Knowledge

Building Information Systems and Managing Projects

Filters