Question 1

Justin works at a top accounting firm in Los Angeles and his responsibilities include developing reports for each salesperson, product, and part as well as department wide sales reports by salesperson, product, and part. Justin's duties provide value to his company and would be categorized as occurring at the different ________.

Accepted Answer

A)   Information levels
B)   Information formats
C)   Information granularities
D)   Information focusE) All of the above
F) A) and B)

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

What is the primary problem with redundant information?

Accepted Answer

A)   It is difficult to determine which values are the most current
B)   It causes confusion
C)   It is difficult to determine which values are the most accurate
D)   All of theseE) A) and D)
F) C) and D)

Question 4

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Accepted Answer

A) True 
 B)False

Question 5

There are only two main primary traits that help you determine the value of information: timeliness and quality.

Accepted Answer

A) True 
 B)False

Question 6

What is static 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 actionE) B) and C)
F) None of the above

Question 7

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

Question 8

What is eintegration?

Accepted Answer

A)   The use of the Internet to provide customers with the ability to gain personalized information by querying corporate databases and their information sources.
B)   The integration of data from multiple sources, which provides a unified view of all data.
C)   Translates information between disparate systems.
D)   Packages commonly used applications together, reducing the time needed to integrate applications from multiple vendors.E) All of the above
F) C) and D)

Question 9

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

Question 10

What are several different types of software that sit between and provide connectivity for two or more software applications?

Accepted Answer

A)   Enterprise systems
B)   Enterprise application integration
C)   Middleware
D)   Enterprise application integration middlewareE) A) and D)
F) A) and B)

Question 11

Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the following represents the three common types of information found throughout an organization?

Accepted Answer

A)   Levels, forms, granularities
B)   Levels, forms, data
C)   Levels, formats, granularities
D)   Data, formats, granularitiesE) A) and D)
F) A) and C)

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Data validation includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

Accepted Answer

A) True 
 B)False

Question 14

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

Accepted Answer

A) True 
 B)False

Question 15

What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?

Accepted Answer

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

Question 16

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?

Accepted Answer

A)   Reduces disk space requirements
B)   Makes updating information easier
C)   Improves information quality
D)   All of theseE) None of the above
F) A) and B)

Question 17

Hierarchal database model stores information in the form of logically related two-dimensional tables.

Accepted Answer

A) True 
 B)False

Question 18

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Accepted Answer

A) True 
 B)False

Question 19

What is data stewardship?

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

Question 20

Reports for each sales person, product, and part are examples of information granularities.

Accepted Answer

A) True 
 B)False

Exam 6: Valuing and Storing Organizational Informationdatabases

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Correct Answer
verified

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

Correct Answer
verified

What is the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?

Correct Answer
verified

Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the following represents the three common types of information found throughout an organization?

Correct Answer
verified

What is static information?

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

What are several different types of software that sit between and provide connectivity for two or more software applications?

Correct Answer
verified

There are only two main primary traits that help you determine the value of information: timeliness and quality.

Correct Answer
verified

What is eintegration?

Correct Answer
verified

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Correct Answer
verified

Data validation includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

Correct Answer
verified

What is data stewardship?

Correct Answer
verified

What is the primary problem with redundant information?

Correct Answer
verified

Reports for each sales person, product, and part are examples of information granularities.

Correct Answer
verified

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

Correct Answer
verified

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?

Correct Answer
verified

Hierarchal database model stores information in the form of logically related two-dimensional tables.

Correct Answer
verified

What is data validation?

Correct Answer
verified

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

Correct Answer
verified

Exam 6: Valuing and Storing Organizational Informationdatabases

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

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 the practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete, including such entities as customers, suppliers, products, sales, employees, and other critical entities that are commonly integrated across organizational systems?

Correct AnswerverifiedShow Answer

Employees need to compare different types of information for what they commonly reveal to make strategic decisions. Which of the following represents the three common types of information found throughout an organization?

Correct AnswerverifiedShow Answer

What is static information?

Correct AnswerverifiedShow Answer

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are several different types of software that sit between and provide connectivity for two or more software applications?

Correct AnswerverifiedShow Answer

There are only two main primary traits that help you determine the value of information: timeliness and quality.

Correct AnswerverifiedShow Answer

What is eintegration?

Correct AnswerverifiedShow Answer

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table.

Correct AnswerverifiedShow Answer

Data validation includes the tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.

Correct AnswerverifiedShow Answer

What is data stewardship?

Correct AnswerverifiedShow Answer

What is the primary problem with redundant information?

Correct AnswerverifiedShow Answer

Reports for each sales person, product, and part are examples of information granularities.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

One of the primary goals of a database is to eliminate information redundancy by recording each piece of data in only one place in the database. What does the elimination of information redundancy do for a database?

Correct AnswerverifiedShow Answer

Hierarchal database model stores information in the form of logically related two-dimensional tables.

Correct AnswerverifiedShow Answer

What is data validation?

Correct AnswerverifiedShow Answer

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

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