Microstrategy Expert Quiz

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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : C

 
 
4) What types of schemas does MicroStrategy Architect support?

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

Answer : C

 
 
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

Answer : A

 
 
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.

Answer : D

 
 
7) Microstrategy has a robust which model

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

Answer : B

 
 
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

Answer : C

 
 
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

Answer : A

 
 
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

Answer : A




 
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

Answer : D

 
 
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

Answer : C

 
 
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

Answer : A

 
 
14) Report generation method not available in Microstrategy through Schema Objects

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

Answer : D

 
 
15) Hierarchies are grouping of

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

Answer : B

 
 
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

Answer : C

 
 
17) Data mart reports store the report data in

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

Answer : A

 
 
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

Answer : C

 
 
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

Answer : B

 
 
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

Answer : B




 
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

Answer : D

 
 
22) Metric Level allows the following to be specified at the attribute level of the Target

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

Answer : A

 
 
23) Which of these is not an Non Aggregatable metric

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

Answer : B

 
 
24) Transformation Metric is primarily useful for

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

Answer : C

 
 
25) Which of these is not an Passthru function

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

Answer : B

 
 
26) Which is not a type of report filters

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

Answer : A

 
 
27) Custom group editor can include a logical expression containing

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

Answer : A

 
 
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

Answer : B

 
 
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

Answer : A

 
 
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

Answer : C




 
31) You can write customized SQL query with

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

Answer : C

 
 
32) The drill options available in Standard Microstrategy reports include

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

Answer : A

 
 
33) Metric Editor does not have :-

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

Answer : C

 
 
34) which of the following is not a valid type of metric

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

Answer : C

 
 
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

Answer : C

 
 
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

Answer : A

 
 
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

Answer : B

 
 
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

Answer : C

 
 
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

Answer : A

 
 
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

Answer : D




 
41) Calculation of Derived Metric is done by

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

Answer : A

 
 
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

Answer : C

 
 
43) After making any kind of modifications to Schema objects, its required to

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

Answer : C

 
 
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

Answer : D

 
 
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

Answer : B

 
 
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

Answer : C

 
 
47) how to decrease logical size of a logical table

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

Answer : A

 
 
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

Answer : A

 
 
49) which objects are not allowed in a cube

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

Answer : C

 
 
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

Answer : A




 
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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : B

 
 
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

Answer : C

 
 
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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : A

 
 
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

Answer : B

 
 
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

Answer : D

 
 
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

Answer : A

 
 
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

Answer : D

 
 
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

Answer : A