Copy and Edit

C192 / OLAP / Data Warehousing

Description

College C192 Databases Quiz on C192 / OLAP / Data Warehousing, created by Craig Willey on 30/06/2020.
Craig Willey
Quiz by Craig Willey, updated more than 1 year ago
Craig Willey
Created by Craig Willey about 4 years ago
8
0
0

Resource summary

Question 1

Question
Which of the following is a characteristic of an OLAP?
Answer
  • Uses single dimensional data analysis techniques
  • Provides introductory database support and complex end user interfaces
  • Provides introductory end-user interfaces
  • Supports client/server architecture

Question 2

Question
Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.
Answer
  • module
  • processing
  • filtering
  • analysis

Question 3

Question
____ is defined as an advanced data analysis environment that supports decision making, business modeling, and an operation’s researching activities.
Answer
  • VLAD
  • ROLAP
  • OLAP
  • DSS

Question 4

Question
The data warehouse and OLAP are two interrelated and complementary ____.
Answer
  • environments
  • programs
  • systems
  • warehouses

Question 5

Question
To provide better performance, some OLAP systems merge the data warehouse and data mart approaches by storing small extracts of the data warehouse at end user ____.
Answer
  • workstations
  • queries
  • schemas
  • servers

Question 6

Question
MOLAP extends OLAP functionality to multidimensional ____ management systems.
Answer
  • online
  • database
  • processing
  • data

Question 7

Question
The location of each data value in the data cube is a function of the x, y, and z axes in a ____ space.
Answer
  • one-dimensional
  • two-dimensional
  • three-dimensional
  • multidimensional

Question 8

Question
Data cubes are created by extracting data from the operational database or from the data ____.
Answer
  • base
  • management system
  • processing system
  • warehouse

Question 9

Question
Since the data cube is predefined with a set number of dimensions, the addition of a new dimension requires that the entire data cube be ____.
Answer
  • modified
  • updated
  • deleted
  • re-created

Question 10

Question
____ schemas yield an easily implemented model for multidimensional data analysis, while still preserving the relational structures on which the operational database is built.
Answer
  • Fact
  • Star
  • Dimensional
  • Operational

Question 11

Question
____ are qualifying characteristics that provide additional perspectives to a given fact.
Answer
  • Views
  • Attributes
  • Dimensions
  • Fact Tables

Question 12

Question
The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.
Answer
  • relational
  • dimensional
  • multidimensional
  • attribute

Question 13

Question
____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.
Answer
  • Partitioning
  • Replication
  • Aggregation
  • Denormalizing

Question 14

Question
____ makes a copy of a table and places it in a different location, to improve access time.
Answer
  • Periodicity
  • Aggregation
  • Partitioning
  • Replication

Question 15

Question
____ provides information about the timespan of the data stored in the table.
Answer
  • Periodicity
  • Partitioning
  • Replication
  • Aggregation

Question 16

Question
During the data ____ phase of data mining, the main data sets to be used by the data mining operation are identified and cleansed of any data impurities.
Answer
  • analysis
  • preparation
  • classification
  • acquisition

Question 17

Question
During the data ____ phase of data mining, common characteristics or patterns are identified.
Answer
  • analysis
  • preparation
  • extraction
  • acquisition

Question 18

Question
During the ____ phase of data mining, the data mining findings are used to predict future behavior and forecast business outcomes.
Answer
  • analysis and classification
  • preparation
  • prognosis
  • knowledge acquisition

Question 19

Question
The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.
Answer
  • star
  • square
  • OLAP
  • ROLAP

Question 20

Question
Which of the following is NOT a basic component of a star schema?
Answer
  • Attribute hierarchy
  • Fact
  • Domain
  • Dimension

Question 21

Question
Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.
Answer
  • star cuts
  • slice and dice
  • microscoping
  • TPL processing

Question 22

Question
In contrast to the traditional DSS tools, data mining is ____.
Answer
  • proactive
  • protective
  • automatic
  • costly
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

KEE3
harrym
The Heart
annalieharrison
Structure of the League of Nations
saskiamitchell.19
OCR Physics P4 Revision
Dan Allibone
Repaso de Revalida Enfermeria 2015
Francisco Rivera
Japanese Hiragana
pangcaberte
Vampires, Dracula, and Morality Victorian Anxieties!
Anna-Maria Kotulski
Linking Rossetti and A Doll's House
Mrs Peacock
PROFESSIONAL DEVELOPER TEST POOL-1 (MAGENTO 2 CERTIFIED )
Miska Red
Equality Act 2010 [25 marks]
Carina Storm
Data Protection Act 1998
Carina Storm
Browse Library