Question 1

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 2

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, granularities

Question 3

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

Accepted Answer

A) True 
 B)False

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

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.

Question 6

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 7

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 8

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

Question 9

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 these

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 middleware

Question 11

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 gaps

Question 12

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 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 these

Question 16

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 focus

Question 17

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 18

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 management

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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 action

Exam 6: Valuing and Storing Organizational Informationdatabases

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

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?

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

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

What is eintegration?

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

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

What is data validation?

What is the primary problem with redundant information?

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

What is data stewardship?

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.

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

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

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?

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

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?

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

What is static information?