Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

Identify the business advantages of a relational database.

Accepted Answer

Many business managers are familiar with

Question 3

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Accepted Answer

A)  Database element 
B)  Database management system 
C)  Data governance 
D)  Data file 
A)  Database element 
B)  Database management system 
C)  Data governance 
D)  Data file

Question 4

What is a backward integration?

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)  Sending information entered into a given system automatically to all downstream systems and processes 
D)  Sending information entered into a given system automatically to all upstream systems and 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)  Sending information entered into a given system automatically to all downstream systems and processes 
D)  Sending information entered into a given system automatically to all upstream systems and processes

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Unique information asks if the information is current with respect to the business needs.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following encompasses all organizational information with the primary purpose of supporting the performance of managerial analysis tasks?

Accepted Answer

A)  Analytical information 
B)  Transactional information 
C)  Statistical information 
D)  Targeted information 
A)  Analytical information 
B)  Transactional information 
C)  Statistical information 
D)  Targeted information

Question 8

Integrations allow separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a record?

Accepted Answer

A)  Entity 
B)  Extraction 
C)  Attribute 
D)  Foreign key 
A)  Entity 
B)  Extraction 
C)  Attribute 
D)  Foreign key

Question 10

Foreign key is a primary 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 11

Application integration is the integration of data from multiple sources, which provides a unified view of all data.

Accepted Answer

A) True 
 B)False

Question 12

Timely information asks if the information is current with respect to the business needs.

Accepted Answer

A) True 
 B)False

Question 13

What is a foreign key?

Accepted Answer

A)  A field (or group of fields) that uniquely identifies a given entity 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 entity 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 14

Which of the following is correct in reference to a database?

Accepted Answer

A)  A database can support only one logical view 
B)  A database can support many physical views 
C)  A database can support many logical views 
D)  A database can support up to 3 logical views 
A)  A database can support only one logical view 
B)  A database can support many physical views 
C)  A database can support many logical views 
D)  A database can support up to 3 logical views

Question 15

Data element (or data field) is the smallest, or basic, unit of information.

Accepted Answer

A) True 
 B)False

Question 16

What is a data steward responsible for?

Accepted Answer

A)  Acting as a liaison between the MIS department and the business 
B)  Ensuring policies and procedures are implemented across the organization 
C)  Acting as a liaison between the MIS department and the business and ensuring policies and procedures are implemented across the organization 
D)  None of these 
A)  Acting as a liaison between the MIS department and the business 
B)  Ensuring policies and procedures are implemented across the organization 
C)  Acting as a liaison between the MIS department and the business and ensuring policies and procedures are implemented across the organization 
D)  None of these

Question 17

What is immediate, up-to-date information?

Accepted Answer

A)  Real-time information 
B)  Real-time systems 
C)  Information granularity 
D)  Information governance 
A)  Real-time information 
B)  Real-time systems 
C)  Information granularity 
D)  Information governance

Question 18

What is the term for the time it takes for data to be stored or retrieved?

Accepted Answer

A)  Data governance 
B)  Data latency 
C)  Data validation 
D)  Data gap analysis 
A)  Data governance 
B)  Data latency 
C)  Data validation 
D)  Data gap analysis

Question 19

What is a data-driven website?

Accepted Answer

A)  The person responsible for creating the original website content 
B)  Includes data that change based on user action 
C)  Information is stored in a dynamic catalog, or an area of a website that stores information about products in a database 
D)  An interactive website kept constantly updated and relevant to the needs of its customers using a database 
A)  The person responsible for creating the original website content 
B)  Includes data that change based on user action 
C)  Information is stored in a dynamic catalog, or an area of a website that stores information about products in a database 
D)  An interactive website kept constantly updated and relevant to the needs of its customers using a database

Question 20

Data dictionary compiles all of the metadata about the data elements in the data model.

Accepted Answer

A) True 
 B)False

Exam 6: Valuing and Storing Organizational Informationdatabases

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

Identify the business advantages of a relational database.

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

What is a backward integration?

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

Unique information asks if the information is current with respect to the business needs.

Which of the following encompasses all organizational information with the primary purpose of supporting the performance of managerial analysis tasks?

Integrations allow separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems.

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a record?

Foreign key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Application integration is the integration of data from multiple sources, which provides a unified view of all data.

Timely information asks if the information is current with respect to the business needs.

What is a foreign key?

Which of the following is correct in reference to a database?

Data element (or data field) is the smallest, or basic, unit of information.

What is a data steward responsible for?

What is immediate, up-to-date information?

What is the term for the time it takes for data to be stored or retrieved?

What is a data-driven website?

Data dictionary compiles all of the metadata about the data elements in the data model.

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