Question 1

Data warehouses and data marts are updated by users.

Accepted Answer

A) True 
 B)False

Question 2

A(n)  ________ of an entity refers to each row in a relational table, which is a specific, unique representation of the entity.

Accepted Answer

A)   attribute
B)   field
C)   instance
D)   record

Question 3

Data marts and data warehouses typically use ________.

Accepted Answer

A)   ERP
B)   OLAP
C)   OLTP
D)   RFID

Question 4

________ is an intellectual asset.

Accepted Answer

A)   Data
B)   Information
C)   Knowledge
D)   Wisdom

Question 5

Database systems maximize ________.

Accepted Answer

A)   inconsistency
B)   independence
C)   isolation
D)   redundancy

Question 6

Data warehouses are information silos.

Accepted Answer

A) True 
 B)False

Question 7

Each bicycle in the 2018 Tour de France produced a total of more than 3 ____ data points during the course of the race.

Accepted Answer

A)   thousand
B)   million
C)   billion
D)   trillion

Question 8

Database systems minimize ________.

Accepted Answer

A)   inconsistency
B)   independence
C)   integrity
D)   security

Question 9

___ is a process that spans all organizational business processes and applications.

Accepted Answer

Master dat...

Question 10

Google's Cloud Spanner is a globally distributed ___ database that ____.

Accepted Answer

A)   NewSQL; synchronizes time
B)   NewSQL; tracks users
C)   SQL; synchronizes time
D)   SQL; tracks users

Question 11

Data ________ refers primarily to problems with the media on which the data are stored.

Accepted Answer

A)   clickstreaming
B)   degradation
C)   scattering
D)   rot

Question 12

Sarbanes-Oxley holds CIOs personally responsible for financial disclosures since they manage the systems that hold financial information.

Accepted Answer

A) True 
 B)False

Question 13

Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance.

Accepted Answer

A)   maximum; maximum
B)   maximum; minimum
C)   minimum; maximum
D)   minimum; minimum

Question 14

Considering the following tables, ________ is a primary key.

Accepted Answer

A)   Class Table: PID
B)   Professor Table: Name
C)   Student Table: Expected Graduation Year
D)   Student Table: ID

Question 15

Which of the following companies is NOT developing cars and self-driving technology/services?

Accepted Answer

A)   Amazon
B)   Apple
C)   Google
D)   IBM

Question 16

List and describe the nine issues that make managing data so difficult. Discuss how your university may struggle with each issue. Now evaluate how a business like Amazon may struggle with each issue.

Accepted Answer

<img  loading="lazy" src="/assets/images/blured-textbook.svg" class="d-inline m-1" alt="blured image" width="139" height="30">Amount of data increasing - more new stu...

Question 17

We leave valuable trails of data behind when we use tracking and recording devices called data ________.

Accepted Answer

A)   debris
B)   exhaust
C)   markers
D)   roads

Question 18

Which of the following is NOT a problem associated with Big Data?

Accepted Answer

A)   Big Data can be structured, unstructured, or semi-structured.
B)   Big Data can come from untrusted sources.
C)   Big Data changes.
D)   Big Data lacks quality.

Question 19

The 2018 Tour de France bicycles transmitted data over a ___ network.

Accepted Answer

A)   data
B)   mesh
C)   personal area
D)   satellite

Question 20

Which of the following is the correct order of the KMS cycle?

Accepted Answer

A)   capture, create, refine, store, manage, disseminate
B)   capture, create, refine, store, disseminate, manage
C)   create, capture, refine, store, manage, disseminate
D)   create, capture, refine, store, disseminate, manage

Exam 5: Data and Knowledge Management

Data warehouses are information silos.

Correct AnswerverifiedShow Answer

Which of the following is NOT a problem associated with Big Data?

Correct AnswerverifiedShow Answer

Which of the following is the correct order of the KMS cycle?

Correct AnswerverifiedShow Answer

Sarbanes-Oxley holds CIOs personally responsible for financial disclosures since they manage the systems that hold financial information.

Correct AnswerverifiedShow Answer

A(n) ________ of an entity refers to each row in a relational table, which is a specific, unique representation of the entity.

Correct AnswerverifiedShow Answer

List and describe the nine issues that make managing data so difficult. Discuss how your university may struggle with each issue. Now evaluate how a business like Amazon may struggle with each issue.

Correct AnswerverifiedAmount of data increasing - more new stu...View AnswerShow Answer

Data warehouses and data marts are updated by users.

Correct AnswerverifiedShow Answer

Data ________ refers primarily to problems with the media on which the data are stored.

Correct AnswerverifiedShow Answer

We leave valuable trails of data behind when we use tracking and recording devices called data ________.

Correct AnswerverifiedShow Answer

Data marts and data warehouses typically use ________.

Correct AnswerverifiedShow Answer

The 2018 Tour de France bicycles transmitted data over a ___ network.

Correct AnswerverifiedShow Answer

Which of the following companies is NOT developing cars and self-driving technology/services?

Correct AnswerverifiedShow Answer

Google's Cloud Spanner is a globally distributed ___ database that ____.

Correct AnswerverifiedShow Answer

Each bicycle in the 2018 Tour de France produced a total of more than 3 ____ data points during the course of the race.

Correct AnswerverifiedShow Answer

___ is a process that spans all organizational business processes and applications.

Correct AnswerverifiedMaster dat...View AnswerShow Answer

Database systems maximize ________.

Correct AnswerverifiedShow Answer

________ is an intellectual asset.

Correct AnswerverifiedShow Answer

Considering the following tables, ________ is a primary key.

Correct AnswerverifiedShow Answer

Database systems minimize ________.

Correct AnswerverifiedShow Answer

Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Amount of data increasing - more new stu...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Google's Cloud Spanner is a globally distributed _ database that __.

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Master dat...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure redundancy, data integrity, and optimal processing performance.

Correct Answer
verified