Question 1

Data validation helps to ensure that every data value is correct and accurate.In Microsoft Word,you can use data validation to control the type of data or the values that users enter into a cell.

Accepted Answer

A) True 
 B)False

Question 2

What is an individual item on a graph or a chart?

Accepted Answer

A)   Data set
B)   Dirty data
C)   Data map
D)   Data pointE) A) and B)
F) B) and D)

Question 3

How would the marketing industry use business intelligence?

Accepted Answer

A)   Track crime patterns,locations,and criminal behavior
B)   Analyze customer demographics
C)   Predict sales,inventory levels,and distribution
D)   Predict hardware failuresE) None of the above
F) C) and D)

Question 4

Association detection reveals the relationship between variables along with the nature and frequency of the relationship.

Accepted Answer

A) True 
 B)False

Question 5

Real-time information refers to the extent of detail within the information (fine and detailed,or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 6

Real-time systems provide real-time information in response to requests.

Accepted Answer

A) True 
 B)False

Question 7

In terms of Big Data,what includes the scale of data?

Accepted Answer

A)   Variety
B)   Veracity
C)   Volume
D)   VelocityE) All of the above
F) A) and B)

Question 8

What is Web analytics?

Accepted Answer

A)   Unstructured data associated with websites to identify consumer behavior and website navigation
B)   Analyzes structured data associated with a website
C)   Filters information,both structured and unstructured,to help identify strong Web customers
D)   None of these choicesE) All of the above
F) A) and C)

Question 9

What is a business that collects personal information about consumers and sells that information to other organizations?

Accepted Answer

A)   Repository
B)   Data warehouse
C)   Data aggregation
D)   Data brokerE) B) and C)
F) All of the above

Question 10

Which of the following is the common term for the representation of multidimensional information?

Accepted Answer

A)   Block
B)   Square
C)   Column
D)   CubeE) A) and D)
F) B) and D)

Question 11

In a data warehouse,information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Accepted Answer

A) True 
 B)False

Question 12

What 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)   Information inconsistency
B)   Information integrity issues
C)   Data governance
D)   Master data managementE) A) and B)
F) All of the above

Question 13

Which of the below reveals the relationship between variables along with the nature and frequency of the relationship?

Accepted Answer

A)   Association detection
B)   Masking detection tool
C)   Cluster grouping
D)   Blocking barriersE) B) and C)
F) A) and D)

Question 14

What is estimation?

Accepted Answer

A)   Determines values for an unknown continuous variable behavior or estimated future value
B)   Determines which things go together
C)   Segments a heterogeneous population of more homogeneous subgroups
D)   Assigns records to one of a predefined set of classesE) All of the above
F) B) and C)

Question 15

Prediction is a statistical process that finds the way to make a design,system,or decision as effective as possible,for example,finding the values of controllable variables that determine maximal productivity or minimal waste.

Accepted Answer

A) True 
 B)False

Question 16

How would the health care industry use business intelligence?

Accepted Answer

A)   Analyze popular vacation locations with current flight listings
B)   Understand customer credit card usage and nonpayment rates
C)   Compare the demographics of patients with critical illnesses
D)   Predict claim amounts and medical coverage costsE) B) and C)
F) A) and D)

Question 17

What is a data lake?

Accepted Answer

A)   A business that collects personal information about consumers and sells that information to other organizations
B)   A storage repository that holds a vast amount of raw data in its original format until the business needs it
C)  	A technique for establishing a match, or balance, between the source data and the target data warehouse
D)   	An approach to business governance that values decisions that can be backed up with verifiable dataA data lake is a storage repository that holds a vast amount of raw data in its original format until the business needs it.E) A) and C)
F) B) and C)

Question 18

What segments a heterogeneous population of more homogeneous subgroups?

Accepted Answer

A)   Classification
B)   Estimation
C)   Affinity grouping
D)   ClusteringE) A) and B)
F) A) and C)

Question 19

A comparative analysis can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 20

What is Big Data?

Accepted Answer

A)   A collection of large,complex data sets,including structured and unstructured data,which can't be analyzed using traditional database methods and tools
B)   Processes and manages algorithms across many machines in a computing environment
C)   Focuses on forecasting future trends and producing insights using sophisticated quantitative methods,including statistics,descriptive and predictive data mining,simulation,and optimization
D)   Extracts knowledge from data by performing statistical analysis,data mining,and advanced analytics on Big Data to identify trends,market changes,and other relevant informationE) A) and D)
F) None of the above

Exam 6: Data: Business Intelligence

What is Web analytics?

Correct AnswerverifiedShow Answer

Which of the below reveals the relationship between variables along with the nature and frequency of the relationship?

Correct AnswerverifiedShow Answer

How would the health care industry use business intelligence?

Correct AnswerverifiedShow Answer

A comparative analysis can compare two or more data sets to identify patterns and trends.

Correct AnswerverifiedShow Answer

What is estimation?

Correct AnswerverifiedShow Answer

In a data warehouse,information cleansing occurs first during the ETL process and again once the information is in the data warehouse.

Correct AnswerverifiedShow Answer

What 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

In terms of Big Data,what includes the scale of data?

Correct AnswerverifiedShow Answer

What is Big Data?

Correct AnswerverifiedShow Answer

What is a data lake?

Correct AnswerverifiedShow Answer

What is a business that collects personal information about consumers and sells that information to other organizations?

Correct AnswerverifiedShow Answer

Which of the following is the common term for the representation of multidimensional information?

Correct AnswerverifiedShow Answer

What is an individual item on a graph or a chart?

Correct AnswerverifiedShow Answer

Data validation helps to ensure that every data value is correct and accurate.In Microsoft Word,you can use data validation to control the type of data or the values that users enter into a cell.

Correct AnswerverifiedShow Answer

Real-time information refers to the extent of detail within the information (fine and detailed,or coarse and abstract).

Correct AnswerverifiedShow Answer

What segments a heterogeneous population of more homogeneous subgroups?

Correct AnswerverifiedShow Answer

Prediction is a statistical process that finds the way to make a design,system,or decision as effective as possible,for example,finding the values of controllable variables that determine maximal productivity or minimal waste.

Correct AnswerverifiedShow Answer

Association detection reveals the relationship between variables along with the nature and frequency of the relationship.

Correct AnswerverifiedShow Answer

Real-time systems provide real-time information in response to requests.

Correct AnswerverifiedShow Answer

How would the marketing industry use business intelligence?

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified