Microstrategy Quiz
Microstrategy Quiz : This Microstrategy Beginner Quiz contains set of 60 Microstrategy Quiz which will help to clear any exam which is designed for Beginner.
1) The database repository where definitions of all MicroStrategy objects are stored is _____________
- Metadata
- Attribute
- Dimension
- Report
2) Which of the following tasks you can perform with the MicroStrategy Architect?
- Create Metrics
- Create Statistic tables
- create schema objects
- Create Configuration Objects
3) Microstrategy Business Intelligent(BI) Architecture has the following components___________
- Command Manager
- Desktop
- Project Merge
- ODBC Test Tool
4) _____________map directly to information in your data warehouse. Examples of schema objects are facts, attributes and hierarchies.
- Report
- Microstrategy tool
- Schema Object
- Data Warehouse
5) __________are numeric data in your data warehouse that you want to be able to aggrigate/calculate.
- Attribute
- Facts
- Dimension
- Tables
6) In Microstrategy _________is descriptive data provides context for analyzing facts.
- Attribute
- Facts
- Dimension
- Transformations
7) In Microstrategy, these enable you to browse/drill attribute data in a project
- Attribute
- Facts
- Hierarchies
- Transformations
8) There are two types of predefined reports and documents___________and __________.
- Fix and Dynamic
- Static and Prompted
- Constant and variable
- Filtered and MDX
9) Which report or document in Microstrategy requires the developer to define all of the content before execution?
- Dynamic report
- Static Report
- Variable Report
- Dashboard
10) Which report or document in Microstrategy, the developer has to only define some of the content before execution. Some of the content is dynamic and is determined by you at run time.
- Prompted report
- Static Report
- Variable Report
- Filtered Report
11) SQL can be divided into two parts: The Data Manipulation Language (DML) and the Data Definition Language (DDL). Choose commands form the DML part of SQL:
- Select & Delete
- Revoke & Commit
- Update & Insert
- a and c
12) _________ server provides jobs management and analytical processing for all MicroStrategy applications. This acts as a central component connecting the metadata, warehouse, desktop, Web server and Narrow cast Server. Few or main features: Reports Service
- MicroStrategy Desktop
- MicroStrategy Report Server
- I-Server or MicroStrategy Intelligent Server
- Analytical Server
13) A server in MicroStrategy responds to the requests from browsers and interacts with the I-server to extract the necessary information. Also it can be installed on most of the major web servers and supports most popular browsers.
- MicroStrategy Web Server
- MicroStrategy Report Server
- I-Server or MicroStrategy Intelligent Server
- Narrowcast Server
14) _________on report enables to view data at different levels that the ones displayed in the result set.
- Overview
- Report
- Drilling
- Filtering
15) _________are report components that enable analytical calculations against the warehouse data.
- Attributes
- Hierarchies
- Metrics
- Filters
16) In MicroStrategy report, SQL query running behind report can be viewed in _________
- grid view
- SQL view
- graph view
- grid graph view
17) How to restrict number of records on Microstrategy reports?
- Using Filter
- Using Prompt
- Using Attribute
- Using Hierarchy
18) A Physical schema includes the following of the two primary components.
- Fact and Dimension
- Columns and Tables
- Custom groups and Consolidations
- Prompts and Filters
19) MicroStrategy applications use ____________ to translate user requests into SQL queries and then translate the results of those queries back into MicroStrategy objects like reports and documents.
- Attribute
- Facts
- Metadata
- Transformations
20) __________ process is used to transform data , prepare data and load data into the data warehouse?
- Business Intelligence
- ETL
- Data Modeling
- Data Warehouse
21) A ________ is a logical and physical definition of warehouse data elements, physical characteristics, and interrelationships.
- Schema
- data warehouse operation
- Warehouse Catalog
- ERD
22) A ___________ graphically depicts the flow and structure of data in a business environment. It provides a way of organizing facts so that they can be analyzed from different business perspectives.
- Logical data model
- Data warehouse
- Physical Schema
- Attributes
23) Which object provides following advantages :
- Virtual attribute
- Row level Mathematics
- Custom group
- Consolidation
- Attribute
- Metric
24) View filter is ___________
- Memory operation
- data warehouse operation
- Metadeta operation
- Table transformation
25) Report local filter is ___________
- Memory operation
- data warehouse operation
- Metadata operation
- Table operation
26) Which of the following option is TRUE about the Report Limit.
- report limit always affect metrics calculations
- report limit does not affect metrics calculations
- may affect or may not affect metrics calculations
- May affect filters
27) Which of the following affect metrics calculations?
- report limit
- view filters
- report filters
- Prompts
28) ________ will not modify the SQL of the Report
- Report Limit filter
- view filters
- report filters
- Prompts
29) _________ 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
- Promtps
30) _____ an additional filter applied in memory to the report data set and affects only the view definition
- Report Filter
- Prompt
- View filter
- Security Filter
31) A _______ is used to dynamically modify the contents of a report
- Attribute
- Hierarchy
- prompt
- Metric
32) A default prompt answers set during prompt creation, can be modified by user during report execution.
- TRUE
- FALSE
33) Which of the following objects can be placed into a report
- Attributes
- Dashboard
- I Cube
- MDX Report
34) A _________ can hold multiple projects
- Project source
- Project
- Schema
- Table
35) _______ enables you to select and display subsets of your report results as separate pages
- Report Filter
- Metric
- Group By
- Page-by
36) Thresholds offer conditional formatting for ________
- Attributes
- Metrics
- Filters
- Prompts
37) which of the following is NOT a Microstrategy type of Filter
- Report limit
- View Limit
- View Filter
- Report Filter
38) In a Filter _______ restrict the amount of data used to calculate the metrics on a report
- Hierarchy Qualifier
- Fact Qualifier
- Table Qualifier
- Metric qualifiers
39) A ________ is a set of special filters that can be placed on a template that allows to group attribute elements in different ways without changing the metadata and warehouse definitions.
- Custom group
- Attribute
- Metric
- Consolidations
40) ________ has the ability to group attribute elements in a way that is not defined in the data warehouse.
- Custom group
- Filters
- Prompts
- View Filter
41) ______ determine the options available to an end user when drilling on a report
- Template
- Hierarchy
- Drill maps
- Filter
42) A Microstrategy project includes
- Project source
- Warehouse Catalog
- I Server
- Attributes
43) In Report service documents a ‘Dataset’ refers to _________
- Prompt
- Table
- Metric
- Report
44) selector in a document can be used to select
- Filter
- Prompt
- View Filter
- Attributes
45) Multiple reports can be assigned as Primary and ____ in a document.
- Secondary
- PrePrimary
- Final
- Custom
46) which of following can be placed in document.
- Project source
- I Cube
- MDX Adapters
- Panels
47) Which mode of the following a document can be opened
- Express
- Passenger
48) What object is set advanced qualification in MicroStartegy
- Filter
- Prompt
- Metric
- Transformations
49) which server is engine of MicroStrategy
- Narrowcast Server
- iServer
- Clusterred Server
- Analytical Server
50) which one of the following is correct user access license for the MicroStrategy users and developers
- Command Manager Analyst
- Project Merge master
- ODBC Test tool Developer
- Desktop Designer
51) which one of the following is correct view to see the query behind a report in desktop
- SQL View
- pdfview
- xview
- Rear View
52) Distrubuton services has replaced which services in MSTR9.x
- OLAP
- Reporting
- Narrowcast server
- mathematical
53) MicroStartegy is what type of OLAP tool
- MOLAP
- ROLAP
- HOLAP
- OLAP
54) what is the type of join between datasets of a document
- inner
- outer
- self
- Cross
55) which one of the following is not a public object
- Derived Metric
- Smart metric
- Conditional Metric
- Level Metric
56) Which one of the following filter will not generate a SQL query
- Security Filter
- Report Filter
- View Filter
- Prompted Filter
57) which prompt can no be used in a document dataset directly
- filter Prompt
- Object Prompt
- filter prompt
- value prompt
58) which object can not be addded to a report directly
- Attribute
- metric
- filter
- fact
59) Consolidation does what operation
- row level math
- summation
- aggregation
- Exponential
60) which user can bypass security filter
- Desktop Designer
- Desktop Analyst
- Architect
- Administrator