Microstrategy Beginner Quiz

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 _____________

  1. Metadata
  2. Attribute
  3. Dimension
  4. Report

Answer : A

 
 
2) Which of the following tasks you can perform with the MicroStrategy Architect?

  1. Create Metrics
  2. Create Statistic tables
  3. create schema objects
  4. Create Configuration Objects

Answer : C

 
 
3) Microstrategy Business Intelligent(BI) Architecture has the following components___________

  1. Command Manager
  2. Desktop
  3. Project Merge
  4. ODBC Test Tool

Answer : B

 
 
4) _____________map directly to information in your data warehouse.  Examples of schema objects are facts, attributes and hierarchies.

  1. Report
  2. Microstrategy tool
  3. Schema Object
  4. Data Warehouse

Answer : C

 
 
5) __________are numeric data in your data warehouse that you want to be able to aggrigate/calculate.

  1. Attribute
  2. Facts
  3. Dimension
  4. Tables

Answer : B

 
 
6) In Microstrategy  _________is descriptive data provides context for analyzing facts.

  1. Attribute
  2. Facts
  3. Dimension
  4. Transformations

Answer : A

 
 
7) In Microstrategy, these enable you to browse/drill attribute data in a project

  1. Attribute
  2. Facts
  3. Hierarchies
  4. Transformations

Answer : C

 
 
8) There are two types of predefined reports and documents___________and __________.

  1. Fix and Dynamic
  2. Static and Prompted
  3. Constant and variable
  4. Filtered and MDX

Answer : B

 
 
9) Which report or document in Microstrategy requires the developer to define all of the content before execution?

  1. Dynamic report
  2. Static Report
  3. Variable Report
  4. Dashboard

Answer : B

 
 
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.

  1. Prompted report
  2. Static Report
  3. Variable Report
  4. Filtered Report

Answer : A




 
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:

  1. Select & Delete
  2. Revoke & Commit
  3. Update & Insert
  4. a and c

Answer : D

 
 
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

  1. MicroStrategy Desktop
  2. MicroStrategy Report Server
  3. I-Server or MicroStrategy Intelligent Server
  4. Analytical Server

Answer : C

 
 
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.

  1. MicroStrategy Web Server
  2. MicroStrategy Report Server
  3. I-Server or MicroStrategy Intelligent Server
  4. Narrowcast Server

Answer : A

 
 
14) _________on report enables to view data at different levels that the ones displayed in the result set.

  1. Overview
  2. Report
  3. Drilling
  4. Filtering

Answer : C

 
 
15) _________are report components that enable analytical calculations against the warehouse data.

  1. Attributes
  2. Hierarchies
  3. Metrics
  4. Filters

Answer : C

 
 
16) In MicroStrategy report,  SQL query running behind report can be viewed in _________

  1. grid view
  2. SQL view
  3. graph view
  4. grid graph view

Answer : B

 
 
17) How to restrict number of records on Microstrategy reports?

  1. Using Filter
  2. Using Prompt
  3. Using Attribute
  4. Using Hierarchy

Answer : A

 
 
18) A Physical schema includes the following of the two primary components.

  1. Fact and Dimension
  2. Columns and Tables
  3. Custom groups and Consolidations
  4. Prompts and Filters

Answer : B

 
 
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.

  1. Attribute
  2. Facts
  3. Metadata
  4. Transformations

Answer : C

 
 
20) __________ process is used to transform data , prepare data and load data into  the  data  warehouse?

  1. Business Intelligence
  2. ETL
  3. Data Modeling
  4. Data Warehouse

Answer : B




 
21) A  ________  is  a  logical  and  physical  definition  of  warehouse  data  elements,  physical characteristics, and interrelationships.

  1. Schema
  2. data warehouse operation
  3. Warehouse Catalog
  4. ERD

Answer : A

 
 
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.

  1. Logical data  model
  2. Data warehouse
  3. Physical Schema
  4. Attributes

Answer : A

 
 
23) Which object provides following advantages :

  1. Virtual attribute
  2. Row level Mathematics
  3. Custom group
  4. Consolidation
  5. Attribute
  6. Metric

Answer : B

 
 
24) View filter is  ___________

  1. Memory operation
  2. data warehouse operation
  3. Metadeta operation
  4. Table transformation

Answer : A

 
 
25) Report local filter is ___________

  1. Memory operation
  2. data warehouse operation
  3. Metadata operation
  4. Table operation

Answer : B

 
 
26) Which of the following option is TRUE about the Report Limit.

  1. report limit always affect metrics calculations
  2. report limit does not affect metrics calculations
  3. may affect or may not affect metrics calculations
  4. May affect filters

Answer : B

 
 
27) Which of the following affect metrics calculations?

  1. report limit
  2. view filters
  3. report filters
  4. Prompts

