Question 1

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Accepted Answer

A)  relational integrity constraint
B)  business-critical integrity constraint
C)  information-critical integrity constraint
D)  mission-critical integrity constraintE) A) and B)
F) A) and C)

Question 2

Which of the following is a valid type of integrity constraint?

Accepted Answer

A)  relational-critical integrity constraint
B)  business integrity constraint
C)  relational integrity constraint
D)  business-critical integrity constraintE) A) and B)
F) A) and C)

Question 3

What includes fixed data incapable of change in the event of a user action?

Accepted Answer

A)  content creator
B)  content editor
C)  static information
D)  dynamic informationE) All of the above
F) C) and D)

Question 4

Advanced analytics focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following statements is true?

Accepted Answer

A)  The more complete an organization wants to get its information, the less it costs.
B)  The more accurate an organization wants to get its information, the less it costs.
C)  The less accurate an organization wants to get its information, the more it costs.
D)  The more complete and accurate an organization wants to get its information, the more it costs.E) B) and D)
F) All of the above

Question 6

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Accepted Answer

A)  data mining tools
B)  structured example language
C)  query-by-example tool
D)  relational query toolE) A) and C)
F) None of the above

Question 7

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

Accepted Answer

A)  information inconsistency issue
B)  information integrity issue
C)  data control issue
D)  data mining issueE) None of the above
F) A) and B)

Question 8

Classification assigns records to one of a predefined set of classes.

Accepted Answer

A) True 
 B)False

Question 9

What is distributed computing?

Accepted Answer

A)  processes and manages algorithms across many machines in a computing environment
B)  focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization
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)  a business analytics specialist who uses visual tools to help people understand complex dataE) None of the above
F) B) and C)

Question 10

Static information includes fixed data incapable of change in the event of a user action.

Accepted Answer

A) True 
 B)False

Question 11

What is big data?

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

Question 12

Which of the following would not be considered part of the unique characteristic of high-quality information?

Accepted Answer

A)  Are there any duplicate orders?
B)  Are there any duplicate customers?
C)  Is aggregate information in agreement with detailed information?
D)  Is each transaction and event represented only once in the information?E) A) and C)
F) None of the above

Question 13

Unique information asks if each transaction and event is represented only once in the information.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following illustrates the primary concepts of the relational database model?

Accepted Answer

A)  ethics, applications, keys, and relationships
B)  entities, attributes, keys, and relationships
C)  endeavor, aspire, control, and regulate
D)  early, after, before, and futureE) B) and D)
F) None of the above

Question 15

What analyzes unstructured data associated with websites to identify consumer behavior and website navigation?

Accepted Answer

A)  social media analytics
B)  speech analytics
C)  text analytics
D)  web analyticsE) A) and C)
F) B) and C)

Question 16

Which of the following is incorrect in terms of data warehousing and business intelligence?

Accepted Answer

A)  does not include information from other operational applications
B)  operational systems are integrated
C)  operational information is mainly current
D)  operational information frequently has quality issuesE) A) and D)
F) All of the above

Question 17

What are the rules that enforce basic and fundamental information-based constraints?

Accepted Answer

A)  responsible integrity constraints
B)  quality constraints
C)  web integrity constraints
D)  relational integrity constraintsE) A) and D)
F) All of the above

Question 18

Identify the business advantages of a relational database.

Accepted Answer

Many business managers are familiar with...

Question 19

Distributed computing processes and manages algorithms across many machines in a computing environment.

Accepted Answer

A) True 
 B)False

Question 20

Identify the advantages of using business intelligence to support managerial decision making.

Accepted Answer

Many organizations today find it next to...

Exam 6: Data: Business Intelligence

Distributed computing processes and manages algorithms across many machines in a computing environment.

Correct AnswerverifiedShow Answer

Identify the advantages of using business intelligence to support managerial decision making.

Correct AnswerverifiedMany organizations today find it next to...View AnswerShow Answer

What is the primary tool that retrieves information and helps users graphically design the answer to a question?

Correct AnswerverifiedShow Answer

Which of the following would not be considered part of the unique characteristic of high-quality information?

Correct AnswerverifiedShow Answer

Static information includes fixed data incapable of change in the event of a user action.

Correct AnswerverifiedShow Answer

What are the rules that enforce basic and fundamental information-based constraints?

Correct AnswerverifiedShow Answer

Which of the following statements is true?

Correct AnswerverifiedShow Answer

Unique information asks if each transaction and event is represented only once in the information.

Correct AnswerverifiedShow Answer

What analyzes unstructured data associated with websites to identify consumer behavior and website navigation?

Correct AnswerverifiedShow Answer

What includes fixed data incapable of change in the event of a user action?

Correct AnswerverifiedShow Answer

Identify the business advantages of a relational database.

Correct AnswerverifiedMany business managers are familiar with...View AnswerShow Answer

What is big data?

Correct AnswerverifiedShow Answer

Classification assigns records to one of a predefined set of classes.

Correct AnswerverifiedShow Answer

Which of the following is a valid type of integrity constraint?

Correct AnswerverifiedShow Answer

Which of the following illustrates the primary concepts of the relational database model?

Correct AnswerverifiedShow Answer

What type of integrity constraint does not allow someone to create an order for a nonexistent customer?

Correct AnswerverifiedShow Answer

Which of the following occurs when a system produces incorrect, inconsistent, or duplicate data?

Correct AnswerverifiedShow Answer

What is distributed computing?

Correct AnswerverifiedShow Answer

Which of the following is incorrect in terms of data warehousing and business intelligence?

Correct AnswerverifiedShow Answer

Advanced analytics focuses on forecasting future trends and producing insights using sophisticated quantitative methods, including statistics, descriptive and predictive data mining, simulation, and optimization.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
Many organizations today find it next to...
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
Many business managers are familiar with...
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