Question 1

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

Question 2

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 3

Velocity includes different forms of structured and unstructured data.

Accepted Answer

A) True 
 B)False

Question 4

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

Question 5

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

Question 6

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

Question 7

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 8

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 9

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

Question 10

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

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Question 14

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

Question 16

Data warehouses struggle with combining too much standardized information.

Accepted Answer

A) True 
 B)False

Question 17

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

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 6: Data: Business Intelligence

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

Which of the following are examples of transactional information?

Correct AnswerverifiedShow Answer

What is a foreign key?

Correct AnswerverifiedShow Answer

Velocity includes different forms of structured and unstructured data.

Correct AnswerverifiedShow Answer

What is classification?

Correct AnswerverifiedShow Answer

Which of the following occurs during data cleansing?

Correct AnswerverifiedShow Answer

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

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

Which of the following represents the different information granularities?

Correct AnswerverifiedShow Answer

What is a real-time system?

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

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

Correct AnswerverifiedShow Answer

What is optimization?

Correct AnswerverifiedShow 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 it called when each transaction, entity, and event is represented only once in the information?

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

How would the retail industry use business intelligence?

Correct AnswerverifiedShow Answer

Data warehouses struggle with combining too much standardized information.

Correct AnswerverifiedShow Answer

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

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

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified