Question 1

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 2

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

Accepted Answer

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

Question 3

Data warehouses and data marts are updated by users.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

Master dat...

Question 5

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 6

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 7

Data warehouses are information silos.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Database systems maximize ________.

Accepted Answer

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

Question 10

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 11

Data marts and data warehouses typically use ________.

Accepted Answer

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

Question 12

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 13

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 14

Database systems minimize ________.

Accepted Answer

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

Question 15

________ is an intellectual asset.

Accepted Answer

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

Question 16

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 17

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

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

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 20

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

Accepted Answer

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

Exam 5: Data and Knowledge Management

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

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

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

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

Correct AnswerverifiedMaster dat...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

Data warehouses are information silos.

Correct AnswerverifiedShow Answer

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

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

________ is an intellectual asset.

Correct AnswerverifiedShow Answer

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

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

Database systems maximize ________.

Correct AnswerverifiedShow Answer

Considering the following tables, ________ is a primary key.

Correct AnswerverifiedShow Answer

Database systems minimize ________.

Correct AnswerverifiedShow Answer

Data marts and data warehouses typically use ________.

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 warehouses and data marts are updated by users.

Correct AnswerverifiedShow 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

Correct Answer
verified
Master dat...
View Answer

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified