Craig Willey
Quiz by , created more than 1 year ago

College C192 Databases Quiz on C192 / OLAP / Data Warehousing, created by Craig Willey on 30/06/2020.

8
0
0
Craig Willey
Created by Craig Willey over 4 years ago
Close

C192 / OLAP / Data Warehousing

Question 1 of 22

1

Which of the following is a characteristic of an OLAP?

Select one of the following:

  • Uses single dimensional data analysis techniques

  • Provides introductory database support and complex end user interfaces

  • Provides introductory end-user interfaces

  • Supports client/server architecture

Explanation

Question 2 of 22

1

Many of the OLAP interface features are "borrowed" from previous generations of data ____ tools.

Select one of the following:

  • module

  • processing

  • filtering

  • analysis

Explanation

Question 3 of 22

1

____ is defined as an advanced data analysis environment that supports decision making, business modeling, and an operation’s researching activities.

Select one of the following:

  • VLAD

  • ROLAP

  • OLAP

  • DSS

Explanation

Question 4 of 22

1

The data warehouse and OLAP are two interrelated and complementary ____.

Select one of the following:

  • environments

  • programs

  • systems

  • warehouses

Explanation

Question 5 of 22

1

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 ____.

Select one of the following:

  • workstations

  • queries

  • schemas

  • servers

Explanation

Question 6 of 22

1

MOLAP extends OLAP functionality to multidimensional ____ management systems.

Select one of the following:

  • online

  • database

  • processing

  • data

Explanation

Question 7 of 22

1

The location of each data value in the data cube is a function of the x, y, and z axes in a ____ space.

Select one of the following:

  • one-dimensional

  • two-dimensional

  • three-dimensional

  • multidimensional

Explanation

Question 8 of 22

1

Data cubes are created by extracting data from the operational database or from the data ____.

Select one of the following:

  • base

  • management system

  • processing system

  • warehouse

Explanation

Question 9 of 22

1

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 ____.

Select one of the following:

  • modified

  • updated

  • deleted

  • re-created

Explanation

Question 10 of 22

1

____ schemas yield an easily implemented model for multidimensional data analysis, while still preserving the relational structures on which the operational database is built.

Select one of the following:

  • Fact

  • Star

  • Dimensional

  • Operational

Explanation

Question 11 of 22

1

____ are qualifying characteristics that provide additional perspectives to a given fact.

Select one of the following:

  • Views

  • Attributes

  • Dimensions

  • Fact Tables

Explanation

Question 12 of 22

1

The ____ hierarchy provides a top-down data organization that is used for two main purposes: aggregation and drill-down/roll-up data analysis.

Select one of the following:

  • relational

  • dimensional

  • multidimensional

  • attribute

Explanation

Question 13 of 22

1

____ splits a table into subsets of rows or columns and places the subsets close to the client computer to improve data access time.

Select one of the following:

  • Partitioning

  • Replication

  • Aggregation

  • Denormalizing

Explanation

Question 14 of 22

1

____ makes a copy of a table and places it in a different location, to improve access time.

Select one of the following:

  • Periodicity

  • Aggregation

  • Partitioning

  • Replication

Explanation

Question 15 of 22

1

____ provides information about the timespan of the data stored in the table.

Select one of the following:

  • Periodicity

  • Partitioning

  • Replication

  • Aggregation

Explanation

Question 16 of 22

1

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.

Select one of the following:

  • analysis

  • preparation

  • classification

  • acquisition

Explanation

Question 17 of 22

1

During the data ____ phase of data mining, common characteristics or patterns are identified.

Select one of the following:

  • analysis

  • preparation

  • extraction

  • acquisition

Explanation

Question 18 of 22

1

During the ____ phase of data mining, the data mining findings are used to predict future behavior and forecast business outcomes.

Select one of the following:

  • analysis and classification

  • preparation

  • prognosis

  • knowledge acquisition

Explanation

Question 19 of 22

1

The ____ schema creates the near equivalent of a multidimensional database schema from the existing relational database.

Select one of the following:

  • star

  • square

  • OLAP

  • ROLAP

Explanation

Question 20 of 22

1

Which of the following is NOT a basic component of a star schema?

Select one of the following:

  • Attribute hierarchy

  • Fact

  • Domain

  • Dimension

Explanation

Question 21 of 22

1

Using multidimensional jargon, the ability to focus on slices of the cube to perform a more detailed analysis is known as ____.

Select one of the following:

  • star cuts

  • slice and dice

  • microscoping

  • TPL processing

Explanation

Question 22 of 22

1

In contrast to the traditional DSS tools, data mining is ____.

Select one of the following:

  • proactive

  • protective

  • automatic

  • costly

Explanation