Question 1

Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Accepted Answer

A)  Database element
B)  Database management system
C)  Data governance
D)  Data FileE) A) and D)
F) A) and B)

Question 3

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A)  It is only available to high-level executives due to the expense.
B)  It is only available in aggregate levels of granularity.
C)  It continually changes.
D)  It rarely changes.E) A) and B)
F) A) and C)

Question 4

Complete information asks if there is an incorrect value in the information.

Accepted Answer

A) True 
 B)False

Question 5

Data latency is the time it takes for data to be stored or retrieved.

Accepted Answer

A) True 
 B)False

Question 6

The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

Accepted Answer

A) True 
 B)False

Question 7

The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

Accepted Answer

A)  Increased scalability and performance
B)  Increased information security
C)  Reduced information redundancy
D)  Increased flexibilityE) A) and D)
F) A) and C)

Question 8

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Accepted Answer

A)  Entity
B)  Extraction
C)  Attribute
D)  Foreign keyE) B) and C)
F) A) and B)

Question 9

What is dynamic information?

Accepted Answer

A)  The person responsible for creating the original website content.
B)  The person responsible for updating and maintaining website content.
C)  Includes fixed data incapable of change in the event of a user action.
D)  Includes data that change based on user action.E) C) and D)
F) B) and D)

Question 10

Relational database management system allows users to create, read, update, and delete data in a relational database.

Accepted Answer

A) True 
 B)False

Question 11

What is immediate, up-to-date information?

Accepted Answer

A)  Real-time information
B)  Real-time systems
C)  Information granularity
D)  Information governanceE) None of the above
F) A) and B)

Question 12

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Accepted Answer

A) True 
 B)False

Question 13

Data element (or data field) is the smallest, or basic, unit of information.

Accepted Answer

A) True 
 B)False

Question 14

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 15

A forward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

Accepted Answer

A) True 
 B)False

Question 16

The physical view of information deals with the physical storage of information on a storage device.

Accepted Answer

A) True 
 B)False

Question 17

What maintains information about various types of objects, events, people, and places?

Accepted Answer

A)  Database
B)  Data model
C)  Data mining
D)  Data intelligenceE) A) and C)
F) All of the above

Question 18

What is a foreign key?

Accepted Answer

A)  A field (or group of fields)  that uniquely identifies a given entity in a table.
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables.
C)  Characteristics or properties of an entity.
D)  A field (or group of fields)  that uniquely identifies a given attribute in a table.E) C) and D)
F) B) and C)

Question 19

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Accepted Answer

A) True 
 B)False

Question 20

Integrity constraints are rules that help ensure the quality of information.

Accepted Answer

A) True 
 B)False

Exam 6: Valuing and Storing Organizational Information Databases

Complete information asks if there is an incorrect value in the information.

Correct AnswerverifiedShow Answer

A forward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

Correct AnswerverifiedShow Answer

The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

Correct AnswerverifiedShow Answer

What is immediate, up-to-date information?

Correct AnswerverifiedShow Answer

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Correct AnswerverifiedShow Answer

What is a foreign key?

Correct AnswerverifiedShow Answer

Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Correct AnswerverifiedShow Answer

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Correct AnswerverifiedShow Answer

Data latency is the time it takes for data to be stored or retrieved.

Correct AnswerverifiedShow Answer

What is one of the biggest pitfalls associated with real-time information?

Correct AnswerverifiedShow Answer

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Correct AnswerverifiedShow Answer

What is dynamic information?

Correct AnswerverifiedShow Answer

What maintains information about various types of objects, events, people, and places?

Correct AnswerverifiedShow Answer

Data element (or data field) is the smallest, or basic, unit of information.

Correct AnswerverifiedShow Answer

The physical view of information deals with the physical storage of information on a storage device.

Correct AnswerverifiedShow Answer

Relational database management system allows users to create, read, update, and delete data in a relational database.

Correct AnswerverifiedShow Answer

The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

Correct AnswerverifiedShow Answer

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Correct AnswerverifiedShow Answer

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Correct AnswerverifiedShow Answer

Integrity constraints are rules that help ensure the quality of information.

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified