Question 1

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

Accepted Answer

A)  An attribute is a table, whereas 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 part of a table that stores information about people, places, or events, whereas an attribute is a column or specific field of the data elements associated with an entity. 
A)  An attribute is a table, whereas 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 part of a table that stores information about people, places, or events, whereas an attribute is a column or specific field of the data elements associated with an entity.

Question 2

Complete information asks if there is an incorrect value in the information.

Accepted Answer

A) True 
 B)False

Question 3

What are the two different categories for information type?

Accepted Answer

A)  Analytical and productive 
B)  Analytical and analysis 
C)  Transactional and analytical 
D)  Transactional and analysis 
A)  Analytical and productive 
B)  Analytical and analysis 
C)  Transactional and analytical 
D)  Transactional and analysis

Question 4

Integrity constraints are rules that help ensure the quality of information.

Accepted Answer

A) True 
 B)False

Question 5

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 information 
A)  Targeted information 
B)  Analytical information 
C)  Productive information 
D)  Transactional information

Question 6

Which of the following is not one of the five characteristics common to high-quality information?

Accepted Answer

A)  Accuracy 
B)  Completeness 
C)  Quantity 
D)  Consistency 
A)  Accuracy 
B)  Completeness 
C)  Quantity 
D)  Consistency

Question 7

Dynamic information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Question 8

What is a primary key?

Accepted Answer

A)  A field (or group of fields) that uniquely identifies a given record in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity 
D)  A field (or group of fields) that uniquely identifies a given attribute in a table 
A)  A field (or group of fields) that uniquely identifies a given record in a table 
B)  A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables 
C)  Characteristics or properties of an entity 
D)  A field (or group of fields) that uniquely identifies a given attribute in a table

Question 9

Static information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Question 10

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 11

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 12

A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

Accepted Answer

A) True 
 B)False

Question 13

What is the overall management of the availability, usability, integrity, and security of company data?

Accepted Answer

A)  Data intelligence 
B)  Data governance 
C)  Data forbearance 
D)  Data forecasting 
A)  Data intelligence 
B)  Data governance 
C)  Data forbearance 
D)  Data forecasting

Question 14

Which of the following is true in regards to the elimination of redundant information?

Accepted Answer

A)  Uses additional hard disk space 
B)  Makes performing information updates harder 
C)  Improves information quality 
D)  All of these 
A)  Uses additional hard disk space 
B)  Makes performing information updates harder 
C)  Improves information quality 
D)  All of these

Question 15

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 
A)  Detail, summary, aggregate 
B)  Document, presentation, spreadsheet, database 
C)  Individual, department, enterprise 
D)  Executives, managers, operational employees

Question 16

What is enterprise application integration (EAI) middleware?

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. 
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 17

What is identity management?

Accepted Answer

A)  Enforces business rules vital to an organization's success 
B)  The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete 
C)  A broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system 
D)  A company's examination of its data to determine if the company can meet business expectations and to identify possible data gaps 
A)  Enforces business rules vital to an organization's success 
B)  The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete 
C)  A broad administrative area that deals with identifying individuals in a system and controlling their access to resources within that system 
D)  A company's examination of its data to determine if the company can meet business expectations and to identify possible data gaps

Question 18

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 issue 
A)  Data modeling issue 
B)  Data mining issue 
C)  Data governance issue 
D)  Information inconsistency issue

Question 19

What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?

Accepted Answer

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

Question 20

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 information 
A)  Dynamic website 
B)  Data-driven website 
C)  Static information 
D)  Dynamic information

Exam 6: Valuing and Storing Organizational Informationdatabases

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

Complete information asks if there is an incorrect value in the information.

What are the two different categories for information type?

Integrity constraints are rules that help ensure the quality of information.

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?

Which of the following is not one of the five characteristics common to high-quality information?

Dynamic information includes data that change based on user actions.

What is a primary key?

Static information includes data that change based on user actions.

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Information quality refers to the extent of detail within the information (fine and detailed or coarse and abstract).

A data steward is responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

What is the overall management of the availability, usability, integrity, and security of company data?

Which of the following is true in regards to the elimination of redundant information?

Which of the following represents the different information levels?

What is enterprise application integration (EAI) middleware?

What is identity management?

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

What encompasses all organizational information and its primary purpose is to support the performing of managerial analysis tasks?

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

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Accessing Organizational Informationdata Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organizationdecision Making

Extending the Organizationsupply Chain Management

Building a Customer-Centric Organizationcustomer Relationship Management

Integrating the Organization From End to Endenterprise Resource Planning

Creating Innovative Organizations

Ebusiness

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Valuing and Storing Organizational Informationdatabases

Accessing Organizational Informationdata Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organizationdecision Making

Extending the Organizationsupply Chain Management

Building a Customer-Centric Organizationcustomer Relationship Management

Integrating the Organization From End to Endenterprise Resource Planning

Filters