Question 1

What is a dynamic 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.E) A) and D)
F) C) and D)

Question 2

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 3

What is the overall management of the availability, usability, integrity, and security of company data?

Accepted Answer

A)  Data Intelligence
B)  Data governance
C)  Data forbearance
D)  Data forecastingE) A) and B)
F) A) and C)

Question 4

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 aloneE) None of the above
F) B) and C)

Question 5

What are predictions based on time-series information?

Accepted Answer

A)  Prediction
B)  Optimization
C)  Forecasting
D)  RegressionE) A) and B)
F) A) and C)

Question 6

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Accepted Answer

A) True 
 B)False

Question 7

What is the primary problem with redundant information?

Accepted Answer

A)  It is difficult to determine which values are the most current
B)  It is often inconsistent
C)  It is difficult to determine which values are the most accurate
D)  All of the aboveE) A) and D)
F) B) and D)

Question 8

What is an example of using cluster analysis in business to create target-marketing strategies?

Accepted Answer

A)  Google search
B)  First name information
C)  Zip code segmentation
D)  Last name associationsE) All of the above
F) A) and B)

Question 9

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is a disadvantage of database-stored information?

Accepted Answer

A)  Increased flexibility
B)  Increased performance
C)  Increased information redundancy
D)  Increased information integrityE) A) and B)
F) None of the above

Question 11

Which of the following describes ETL?

Accepted Answer

A)  A process that extracts information from internal and external databases
B)  A process that transforms information using a common set of enterprise definitions
C)  A process that loads information into a data warehouse
D)  All of the aboveE) B) and D)
F) A) and D)

Question 12

What is master data management?

Accepted Answer

A)  The time it takes for data to be stored or retrieved.
B)  The practice of gathering data and ensuring that it is uniform, accurate, consistent, and complete.
C)  The tests and evaluations used to determine compliance with data governance policies to ensure correctness of data.
D)  When a company examines its data to determine if it can meet business expectations, while identifying possible data gaps.E) A) and D)
F) A) and C)

Question 13

Which of the following represent the four primary traits that help determine the value of information?

Accepted Answer

A)  Information type, information timeliness, information quality, and information governance
B)  Information statistics, information tracking, information quality, and information governance
C)  Information type, information chance, information analytics, and information policy
D)  Information timeliness, information quality, information quantity, and information governance policyE) A) and D)
F) C) and D)

Question 14

The financial industry uses business intelligence to predict hardware failures.

Accepted Answer

A) True 
 B)False

Question 15

What is erroneous or flawed data?

Accepted Answer

A)  Data set.
B)  Dirty data.
C)  Data map.
D)  Data point.E) B) and D)
F) B) and C)

Question 16

Estimation determines which things go together.

Accepted Answer

A) True 
 B)False

Question 17

A primary key is the smallest or basic unit of information.

Accepted Answer

A) True 
 B)False

Question 18

What is a business analytics specialist who uses visual tools to help people understand complex data?

Accepted Answer

A)  Distributed computing
B)  Advanced analytics
C)  Analysis paralysis
D)  Data artistE) B) and C)
F) All of the above

Question 19

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)  QualityE) A) and B)
F) B) and C)

Question 20

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) A) and B)
F) None of the above

Exam 6: Data: Business Intelligence

Which of the following represent the four primary traits that help determine the value of information?

Correct AnswerverifiedShow Answer

What is a dynamic website?

Correct AnswerverifiedShow Answer

What is data mining?

Correct AnswerverifiedShow Answer

The financial industry uses business intelligence to predict hardware failures.

Correct AnswerverifiedShow Answer

A data mart is the process of analyzing data to extract information not offered by the raw data alone.

Correct AnswerverifiedShow Answer

What is master data management?

Correct AnswerverifiedShow Answer

A primary key is the smallest or basic unit of information.

Correct AnswerverifiedShow Answer

What is erroneous or flawed data?

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

What is a business analytics specialist who uses visual tools to help people understand complex data?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What are predictions based on time-series information?

Correct AnswerverifiedShow Answer

Transactional information is used when performing operational tasks and repetitive decisions such as analyzing daily sales reports and production schedules to determine how much inventory to carry.

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 the overall management of the availability, usability, integrity, and security of company data?

Correct AnswerverifiedShow Answer

Estimation determines which things go together.

Correct AnswerverifiedShow Answer

Which of the following is a disadvantage of database-stored information?

Correct AnswerverifiedShow Answer

What is an example of using cluster analysis in business to create target-marketing strategies?

Correct AnswerverifiedShow Answer

Which of the following describes ETL?

Correct AnswerverifiedShow Answer

What is the primary problem with redundant information?

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