Microstrategy Expert Quiz

Posted on: | By: – Comments Off

Microstrategy Quiz

Microstrategy Quiz : This Microstrategy Expert Quiz contains set of 60 Microstrategy Quiz which will help to clear any exam which is designed for Expert.



1) _______  allow facts stored in the data
warehouse at one level to be reported at an unrelated
level.

  1. Fact extensions
  2. Table extensions
  3. Attribute extensions
  4. Compound Metric

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
2) In a _______ relationship each element in the parent attribute has one and only one corresponding element in the child attribute

  1. One-to-one
  2. One-to-Many
  3. Many-to-Many
  4. Many-to-one

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
3) In a ______ relationship each element in the parent attribute can have multiple children and each child element in the child attribute can have multiple parents

  1. Many-to-one
  2. One-to-Many
  3. Many-to-Many
  4. One-to-one

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
4) What types of schemas does MicroStrategy Architect support?

  1. Star Schema
  2. Snowflake Schema
  3. A&B
  4. Database Schema

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
5) ___________________ is a MicroStrategy object appearing in the system layer and usable across multiple projects. These include these object types: users, database instances, database login
IDs, schedules.

  1. Configuration Objects
  2. Consolidations
  3. Public Objects
  4. Project Objects

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
6) To support database-level partitioning in microstrategy you need to enable

  1. Application Partitioning
  2. Configuration Objects
  3. VLDB setting changes
  4. No changes need to be done.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
7) Microstrategy has a robust which model

  1. Multidimensional OLAP
  2. Relational OLAP
  3. Hybrid OLAP
  4. OLAP

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
8) What is factless fact

  1. some facts lying in the fact table without connecting to any of the dimension table
  2. Fact table connected to dimension tables with NULL values in it
  3. Fact table connected to dimension tables without any fact values in it
  4. Fact table connected to dimension tables with fact values in it

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
9) Which type of Slowly Changing Dimension (SCD) will have no history data

  1. Type 1
  2. Type 2
  3. Type 3
  4. A&C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
10) Collection of privileges that are assigned to users and groups and can be reused from project to project  is called

  1. Security Role
  2. Security Filter
  3. Access Control List
  4. Group

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
11) The concept of _________  is to hold a copy of the report data saved in memory and used for manipulation of the view definition

  1. MS OLAP Cube
  2. Report Wizard
  3. Report filter
  4. Intelligent Cube

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
12) Intelligent cubes are a result set stored in the memory of

  1. Intelligence Server
  2. Desktop Client
  3. Both A & B
  4. Command manager

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
13) Which of the following is not a advantage of Intelligent cube

  1. Decreased Traffic to I server
  2. Decreased Traffic to Database
  3. Increased performance
  4. Scalability

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
14) Report generation method not available in Microstrategy through Schema Objects

  1. General Reports
  2. Intelligent Cubes
  3. ODBC Sources
  4. Stored Procedures

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
15) Hierarchies are grouping of

  1. Metrics
  2. Attributes
  3. Filters
  4. Public Objects

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
16) Logical data model is an arrangement of data from the perspective of

  1. Technical User
  2. Database Admin
  3. Business User
  4. Project Manager

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
17) Data mart reports store the report data in

  1. Database
  2. Application Cache
  3. Database cache
  4. Logical views

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
18) A type of fact extension in which values at one level of aggregation are reported at a second, lower attribute level

  1. Aggregation
  2. Fact Dimensionality
  3. Degradation
  4. Compression ratio

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
19) Named sets of attributes and their relationships, arranged in specific sequences for a logical business organization is known as

  1. System Hierarchy
  2. User hierarchy
  3. Attribute elements
  4. Drill Hierarchy

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
20) At runtime, whenever the display level of data on a report must differ from the level at which it is initially captured,______________must occur

  1. Pre-Aggregation
  2. Aggregation
  3. Compression
  4. Degradation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]



 
