Microstrategy Quiz
Microstrategy Quiz : This Microstrategy Intermediate Quiz contains set of 60 Microstrategy Quiz which will help to clear any exam which is designed for Intermediate.
1) The feature that allows user or group in Microstrategy system to a specific login ID on the Data Warehouse RDBMS is called
- Connection mapping
- database instance
- Database Connection
- Metadata Connection
2) ___________________ enables you to control at Microstrategy level, what warehouse data users can see
- Report Filter
- Metric Filter
- Security Filter
- Prompts
3) The process of logging and analyzing operation and performance information is known as _____________________
- Diagnostics
- Performance Tuning
- Debugging
- Event viewer
4) The calculations associated with a consolidation are done by
—————————- component of Intelligence Server.
- Analytical Engine
- Query Engine
- SQL Engine
- Buses
5) Upto how many SQL passes may be needed for all consolidation elements
- One
- Five
- Three
- Two
6) What comprises the Microstrategy Engine?
- The SQL Engine
- The Query Engine
- The Analytical Engine
- All
7) Which of the following Microstrategy objects is Schema objects
- Filter
- Prompt
- Attribute
- Drill Map
8) Which of the following Report Type WILL NOT BE EXPORTED ACCURATELY to Excel from Desktop?
- Grid Report
- Graph Report
- Grid & Graph Report
- Both (A & B)
9) Report objects section in Report contains
- List of all objects in Project
- List of all the Objects selected for report
- List of Objects placed in Grid
- List of all Objects in I cube
10) Which of the following filter DO NOT modify SQL of the report
- View Filter
- Report Filter
- Report Limit
- Nested Filter
11) Which of the following option “Enables to select and display subsets of report results as separate pages”
- Subtotals
- Autostyle
- Thresholds
- Page-by
12) Which of the following type of prompt allows to select Microstrategy objects to include in a report
- Value Prompt
- Hierarchical Prompt
- Level Prompt
- Object Prompt
13) A _________ that specifies a set of criteria used to restrict the data returned in the report data set after the report metrics are calculated
- Report limit
- Report Filter
- View Filter
- Prompts
14) A _____ is an additional filter applied in memory to the report data set and affects only the view definition
- Report Filter
- Prompt
- View filter
- Template
15) __________ are made up of other metrics, which
could be simple, nested, or other compound metrics
- Compound metrics
- Compound Attributes
- Simple Metrics
- Smart Metrics
16) A Microstrategy _________ contains objects representing data coming from one or more reports
- Freeform SQL
- Template
- Report services document
- OLAP
17) HTML Documents in the Microstrategy platform, formerly known as
- Documents
- Templates
- Reports
- Drill Maps
18) In a project by default ‘Metrics’ Folder will be available in
- Public Objects
- Schema Objects
- My Personal Objects
- Profiles
19) _______ are used for time-series analysis,
to compare values at different times such as Current versus last year.
- Templates
- Attributes
- Transformations
- Prompts
20) _________ are built-in prompts that are created when the project is created
- Value Prompt
- Object Prompt
- System prompt
- Element Prompt
21) _________ project can be accessed from Microstrategy Web
- One tier
- Two tier
- Three tier
- Four tier
22) A _______ is a report result set that is saved on Microstrategy Intelligence Server
- Report cache
- Element cache
- Object Cache
- Database Cache
23) In a Filter ______ defines the set of data that this qualification contributes to the filter as a whole
- Metric
- Output level
- Attribute
- Custom Group
24) Which of the following is a project default Autostyle
- Green Leaves
- Red Carpet
- Woody Look
- Finance
25) Dashboards and Scorecards can be created using
- Reports
- Templates
- Drill Maps
- Report Services document
26) In Desktop a report sql of a opened report can be viewed by selecting
- View -> Sql view
- View -> Grid view
- View -> Graph view
- View->Graph
27) _____ helps in creating a report in Microstrategy
- Report Wizard
- Prompt Wizard
- Project Wizard
- Metric Wizard
28) ______ determine the options available to an end user when drilling on a report
- Template
- Hierarchy
- Drill maps
- Filter
29) Which of the following object is not a ‘Public Object’
- Metric
- Report
- Filter
- Hierarchy
30) Sorting is processed by _______________
- Analytical Engine
- Execution Engine
- SQL Engine
- Metric Wizard
31) Customizing the Microstrategy products or developing custom applications with ____________
- Microstrategy Desktop
- Microstrategy SDK
- Microstrategy Web
- Microstrategy ODBC tool
32) A project source represents a connection to a ______________________
- Database
- Warehouse
- Metadata
- I Cube
33) To view project on Microstrategy Web, it must be connected to an _________ that has the project loaded
- Narrowcast Server
- Distribution Manager
- Intelligence Server
- Clustered Servers
34) In Narrowcast, _____ is a container that holds a set of questions that users answer to define their preferences
- Schedule
- Answer Object
- Subscription Set
- Question object
35) In Narrowcast, _____ stores all subscribers data,
including end users, addresses, personalization, and subscription sets.
- Subscription Book Repository
- Document
- Device
- Locale
36) In Narrowcast, an _____ is a set of instructions specifying how to get data from an external information source
- Report
- Intelligence server
- Template
- Information object
37) In Narrowcast, a _____ sets the times or frequencies a service is executed and represents a recurrence pattern
- Service
- Device
- Schedule
- Trigger
38) Element caches are stored
- Only in memory
- Only on disk
- A and B
- in Datawarehouse
39) Microstrategy Intelligence Server integrates with SAP BW by using SAP’s OLAP
- BAPI (Business Application Programming Interface)
- Free Form SQL
- MDX(Multidimensional Expression)
- A and C
40) Which one is not part of 3 tier environment
- Client
- Web server
- Iserver
- Data Warehouse
41) ________________ is powerful tool that allows reporting from a platform independent architecture
- Microstrategy Web
- Microstrategy Web Universal
- Microstrategy Desktop
- Microstrategy Architect
42) Following is not a valid format of reporting are available in Microstrategy
- Standard Reports
- Report Services Document
- PowerPoint Presentation Format
- HTML Documents
43) Microstrategy reports cannot be exported to following formats:-
- MS EXCEL
- Text File
- IBM DB2
44) View Filters and Report objects Windows is only available with
- Microstrategy Narrowcast Services
- Microstrategy OLAP Services
- Microstrategy Intelligence Server
- Microstrategy PDF output files.
45) ______ allows you to run, edit, and format Microstrategy reports and documents in Microsoft office applications like PowerPoint, Word, etc.,
- Microstrategy Office
- Microsoft Office
- Microstrategy Web
- Front Office
46) If you are not able move objects such as titles or the graph legend on your graph, then you need to enable
- Manual Layout Mode
- Automatic Layout Mode
- Dynamic Layout Mode
- Design View
47) In Narrowcast each means of delivering a message (via email, mobile, etc.,) is known as
- Delivery method
- User
- Report
- Subscriptions
48) Command Manager can be used for making changes to
- MSTR Security
- reports for Governing & Tuning of MSTR environment
- Project Management
- Report Scheduling
49) In Narrowcast, A _____ defines who receives a particular service.
- Schedule
- Subscription set
- XML file
- Information object
50) Which feature is used to migrate MSTR objects between different environments
- Enterprise Manager
- Project Merge
- Object Manager
- B&C
51) Microstrategy Command Manager lets you perform various administrative and application development tasks. Which of the following tasks cannot be performed using Command Manager:-
- Server Management
- User Management
- Report Creation commands
- Database Management
52) Putting user specific restrictions at the database end and using user specific connection mapping is called
- Column level security
- Row level security
- Report level Security
- Role based security
53) Which of the following cannot be set as a rule for Microstrategy password
- The minimum number of characters that the password must contain
- The minimum number of upper-case characters that the password must contain
- The minimum number of special characters, that is, symbols, that the password must contain
- The max number of repeated characters in a password
54) how to create a joint element list
- using advance prompt
- using advance filter qualification
- using advance mteric
- using smart metrics
55) which MicroStrategy tool is used for project merge
- object manager
- integrity manager
- enterprise manager
- license manager
56) how to stop the drilling option in ia report
- using report data option
- using pass throgh function
- not possible
- click on stop
57) how many minimum metrics required to use a microchart widget
- 3
- 5
- 7
- 9
58) which widget is used to show multiple metrics/KPIs
- Heatmap
- microchart
- googlemap
- bubble