Question 1

What is the term for 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)   Data steward
B)   Data stewardship
C)   Data gap analysis
D)   Data governanceE) A) and B)
F) All of the above

Question 2

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Accepted Answer

A) True 
 B)False

Question 3

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following refers to the extent of detail within the information?

Accepted Answer

A)   Knowledge information
B)   Information granularity
C)   Chance information
D)   Information analyticsE) B) and C)
F) C) and D)

Question 5

What are the rules that enforce basic and fundamental information-based constraints?

Accepted Answer

A)   Responsibly integrity constraints
B)   Quality constraints
C)   Web integrity constraints
D)   Relational integrity constraintsE) B) and C)
F) C) and D)

Question 6

What occurs when a system produces incorrect, inconsistent, or duplicate data?

Accepted Answer

A)   Information inconsistency
B)   Information integrity issues
C)   Data governance
D)   Master data managementE) A) and B)
F) A) and D)

Question 7

What is data gap analysis?

Accepted Answer

A)   The time it takes for data to be stored or retrieved
B)   The management and oversight of an organization's data assets
C)   The tests and evaluations used to determine compliance with data governance policies to ensure correctness of data
D)   When a company examines its data to determine if it can meet business expectations, while identifying possible data gapsE) None of the above
F) A) and B)

Question 8

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Accepted Answer

A)   Business intelligence system
B)   Informational database system
C)   Relational database management system
D)   Data mining systemE) A) and C)
F) None of the above

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Accepted Answer

A) True 
 B)False

Question 11

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Accepted Answer

A)   Data-driven website
B)   Interactive website
C)   Database performing website
D)   Data processing websiteE) A) and D)
F) None of the above

Question 12

What are enterprise systems?

Accepted Answer

A)   The integration of a company's existing management information systems.
B)   The integration of data from multiple sources, which provides a unified view of all data.
C)   Sends information entered into a given system automatically to all downstream systems and processes.
D)   Enterprisewide support and data access for a firm's operations and business processes.E) A) and D)
F) B) and C)

Question 13

Which of the following represents a reason for low-quality information?

Accepted Answer

A)   Online customers intentionally enter inaccurate information to protect their privacy.
B)   Different systems have different information entry standards and formats.
C)   Third-party and external information contains inaccuracies and errors.
D)   All of these.E) A) and D)
F) All of the above

Question 14

What takes information entered into a given system and sends it automatically to all downstream systems and processes?

Accepted Answer

A)   Backward integration
B)   Application integration
C)   Data integration
D)   Forward integrationE) A) and C)
F) A) and D)

Question 15

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Accepted Answer

A) True 
 B)False

Question 16

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Accepted Answer

A)   Relational integrity constraint
B)   Business-critical integrity constraint
C)   Information-critical integrity constraint
D)   Mission-critical integrity constraintE) A) and B)
F) A) and C)

Question 17

Attributes (also called columns or fields) are the data elements associated with an entity.

Accepted Answer

A) True 
 B)False

Question 18

What is supply chain management (SCM) ?

Accepted Answer

A)   The management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability.
B)   Takes information entered into a given system and sends it automatically to all downstream systems and processes.
C)   A means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability.
D)   Connects the plans, methods, and tools aimed at integrating separate enterprise system.E) C) and D)
F) A) and B)

Question 19

Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

Accepted Answer

A)   Improvements
B)   Change
C)   Clustering
D)   CleansingE) None of the above
F) A) and D)

Question 20

Which of the following represent the four primary traits that help determine the value of information?

Accepted Answer

A)   Information type, information timeliness, information quality, and information governance
B)   Information statistics, information tracking, information quality, and information governance
C)   Information type, information chance, information analytics, and information policy
D)   Information timeliness, information quality, information quantity, and information governance policyE) None of the above
F) A) and B)

Exam 6: Valuing and Storing Organizational Informationdatabases

What is data gap analysis?

Correct AnswerverifiedShow Answer

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Correct AnswerverifiedShow Answer

Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

Correct AnswerverifiedShow Answer

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Correct AnswerverifiedShow Answer

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Correct AnswerverifiedShow Answer

What are enterprise systems?

Correct AnswerverifiedShow Answer

One of the advantages found in a relational database is increased information redundancy.

Correct AnswerverifiedShow Answer

Which of the following refers to the extent of detail within the information?

Correct AnswerverifiedShow Answer

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is the term for 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

Attributes (also called columns or fields) are the data elements associated with an entity.

Correct AnswerverifiedShow Answer

A primary key is a foreign key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Correct AnswerverifiedShow Answer

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Correct AnswerverifiedShow Answer

What are the rules that enforce basic and fundamental information-based constraints?

Correct AnswerverifiedShow Answer

What is supply chain management (SCM) ?

Correct AnswerverifiedShow Answer

Which of the following represents a reason for low-quality information?

Correct AnswerverifiedShow Answer

What occurs when a system produces incorrect, inconsistent, or duplicate data?

Correct AnswerverifiedShow Answer

What takes information entered into a given system and sends it automatically to all downstream systems and processes?

Correct AnswerverifiedShow Answer

Which of the following represent the four primary traits that help determine the value 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