2

___________ is a good alternative to the star schema.
A. Star schema.
B. Snowflake schema.
C. Fact constellation.
D. Star-snowflake schema.
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Fact constellation.[/bg_collapse]

3

Aggregate navigator is based on
Select one:
a. Summary tables
b. Logical Views
c. Indexes
d. Materialized Views
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Materialized Views[/bg_collapse]
4
MOLAP stores aggregate values in which of the following structure?
Select one:
a. View
b. Table
c. Index
d. Array
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Array[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Includes user data[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: D1 and D2 are present on the same server[/bg_collapse]
6
A bitmap index is most appropriate on which of these columns
Select one:
a. Date of Birth
b. Name
c. Salary
d. Gender
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Gender[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Rank gives a separate sequence of numbers[/bg_collapse]
8
The SQL analytical function to divide records into equal sized groups is
Select one:
a. GROUP BY
b. NTILE
c. QUARTILE
d. PERCENTILE
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: NTILE[/bg_collapse]
9
When were analytic functions introduced in SQL?
Select one:
a. 2011
b. 2003
c. 1992
d. 1999
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: 2003[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: 16 [/bg_collapse]
11
Which of the following OLAP techniques offers best latency?
Select one:
a. HOLAP
b. MOLAP
c. ROLAP
d. DOLAP
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: ROLAP[/bg_collapse]
12
A table can not be partitioned by
Select one:
a. Hash
b. Range
c. Rank
d. List
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Rank[/bg_collapse]
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.
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: WHERE clause[/bg_collapse]
14
Which of the following is Apache data warehouse?
Select one:
a. Sqoop
b. Hive
c. Hbase
d. HDFS
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Hive[/bg_collapse]
15
Views in SQL are of the type
Select one:
a. Always Virtual
b. Always up-to-date
c. Always Physical
d. Sometimes physical
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Sometimes physical[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Transaction processing[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: ROLLUP[/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Independent Data Mart [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Materialized View [/bg_collapse]
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
[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ] Feedback
Your answer is correct.
The correct answer is: Restricted cross dimensional operation [/bg_collapse]