Question 1

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

Question 2

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 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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 6

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 7

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 8

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

Question 9

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

Question 10

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

Question 11

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

Question 12

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 13

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

Question 14

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

Question 15

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

Question 16

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

Accepted Answer

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

Question 17

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

Question 18

Affinity grouping determine which things go together.

Accepted Answer

A) True 
 B)False

Question 19

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.

Question 20

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

Exam 6: Data: Business Intelligence

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Affinity grouping determine which things go together.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is data mining?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

What is a dynamic website?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA data warehouse is a logical collection...View AnswerShow Answer

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.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data warehouse is a logical collection...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified