Question 1

Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

Accepted Answer

A)  Improvements 
B)  Change 
C)  Clustering 
D)  Cleansing 
A)  Improvements 
B)  Change 
C)  Clustering 
D)  Cleansing

Question 2

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Accepted Answer

A)  Business intelligence system 
B)  Informational database system 
C)  Relational database management system 
D)  Data mining system 
A)  Business intelligence system 
B)  Informational database system 
C)  Relational database management system 
D)  Data mining system

Question 3

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following represent the four primary traits that help determine the value of information?

Accepted Answer

A)  Information type, information timeliness, information quality, and information governance 
B)  Information statistics, information tracking, information quality, and information governance 
C)  Information type, information chance, information analytics, and information policy 
D)  Information timeliness, information quality, information quantity, and information governance policy 
A)  Information type, information timeliness, information quality, and information governance 
B)  Information statistics, information tracking, information quality, and information governance 
C)  Information type, information chance, information analytics, and information policy 
D)  Information timeliness, information quality, information quantity, and information governance policy

Question 5

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Accepted Answer

A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  Mission-critical integrity constraint 
A)  Relational integrity constraint 
B)  Business-critical integrity constraint 
C)  Information-critical integrity constraint 
D)  Mission-critical integrity constraint

Question 6

One of the advantages found in a relational database is increased information redundancy.

Accepted Answer

A) True 
 B)False

Question 7

What is supply chain management (SCM)?

Accepted Answer

A)  The management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability. 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes. 
C)  A means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability. 
D)  Connects the plans, methods, and tools aimed at integrating separate enterprise system. 
A)  The management of information flows between and among activities in a supply chain to maximize total supply chain effectiveness and corporate profitability. 
B)  Takes information entered into a given system and sends it automatically to all downstream systems and processes. 
C)  A means of managing all aspects of a customer's relationship with an organization to increase customer loyalty and retention and an organization's profitability. 
D)  Connects the plans, methods, and tools aimed at integrating separate enterprise system.

Question 8

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 9

What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

Accepted Answer

A)  Data steward 
B)  Data stewardship 
C)  Data gap analysis 
D)  Data governance 
A)  Data steward 
B)  Data stewardship 
C)  Data gap analysis 
D)  Data governance

Question 10

Attributes (also called columns or fields) are the data elements associated with an entity.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following represents a reason for low-quality information?

Accepted Answer

A)  Online customers intentionally enter inaccurate information to protect their privacy. 
B)  Different systems have different information entry standards and formats. 
C)  Third-party and external information contains inaccuracies and errors. 
D)  All of these. 
A)  Online customers intentionally enter inaccurate information to protect their privacy. 
B)  Different systems have different information entry standards and formats. 
C)  Third-party and external information contains inaccuracies and errors. 
D)  All of these.

Question 12

What occurs when a system produces incorrect, inconsistent, or duplicate data?

Accepted Answer

A)  Information inconsistency 
B)  Information integrity issues 
C)  Data governance 
D)  Master data management 
A)  Information inconsistency 
B)  Information integrity issues 
C)  Data governance 
D)  Master data management

Question 13

What are the rules that enforce basic and fundamental information-based constraints?

Accepted Answer

A)  Responsibly integrity constraints 
B)  Quality constraints 
C)  Web integrity constraints 
D)  Relational integrity constraints 
A)  Responsibly integrity constraints 
B)  Quality constraints 
C)  Web integrity constraints 
D)  Relational integrity constraints

Question 14

A forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  Data-driven website 
B)  Interactive website 
C)  Database performing website 
D)  Data processing website 
A)  Data-driven website 
B)  Interactive website 
C)  Database performing website 
D)  Data processing website

Question 16

What are enterprise systems?

Accepted Answer

A)  The integration of a company's existing management information systems. 
B)  The integration of data from multiple sources, which provides a unified view of all data. 
C)  Sends information entered into a given system automatically to all downstream systems and processes. 
D)  Enterprisewide support and data access for a firm's operations and business processes. 
A)  The integration of a company's existing management information systems. 
B)  The integration of data from multiple sources, which provides a unified view of all data. 
C)  Sends information entered into a given system automatically to all downstream systems and processes. 
D)  Enterprisewide support and data access for a firm's operations and business processes.

Question 17

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 
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 18

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

Accepted Answer

A)  Backward integration 
B)  Application integration 
C)  Data integration 
D)  Forward integration 
A)  Backward integration 
B)  Application integration 
C)  Data integration 
D)  Forward integration

Question 19

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following refers to the extent of detail within the information?

Accepted Answer

A)  Knowledge information 
B)  Information granularity 
C)  Chance information 
D)  Information analytics 
A)  Knowledge information 
B)  Information granularity 
C)  Chance information 
D)  Information analytics

Exam 6: Valuing and Storing Organizational Informationdatabases

Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

Which of the following systems allow users to create, read, update, and delete data in a relational database?

A data-driven website can help limit the amount of information displayed to customers based on unique search requirements.

Which of the following represent the four primary traits that help determine the value of information?

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

One of the advantages found in a relational database is increased information redundancy.

What is supply chain management (SCM)?

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.

What is the term for the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner?

Attributes (also called columns or fields) are the data elements associated with an entity.

Which of the following represents a reason for low-quality information?

What occurs when a system produces incorrect, inconsistent, or duplicate data?

What are the rules that enforce basic and fundamental information-based constraints?

A forward integration takes information entered into a given system and sends it automatically to all downstream systems and processes.

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

What are enterprise systems?

What is data gap analysis?

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

Databases offer many security features including passwords to provide authentication, access levels to determine who can access the data, and access controls to determine what type of access they have to the information.

Which of the following refers to the extent of detail within the information?

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