Question 1

What is optimization?

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

Question 2

Which of the following is a business-critical integrity constraint?

Accepted Answer

A)  System will not allow an entry for an order for a nonexistent customer.
B)  System will not allow returns of fresh produce after 15 days past delivery.
C)  System will not allow shipping a product to a customer who does not have a valid address.
D)  system will not allow shipping of a nonexistent product to a customer.

Question 3

Which of the following represents the different information granularities?

Accepted Answer

A)  detail, summary, aggregate
B)  document, presentation, spreadsheet, database
C)  individual, department, enterprise
D)  executives, managers, operational employees

Question 4

Define a data warehouse, and provide a few reasons it can make a manager more effective.

Accepted Answer

A data warehouse is a logical collection...

Question 5

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Accepted Answer

A) True 
 B)False

Question 6

What is it called when each transaction, entity, and event is represented only once in the information?

Accepted Answer

A)  uniqueness
B)  accuracy
C)  consistency
D)  timeliness

Question 7

Which of the following occurs during data cleansing?

Accepted Answer

A)  clean missing records
B)  clean redundant records
C)  clean inaccurate data
D)  All of these are correct.

Question 8

Human-generated unstructured data includes text messages, social media data, and emails.

Accepted Answer

A) True 
 B)False

Question 9

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Accepted Answer

A) True 
 B)False

Question 10

A 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 11

How would the retail 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 failures

Question 12

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 13

What is classification?

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

Question 14

Machine-generated data is data that humans, in interaction with computers, generate.Human-generated structured data includes input data, click-stream data, or gaming data.

Accepted Answer

A) True 
 B)False

Question 15

What is a foreign key?

Accepted Answer

A)  a field (or group of fields)  that uniquely identifies a given entity in a table
B)  a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables
C)  characteristics or properties of an entity
D)  a field (or group of fields)  that uniquely identifies a given attribute in a table

Question 16

Big data is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools.

Accepted Answer

A) True 
 B)False

Question 17

Velocity includes the analysis of streaming data as it travels around the Internet.

Accepted Answer

A) True 
 B)False

Question 18

Velocity includes different forms of structured and unstructured data.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following are examples of transactional information?

Accepted Answer

A)  airline ticket, sales receipts, and packing slips
B)  trends and sales statistics
C)  product sales results, grocery receipts, and growth projections
D)  airline tickets and sales growth spreadsheets

Question 20

What is a real-time system?

Accepted Answer

A)  provides immediate, up-to-date information
B)  provides real-time information in response to query requests
C)  encompasses all organization information, and its primary purpose is to support the performing of managerial analysis tasks
D)  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

Exam 6: Data: Business Intelligence

What is optimization?

Correct AnswerverifiedShow Answer

A 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

Relational integrity constraints are rules that enforce basic and fundamental information-based constraints.

Correct AnswerverifiedShow Answer

Which of the following is a business-critical integrity constraint?

Correct AnswerverifiedShow Answer

What is it called when each transaction, entity, and event is represented only once in the information?

Correct AnswerverifiedShow Answer

Data warehouses struggle with combining too much standardized information.

Correct AnswerverifiedShow Answer

Big data is a collection of large, complex data sets, including structured and unstructured data, which cannot be analyzed using traditional database methods and tools.

Correct AnswerverifiedShow Answer

Which of the following represents the different information granularities?

Correct AnswerverifiedShow Answer

Human-generated unstructured data includes text messages, social media data, and emails.

Correct AnswerverifiedShow Answer

Which of the following are examples of transactional information?

Correct AnswerverifiedShow Answer

Business critical integrity constraints enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.

Correct AnswerverifiedShow Answer

What is a foreign key?

Correct AnswerverifiedShow Answer

How would the retail industry use business intelligence?

Correct AnswerverifiedShow Answer

Define a data warehouse, and provide a few reasons it can make a manager more effective.

Correct AnswerverifiedA data warehouse is a logical collection...View AnswerShow Answer

Machine-generated data is data that humans, in interaction with computers, generate.Human-generated structured data includes input data, click-stream data, or gaming data.

Correct AnswerverifiedShow Answer

What is classification?

Correct AnswerverifiedShow Answer

Velocity includes the analysis of streaming data as it travels around the Internet.

Correct AnswerverifiedShow Answer

Which of the following occurs during data cleansing?

Correct AnswerverifiedShow Answer

Velocity includes different forms of structured and unstructured data.

Correct AnswerverifiedShow Answer

What is a real-time system?

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
A data warehouse is a logical collection...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified