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.
- Fact extensions
- Table extensions
- Attribute extensions
- Compound Metric
2) In a _______ relationship each element in the parent attribute has one and only one corresponding element in the child attribute
- One-to-one
- One-to-Many
- Many-to-Many
- Many-to-one
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
- Many-to-one
- One-to-Many
- Many-to-Many
- One-to-one
4) What types of schemas does MicroStrategy Architect support?
- Star Schema
- Snowflake Schema
- A&B
- Database Schema
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.
- Configuration Objects
- Consolidations
- Public Objects
- Project Objects
6) To support database-level partitioning in microstrategy you need to enable
- Application Partitioning
- Configuration Objects
- VLDB setting changes
- No changes need to be done.
7) Microstrategy has a robust which model
- Multidimensional OLAP
- Relational OLAP
- Hybrid OLAP
- OLAP
8) What is factless fact
- some facts lying in the fact table without connecting to any of the dimension table
- Fact table connected to dimension tables with NULL values in it
- Fact table connected to dimension tables without any fact values in it
- Fact table connected to dimension tables with fact values in it
9) Which type of Slowly Changing Dimension (SCD) will have no history data
- Type 1
- Type 2
- Type 3
- A&C
10) Collection of privileges that are assigned to users and groups and can be reused from project to project is called
- Security Role
- Security Filter
- Access Control List
- Group
11) The concept of _________ is to hold a copy of the report data saved in memory and used for manipulation of the view definition
- MS OLAP Cube
- Report Wizard
- Report filter
- Intelligent Cube
12) Intelligent cubes are a result set stored in the memory of
- Intelligence Server
- Desktop Client
- Both A & B
- Command manager
13) Which of the following is not a advantage of Intelligent cube
- Decreased Traffic to I server
- Decreased Traffic to Database
- Increased performance
- Scalability
14) Report generation method not available in Microstrategy through Schema Objects
- General Reports
- Intelligent Cubes
- ODBC Sources
- Stored Procedures
15) Hierarchies are grouping of
- Metrics
- Attributes
- Filters
- Public Objects
16) Logical data model is an arrangement of data from the perspective of
- Technical User
- Database Admin
- Business User
- Project Manager
17) Data mart reports store the report data in
- Database
- Application Cache
- Database cache
- Logical views
18) A type of fact extension in which values at one level of aggregation are reported at a second, lower attribute level
- Aggregation
- Fact Dimensionality
- Degradation
- Compression ratio
19) Named sets of attributes and their relationships, arranged in specific sequences for a logical business organization is known as
- System Hierarchy
- User hierarchy
- Attribute elements
- Drill Hierarchy
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
- Pre-Aggregation
- Aggregation
- Compression
- Degradation
21) Smart Metric can be defined as
- It allows combining one or more metric objects with one or more mathematical operators
- It allows for creation of metric on the fly
- Allows you to compute metric values at page by level.
- It changes the manner in which its metric value, including subtotals, are calculated
22) Metric Level allows the following to be specified at the attribute level of the Target
- Grouping
- Threshholding
- Prompting
- Drilling
23) Which of these is not an Non Aggregatable metric
- Bank Balance
- Revenue
- Stock Price
- Inventory level
24) Transformation Metric is primarily useful for
- Product Analysis
- Geography Analysis
- Time Series Analysis
- Dimensional Analysis
25) Which of these is not an Passthru function
- ApplySimple
- ApplyComplex
- ApplyAgg
- ApplyLogic
26) Which is not a type of report filters
- View Filter
- Report as filter
- Filter Qualification
- Attribute Form Qualification
27) Custom group editor can include a logical expression containing
- Report Object
- Tables
- Random Charts
- Panels
28) A custom group element can also use combinations of any of the components listed above, except
- Set qualification
- custom group banding qualifications
- Report object
- Filter object
29) Rearranging the columns and rows in a report so that you get better perspective is
- Data Pivoting
- View Filters
- Filter Editing
- Drilling Down
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
- Metric
- Hierarchy
- Filter
- Attributes
31) You can write customized SQL query with
- Query Builder
- Metric Builder
- Free Form SQL Report
- Standard report
32) The drill options available in Standard Microstrategy reports include
- Drill Up
- Drill over
- Drill middle
- Drill East
33) Metric Editor does not have :-
- Formula Tab
- Subtotal Tab
- Attribute Tab
- Data Tab
34) which of the following is not a valid type of metric
- Derived Metric
- Simple Metric
- Pivot Metric
- Nested Metric
35) To set a drill path as the default, the priority setting for the drill path should be set to
- Low
- Medium
- High
- Default
36) Which of the following is not a level of Drill Map association
- Database Level
- Project Level
- Report Level
- Grid unit level
37) While logical tables are set up in a project by using the Warehouse Catalog, logical views are created using
- View Editor
- Table Editor
- Warehouse Catalog
- Attributes
38) The common modeling scenarios that are easier to manage with the use of logical views
- Slowly-changing dimensions
- Recursive Hierarchies
- A&B
- Conceptual Modelling
39) Which of the following servers needs to be running to access a 3tier project from Desktop
- Intelligence Server
- Narrowcast Server
- Transact or
- No server is required to access 3 tier project
40) In Narrowcast, an _____ is a set of instructions specifying how to get data from an external information source
- Report
- Intelligence server
- Template
- Information object
41) Calculation of Derived Metric is done by
- Intelligence Server
- Database
- Narrowcast Server
- Analytical Engine
42) _______________specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are calculated.
- Report Filter
- Report Prompt
- Report Limit
- VLDB Property
43) After making any kind of modifications to Schema objects, its required to
- Reload Project
- Update Table
- Update Schema
- Refresh
44) In ‘Update Schema’ selecting “Recalculate table logical sizes” will
- override any modifications that are made to Database
- override any modifications that are made to Facts
- override any modifications that are made to logical schema size
- override any modifications that are made to logical table sizes and recalculate these logical sizes
45) Setting the metric join type at the metric level affects the results for
- only the results for the report being modified.
- all reports using that metric
- All prompts that have the metric in the report
- All Filters which use the metric in report
46) The ______ is the default hierarchy that Microstrategy sets up for you each time you create a project
- Schema Hierarchy
- User hierarchy
- System hierarchy
- Drillup Hierarchy
47) how to decrease logical size of a logical table
- manually
- reucing data volume
- not possible
- drop the table
48) how to brake the M to M relationship
- using bridge tables
- using facts in metrics
- using compound attributes
- using None in metrics
49) which objects are not allowed in a cube
- Attributes in a hierarchy
- Metrics
- prompts
- Consolidation
50) how to refresh a cube at backend
- using subscriptions
- running the cube manually
- not possible
- Press refresh button in IE
51) how to configure data mart report
- at report level
- at project configuration level
- at project source configuration level
- at Database level
52) what is dynamic sourcing
- pulling data from multiple cubes
- pulling data from multiple reports
- pulling data from multiple facts
- Pulling data from multiple datasets
53) which feature allows to pull diffent databases table in datawarehouse catalogue of a project
- dynamic sourcing
- multi sourcing
- dynamic aggregation
- Fact Degradation
54) whar are the differnet type of projectsource can be configured in MicroStrategy
- 4-tier
- 1-tier
- 3-tier
- 2 tier
55) how to disable the dynamic sourcing feature of a cube based report
- through report data option
- detach drillmaps
- not possible
- Autostyles
56) how to enable the Weburl to connect to the iServer
- creating trusted token
- configuring the iserver
- configuring project source
- configuring project
57) how to pull the procedures and functions in MSTR project
- using transaction services
- updating warehouse catalogue
- connecting directly
- through database mapping
58) While logical tables are set up in a project by using the Warehouse Catalog, logical views are created using
- View Editor
- Table Editor
- Warehouse Catalog
- Table Alais
59) The common modeling scenarios that are easier to manage with the use of logical views
- Pre Aggregation
- Dynamic Relationships
- A&B
- Snowflake and Star Schema Modelling
60) How will Project Sources be configured in MSTR Office
- By editing the projectsources.xml
- By creating a new projectsource.xml
- By creating a new project source in Microsoft Excel
- By creating a new project source in Microstrategy Desktop
61) Filter definition prompt encompasses four different prompt types. Please select the incorrect option:-
- Attributes in a hierarchy
- Attribute Forms
- Metrics
- Hierarchy
62) The value chosen by the user in a Value prompt can be compared against
- Attribute element values
- Hierarchy
- Configuration object
- Report ID