Question 1

The data in a data warehouse have which of the following characteristics?

Accepted Answer

A)  They are organized by subject. 
B)  They are coded in different formats. 
C)  They are updated in real time. 
D)  They are typically retained for a defined, but limited, period of time. 
E)  They are organized in a hierarchical structure. 
A)  They are organized by subject. 
B)  They are coded in different formats. 
C)  They are updated in real time. 
D)  They are typically retained for a defined, but limited, period of time. 
E)  They are organized in a hierarchical structure.

Question 2

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry at a time. Which of the following entity-relationship diagrams is true?

Accepted Answer

A)    
B)    
C)    
D)   
Е.   
A)    
B)    
C)    
D)   
Е.

Question 3

Differentiate between explicit knowledge and tacit knowledge. Provide examples of each.

Accepted Answer

Explicit knowledge refers to knowledge t

Question 4

What are the advantages of a data mart?

Accepted Answer

A data mart is a subset of a data wareho

Question 5

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way. They are sharing their tacit knowledge.

Accepted Answer

A) True 
 B)False

Question 6

Describe the six steps of the knowledge management system cycle.

Accepted Answer

The six steps of the knowledge managemen

Question 7

Why is data governance so important for organizations?

Accepted Answer

Data governance is critically important

Question 8

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Accepted Answer

A) True 
 B)False

Question 9

Identify and explain the advantages of the four characteristics of data warehouses.

Accepted Answer

Data warehouses have four key characteri

Question 10

In the data hierarchy, the smallest element is the _____.

Accepted Answer

A)  Record. 
B)  Bit. 
C)  Byte. 
D)  Character. 
E)  File. 
A)  Record. 
B)  Bit. 
C)  Byte. 
D)  Character. 
E)  File.

Question 11

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

Accepted Answer

A)  Primary keys 
B)  Secondary keys 
C)  Duplicate keys 
D)  Attribute keys 
E)  Record keys 
A)  Primary keys 
B)  Secondary keys 
C)  Duplicate keys 
D)  Attribute keys 
E)  Record keys

Question 12

_____ occurs when various copies of the data agree.

Accepted Answer

A)  Data isolation 
B)  Data integrity 
C)  Data consistency 
D)  Data redundancy 
E)  Application/Data dependence 
A)  Data isolation 
B)  Data integrity 
C)  Data consistency 
D)  Data redundancy 
E)  Application/Data dependence

Question 13

Not including alphabetic characters in a Social Security Number field is an example of _____ .

Accepted Answer

A)  Data isolation. 
B)  Data integrity. 
C)  Data consistency. 
D)  Data redundancy. 
E)  Application/data dependence. 
A)  Data isolation. 
B)  Data integrity. 
C)  Data consistency. 
D)  Data redundancy. 
E)  Application/data dependence.

Question 14

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

Accepted Answer

A)  Primary key in Student entity 
B)  Primary key in Course entity 
C)  Its own primary key. 
D)  Primary key made up of the primary keys in Student entity and Course entity 
E)  It doesn't need a primary key. 
A)  Primary key in Student entity 
B)  Primary key in Course entity 
C)  Its own primary key. 
D)  Primary key made up of the primary keys in Student entity and Course entity 
E)  It doesn't need a primary key.

Question 15

Differentiate between master data and transaction data.

Accepted Answer

Master data and transaction data are two

Question 16

The secondary key is a field that identifies a record with complete uniqueness.

Accepted Answer

A) True 
 B)False

Question 17

The best way to capture the data in an organized format is to use a database.

Accepted Answer

A) True 
 B)False

Question 18

Online analytical processing (OLAP) involves the analysis of accumulated data by end users.

Accepted Answer

A) True 
 B)False

Question 19

For the following entity-relationship diagram, the Student entity would have the foreign key.

Accepted Answer

A) True 
 B)False

Question 20

Refer to IT's About Business 5.2. - Cell phone owners in Mexico: The cell phone registry is useless because:

