Question 1

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Accepted Answer

A) True 
 B)False

Question 2

Dynamic information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Question 3

Structured query language compiles all of the metadata about the data elements in the data model.

Accepted Answer

A) True 
 B)False

Question 4

Static information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Question 5

What is the primary difference between an entity and an attribute?

Accepted Answer

A)  An attribute is a table, an entity is a column from the attribute table.
B)  An entity is specific, whereas an attribute is not data at all but brainstorming of ideas that takes place before the entity is created.
C)  An attribute refers to applications, and an entity refers to executives.
D)  An entity is a table that stores information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entity.

Question 6

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 7

A foreign key uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following would not be considered part of the complete characteristic of high-quality information?

Accepted Answer

A)  Is a value missing from the personal information?
B)  Is each transaction represented only once in the information?
C)  Is the address incomplete?
D)  Is the area code missing for the phone information?

Question 9

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 10

Organizational information comes at the same level, formats, and granularities.

Accepted Answer

A) True 
 B)False

Question 11

What are rules that help ensure the quality of information?

Accepted Answer

A)  Information integrity
B)  Integrity constraints
C)  Information quality
D)  Information ethics

Question 12

Which of the below is not an example of an advantage of using a relational database?

Accepted Answer

A)  Increased information quality
B)  Increased flexibility
C)  Decreased information redundancy
D)  Decreased information security

Question 13

What is a data steward?

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 person responsible for ensuring policies and procedures are implemented across the organization.
D)  When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.

Question 14

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Accepted Answer

A)  Transactional information
B)  Analytical information
C)  Timeliness
D)  Quality

Question 15

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

Accepted Answer

A)  Dynamic website
B)  Data-driven website
C)  Static information
D)  Dynamic information

Question 16

Which of the following represents the different information levels?

Accepted Answer

A)  Detail, summary, aggregate
B)  Document, presentation, spreadsheet, database
C)  Individual, department, enterprise
D)  Executives, managers, operational employees

Question 17

Unique information asks if the information is current with respect to the business needs.

Accepted Answer

A) True 
 B)False

Question 18

Dynamic website information is stored in a dynamic catalog, or an area of a website that stores information about products in a database.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following asks users to write lines of code to answer questions against a database?

Accepted Answer

A)  Structured query language
B)  Relational query language
C)  Structured elements
D)  Data mining tools

Question 20

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

Accepted Answer

A)  Forward integration
B)  Forward data interchange
C)  Backward integration
D)  Backward data interchange

Exam 6: Valuing and Storing Organizational Information Databases

Dynamic website information is stored in a dynamic catalog, or an area of a website that stores information about products in a database.

Correct AnswerverifiedShow Answer

Which of the following represents the different information levels?

Correct AnswerverifiedShow Answer

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Correct AnswerverifiedShow Answer

Structured query language compiles all of the metadata about the data elements in the data model.

Correct AnswerverifiedShow Answer

Which of the following would not be considered part of the complete characteristic of high-quality information?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Correct AnswerverifiedShow Answer

Which of the following asks users to write lines of code to answer questions against a database?

Correct AnswerverifiedShow Answer

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Correct AnswerverifiedShow Answer

What is a data steward?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Unique information asks if the information is current with respect to the business needs.

Correct AnswerverifiedShow Answer

A foreign key provides details about data.

Correct AnswerverifiedShow Answer

Organizational information comes at the same level, formats, and granularities.

Correct AnswerverifiedShow Answer

What are rules that help ensure the quality of information?

Correct AnswerverifiedShow Answer

What is the primary difference between an entity and an attribute?

Correct AnswerverifiedShow Answer

A foreign key uniquely identifies a given record in a table.

Correct AnswerverifiedShow Answer

Static information includes data that change based on user actions.

Correct AnswerverifiedShow Answer

Dynamic information includes data that change based on user actions.

Correct AnswerverifiedShow Answer

Which of the below is not an example of an advantage of using a relational database?

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