Answer : C

 
 
28) ________ will not modify the SQL of the Report

  1. Report Limit filter
  2. view filters
  3. report filters
  4. Prompts

Answer : A

 
 
29) _________ 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. Promtps

Answer : A

 
 
30) _____ 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. Security Filter

Answer : C




 
31) A _______ is used to dynamically modify the contents of a report

  1. Attribute
  2. Hierarchy
  3. prompt
  4. Metric

Answer : C

 
 
32) A default prompt answers set during prompt creation, can be modified by user during report execution.

  1. TRUE
  2. FALSE

Answer : A

 
 
33) Which of the following objects can be placed into a report

  1. Attributes
  2. Dashboard
  3. I Cube
  4. MDX Report

Answer : A

 
 
34) A _________ can hold multiple projects

  1. Project source
  2. Project
  3. Schema
  4. Table

Answer : A

 
 
35) _______ enables you to select and display subsets of your report results as separate pages

  1. Report Filter
  2. Metric
  3. Group By
  4. Page-by

Answer : D

 
 
36) Thresholds offer conditional formatting for ________

  1. Attributes
  2. Metrics
  3. Filters
  4. Prompts

Answer : C

 
 
37) which of the following is NOT a Microstrategy type of  Filter

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

Answer : B

 
 
38) In a Filter _______ restrict the amount of data used to calculate the metrics on a report

  1. Hierarchy Qualifier
  2. Fact Qualifier
  3. Table Qualifier
  4. Metric qualifiers

Answer : D

 
 
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.

  1. Custom group
  2. Attribute
  3. Metric
  4. Consolidations

Answer : A

 
 
40) ________  has the ability to group attribute elements in a way that is not defined in the data warehouse.

  1. Custom group
  2. Filters
  3. Prompts
  4. View Filter

Answer : A




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

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

Answer : C

 
 
42) A Microstrategy project includes

  1. Project source
  2. Warehouse Catalog
  3. I Server
  4. Attributes

Answer : D

 
 
43) In Report service documents a ‘Dataset’ refers to _________

  1. Prompt
  2. Table
  3. Metric
  4. Report

Answer : D

 
 
44) selector in a document can be used to select

  1. Filter
  2. Prompt
  3. View Filter
  4. Attributes

Answer : D

 
 
45) Multiple reports can be assigned as Primary and ____ in a document.

  1. Secondary
  2. PrePrimary
  3. Final
  4. Custom

Answer : A

 
 
46) which of following can be placed in document.

  1. Project source
  2. I Cube
  3. MDX Adapters
  4. Panels

Answer : D

 
 
47) Which mode of the following a document can be opened

  1. Express
  2. Passenger
  3. Mail
  4. Email

Answer : A

 
 
48) What object is set advanced qualification in MicroStartegy

  1. Filter
  2. Prompt
  3. Metric
  4. Transformations

Answer : A

 
 
49) which server is engine of MicroStrategy

  1. Narrowcast Server
  2. iServer
  3. Clusterred Server
  4. Analytical Server

Answer : B

 
 
50) which one of the following is correct user access license for the MicroStrategy users and developers

  1. Command Manager Analyst
  2. Project Merge master
  3. ODBC Test tool Developer
  4. Desktop Designer

Answer : D




 
51) which one of the following is correct view to see the query behind a report in desktop

  1. SQL View
  2. pdfview
  3. xview
  4. Rear View

Answer : A

 
 
52) Distrubuton services has replaced which services in MSTR9.x

  1. OLAP
  2. Reporting
  3. Narrowcast server
  4. mathematical

Answer : C

 
 
53) MicroStartegy is what type of OLAP tool

  1. MOLAP
  2. ROLAP
  3. HOLAP
  4. OLAP

Answer : B

 
 
54) what is the type of join between datasets of a document

  1. inner
  2. outer
  3. self
  4. Cross

Answer : B

 
 
55) which one of the following is not a public object

  1. Derived Metric
  2. Smart metric
  3. Conditional Metric
  4. Level Metric

Answer : A

 
 
56) Which one of the following  filter will not generate a SQL query

  1. Security Filter
  2. Report Filter
  3. View Filter
  4. Prompted Filter

Answer : C

 
 
57) which prompt can no be used in a document dataset directly

  1. filter Prompt
  2. Object Prompt
  3. filter prompt
  4. value prompt

Answer : B

 
 
58) which object can not be addded to a report directly

  1. Attribute
  2. metric
  3. filter
  4. fact

Answer : D

 
 
59) Consolidation does what operation

  1. row level math
  2. summation
  3. aggregation
  4. Exponential

Answer : A

 
 
60) which user can bypass security filter

  1. Desktop Designer
  2. Desktop Analyst
  3. Architect
  4. Administrator

Answer : D