Question 1

Which of the following asks users to write lines of code to answer questions against a database?

Accepted Answer

A) Structured query language 
B) Relational query language 
C) Structured elements 
D) Data mining tools 
A) Structured query language 
B) Relational query language 
C) Structured elements 
D) Data mining tools

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Which of the following would not be considered part of the complete characteristic of high-quality information?

Accepted Answer

A) Is a value missing from the personal information? 
B) Is each transaction represented only once in the information? 
C) Is the address incomplete? 
D) Is the area code missing for the phone information? 
A) Is a value missing from the personal information? 
B) Is each transaction represented only once in the information? 
C) Is the address incomplete? 
D) Is the area code missing for the phone information?

Question 4

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 
A) Increased information quality 
B) Increased flexibility 
C) Decreased information redundancy 
D) Decreased information security

Question 5

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

Accepted Answer

A) Forward integration 
B) Forward data interchange 
C) Backward integration 
D) Backward data interchange 
A) Forward integration 
B) Forward data interchange 
C) Backward integration 
D) Backward data interchange

Question 6

What is a data steward?

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

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Accepted Answer

A) True 
 B)False

Question 8

A foreign key uniquely identifies a given record in a table.

Accepted Answer

A) True 
 B)False

Question 9

Structured query language compiles all of the metadata about the data elements in the data model.

Accepted Answer

A) True 
 B)False

Question 10

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

Accepted Answer

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

Question 11

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

Accepted Answer

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

Question 12

What are rules that help ensure the quality of information?

Accepted Answer

A) Information integrity 
B) Integrity constraints 
C) Information quality 
D) Information ethics 
A) Information integrity 
B) Integrity constraints 
C) Information quality 
D) Information ethics

Question 13

What is an interactive website kept constantly updated and relevant to the needs of its customers using 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

Question 14

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 15

Organizational information comes at the same level, formats, and granularities.

Accepted Answer

A) True 
 B)False

Question 16

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 17

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 18

Static information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Question 19

Dynamic information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 6: Valuing and Storing Organizational Information Databases

Which of the following asks users to write lines of code to answer questions against a database?

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

Which of the following would not be considered part of the complete characteristic of high-quality information?

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

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

What is a data steward?

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

A foreign key uniquely identifies a given record in a table.

Structured query language compiles all of the metadata about the data elements in the data model.

What encompasses all of the information contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasks?

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

What are rules that help ensure the quality of information?

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

Which of the following represents the different information levels?

Organizational information comes at the same level, formats, and granularities.

Relational integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

A foreign key provides details about data.

Static information includes data that change based on user actions.

Dynamic information includes data that change based on user actions.

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

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 Information Data Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End to End Enterprise Resource Planning

Creating Innovative Organizations

E-business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

B: Extension: A Business Basics

B: Extension: A Business Process

B: Extension: A Hardware and Software Basics

B: Extension: A Mis Infrastructures

B: Extension: A Networks and Telecommunications

B: Extension: A Information Security

B: Extension: A Ethics

B: Extension: A Operations Management

B: Extension: A Sustainable Mis Infrastructures

B: Extension: A Business Intelligence

B: Extension: A Global Information Systems

B: Extension: A Global Trends

Filters