Quiz Summary
0 of 46 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 46 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
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 46
1. Question
Data warehouses were seen as a means to?
CorrectIncorrect -
Question 2 of 46
2. Question
Which of these is NOT an important activity in Data Warehousing and Business Intelligence?
CorrectIncorrect -
Question 3 of 46
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 46
4. Question
Business Intelligence tools enable:
CorrectIncorrect -
Question 5 of 46
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 46
6. Question
What is NOT true of Data Warehouses, according to Bill Inmon?
CorrectIncorrect -
Question 7 of 46
7. Question
According to Ralph Kimball, data in a Data Warehouse is stored in which model?
CorrectIncorrect -
Question 8 of 46
8. Question
In Kimball’s Data Warehouse Chess Pieces view of DW/BI architecture, which component most influences the quality of the analytics being delivered?
CorrectIncorrect -
Question 9 of 46
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 46
10. Question
What is a data mart?
CorrectIncorrect -
Question 11 of 46
11. Question
What is NOT true of a Data Vault?
CorrectIncorrect -
Question 12 of 46
12. Question
When gathering requirements for Data Warehouse projects, we should start with:
CorrectIncorrect -
Question 13 of 46
13. Question
There are typically 3 concurrent development tracks in Data Warehouse and Business Intelligence projects. What are they?
CorrectIncorrect -
Question 14 of 46
14. Question
When performing source to target mapping, one of the main challenges with any mapping effort is:
CorrectIncorrect -
Question 15 of 46
15. Question
When defining a population approach for the Data Warehouse, we should consider:
CorrectIncorrect -
Question 16 of 46
16. Question
When defining target user group for BI tools, we should:
CorrectIncorrect -
Question 17 of 46
17. Question
Which process is critical to the incremental development, production, deployment and regular maintenance of a Data Warehouse?
CorrectIncorrect -
Question 18 of 46
18. Question
What are ways we can monitor and adjust Business Intelligence performance and activity?
CorrectIncorrect -
Question 19 of 46
19. Question
When selecting a DW/BI tool for your organisation, which is NOT a factor to consider?
CorrectIncorrect -
Question 20 of 46
20. Question
Data lineage analysis is useful for the following functions EXCEPT:
CorrectIncorrect -
Question 21 of 46
21. Question
What implementation approaches do not support OLAP?
CorrectIncorrect -
Question 22 of 46
22. Question
Why should you profile data before starting a DW implementation?
CorrectIncorrect -
Question 23 of 46
23. Question
Which of these points do NOT describe Self service BI?
CorrectIncorrect -
Question 24 of 46
24. Question
Data Warehouses can usually be implemented with which method?
CorrectIncorrect -
Question 25 of 46
25. Question
What is NOT a critical success factor when it comes to DW/BI projects?
CorrectIncorrect -
Question 26 of 46
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 46
27. Question
Which of these is LEAST IMPORTANT when creating a reporting strategy for the BI Portfolio?
CorrectIncorrect -
Question 28 of 46
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 46
29. Question
What is one of the major differences between operational systems and data warehouses?
CorrectIncorrect -
Question 30 of 46
30. Question
Which of these is a core idea of Data Warehousing shared by both Inmon and Kimball?
CorrectIncorrect -
Question 31 of 46
31. Question
When supporting multi-dimensional business report requests, which would be best?
CorrectIncorrect -
Question 32 of 46
32. Question
Which of these reporting types would be least suited to BI?
CorrectIncorrect -
Question 33 of 46
33. Question
What kind of data processing uses Slice, Dice, Roll-up and Pivot?
CorrectIncorrect -
Question 34 of 46
34. Question
When estimating the level of effort needed to implement different DW technologies, which is least important?
CorrectIncorrect -
Question 35 of 46
35. Question
Data Warehouses need to be incrementally developed. Which process is critical to the success of such a project?
CorrectIncorrect -
Question 36 of 46
36. Question
What would be the broadest description of the contents of a Data Warehouse?
CorrectIncorrect -
Question 37 of 46
37. Question
Which of the following is most likely to be utilised by executives for assessing metrics aligned with long-term organisational goals?
CorrectIncorrect -
Question 38 of 46
38. Question
Which of the following best describes a comprehensive approach to selecting data warehouse tools?
CorrectIncorrect -
Question 39 of 46
39. Question
Which step in the DW/BI implementation effort requires the most effort?
CorrectIncorrect -
Question 40 of 46
40. Question
Why is determining valid links or equivalencies between data elements when integrating multiple source systems such a challenge?
CorrectIncorrect -
Question 41 of 46
41. Question
In order to demonstrate progress towards the desired end state of your DW/BI program, which of these is most important?
CorrectIncorrect -
Question 42 of 46
42. Question
Data Governance is critical to the success of Data Warehousing and BI projects. Which of these methods is least useful for getting Business Acceptance?
CorrectIncorrect -
Question 43 of 46
43. Question
End-to-end metadata is most useful for answering which of the following questions?
CorrectIncorrect -
Question 44 of 46
44. Question
What is the primary advantage of using OLAP cubes in financial analysis?
CorrectIncorrect -
Question 45 of 46
45. Question
What metric is most useful for tuning BI activity and performance in a data warehouse/BI project?
CorrectIncorrect -
Question 46 of 46
46. Question
What source primarily informs the content of a data dictionary in a data warehouse?
CorrectIncorrect