Data Warehousing MCQs (Chapterwise Multiple Choice Questions)

Which of the following is true about Specialized SQL servers?

It uses the two level of data storage representation to handle dense and sparse data sets

It provides advanced query language and query processing support for SQL queries over star and snowflake schemas

It facilitates OLTP operations in SQL

It uses array-based multidimensional storage engines

Answer & Explanation

Correct Answer: It provides advanced query language and query processing support for SQL queries over star and snowflake schemas

Note: This Question is unanswered, help us to find answer for this one

Which of the following enviroments are in third normal form 3NF?

All of the options are correct

OLAP

Data Warehousing env

OLTP

Answer & Explanation

Correct Answer: OLTP

Note: This Question is unanswered, help us to find answer for this one

The term OLAP was coined by:

Date

Codd

IBM

Oracle

Microsoft

Answer & Explanation

Correct Answer: Codd

Note: This Question is unanswered, help us to find answer for this one

All else being equal, which of the following elements of a single MDX WHERE clause will evaluate first?

MEMBER [Measures].[A Squared] AS [Measures].[Measure A] * [Measures].[Measure A], SOLVE_ORDER = 2

MEMBER [Measures].[C Less One] AS [Measures].[Measure C] - 1, SOLVE_ORDER = 1

All elements evaluate simultaneously

MEMBER [Measures].[B Twice] AS [Measures].[Measure B] + [Measures].[Measure B], SOLVE_ORDER = 4

Answer & Explanation

Correct Answer: MEMBER [Measures].[B Twice] AS [Measures].[Measure B] + [Measures].[Measure B], SOLVE_ORDER = 4

Note: This Question is unanswered, help us to find answer for this one

Which technique of Data Mining involves developing mathematical structures with the ability to learn?

Clustering and Segmentation

Neural Networks

Fuzzy Logic

Linear Regression Analysis

Rule based Analysis

Answer & Explanation

Correct Answer: Neural Networks

Note: This Question is unanswered, help us to find answer for this one

The movement of data from one environment to another is known as:

Data Migration

Normalization

Replication

Data Mining

Data Cleansing

Answer & Explanation

Correct Answer: Data Migration

Note: This Question is unanswered, help us to find answer for this one

Which of the following is an architecture for OLAP?

MOLAP

ROLAP

KOLAP

MOLAP and ROLAP

MOLAP, ROLAP and KOLAP

Answer & Explanation

Correct Answer: MOLAP

Note: This Question is unanswered, help us to find answer for this one

Choose the most correct statement:

Star and snowflake schema contains two Fact tables

Snowflake schema contains two Fact tables

Fact Constellation schema contains two Fact tables

Star schema contains two Fact tables

Answer & Explanation

Correct Answer: Fact Constellation schema contains two Fact tables

Note: This Question is unanswered, help us to find answer for this one

A data warehouse is an ‘integrated’ collection of data because?

It contains summarized data

It is a collection of data of derived from multiple sources

It is a relational database

It is a collection of data of different types

Answer & Explanation

Correct Answer: It is a collection of data of different types

Note: This Question is unanswered, help us to find answer for this one

Where is the OLAP page pool stored in memory in an Oracle Database 10g and later?

Private SQL Area

User Global Area

Program Global Area

SQL Work Area

Answer & Explanation

Correct Answer: User Global Area

Note: This Question is unanswered, help us to find answer for this one

Data Warehousing Quick Quiz

Poor Results!

You need a lot of improvement.

Just don't give up!

Correct Answers: 0/10

Start Practicing with our MCQs given below.