Question 1

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

Accepted Answer

A) True 
 B)False

Question 2

What is regression?

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

Question 3

What is the ultimate outcome of a data warehouse?

Accepted Answer

A)  data goals
B)  data relationships
C)  data marketing
D)  data martsE) C) and D)
F) A) and B)

Question 4

What occurs when a system produces incorrect, inconsistent, or duplicate data?

Accepted Answer

A)  information inconsistency
B)  information integrity issues
C)  data governance
D)  master data managementE) A) and B)
F) A) and C)

Question 5

The physical view of information deals with the physical storage of information on a storage device.

Accepted Answer

A) True 
 B)False

Question 6

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Accepted Answer

A) True 
 B)False

Question 7

Dynamic information includes data that change based on user actions.

Accepted Answer

A) True 
 B)False

Question 8

Affinity determines values for an unknown continuous variable behavior or estimated future value.

Accepted Answer

A) True 
 B)False

Question 9

What is advanced analytics?

Accepted Answer

A)  a collection of large, complex data sets, including structured and unstructured data, which cannot 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) All of the above
F) C) and D)

Question 10

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

Question 11

Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

Accepted Answer

A)  improvements
B)  change
C)  clustering
D)  cleansingE) A) and C)
F) B) and C)

Question 12

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

Question 13

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Accepted Answer

A) True 
 B)False

Question 14

Which of the choices below does not represent an organization that requires up-to-the-second information?

Accepted Answer

A)  911 response center
B)  stock traders
C)  banks
D)  construction companiesE) C) and D)
F) None of the above

Question 15

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

Question 16

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Accepted Answer

A)  business intelligence system
B)  informational database system
C)  relational database management system
D)  data mining systemE) B) and C)
F) C) and D)

Question 17

Machine-generated data is created by a machine without human intervention.Machine-generated structured data includes sensor data, point-of-sale data, and web log (blog) data.

Accepted Answer

A) True 
 B)False

Question 18

What segments a heterogeneous population of more homogeneous subgroups?

Accepted Answer

A)  classification
B)  estimation
C)  affinity grouping
D)  clusteringE) B) and D)
F) A) and C)

Question 19

Which of the following is an example of an external databases in the data warehouse model?

Accepted Answer

A)  marketing information
B)  sales information
C)  competitor information
D)  All of these are correct.E) B) and D)
F) B) and C)

Question 20

Human-generated data is created by a machine without human intervention.Machine-generated structured data includes sensor data, point-of-sale data, and web log (blog) data.

Accepted Answer

A) True 
 B)False

Exam 6: Data: Business Intelligence

Which of the following systems allow users to create, read, update, and delete data in a relational database?

Correct AnswerverifiedShow Answer

How would the technology industry use business intelligence?

Correct AnswerverifiedShow Answer

A business catalog defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Correct AnswerverifiedShow Answer

Dynamic information includes data that change based on user actions.

Correct AnswerverifiedShow Answer

What segments a heterogeneous population of more homogeneous subgroups?

Correct AnswerverifiedShow Answer

Machine-generated data is created by a machine without human intervention.Machine-generated structured data includes sensor data, point-of-sale data, and web log (blog) data.

Correct AnswerverifiedShow Answer

The physical view of information deals with the physical storage of information on a storage device.

Correct AnswerverifiedShow Answer

Which of the choices below does not represent an organization that requires up-to-the-second information?

Correct AnswerverifiedShow Answer

What is a content editor?

Correct AnswerverifiedShow Answer

Metadata are logical data structures that detail the relationships among data elements by using graphics or pictures.

Correct AnswerverifiedShow Answer

Affinity determines values for an unknown continuous variable behavior or estimated future value.

Correct AnswerverifiedShow Answer

Which of the following is an example of an external databases in the data warehouse model?

Correct AnswerverifiedShow Answer

Most people request real-time information without understanding that continual ________ is one of its biggest pitfalls.

Correct AnswerverifiedShow Answer

What is advanced analytics?

Correct AnswerverifiedShow Answer

The banking industry uses business intelligence to understand customer credit card usage and nonpayment rates.

Correct AnswerverifiedShow Answer

Human-generated data is created by a machine without human intervention.Machine-generated structured data includes sensor data, point-of-sale data, and web log (blog) data.

Correct AnswerverifiedShow Answer

What occurs when a system produces incorrect, inconsistent, or duplicate data?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is regression?

Correct AnswerverifiedShow Answer

What is the ultimate outcome of a data warehouse?

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