Microstrategy Intermediate Quiz

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

  1. Connection mapping
  2. database instance
  3. Database Connection
  4. Metadata Connection

Answer : A

 
 
2) ___________________ enables you to control at Microstrategy level, what warehouse data users can see

  1. Report Filter
  2. Metric Filter
  3. Security Filter
  4. Prompts

Answer : C

 
 
3) The process of logging and analyzing operation and performance information is known as _____________________

  1. Diagnostics
  2. Performance Tuning
  3. Debugging
  4. Event viewer

Answer : A

 
 
4) The calculations associated with a consolidation are done by
—————————- component of Intelligence Server.

  1. Analytical Engine
  2. Query Engine
  3. SQL Engine
  4. Buses

Answer : A

 
 
5) Upto how many SQL passes may be needed for all consolidation elements

  1. One
  2. Five
  3. Three
  4. Two

Answer : A

 
 
6) What comprises the Microstrategy Engine?

  1. The SQL Engine
  2. The Query Engine
  3. The Analytical Engine
  4. All

Answer : D

 
 
7) Which of the following Microstrategy objects is Schema objects

  1. Filter
  2. Prompt
  3. Attribute
  4. Drill Map

Answer : C

 
 
8) Which of the following Report Type WILL NOT BE EXPORTED ACCURATELY to Excel from Desktop?

  1. Grid Report
  2. Graph Report
  3. Grid & Graph Report
  4. Both (A & B)

Answer : C

 
 
9) Report objects section in Report contains

  1. List of all objects in Project
  2. List of all the Objects selected for report
  3. List of Objects placed in Grid
  4. List of all Objects in I cube

Answer : B

 
 
10) Which of the following filter DO NOT modify SQL of the report

  1. View Filter
  2. Report Filter
  3. Report Limit
  4. Nested Filter

Answer : A




 
11) Which of the following option “Enables to select and display subsets of report results as separate pages”

  1. Subtotals
  2. Autostyle
  3. Thresholds
  4. Page-by

Answer : D

 
 
12) Which of the following type of prompt allows to select Microstrategy objects to include in a report

  1. Value Prompt
  2. Hierarchical Prompt
  3. Level Prompt
  4. Object Prompt

Answer : D

 
 
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

  1. Report limit
  2. Report Filter
  3. View Filter
  4. Prompts

Answer : A

 
 
14) A _____ is an additional filter applied in memory to the report data set and affects only the view definition

  1. Report Filter
  2. Prompt
  3. View filter
  4. Template

Answer : C

 
 
15) __________ are made up of other metrics, which
could be simple, nested, or other compound metrics

  1. Compound metrics
  2. Compound Attributes
  3. Simple Metrics
  4. Smart Metrics

Answer : A

 
 
16) A Microstrategy _________  contains objects representing data coming from one or more reports

  1. Freeform SQL
  2. Template
  3. Report services document
  4. OLAP

Answer : C

 
 
17) HTML Documents in the Microstrategy platform, formerly known as

  1. Documents
  2. Templates
  3. Reports
  4. Drill Maps

Answer : A

 
 
18) In a project by default ‘Metrics’ Folder will be available in

  1. Public Objects
  2. Schema Objects
  3. My Personal Objects
  4. Profiles

Answer : A

 
 
19) _______ are used for time-series analysis,
to compare values at different times such as Current versus last year.

  1. Templates
  2. Attributes
  3. Transformations
  4. Prompts

Answer : C

 
 
20) _________ are built-in prompts that are created when the project is created

  1. Value Prompt
  2. Object Prompt
  3. System prompt
  4. Element Prompt

Answer : C




 
21) _________  project can be accessed from Microstrategy Web

  1. One tier
  2. Two tier
  3. Three tier
  4. Four tier

Answer : C

 
 
22) A _______ is a report result set that is saved on Microstrategy Intelligence Server

  1. Report cache
  2. Element cache
  3. Object Cache
  4. Database Cache

Answer : A

 
 
23) In a Filter ______ defines the set of data that this qualification contributes to the filter as a whole

  1. Metric
  2. Output level
  3. Attribute
  4. Custom Group

Answer : B

 
 
24) Which of the following is a  project default Autostyle

  1. Green Leaves
  2. Red Carpet
  3. Woody Look
  4. Finance

Answer : D

 
 
25) Dashboards and Scorecards can be created using

  1. Reports
  2. Templates
  3. Drill Maps
  4. Report Services document

Answer : D

 
 
26) In Desktop a report sql of a opened report can be viewed by selecting

  1. View -> Sql view
  2. View -> Grid view
  3. View -> Graph view
  4. View->Graph

Answer : A

 
 
27) _____  helps in creating a report in Microstrategy

  1. Report Wizard
  2. Prompt Wizard
  3. Project Wizard
  4. Metric Wizard

Answer : A

 
 
28) ______ determine the options available to an end user when drilling on a report

  1. Template
  2. Hierarchy
  3. Drill maps
  4. Filter

Answer : C

 
 
29) Which of the following object is not a ‘Public Object’

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

Answer : D

 
 
30) Sorting is processed by _______________

  1. Analytical Engine
  2. Execution Engine
  3. SQL Engine
  4. Metric Wizard

