2

___________ is a good alternative to the star schema.
A. Star schema.
B. Snowflake schema.
C. Fact constellation.
D. Star-snowflake schema.
Show Answer

3

Aggregate navigator is based on
Select one:
a. Summary tables
b. Logical Views
c. Indexes
d. Materialized Views
Show Answer
4
MOLAP stores aggregate values in which of the following structure?
Select one:
a. View
b. Table
c. Index
d. Array
Show Answer
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
Show Answer
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
Show Answer
6
A bitmap index is most appropriate on which of these columns
Select one:
a. Date of Birth
b. Name
c. Salary
d. Gender
Show Answer
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
Show Answer
8
The SQL analytical function to divide records into equal sized groups is
Select one:
a. GROUP BY
b. NTILE
c. QUARTILE
d. PERCENTILE
Show Answer
9
When were analytic functions introduced in SQL?
Select one:
a. 2011
b. 2003
c. 1992
d. 1999
Show Answer
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
Show Answer
11
Which of the following OLAP techniques offers best latency?
Select one:
a. HOLAP
b. MOLAP
c. ROLAP
d. DOLAP
Show Answer
12
A table can not be partitioned by
Select one:
a. Hash
b. Range
c. Rank
d. List
Show Answer
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.
Show Answer
14
Which of the following is Apache data warehouse?
Select one:
a. Sqoop
b. Hive
c. Hbase
d. HDFS
Show Answer
15
Views in SQL are of the type
Select one:
a. Always Virtual
b. Always up-to-date
c. Always Physical
d. Sometimes physical
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer
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
Show Answer