Question 1

Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

Accepted Answer

A) True 
 B)False

Question 2

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Accepted Answer

A) True 
 B)False

Question 3

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

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 the above.E) A) and D)
F) B) and C)

Question 4

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Accepted Answer

A)  Data-driven website
B)  Interactive website
C)  Database performing website
D)  Data processing websiteE) A) and D)
F) B) and C)

Question 5

Which of the following provides real-time information in response to requests?

Accepted Answer

A)  Sales system
B)  Transactional system
C)  Real-time system
D)  Salary systemE) A) and C)
F) A) and D)

Question 6

Information granularity means immediate, up-to-date information.

Accepted Answer

A) True 
 B)False

Question 7

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

Question 8

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following forms of data mining assigns records to one of a predefined set of classes?

Accepted Answer

A)  Clustering
B)  Classification
C)  Estimation
D)  Affinity groupingE) A) and C)
F) None of the above

Question 10

Which of the following represents the different information levels?

Accepted Answer

A)  Detail, summary, aggregate
B)  Document, presentation, spreadsheet, database
C)  Individual, department, enterprise
D)  Executives, managers, operational employeesE) A) and C)
F) B) and C)

Question 11

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A)  Inaccurate data
B)  Misleading data
C)  Non-formatted data
D)  All of the aboveE) A) and C)
F) A) and B)

Question 13

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 the above.E) C) and D)
F) All of the above

Question 14

What is a content editor?

Accepted Answer

A)  The person responsible for creating the original website content.
B)  The person responsible for updating and maintaining website content.
C)  Includes fixed data incapable of change in the event of a user action.
D)  Includes data that change based on user action.E) A) and B)
F) B) and D)

Question 15

The four primary traits of the value of information include levels, formats, granularities, and type.

Accepted Answer

A) True 
 B)False

Question 16

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

Accepted Answer

A) True 
 B)False

Question 17

What type of keys do you need to use to create a relational database model?

Accepted Answer

A)  Primary keys and secondary keys
B)  Primary keys and foreign keys
C)  Entity keys and attribute keys
D)  Relational keys and DBMS keysE) B) and C)
F) B) and D)

Question 18

A foreign key provides details about data.

Accepted Answer

A) True 
 B)False

Question 19

What is classification?

Accepted Answer

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

Question 20

Information integrity are rules that help ensure the quality of information.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

What is classification?

Correct AnswerverifiedShow Answer

A foreign key provides details about data.

Correct AnswerverifiedShow Answer

Which of the following forms of data mining assigns records to one of a predefined set of classes?

Correct AnswerverifiedShow Answer

What type of website is an interactive website kept constantly updated and relevant to the needs of its customers using a database?

Correct AnswerverifiedShow Answer

Data models can include a customer's name, address, email, discount rate, preferred shipping method, product name, quantity ordered, and so on.

Correct AnswerverifiedShow Answer

How would the banking industry use business intelligence?

Correct AnswerverifiedShow Answer

What type of keys do you need to use to create a relational database model?

Correct AnswerverifiedShow Answer

What is a content editor?

Correct AnswerverifiedShow Answer

Metadata provides details about data. For example, metadata for an image could include its size, resolution, and date created.

Correct AnswerverifiedShow Answer

The four primary traits of the value of information include levels, formats, granularities, and type.

Correct AnswerverifiedShow Answer

Information cleansing or scrubbing is a process that weeds out and fixes or discards inconsistent, incorrect, or incomplete information.

Correct AnswerverifiedShow Answer

Which of the following provides real-time information in response to requests?

Correct AnswerverifiedShow Answer

Information integrity are rules that help ensure the quality of information.

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Data warehouses struggle with combining too much standardized information.

Correct AnswerverifiedShow Answer

Dirty data is erroneous or flawed data. The complete removal of dirty data from a source is impractical or virtually impossible.

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

Information granularity means immediate, up-to-date information.

Correct AnswerverifiedShow Answer

Which of the following represents the different information levels?

Correct AnswerverifiedShow Answer

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

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