Accepted Answer

A)  data for some cell phones are missing. 
B)  data for some cell phones are inaccurate. 
C)  very few Mexicans can afford cell phones. 
D)  All the above 
E)  A and B 
A)  data for some cell phones are missing. 
B)  data for some cell phones are inaccurate. 
C)  very few Mexicans can afford cell phones. 
D)  All the above 
E)  A and B

The data in a data warehouse have which of the following characteristics?

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry at a time. Which of the following entity-relationship diagrams is true?

Differentiate between explicit knowledge and tacit knowledge. Provide examples of each.

What are the advantages of a data mart?

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way. They are sharing their tacit knowledge.

Describe the six steps of the knowledge management system cycle.

Why is data governance so important for organizations?

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Identify and explain the advantages of the four characteristics of data warehouses.

In the data hierarchy, the smallest element is the _____.

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

_____ occurs when various copies of the data agree.

Not including alphabetic characters in a Social Security Number field is an example of _____ .

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

Differentiate between master data and transaction data.

The secondary key is a field that identifies a record with complete uniqueness.

The best way to capture the data in an organized format is to use a database.

Online analytical processing (OLAP) involves the analysis of accumulated data by end users.

For the following entity-relationship diagram, the Student entity would have the foreign key.

Refer to IT's About Business 5.2. - Cell phone owners in Mexico: The cell phone registry is useless because:

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Ethics and Privacy

Information Security and Controls

Telecommunications and Networking

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Social Computing

Information Systems Within the Organization

Customer Relationship Management and Supply Chain Management

Business Intelligence

Acquiring Information Systems and Applications

Technology Guide 1 Hardware

Technology Guide 2 Software

Technology Guide 3 Cloud Computing

Technology Guide 4 Intelligent Systems

Technology Guide 5 Protecting Your Information Assets

Filters

Exam 5: Data and Knowledge Management

The data in a data warehouse have which of the following characteristics?

In a jewelry store, a customer places an order for a piece of jewelry (for example, a silver pin in the shape of a tulip). A customer could order more than one piece of jewelry at a time. Which of the following entity-relationship diagrams is true?

Differentiate between explicit knowledge and tacit knowledge. Provide examples of each.

What are the advantages of a data mart?

When you start a job, you watch what other employees are doing and ask them to explain why they do it in a particular way. They are sharing their tacit knowledge.

Describe the six steps of the knowledge management system cycle.

Why is data governance so important for organizations?

When data are normalized, attributes in the table depend on the primary key and any secondary keys.

Identify and explain the advantages of the four characteristics of data warehouses.

In the data hierarchy, the smallest element is the _____.

_____ are fields in a record that have some identifying information but typically do not identify the record with complete accuracy.

_____ occurs when various copies of the data agree.

Not including alphabetic characters in a Social Security Number field is an example of _____ .

For the following entity-relationship diagram, what could the primary key be in the Grade entity?

Differentiate between master data and transaction data.

The secondary key is a field that identifies a record with complete uniqueness.

The best way to capture the data in an organized format is to use a database.

Online analytical processing (OLAP) involves the analysis of accumulated data by end users.

For the following entity-relationship diagram, the Student entity would have the foreign key.

Refer to IT's About Business 5.2. - Cell phone owners in Mexico: The cell phone registry is useless because:

Introduction to Information Systems

Organizational Strategy, Competitive Advantage, and Information Systems

Ethics and Privacy

Information Security and Controls

Telecommunications and Networking

E-Business and E-Commerce

Wireless, Mobile Computing, and Mobile Commerce

Social Computing

Information Systems Within the Organization

Customer Relationship Management and Supply Chain Management

Business Intelligence

Acquiring Information Systems and Applications

Technology Guide 1 Hardware

Technology Guide 2 Software

Technology Guide 3 Cloud Computing

Technology Guide 4 Intelligent Systems

Technology Guide 5 Protecting Your Information Assets

Filters