Question 1

What is a central location in which data is stored and managed?

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Within the data warehouse model,the external databases could include competitor information,industry information and stock market analysis.

Accepted Answer

A) True 
 B)False

Question 4

What is affinity grouping?

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

Question 5

What assigns records to one of a predefined set of classes?

Accepted Answer

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

Question 6

What analyzes unstructured data to find trends and patterns in words and sentences?

Accepted Answer

A)   Structured data
B)   Unstructured data
C)   Text analytics
D)   Web analyticsE) None of the above
F) A) and B)

Question 7

What is a technique for establishing a match,or balance,between the source data and the target data warehouse?

Accepted Answer

A)   Data set
B)   Dirty data
C)   Data map
D)   Data pointE) All of the above
F) A) and D)

Question 8

What are the rules that help ensure the quality of information?

Accepted Answer

A)   Information integrity
B)   Integrity constraints
C)   Relational integrity constraints
D)   Business-critical integrity constraintsE) None of the above
F) All of the above

Question 9

How would the airline 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) C) and D)
F) B) and C)

Question 10

What is source data?

Accepted Answer

A)   Identifies the primary location where data is collected
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 dataSource data identifies the primary location where data is collected.E) A) and B)
F) A) and C)

Question 11

What is fast data?

Accepted Answer

A)   Processes and manages algorithms across many machines in a computing environment
B)   A data value that is numerically distant from most of the other data points in a set of data
C)   Occurs when the user goes into an emotional state of over-analysis (or over-thinking) a situation so that a decision or action is never taken,in effect paralyzing the outcome
D)   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 valueE) A) and B)
F) A) and D)

Question 12

What is prediction?

Accepted Answer

A)   A statement about what will happen or might happen in the future,for example,predicting future sales or employee turnover
B)   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
C)   Predictions based on time-series information
D)   A statistical process for estimating the relationships among variablesE) B) and D)
F) A) and B)

Question 13

Relational databases offer many advantages over using a text document or a spreadsheet,which include decreased flexibility and decreased scalability and performance.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which of the following occurs during data cleansing?

Accepted Answer

A)   Clean data marts
B)   Clean redundant customer data
C)   Clean accurate data
D)   Clean correct dataE) None of the above
F) All of the above

Question 16

Social media analytics analyzes text flowing across the Internet,including unstructured text from blogs and messages.

Accepted Answer

A) True 
 B)False

Question 17

Why do relational databases use primary keys and foreign keys?

Accepted Answer

A)   To create an entity
B)   To create physical relationships
C)   To create logical relationships
D)   To create an attributeE) None of the above
F) C) and D)

Question 18

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Accepted Answer

A) True 
 B)False

Question 19

Web analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Accepted Answer

A) True 
 B)False

Question 20

A foreign key is a field (or group of fields)that uniquely identifies a given entity in a table.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

What is a central location in which data is stored and managed?

Correct AnswerverifiedShow Answer

Why do relational databases use primary keys and foreign keys?

Correct AnswerverifiedShow Answer

What is fast data?

Correct AnswerverifiedShow Answer

What is a technique for establishing a match,or balance,between the source data and the target data warehouse?

Correct AnswerverifiedShow Answer

What is affinity grouping?

Correct AnswerverifiedShow Answer

Web analytics analyzes unstructured data associated with websites to identify consumer behavior and website navigation.

Correct AnswerverifiedShow Answer

Within the data warehouse model,the external databases could include competitor information,industry information and stock market analysis.

Correct AnswerverifiedShow Answer

What analyzes unstructured data to find trends and patterns in words and sentences?

Correct AnswerverifiedShow Answer

Social media analytics analyzes text flowing across the Internet,including unstructured text from blogs and messages.

Correct AnswerverifiedShow Answer

What assigns records to one of a predefined set of classes?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is prediction?

Correct AnswerverifiedShow Answer

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Correct AnswerverifiedShow Answer

What are the rules that help ensure the quality of information?

Correct AnswerverifiedShow Answer

What is source data?

Correct AnswerverifiedShow Answer

Which of the following occurs during data cleansing?

Correct AnswerverifiedShow Answer

How would the airline industry use business intelligence?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

A foreign key is a field (or group of fields)that uniquely identifies a given entity in a table.

Correct AnswerverifiedShow Answer

Relational databases offer many advantages over using a text document or a spreadsheet,which include decreased flexibility and decreased scalability and performance.

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