Question 1

A central location in which data is stored and managed is called a data mart.

Accepted Answer

A) True 
 B)False

Question 2

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Accepted Answer

A) True 
 B)False  True

Question 3

Explain ETL and the role of a data mart in business.

Accepted Answer

Extraction, transformation, and loading ...

Question 4

Describe a database, a database management system, and the relational database model.

Accepted Answer

A database maintains information about v...

Question 5

A comparative analysis can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 6

What does standardization of data elements accomplish?

Accepted Answer

A)  Greater accuracy.
B)  Completeness and completeness.
C)  Increases the quality of information.
D)  All of these.

Question 7

Which of the following describes ETL?

Accepted Answer

A)  A process that extracts information from internal and external databases.
B)  A process that transforms information using a common set of enterprise definitions.
C)  A process that loads information into a data warehouse.
D)  All of these.

Question 8

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

Question 9

What is another term for information cleansing?

Accepted Answer

A)  Information mining
B)  Information scrubbing
C)  Information scrapping
D)  Information marts B

Question 10

Kassandra Young is a business manager at Weith Productions.Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions.To make her job easier, what can she customize to display data quickly and run custom reports?

Accepted Answer

A)  Data point
B)  Information cleansing
C)  Dashboard
D)  Data set

Question 11

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Accepted Answer

A) True 
 B)False

Question 12

What is a data lake?

Accepted Answer

A)  A business that collects personal information about consumers and sells that information to other organizations.
B)  A storage repository that holds a vast amount of raw data in its original format until the business needs it.
C)  A technique for establishing a match, or balance, between the source data and the target data warehouse.
D)  An approach to business governance that values decisions that can be backed up with verifiable data.

Question 13

The primary purpose of a data warehouse is to _____________.

Accepted Answer

A)  Combine strategic information
B)  Organize departments
C)  Interface between the computer and employees
D)  All of these

Question 14

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following contains a subset of data warehouse information?

Accepted Answer

A)  Data miner
B)  Data mart
C)  Data pool
D)  Data analyzing tool

Question 16

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

Accepted Answer

A)  Inaccurate data
B)  Nonintegrated data
C)  Violates business rules
D)  All of these

Question 17

What is information that people use to support their decision-making efforts?

Accepted Answer

A)  Information cleansing and scrubbing
B)  Data-mining tools
C)  Data mining
D)  Business intelligence

Question 18

A data warehouse is a central location in which data is stored and managed.

Accepted Answer

A) True 
 B)False  False

Question 19

The primary purpose of a data warehouse is to perform transactional processes.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 7: Accessing Organizational Information Data Warehouses

A central location in which data is stored and managed is called a data mart.

Correct AnswerverifiedShow Answer

Many organizations find themselves in the position of being data rich and information poor.Even in today's electronic world, managers struggle with the challenge of turning their business data into business intelligence.

Correct AnswerverifiedTrue

Explain ETL and the role of a data mart in business.

Correct AnswerverifiedExtraction, transformation, and loading ...View AnswerShow Answer

Describe a database, a database management system, and the relational database model.

Correct AnswerverifiedA database maintains information about v...View AnswerShow Answer

A comparative analysis can compare two or more data sets to identify patterns and trends.

Correct AnswerverifiedShow Answer

What does standardization of data elements accomplish?

Correct AnswerverifiedShow Answer

Which of the following describes ETL?

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

What is another term for information cleansing?

Correct AnswerverifiedB

Kassandra Young is a business manager at Weith Productions.Although she does not have a background in technology, her job requires her to work with analytical tools to make data-driven decisions.To make her job easier, what can she customize to display data quickly and run custom reports?

Correct AnswerverifiedShow Answer

Competitive monitoring can compare two or more data sets to identify patterns and trends.

Correct AnswerverifiedShow Answer

What is a data lake?

Correct AnswerverifiedShow Answer

The primary purpose of a data warehouse is to _____________.

Correct AnswerverifiedShow Answer

A data lake is a business that collects personal information about consumers and sells that information to other organizations.

Correct AnswerverifiedShow Answer

Which of the following contains a subset of data warehouse information?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

What is information that people use to support their decision-making efforts?

Correct AnswerverifiedShow Answer

A data warehouse is a central location in which data is stored and managed.

Correct AnswerverifiedFalse

The primary purpose of a data warehouse is to perform transactional processes.

Correct AnswerverifiedShow Answer

How would the banking industry use business intelligence?

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified
True

Correct Answer
verified
Extraction, transformation, and loading ...
View Answer

Correct Answer
verified
A database maintains information about v...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
B

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
False

Correct Answer
verified

Correct Answer
verified