Data Warehousing Questions & Answers | DWH | MCQ

Data Warehousing | DWH | MCQ

1

The operation of moving from coarser granularity data to a finer granularity  is called

Select one:
Feedback
Your answer is correct.
The correct answer is:
2
___________ is a good alternative to the star schema.
A. Star schema.
B. Snowflake schema.
C. Fact constellation.
D. Star-snowflake schema.
Feedback
Your answer is correct.
The correct answer is:
3
Aggregate navigator is based on
Select one:
a. Summary tables
b. Logical Views
c. Indexes
d. Materialized Views
Feedback
Your answer is correct.
The correct answer is: Materialized Views

4
MOLAP stores aggregate values in which of the following structure?
Select one:
a. View
b. Table
c. Index
d. Array
Feedback
Your answer is correct.
The correct answer is: Array

5
Which one of the following is NOT a characteristic of metadata?
Select one:
a. Self-describing
b. Helps user to build ad-hoc queries
c. Includes user data
d. Data about data
Feedback
Your answer is correct.
The correct answer is: Includes user data

6
Dimensions D1 and D2 are not considered conforming if
Select one:
a. D1 identical to D2
b. D1 and D2 are present on the same server
c. D1 is rolled up subset of D2
d. D1 columns are subset of D2
Feedback
Your answer is correct.
The correct answer is: D1 and D2 are present on the same server

6
A bitmap index is most appropriate on which of these columns
Select one:
a. Date of Birth
b. Name
c. Salary
d. Gender
Feedback
Your answer is correct.
The correct answer is: Gender

7
Difference between Rank and Sort in SQL is
Select one:
a. Rank gives a separate sequence of numbers
b. They are same
c. Sort is based on attribute while Rank is not
d. Sort allows aggregates while Rank does not
Feedback
Your answer is correct.
The correct answer is: Rank gives a separate sequence of numbers

8
The SQL analytical function to divide records into equal sized groups is
Select one:
a. GROUP BY
b. NTILE
c. QUARTILE
d. PERCENTILE
Feedback
Your answer is correct.
The correct answer is: NTILE

9
When were analytic functions introduced in SQL?
Select one:
a. 2011
b. 2003
c. 1992
d. 1999
Feedback
Your answer is correct.
The correct answer is: 2003

10
Summarization for a table is to be done using 4 attributes. How many SQL statements using GROUP BY are required to produce equivalent results?
Select one:
a. 4
b. 8
c. 16
d. 64
Feedback
Your answer is correct.
The correct answer is: 16

11
Which of the following OLAP techniques offers best latency?
Select one:
a. HOLAP
b. MOLAP
c. ROLAP
d. DOLAP
Feedback
Your answer is correct.
The correct answer is: ROLAP

12
A table can not be partitioned by
Select one:
a. Hash
b. Range
c. Rank
d. List
Feedback
Your answer is correct.
The correct answer is: Rank

13
In SQL, what is the difference between GROUP BY and PARTITION BY clauses ?
Select one:
a. SELECT clause
b. Type of attributes
c. WHERE clause
d. They are same.
Feedback
Your answer is correct.
The correct answer is: WHERE clause

14
Which of the following is Apache data warehouse?
Select one:
a. Sqoop
b. Hive
c. Hbase
d. HDFS
Feedback
Your answer is correct.
The correct answer is: Hive

15
Views in SQL are of the type
Select one:
a. Always Virtual
b. Always up-to-date
c. Always Physical
d. Sometimes physical
Feedback
Your answer is correct.
The correct answer is: Sometimes physical

16
Which of the following is NOT a kind of data warehouse application?
Select one:
a. Transaction processing
b. Data mining
c. Information processing
d. Analytical processing
Feedback
Your answer is correct.
The correct answer is: Transaction processing

17
If you have to summarize data as per hierarchy in dimension attributes, which is appropriate SQL clause?
Select one:
a. HAVING
b. ROLLUP
c. SUM
d. WHERE
Feedback
Your answer is correct.
The correct answer is: ROLLUP

18
A Data Mart whose source is directly from transactional systems, legacy applications, or external data feeds
Select one:
a. Intra-entry Data Mart
b. Inter-entry Data Mart
c. Dependent Data Mart
d. Independent Data Mart
Feedback
Your answer is correct.
The correct answer is: Independent Data Mart

19
A ___________ is a table on disk that contains the result set of a query
Select one:
a. View
b. Table
c. Pivot
d. Materialized View
Feedback
Your answer is correct.
The correct answer is: Materialized View

20
Which one is NOT the Codd’s rule for OLAP?
Select one:
a. Intuitive Data Manipulation
b. Consistent Reporting Performance
c. Restricted cross dimensional operation
d. Transparency
Feedback
Your answer is correct.
The correct answer is: Restricted cross dimensional operation