Question 1

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 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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 5

In a client/server environment,a DBMS is located on a dedicated computer called a web server.

Accepted Answer

A) True 
 B)False

Question 6

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

Accepted Answer

The first step is to perform a data qual

Question 7

A(n)________ represent data as two-dimensional tables.

Accepted Answer

A) non-relational DBMS 
B) mobile DBMS 
C) relational DBMS 
D) hierarchical DBMS 
E) object-oriented DBMS 
A) non-relational DBMS 
B) mobile DBMS 
C) relational DBMS 
D) hierarchical DBMS 
E) object-oriented DBMS

Question 8

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.

Question 9

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What factors will influence how you design the database?

Accepted Answer

Student answers will vary,but should inc

Question 10

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 11

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

Accepted Answer

A) True 
 B)False

Question 12

Data ________ occurs when the same data is duplicated in multiple files of a database.

Accepted Answer

A) redundancy 
B) repetition 
C) independence 
D) partitions 
E) discrepancy 
A) redundancy 
B) repetition 
C) independence 
D) partitions 
E) discrepancy

Question 13

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use the data mining software you are using to do which of the following?

Accepted Answer

A) Identify associations 
B) Identify clusters 
C) Identify sequences 
D) Classify data 
E) Create a forecast 
A) Identify associations 
B) Identify clusters 
C) Identify sequences 
D) Classify data 
E) Create a forecast

Question 14

Multiple data marts are combined and streamlined to create a data warehouse.

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 17

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

Accepted Answer

A DBMS includes capabilities and tools f

Question 18

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems?

Accepted Answer

A) Program-data dependence 
B) Lack of flexibility 
C) Poor security 
D) Lack of data sharing 
E) Data redundancy 
A) Program-data dependence 
B) Lack of flexibility 
C) Poor security 
D) Lack of data sharing 
E) Data redundancy

Question 19

MongoDB and SimpleDB are both examples of:

Accepted Answer

A) open source databases. 
B) SQL databases. 
C) NoSQL databases. 
D) cloud databases. 
E) big data databases. 
A) open source databases. 
B) SQL databases. 
C) NoSQL databases. 
D) cloud databases. 
E) big data databases.

Question 20

In a table for customers,the information about a single customer resides 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.

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

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

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

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

In a client/server environment,a DBMS is located on a dedicated computer called a web server.

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

A(n)________ represent data as two-dimensional tables.

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

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What factors will influence how you design the database?

A data warehouse is composed of:

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

Data ________ occurs when the same data is duplicated in multiple files of a database.

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use the data mining software you are using to do which of the following?

Multiple data marts are combined and streamlined to create a data warehouse.

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

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?

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

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems?

MongoDB and SimpleDB are both examples of:

In a table for customers,the information about a single customer resides in a single:

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

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

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

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

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

In a client/server environment,a DBMS is located on a dedicated computer called a web server.

Distributors for a furniture manufacturer are complaining that the billing for goods they order is frequently not correct,and sometimes are sent to the wrong e-mail and postal addresses.What steps would you take to improve the quality of data in the manufacturer's databases?

A(n)________ represent data as two-dimensional tables.

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

The small publishing company you work for wants to create a new database for storing information about all of their author contracts.What factors will influence how you design the database?

A data warehouse is composed of:

Middleware is an application that transfers information from an organization's internal database to a web server for delivery to a user as part of a web page.

Data ________ occurs when the same data is duplicated in multiple files of a database.

You work for a car rental agency and want to determine what characteristics are shared among your most loyal customers.To do this,you will want to use the data mining software you are using to do which of the following?

Multiple data marts are combined and streamlined to create a data warehouse.

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

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?

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

The fact that a traditional file system cannot respond to unanticipated information requirements in a timely fashion is an example of which of the following issues with traditional file systems?

MongoDB and SimpleDB are both examples of:

In a table for customers,the information about a single customer resides in a single:

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