Question 1

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)  discrepancyF) B) and D)
G) A) and B)

Question 2

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)  DayF) All of the above
G) D) and E)

Question 3

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 forecastF) None of the above
G) A) and C)

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.F) A) and E)
G) B) and D)

Question 5

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.F) A) and B)
G) C) and D)

Question 6

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 7

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.F) None of the above
G) C) and D)

Question 8

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.F) A) and B)
G) C) and D)

Question 9

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.F) A) and B)
G) B) and C)

Question 10

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

Accepted Answer

A DBMS includes capabilities and tools f...

Question 11

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 12

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 qualityF) D) and E)
G) B) and E)

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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.F) B) and E)
G) B) and C)

Question 17

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 redundancyF) C) and D)
G) A) and D)

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 DBMSF) C) and D)
G) None of the above

Question 20

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.F) D) and E)
G) None of the above

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

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

MongoDB and SimpleDB are both examples of:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedThe first step is to perform a data qual...View AnswerShow Answer

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

Correct AnswerverifiedA DBMS includes capabilities and tools f...View AnswerShow Answer

A data warehouse is composed of:

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedStudent answers will vary,but should inc...View AnswerShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
The first step is to perform a data qual...
View Answer

Correct Answer
verified
A DBMS includes capabilities and tools f...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Student answers will vary,but should inc...
View Answer