21) Smart Metric can be defined as

  1. It allows combining one or more metric objects with one or more mathematical operators
  2. It allows for creation of metric on the fly
  3. Allows you to compute metric values at page by level.
  4. It changes the manner in which its metric value, including subtotals, are calculated

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
22) Metric Level allows the following to be specified at the attribute level of the Target

  1. Grouping
  2. Threshholding
  3. Prompting
  4. Drilling

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
23) Which of these is not an Non Aggregatable metric

  1. Bank Balance
  2. Revenue
  3. Stock Price
  4. Inventory level

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
24) Transformation Metric is primarily useful for

  1. Product Analysis
  2. Geography Analysis
  3. Time Series Analysis
  4. Dimensional Analysis

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
25) Which of these is not an Passthru function

  1. ApplySimple
  2. ApplyComplex
  3. ApplyAgg
  4. ApplyLogic

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
26) Which is not a type of report filters

  1. View Filter
  2. Report as filter
  3. Filter Qualification
  4. Attribute Form Qualification

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
27) Custom group editor can include a logical expression containing

  1. Report Object
  2. Tables
  3. Random Charts
  4. Panels

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
28) A custom group element can also use combinations of any of the components listed above, except

  1. Set qualification
  2. custom group banding qualifications
  3. Report object
  4. Filter object

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
29) Rearranging the columns and rows in a report so that you get better perspective is

  1. Data Pivoting
  2. View Filters
  3. Filter Editing
  4. Drilling Down

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
30) Page by allows you to create subsets of data grouped by specific data elements. Which of these is not a valid object for page by

  1. Metric
  2. Hierarchy
  3. Filter
  4. Attributes

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]



 
31) You can write customized SQL query with

  1. Query Builder
  2. Metric Builder
  3. Free Form SQL Report
  4. Standard report

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
32) The drill options available in Standard Microstrategy reports include

  1. Drill Up
  2. Drill over
  3. Drill middle
  4. Drill East

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
33) Metric Editor does not have :-

  1. Formula Tab
  2. Subtotal Tab
  3. Attribute Tab
  4. Data Tab

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
34) which of the following is not a valid type of metric

  1. Derived Metric
  2. Simple Metric
  3. Pivot Metric
  4. Nested Metric

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
35) To set a drill path as the default, the priority setting for the drill path should be set to

  1. Low
  2. Medium
  3. High
  4. Default

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
36) Which of the following is not a level of Drill Map association

  1. Database Level
  2. Project Level
  3. Report Level
  4. Grid unit level

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
37) While logical tables are set up in a project by using the Warehouse Catalog, logical views are created using

  1. View Editor
  2. Table Editor
  3. Warehouse Catalog
  4. Attributes

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
38) The common modeling scenarios that are easier to manage with the use of logical views

  1. Slowly-changing dimensions
  2. Recursive Hierarchies
  3. A&B
  4. Conceptual Modelling

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
39) Which of the following servers needs to be running to access a 3tier project from Desktop

  1. Intelligence Server
  2. Narrowcast Server
  3. Transact or
  4. No server is required to access 3 tier project

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
40) In Narrowcast, an _____ is a set of instructions specifying how to get data from an external information source

  1. Report
  2. Intelligence server
  3. Template
  4. Information object

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



 
41) Calculation of Derived Metric is done by

  1. Intelligence Server
  2. Database
  3. Narrowcast Server
  4. Analytical Engine

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
42) _______________specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are calculated.

  1. Report Filter
  2. Report Prompt
  3. Report Limit
  4. VLDB Property

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
43) After making any kind of modifications to Schema objects, its required to

  1. Reload Project
  2. Update Table
  3. Update Schema
  4. Refresh

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
44) In ‘Update Schema’ selecting “Recalculate table logical sizes” will

  1. override any modifications that are made to Database
  2. override any modifications that are made to Facts
  3. override any modifications that are made to logical schema size
  4. override any modifications that are made to logical table sizes and recalculate these logical sizes

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
45) Setting the metric join type at the metric level affects the results for

  1. only the results for the report being modified.
  2. all reports using that metric
  3. All prompts that have the metric in the report
  4. All Filters which use the metric in report

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
46) The ______ is the default hierarchy that Microstrategy sets up for you each time you create a project

  1. Schema Hierarchy
  2. User hierarchy
  3. System hierarchy
  4. Drillup Hierarchy

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
47) how to decrease logical size of a logical table

  1. manually
  2. reucing data volume
  3. not possible
  4. drop the table

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
48) how to  brake the M to M relationship

  1. using bridge tables
  2. using facts in metrics
  3. using compound attributes
  4. using None in metrics

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
49) which objects are not allowed in a cube

  1. Attributes in a hierarchy
  2. Metrics
  3. prompts
  4. Consolidation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
50) how to refresh a cube at backend

  1. using subscriptions
  2. running the cube manually
  3. not possible
  4. Press refresh button in IE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
51) how to configure data mart report

  1. at report level
  2. at project configuration level
  3. at project source configuration level
  4. at Database level

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
52) what is dynamic sourcing

  1. pulling data from multiple cubes
  2. pulling data from multiple reports
  3. pulling data from multiple facts
  4. Pulling data from multiple datasets

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
53) which feature allows to pull diffent databases table in datawarehouse catalogue  of a project

  1. dynamic sourcing
  2. multi sourcing
  3. dynamic aggregation
  4. Fact Degradation

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
54) whar are the differnet type of projectsource can be configured in MicroStrategy

  1. 4-tier
  2. 1-tier
  3. 3-tier
  4. 2 tier

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
55) how to disable the dynamic sourcing feature of a cube based report

  1. through report data option
  2. detach drillmaps
  3. not possible
  4. Autostyles

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
56) how to enable the Weburl to connect to the iServer

  1. creating trusted token
  2. configuring the iserver
  3. configuring project source
  4. configuring project

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
57) how to pull the procedures and functions in MSTR project

  1. using transaction services
  2. updating warehouse catalogue
  3. connecting directly
  4. through database mapping

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
58) While logical tables are set up in a project by using the Warehouse Catalog, logical views are created using

  1. View Editor
  2. Table Editor
  3. Warehouse Catalog
  4. Table Alais

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
59) The common modeling scenarios that are easier to manage with the use of logical views

  1. Pre Aggregation
  2. Dynamic Relationships
  3. A&B
  4. Snowflake and Star Schema Modelling

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
60) How will Project Sources be configured in MSTR Office

  1. By editing the projectsources.xml
  2. By creating a new projectsource.xml
  3. By creating a new project source in Microsoft Excel
  4. By creating a new project source in Microstrategy Desktop

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
61) Filter definition prompt encompasses four different prompt types. Please select the incorrect option:-

  1. Attributes in a hierarchy
  2. Attribute Forms
  3. Metrics
  4. Hierarchy

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
62) The value chosen by the user in a Value prompt can be compared against

  1. Attribute element values
  2. Hierarchy
  3. Configuration object
  4. Report ID

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]



 
 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz