Question 1

What is a content creator?

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) B) and D)
F) B) and C)

Question 2

Information granularity means immediate, up-to-date information.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following encompasses all of the information contained within a single business process or unit of work with the primary purpose of supporting daily operational tasks?

Accepted Answer

A)  Targeted information
B)  Analytical information
C)  Productive information
D)  Transactional informationE) A) and B)
F) None of the above

Question 4

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 gaps.E) A) and B)
F) None of the above

Question 5

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

Accepted Answer

A) True 
 B)False

Question 6

Complete information asks if there is a value missing from the information.

Accepted Answer

A) True 
 B)False

Question 7

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 8

Consistent information asks if the aggregate or summary information is in agreement with detailed information.

Accepted Answer

A) True 
 B)False

Question 9

Which of the below does not represent a company that requires up-to-the-second information?

Accepted Answer

A)  911 response
B)  Stock traders
C)  Banks
D)  Construction companiesE) B) and D)
F) B) and C)

Question 10

Which of the following is a business-critical integrity constraint?

Accepted Answer

A)  System will not allow an entry for an order for a nonexistent customer.
B)  System will not allow returns of fresh produce after 15 days past delivery.
C)  System will not allow shipping a product to a customer who does not have a valid address.
D)  Systems will not allow shipping of a nonexistent product to a customer.E) A) and B)
F) B) and C)

Question 11

Which of the following occurs when the same data element has different values?

Accepted Answer

A)  Data modeling issue
B)  Data mining issue
C)  Data governance issue
D)  Information inconsistency issueE) A) and D)
F) All of the above

Question 12

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

Accepted Answer

A)  Dynamic website
B)  Data-driven website
C)  Static information
D)  Dynamic informationE) All of the above
F) None of the above

Question 13

Which of the following refers to immediate, up-to-date information?

Accepted Answer

A)  Daily information
B)  Strategic information
C)  Real-time information
D)  Crisis informationE) None of the above
F) A) and B)

Question 14

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following implies that information is current with respect to the business requirement?

Accepted Answer

A)  Uniqueness
B)  Accuracy
C)  Consistency
D)  TimelinessE) B) and C)
F) C) and D)

Question 16

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Accepted Answer

A) True 
 B)False

Question 17

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 18

What is data validation?

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 gaps.E) None of the above
F) All of the above

Question 19

What provides real-time information in response to query requests?

Accepted Answer

A)  Information systems
B)  Real-time systems
C)  Information level
D)  Information qualityE) B) and C)
F) A) and C)

Question 20

There are three primary data models for organizing information including the hierarchical, network, and relational database models.

Accepted Answer

A) True 
 B)False

Exam 6: Valuing and Storing Organizational Information Databases

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Correct AnswerverifiedShow Answer

A data gap analysis occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Correct AnswerverifiedShow Answer

Complete information asks if there is a value missing from the information.

Correct AnswerverifiedShow Answer

Consistent information asks if the aggregate or summary information is in agreement with detailed information.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

Correct AnswerverifiedShow Answer

Which of the following encompasses all of the information contained within a single business process or unit of work with the primary purpose of supporting daily operational tasks?

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

Which of the below does not represent a company that requires up-to-the-second information?

Correct AnswerverifiedShow Answer

What is data gap analysis?

Correct AnswerverifiedShow Answer

There are three primary data models for organizing information including the hierarchical, network, and relational database models.

Correct AnswerverifiedShow Answer

What is data validation?

Correct AnswerverifiedShow Answer

Which of the following occurs when the same data element has different values?

Correct AnswerverifiedShow Answer

Information granularity means immediate, up-to-date information.

Correct AnswerverifiedShow Answer

Which of the following refers to immediate, up-to-date information?

Correct AnswerverifiedShow Answer

Which of the following implies that information is current with respect to the business requirement?

Correct AnswerverifiedShow Answer

Information redundancy is the duplication of data, or the storage of the same data in multiple places.

Correct AnswerverifiedShow Answer

What provides real-time information in response to query requests?

Correct AnswerverifiedShow Answer

Which of the following is a business-critical integrity constraint?

Correct AnswerverifiedShow Answer

What is a content creator?

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