Reference no: EM133244744
Assignment:
Computer Science
1. What visualization operator do dimension hierarchies enable?
a. Drill down
b. Drill across
c. Pivoting
d. All of the above
2. Chunking is a method which can be used to build a star schema. The chunking involves?
a. Using a Hub and spoke architecture
b. Using an independent architecture
c. Identifying tables which are classified as transactions, components and classification and using them to create facts, dimensions and hierarchy tables in the star schema
d. Identifying tables which are classified as transactions, components and classification and using them to create facts and dimensions in the star schema
3. Operational systems are not very useful for strategic information needs because:
a. They do not have up-to-date data
b. The information in them is only applicable for the purpose of the process that the system is design for
c. You cannot get access to the database through the source application
d. They provide aggregated measures that are too difficult to understand for running a business
4. Which of the following provides the best description for a transactional database?
a. Offers a historical perspective through archival data
b. Delivers a comprehensive overview over organisational data
c. Provides reports to the viewers when they press the 'refresh' button
d. Are optimized for the immediate support of a particular business process
5. The data to ink ratio is a way to:
a. Improve your visualization by making specific parts of your visualization bold
b. Highlight important visuals with a colourful background
c. Improve the visual effect of your image by choosing the correct picture for your dashboard
d. Remove redundant features from your visual