Microstrategy BI Testing | Mock Test
1
A dashboard is
a. Repository holding the definitions of the data structures in a database
b. Central repository for all or significant parts of the data collected by the various business systems of an enterprise.
c. A visual display of the most important information needed to achieve one or more objectives.
d. Compound
2
All users can access the same Intelligent Cube data is defined as
a. Cart Style
b. Non-Cart Style
c. Intelligent Cube Sharing
d. neither MOLAP nor ROLAP
3
An attribute which is made up of one or more expressions in Micro strategy desktop. With this definition, you can define an attribute as a column, constant, or simple expression. This attribute is known as:
a. Simple
b. Implicit
c. Derived
d. Nested Metric
4
Microstrategy supports
a. Both ROLAP and MOLAP
b. Only MOLAP
c. Only ROLAP
d. Collection Objects, Metric Objects and RDBMS Objects
5
which of the following is not a valid type of metric
a. Derived Metric
b. Simple Metric
c. Pivot Metric
d. Fact table connected to dimension tables with fact values in it
6
What are different kinds of objects in Microstrategy
a. Configuration Objects, Schema Objects and Public Objects
b. Collection Objects and RDMBS Object
c. Reports Metrics Objects and RDBMS Objects
d. Update
7
What is factless fact
a. some facts lying in the fact table without connecting to any of the dimension table
b. Fact table connected to dimension tables with NULL values in it
c. Fact table connected to dimension tables without any fact values in it
d. Logical Cubes
8
Which is not a DDL statement from the following?
a. Create Table
b. Create Database
c. Alter
d. Object track option
9
Which of these is not a type of logical tables in the MicroStrategy environment
a. Logical tables
b. Logical Views
c. Logical Aliases
d. Logical Cubes
10
Which option allows you to track changes to objects?
a. Change Journaling option
b. Change option
c. Track changes option
d. Object track option
