Microstrategy Intermediate Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
3) The process of logging and analyzing operation and performance information is known as _____________________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
5) Upto how many SQL passes may be needed for all consolidation elements

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
6) What comprises the Microstrategy Engine?

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
7) Which of the following Microstrategy objects is Schema objects

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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)

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

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



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
16) A Microstrategy _________  contains objects representing data coming from one or more reports

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
17) HTML Documents in the Microstrategy platform, formerly known as

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
18) In a project by default ‘Metrics’ Folder will be available in

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

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



 
21) _________  project can be accessed from Microstrategy Web

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
24) Which of the following is a  project default Autostyle

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
25) Dashboards and Scorecards can be created using

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
27) _____  helps in creating a report in Microstrategy

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
28) ______ determine the options available to an end user when drilling on a report

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
29) Which of the following object is not a ‘Public Object’

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
30) Sorting is processed by _______________

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

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



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

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
32) A project source represents a connection to a ______________________

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
38) Element caches are stored

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
40) Which one is not part of 3 tier environment

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

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



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
43) Microstrategy reports cannot be exported to following formats:-

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
49) In Narrowcast, A _____ defines who receives a particular service.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
50) Which feature is used to migrate MSTR objects between different environments

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

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



 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
55) which MicroStrategy tool is used for project merge

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
57) how many minimum metrics required to use a microchart widget

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
58) which widget is used to show multiple metrics/KPIs

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

[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