1.
Microstrategy supports both ROLAP and MOLAP
a) True
b) False
2.
Which of the following are valid types of caches
?
a.
Matching caches
b.
HTML
caches
c.
Performance caches
d.
Object cache
3.
In case of pass through functions , Micro
strategy checks the actual SQL construct before dumping into the database.
a)
True
b)
False
4.
Joint Child in Micro strategy is used to handle
what type of keys?
a)
Primary
key
b)
Foreign
key
c)
Composite key
d)
Super key
5.
_____________________in the microstrategy allows
you to create any desired view .
a)
View
b)
Logical view
c)
Relational View
d)
Both a and b
6.
Which allows you to track the changes to objects
?
a)
Change Journaling option
b)
Change option
c)
Track changes option
d)
Object track option
7.
What ensure that object definitions are kept
consistent and accurate across all
environments when objects are migrated from a testing environment to a
production environment.
a)
Migration manager
b)
Environment manager
c)
Both a and c
d)
Object manager
8.
When a chosen object already exists in the
target project, what action is taken by the object manager?
a)
It overwrites the existing object.
b)
Creates a new object
c)
It displays all dependent parent and child
objects of any chosen report object
d)
Opens a conflict resolution dialogue prompting
user whether to create the object or overwrite.
9.
___________perform various administrative and
application development task in micro strategy?
a)
Command manager
b)
Object manager
c)
Application manager
d)
Development manager
10.
______________type of filtering raises the
report filter to level of the target.
a)
Standard filtering
b)
Ignore filtering
c)
Absolute filtering
d)
Both a and b
11. Micro strategy allows reporting on
a)
Relational database
b)
Flat file
c)
Multidimensional data base
d)
All of the above
12.
_____________________tables contain data on the
microstrategy system’s usage and performance .
a)
Usage
b)
Factor
c)
Performance
d)
Statistics
13.
Is there a difference between Report Limit and
Report filter?
a)
Yes
b)
No
14.
VLDB is an acronym for
a)
Very Large Database
b)
Very Large Database property
c)
Very Large Database properties
d)
Very Logical Database property
Answers :
1.
A
2.
A
3.
B
4.
C
5.
B
6.
A
7.
D
8.
D
9.
A
10.
C
11.
D
12.
D
13.
A
14.
C
|
Comments