Question 1

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 data
Source data identifies the primary location where data is collected. 
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 data
Source data identifies the primary location where data is collected.

Question 2

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 costs 
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 costs

Question 3

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 variables 
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 variables

Question 4

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

Question 5

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 constraints 
A)  Information integrity 
B)  Integrity constraints 
C)  Relational integrity constraints 
D)  Business-critical integrity constraints

Question 6

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 classes 
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 classes

Question 7

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 attribute 
A)  To create an entity 
B)  To create physical relationships 
C)  To create logical relationships 
D)  To create an attribute

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 point 
A)  Data set 
B)  Dirty data 
C)  Data map 
D)  Data point

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

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

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 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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 analytics 
A)  Structured data 
B)  Unstructured data 
C)  Text analytics 
D)  Web analytics

Question 17

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 value 
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 value

Question 18

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

Accepted Answer

A)  Classification 
B)  Estimation 
C)  Affinity grouping 
D)  Clustering 
A)  Classification 
B)  Estimation 
C)  Affinity grouping 
D)  Clustering

Question 19

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 data 
A)  Clean data marts 
B)  Clean redundant customer data 
C)  Clean accurate data 
D)  Clean correct data

Question 20

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

Accepted Answer

A) True 
 B)False

What is source data?

How would the airline industry use business intelligence?

What is prediction?

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

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

What is affinity grouping?

Why do relational databases use primary keys and foreign keys?

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

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

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

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

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.

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

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

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

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

What is fast data?

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

Which of the following occurs during data cleansing?

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

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 source data?

How would the airline industry use business intelligence?

What is prediction?

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

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

What is affinity grouping?

Why do relational databases use primary keys and foreign keys?

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

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

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

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

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.

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

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

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

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

What is fast data?

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

Which of the following occurs during data cleansing?

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

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