Question 1

What is a collection of data from various sources for the purpose of data processing?

Accepted Answer

A)  Repository 
B)  Data warehouse 
C)  Data aggregation 
D)  Data broker 
A)  Repository 
B)  Data warehouse 
C)  Data aggregation 
D)  Data broker

Question 2

Identity management 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) True 
 B)False

Question 3

Define a data warehouse,and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection

Question 4

Which of the following encompasses all organizational information,and its primary purpose is to support the performing 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 5

A data broker is an individual item on a graph or a chart.

Accepted Answer

A) True 
 B)False

Question 6

What is a statistical process for estimating the relationships among variables?

Accepted Answer

A)  Prediction 
B)  Optimization 
C)  Forecasting 
D)  Regression 
A)  Prediction 
B)  Optimization 
C)  Forecasting 
D)  Regression

Question 7

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 8

What is a dynamic website?

Accepted Answer

A)  The person responsible for creating original website content 
B)  Includes data that changes 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 original website content 
B)  Includes data that changes 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 9

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Accepted Answer

A) True 
 B)False

Question 10

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 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,where as an attribute is not data at all but brainstorming ideas that take 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,where as an attribute is not data at all but brainstorming ideas that take 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

Affinity grouping determine which things go together.

Accepted Answer

A) True 
 B)False

Question 13

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Accepted Answer

A) True 
 B)False

Question 14

Businesses collect a tremendous amount of _____________ information as part of their routine operations.

Accepted Answer

A)  operational 
B)  transactional 
C)  aggregate 
D)  comparative 
A)  operational 
B)  transactional 
C)  aggregate 
D)  comparative

Question 15

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

Accepted Answer

A) True 
 B)False

Question 16

What is data mining?

Accepted Answer

A)  The common term for the representation of multidimensional information 
B)  A particular attribute of information 
C)  Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making 
D)  Process of analyzing data to extract information not offered by the raw data alone 
A)  The common term for the representation of multidimensional information 
B)  A particular attribute of information 
C)  Uses a variety of techniques to find patterns and relationships in large volumes of information and infer rules from them that predict future behavior and guide decision making 
D)  Process of analyzing data to extract information not offered by the raw data alone

Question 17

What is the application of Big Data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

Accepted Answer

A)  Fast data 
B)  Outlier 
C)  Analysis paralysis 
D)  Cube 
A)  Fast data 
B)  Outlier 
C)  Analysis paralysis 
D)  Cube

Question 18

Which of the following is a problem associated with dirty data?

Accepted Answer

A)  Inaccurate data 
B)  Nonintegrated data 
C)  Violates business rules 
D)  All of these choices 
A)  Inaccurate data 
B)  Nonintegrated data 
C)  Violates business rules 
D)  All of these choices

Question 19

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business is going?

Accepted Answer

A)  A historical perspective offers important variables for determining trends and patterns. 
B)  Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C)  Setting strategic direction is critical for planning and creating solid business strategies. 
D)  None of these choices 
A)  A historical perspective offers important variables for determining trends and patterns. 
B)  Looking at the current business situation allows managers to take effective action to solve issues before they grow out of control. 
C)  Setting strategic direction is critical for planning and creating solid business strategies. 
D)  None of these choices

Question 20

Speech analytics is heavily used in the customer service department to help improve processes by identifying angry customers and routing them to the appropriate customer service representative.

Accepted Answer

A) True 
 B)False

What is a collection of data from various sources for the purpose of data processing?

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

Define a data warehouse,and provide a few reasons it can make a manager more effective.

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

A data broker is an individual item on a graph or a chart.

What is a statistical process for estimating the relationships among variables?

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.

What is a dynamic website?

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

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

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

Affinity grouping determine which things go together.

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Businesses collect a tremendous amount of _____________ information as part of their routine operations.

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

What is data mining?

What is the application of Big Data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

Which of the following is a problem associated with dirty data?

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business is going?

Speech analytics is heavily used in the customer service department to help improve processes by identifying angry customers and routing them to the appropriate customer service representative.

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Understanding Computer Hardware and Software: From CPUs to Operating Systems

Understanding Telecommunication Systems and Network Topologies

Database Design and Entity Relationships

Filters

Exam 6: Data: Business Intelligence

What is a collection of data from various sources for the purpose of data processing?

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

Define a data warehouse,and provide a few reasons it can make a manager more effective.

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

A data broker is an individual item on a graph or a chart.

What is a statistical process for estimating the relationships among variables?

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.

What is a dynamic website?

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

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

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

Affinity grouping determine which things go together.

Determining if all total columns equal the true total of the individual item is an example of a consistent characteristic of high-quality information.

Businesses collect a tremendous amount of _____________ information as part of their routine operations.

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers using a database.

What is data mining?

What is the application of Big Data analytics to smaller data sets in near-real or real-time in order to solve a problem or create business value?

Which of the following is a problem associated with dirty data?

Managers can use BI to answer tough business questions.Which of the following describes the value of knowing where the business is going?

Speech analytics is heavily used in the customer service department to help improve processes by identifying angry customers and routing them to the appropriate customer service representative.

Management Information Systems: Business Driven MIS

Decisions Processes: Value Driven Business

Ebusiness: Electronic Business Value

Ethics Information Security: MIS Business Concerns

Infrastructures: Sustainable Technologies

Networks: Mobile Business

Enterprise Applications: Business Communications

Systems Development and Project Management: Corporate Responsibility

Understanding Computer Hardware and Software: From CPUs to Operating Systems

Understanding Telecommunication Systems and Network Topologies

Database Design and Entity Relationships

Filters