Quiz Summary
0 of 36 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 36 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Data Warehousing and Business Intelligence 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 36
1. Question
Data warehouses were seen as a means to?
CorrectIncorrect -
Question 2 of 36
2. Question
Which of these is NOT an important activity in Data Warehousing and Business Intelligence?
CorrectIncorrect -
Question 3 of 36
3. Question
When implementing a Data Warehouse, a principle to follow is building metadata along with the Data Warehouse. This is because:
CorrectIncorrect -
Question 4 of 36
4. Question
Business Intelligence tools enable:
CorrectIncorrect -
Question 5 of 36
5. Question
Bill Inmon and Ralph Kimball have different approaches to developing Data Warehouses. They both however have similar principles. Which of these is an area of difference between the two?
CorrectIncorrect -
Question 6 of 36
6. Question
What is NOT true of Data Warehouses, according to Bill Inmon?
CorrectIncorrect -
Question 7 of 36
7. Question
According to Ralph Kimball, data in a Data Warehouse is stored in which model?
CorrectIncorrect -
Question 8 of 36
8. Question
What component is NOT part of Kimball’s Data Warehouse Chess Pieces view of DW/BI architecture?
CorrectIncorrect -
Question 9 of 36
9. Question
What is the key difference in the data lifecycle of a DW/BI landscape when dealing with big data?
CorrectIncorrect -
Question 10 of 36
10. Question
What is a data mart?
CorrectIncorrect -
Question 11 of 36
11. Question
What is NOT true of a Data Vault?
CorrectIncorrect -
Question 12 of 36
12. Question
When gathering requirements for Data Warehouse projects, we should start with:
CorrectIncorrect -
Question 13 of 36
13. Question
There are typically 3 concurrent development tracks in Data Warehouse and Business Intelligence projects. What are they?
CorrectIncorrect -
Question 14 of 36
14. Question
When performing source to target mapping, one of the main challenges with any mapping effort is:
CorrectIncorrect -
Question 15 of 36
15. Question
When defining a population approach for the Data Warehouse, we should consider:
CorrectIncorrect -
Question 16 of 36
16. Question
When defining target user group for BI tools, we should:
CorrectIncorrect -
Question 17 of 36
17. Question
Which process is critical to the incremental development, production, deployment and regular maintenance of a Data Warehouse?
CorrectIncorrect -
Question 18 of 36
18. Question
What are ways we can monitor and adjust Business Intelligence performance and activity?
CorrectIncorrect -
Question 19 of 36
19. Question
When selecting a DW/BI tool for your organisation, which is NOT a factor to consider?
CorrectIncorrect -
Question 20 of 36
20. Question
Data lineage analysis is useful for the following functions EXCEPT:
CorrectIncorrect -
Question 21 of 36
21. Question
What implementation approaches do not support OLAP?
CorrectIncorrect -
Question 22 of 36
22. Question
Why should you profile data before starting a DW implementation?
CorrectIncorrect -
Question 23 of 36
23. Question
Which of these points do NOT describe Self service BI?
CorrectIncorrect -
Question 24 of 36
24. Question
Data Warehouses can usually be implemented with which method?
CorrectIncorrect -
Question 25 of 36
25. Question
What is NOT a critical success factor when it comes to DW/BI projects?
CorrectIncorrect -
Question 26 of 36
26. Question
When trying to meet requirements from the business during any DW/BI implementation, which of these architectural sub components should also be considered?
CorrectIncorrect -
Question 27 of 36
27. Question
Which of these is LEAST IMPORTANT when creating a reporting strategy for the BI Portfolio?
CorrectIncorrect -
Question 28 of 36
28. Question
Establishing usage metrics typically involves tracking all the licensed account users and their activity. A good way to measure this is:
CorrectIncorrect -
Question 29 of 36
29. Question
What is one of the major differences between operational systems and data warehouses?
CorrectIncorrect -
Question 30 of 36
30. Question
Which of these is a core idea of Data Warehousing shared by both Inmon and Kimball?
CorrectIncorrect -
Question 31 of 36
31. Question
When supporting multi-dimensional business report requests, which would be best?
CorrectIncorrect -
Question 32 of 36
32. Question
Which of these reporting types would be least suited to BI?
CorrectIncorrect -
Question 33 of 36
33. Question
What kind of data processing uses Slice, Dice, Roll-up and Pivot?
CorrectIncorrect -
Question 34 of 36
34. Question
When estimating the level of effort needed to implement different DW technologies, which is least important?
CorrectIncorrect -
Question 35 of 36
35. Question
Data Warehouses need to be incrementally developed. Which process is critical to the success of such a project?
CorrectIncorrect -
Question 36 of 36
36. Question
What would be the broadest description of the contents of a Data Warehouse?
CorrectIncorrect