Question 1 (1 point) Data warehouses have all the following characteristics exce
ID: 3768841 • Letter: Q
Question
Question 1 (1 point)
Data warehouses have all the following characteristics except that data stored in them are not:
Question 1 options:
A)
non-volatile
B)
time variant
C)
subject-oriented
D)
organized by process
Page 1 of 15
Quiz
Page 2 of 15
Note: It is recommended that you save your response as you complete each question.
Question 2 (1 point)
The Balanced Scorecard is a ________ system.
Question 2 options:
A)
measurement
B)
management
C)
performance
D)
all of the above
Page 2 of 15
Quiz
Page 3 of 15
Note: It is recommended that you save your response as you complete each question.
Question 3 (1 point)
Which of the following is true regarding data mining?
Question 3 options:
A)
Data mining is similar to corporate reporting.
B)
Data mining ususally starts off with a hypothesis that must be tested.
C)
The roots of data mining are in marketing and financial services
D)
All of the above
Page 3 of 15
Quiz
Page 4 of 15
Note: It is recommended that you save your response as you complete each question.
Question 4 (1 point)
On a user's dashboard, customer satisfaction and ontime delivery rate KPIs are both yellow. This would mean:
Question 4 options:
A)
these customer metrics need immediate attention.
B)
it may be important to focus on why these customer metrics are not green.
C)
the way that these customer metrics are being measured should be updated.
D)
internal processes have gone away and are being noticed by customers.
Page 4 of 15
Quiz
Page 5 of 15
Note: It is recommended that you save your response as you complete each question.
Question 5 (1 point)
Which of the following BI tools is most proactive?
Question 5 options:
A)
statistical analysis
B)
queries
C)
predictive modeling
D)
alerting
Page 5 of 15
Quiz
Page 6 of 15
Note: It is recommended that you save your response as you complete each question.
Question 6 (1 point)
Which of the following types of tools is likely to be included in a BI application?
Question 6 options:
A)
predefined reports
B)
ad hoc querying and reporting
C)
scorecarding
D)
all of the above
Page 6 of 15
Quiz
Page 7 of 15
Note: It is recommended that you save your response as you complete each question.
Question 7 (1 point)
______ methods are used to populate a data warehouse.
Question 7 options:
A)
Data normalization
B)
ETL (extract, transform, and load)
C)
Data mining
D)
Data mart aggregration
Page 7 of 15
Quiz
Page 8 of 15
Note: It is recommended that you save your response as you complete each question.
Question 8 (1 point)
_______ includes activities to ensure that goals are consistently being met in an effective and efficient manner.
Question 8 options:
The Balanced Scorecard
Business Performance Management (BPM)
Data Governance
Business Intelligence
Page 8 of 15
Quiz
Page 9 of 15
Note: It is recommended that you save your response as you complete each question.
Question 9 (1 point)
_____ analyzes historic transaction records to identify opportunities to gain an advantage; _____ isolates specific data to indicate which processes are operating at peak efficiency and which need immediate attention to avoid suboptimal performance.
Question 9 options:
A)
BPM; Balanced Scorecard
B)
BI; BPM
C)
BPM; Data Governance
D)
Data mining; predictive analytics
Page 9 of 15
Quiz
Page 10 of 15
Note: It is recommended that you save your response as you complete each question.
Question 10 (1 point)
Which of the following is consistent with BI best practices?
Question 10 options:
A)
standardizing and cleansing data to be used in BI
B)
integrating data using the best data structuring alternatives available
C)
training users to manipulate the data to get meaningful and valuable answers
D)
all of the above
Page 10 of 15
Quiz
Page 11 of 15
Note: It is recommended that you save your response as you complete each question.
Question 11 (1 point)
End users are most likely to use a BI tool when:
Question 11 options:
A)
users are confident that knowledge gained from using BI tool will benefit their decision-making.
B)
the BI tool's user interface is easy to navigate and facilitates the extraction of useful information.
C)
the BI tool can be used to respond to a wide range of information requests.
D)
all of the above
Page 11 of 15
Quiz
Page 12 of 15
Note: It is recommended that you save your response as you complete each question.
Question 12 (1 point)
_____ includes metrics that visually communicates when buisness performance is satifactory or needs attention, often by using red, yellow, and green color codes to indicate performance status.
Question 12 options:
A)
An alert
B)
Scorecarding
C)
A key performance indicator (KPI)
D)
Leading indicators
Page 12 of 15
Quiz
Page 13 of 15
Note: It is recommended that you save your response as you complete each question.
Question 13 (1 point)
Which quadrant of the Balanced Scorecard addesses the question "Can we continue to improve and create value?"
Question 13 options:
A)
the financial perspective
B)
the learning and growth perspective
C)
the internal business process perspective
D)
the customer perspective
Page 13 of 15
Quiz
Page 14 of 15
Note: It is recommended that you save your response as you complete each question.
Question 14 (1 point)
______ metrics are examples of lagging indicators.
Question 14 options:
A)
Financial
B)
New patents pending
C)
Confirmed customer orders
D)
None of the above
Page 14 of 15
Quiz
Page 15 of 15
Note: It is recommended that you save your response as you complete each question.
Question 15 (1 point)
A sound data governance progam within an organization typically includes:
Question 15 options:
A)
a cross-functional data governance committee.
B)
a defined set of procedures for data quality.
C)
a measurable plan to improve data data integrity and overall data quality.
D)
all of the above
A)
non-volatile
B)
time variant
C)
subject-oriented
D)
organized by process
Explanation / Answer
1. B) Time Variant
2. c) performance - it is user for measuring employee performance. - so right answer may vary from person to person.
3. c) The roots of data mining are in marketing and financial services
4. c) the way that these customer metrics are being measured should be updated.
5. A) statistical analysis
6. d) all of the above
7. B) ETL
8. Business Performance Management (BPM)
9. B) BI; BPM
10. D) all of the above.
11. A) users are confident that knowledge gained from using BI tool will benefit their decision-making.
12. c) A key performance indicator (KPI)
13. c) the internal business process perspective
14. D) None of the above
15. D) all of the above