> > Analysis MCQs > Microstrategy MCQs

Microstrategy MCQ

____________in MicroStrategy allows you to create any desired view.

None

Relational View

Logical view

View

Answer

Correct Answer: Logical view

Note: This Question is unanswered, help us to find answer for this one

Joint Child in Micsrostrategy is used to handle what type of keys?

Primary key

Composite key

Super key

Foreign key

Answer

Correct Answer: Composite key

Note: This Question is unanswered, help us to find answer for this one

___________ perform various administrative and application development tasks in Microstrategy.

Command manager

Application manager

Development manager

Object manager

Answer

Correct Answer: Command manager

Note: This Question is unanswered, help us to find answer for this one

VLDB is an acronym for:

Very Logical Database property

Very Large Database

Very Large Database properties

Very Large Database property

Answer

Correct Answer: Very Large Database properties

Note: This Question is unanswered, help us to find answer for this one

In case of pass through functions, Microstrategy checks the actual SQL construct before dumping into the database.

True

False

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

When a chosen object already exists in the target project, what action is taken by the object manager?

Opens a conflict resolution dialogue prompting user whether to create the object or overwrite.

It overwrites the existing object.

It displays all dependent parent and child objects of any chosen report object

Creates a new object

Answer

Correct Answer: Opens a conflict resolution dialogue prompting user whether to create the object or overwrite.

Note: This Question is unanswered, help us to find answer for this one

Which option allows you to track changes to objects?

Change option

Change Journaling option

Object track option

Track changes option

Answer

Correct Answer: Change Journaling option

Note: This Question is unanswered, help us to find answer for this one

Is there a difference between Report Limit and Report Filter?

Yes

Answer

Correct Answer: Yes

Note: This Question is unanswered, help us to find answer for this one

Microstrategy supports both ROLAP and MOLAP:

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

_________ type of filtering raises the report filter to the level of the target.

None

Absolute filtering

Standard filtering

Ignore filtering

Answer

Correct Answer: Absolute filtering

Note: This Question is unanswered, help us to find answer for this one

_________ Tables contain data on the MicroStrategy system’s usage and performance.

Statistics

Usage

Factor

Performance

Answer

Correct Answer: Statistics

Note: This Question is unanswered, help us to find answer for this one

What is the advantage of consolidation?

None

It is ordered collection of elements that grouping of data in new ways

It allows grouping of data in new ways without changing the metadata and warehouse definitions.

It is set of special filters that can be placed on a template

Answer

Correct Answer: It allows grouping of data in new ways without changing the metadata and warehouse definitions.

Note: This Question is unanswered, help us to find answer for this one

What ensures that object definitions are kept consistent and accurate across all environments when objects are migrated from a testing environment to a production environment.

None

Object manager

Migration manager

Environment manager

Answer

Correct Answer: Object manager

Note: This Question is unanswered, help us to find answer for this one

Microstrategy allows reporting on:

Multidimensional data base

None

Flat file

Relational database

Answer

Correct Answer: Relational database

Note: This Question is unanswered, help us to find answer for this one

Which of the following are valid types of caches?

HTML cache

Performance cache

Matching caches

Object cache

Answer

Correct Answer: Matching caches

Note: This Question is unanswered, help us to find answer for this one