OLAP - Cube — Learn free

Self-check

Questions 1–10 of 10

1. What is an OLAP cube?
Question 1A. A normalised table of transactionsB. Data joined from fact and dimension tables and loaded into one table with multi-dimensional data pre-loadedC. A virtual view over source systemsD. A JSON transaction logE. A web-based reporting tool
2. Which of the following is NOT a listed disadvantage of OLAP cubes?
Question 2A. They are huge in sizeB. They are very difficult to refresh in real timeC. Housekeeping is a challengeD. Queries against them are slowE. They are seen by many as not worth having
3. Which OLAP type sits directly on top of an RDBMS star or snowflake schema and can be built with standard SQL?
Question 3A. MOLAPB. ROLAPC. HOLAPD. WOLAPE. SOLAP
4. Cubes are the best example of which OLAP type?
Question 4A. ROLAPB. DOLAPC. MOLAPD. WOLAPE. HTAP
5. What is a cube with more than three dimensions of data called?
Question 5A. A supercubeB. A galaxyC. A hypercubeD. A constellationE. A tesseract table
6. Which operations can users perform within a single MOLAP cube without joining other tables?
Question 6A. Insert, update and deleteB. Slice, dice, drill up and down, roll up and pivotC. Encrypt and decryptD. Scrape and harvestE. Normalise and denormalise
7. What is HOLAP?
Question 7A. A hybrid mixture of ROLAP and MOLAPB. A web-only OLAP accessed through a browserC. An OLAP for geo-business intelligenceD. An in-memory system doing both OLTP and OLAPE. An offline desktop portion of OLAP
8. Which OLAP type allows users to download a portion of the OLAP data to their own machine for offline working?
Question 8A. WOLAPB. SOLAPC. DOLAPD. HOLAPE. ROLAP
9. What is SOLAP designed to tackle?
Question 9A. Issues in the field of geo-business intelligenceB. Streaming social media dataC. Secure encrypted cubesD. Server-side caching of queriesE. Scheduling of cube refreshes
10. What is a benefit of ROLAP over MOLAP with respect to storage?
Question 10A. ROLAP compresses cubes to half their sizeB. ROLAP needs no additional storage because it runs on top of the RDBMSC. ROLAP stores everything in memoryD. ROLAP downloads data to the desktopE. ROLAP stores data only in the browser