Answer : A




 
31) Customizing the Microstrategy products or developing custom applications with ____________

  1. Microstrategy Desktop
  2. Microstrategy SDK
  3. Microstrategy Web
  4. Microstrategy ODBC tool

Answer : B

 
 
32) A project source represents a connection to a ______________________

  1. Database
  2. Warehouse
  3. Metadata
  4. I Cube

Answer : C

 
 
33) To view project on Microstrategy Web, it must be connected to an _________ that has the project loaded

  1. Narrowcast Server
  2. Distribution Manager
  3. Intelligence Server
  4. Clustered Servers

Answer : C

 
 
34) In Narrowcast, _____ is a container that holds a set of questions that users answer to define their preferences

  1. Schedule
  2. Answer Object
  3. Subscription Set
  4. Question object

Answer : D

 
 
35) In Narrowcast, _____ stores all subscribers data,
including end users, addresses, personalization, and subscription sets.

  1. Subscription Book Repository
  2. Document
  3. Device
  4. Locale

Answer : A

 
 
36) 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

 
 
37) In Narrowcast, a  _____ sets the times or frequencies a service is executed and represents a recurrence pattern

  1. Service
  2. Device
  3. Schedule
  4. Trigger

Answer : C

 
 
38) Element caches are stored

  1. Only in memory
  2. Only on disk
  3. A and B
  4. in Datawarehouse

Answer : C

 
 
39) Microstrategy Intelligence Server integrates with SAP BW by using SAP’s OLAP

  1. BAPI (Business Application Programming Interface)
  2. Free Form SQL
  3. MDX(Multidimensional Expression)
  4. A and C

Answer : D

 
 
40) Which one is not part of 3 tier environment

  1. Client
  2. Web server
  3. Iserver
  4. Data Warehouse

Answer : B




 
41) ________________ is powerful tool that allows reporting from a platform independent architecture

  1. Microstrategy Web
  2. Microstrategy Web Universal
  3. Microstrategy Desktop
  4. Microstrategy Architect

Answer : B

 
 
42) Following is not a valid format of reporting are available in Microstrategy

  1. Standard Reports
  2. Report Services Document
  3. PowerPoint Presentation Format
  4. HTML Documents

Answer : C

 
 
43) Microstrategy reports cannot be exported to following formats:-

  1. MS EXCEL
  2. PDF
  3. Text File
  4. IBM DB2

Answer : D

 
 
44) View Filters and Report objects Windows is only available with

  1. Microstrategy Narrowcast Services
  2. Microstrategy OLAP Services
  3. Microstrategy Intelligence Server
  4. Microstrategy PDF output files.

Answer : B

 
 
45) ______ allows you to run, edit, and format Microstrategy reports and documents in Microsoft office applications like PowerPoint, Word, etc.,

  1. Microstrategy Office
  2. Microsoft Office
  3. Microstrategy Web
  4. Front Office

Answer : A

 
 
46) If you are not able move objects such as titles or the graph legend on your graph, then you need to enable

  1. Manual Layout Mode
  2. Automatic Layout Mode
  3. Dynamic Layout Mode
  4. Design View

Answer : A

 
 
47) In Narrowcast each means of delivering a message (via email, mobile, etc.,) is known as

  1. Delivery method
  2. User
  3. Report
  4. Subscriptions

Answer : A

 
 
48) Command Manager can be used for making changes to

  1. MSTR Security
  2. reports for Governing & Tuning of MSTR environment
  3. Project Management
  4. Report Scheduling

Answer : B

 
 
49) In Narrowcast, A _____ defines who receives a particular service.

  1. Schedule
  2. Subscription set
  3. XML file
  4. Information object

Answer : B

 
 
50) Which feature is used to migrate MSTR objects between different environments

  1. Enterprise Manager
  2. Project Merge
  3. Object Manager
  4. B&C

Answer : D




 
51) Microstrategy Command Manager lets you perform various administrative and application development tasks. Which of the following tasks cannot be performed using Command Manager:-

  1. Server Management
  2. User Management
  3. Report Creation commands
  4. Database Management

Answer : D

 
 
52) Putting user specific restrictions at the database end and using user specific connection mapping is called

  1. Column level security
  2. Row level security
  3. Report level Security
  4. Role based security

Answer : A

 
 
53) Which of the following cannot be set as a rule for Microstrategy password

  1. The minimum number of characters that the password must contain
  2. The minimum number of upper-case characters that the password must contain
  3. The minimum number of special characters, that is, symbols, that the password must contain
  4. The max number of repeated characters in a password

Answer : D

 
 
54) how to create a joint element list

  1. using advance prompt
  2. using advance filter qualification
  3. using advance mteric
  4. using smart metrics

Answer : B

 
 
55) which MicroStrategy tool is used for project merge

  1. object manager
  2. integrity manager
  3. enterprise manager
  4. license manager

Answer : A

 
 
56) how to stop the drilling option in ia report

  1. using report data option
  2. using pass throgh function
  3. not possible
  4. click on stop

Answer : A

 
 
57) how many minimum metrics required to use a microchart widget

  1. 3
  2. 5
  3. 7
  4. 9

Answer : C

 
 
58) which widget is used to show multiple metrics/KPIs

  1. Heatmap
  2. microchart
  3. googlemap
  4. bubble

Answer : A