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 over 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

Henry VIII - Annulment and Divorce
Eva Clifton
GCSE Statistics
Felix Ulrich-Oltean
Global History Regents Review Notes (Europe)
Jen Molte
1984 - Good quotes to memorise
jenniferlg
The structure of the Heart, AS Biology
mill-bill
How Parliament Makes Laws
harryloftus505
F212: Classification, Biodiversity & Evolution
helen.rebecca
Psychology subject map
Jake Pickup
GCSE Biology B1 (OCR)
Usman Rauf
Macroeconomics year 1
Nkolika Ezepue
IB ITGS AREAS OF IMPACT
san wis
Browse Library