MicroStrategy Web
Cancel
-
+
Multiple Choice (2pts each). Please select the best answer for each of the following questions. There is only ONE correct answer.
- 1.
- A.
It stores all of the information that you want to analyze from your various business systems.
- B.
It contains the definition of reports as well as all of the objects that are included in reports.
- C.
It records data about your business
- 2.Which of the following objects provides descriptive information from the data warehouse that can be displayed on a report?
- A.
Fact
- B.
Attribute
- C.
Hierarchy
- 3.Which of the following objects enables users to select the information to be included in a report or document at run time?
- A.
Metric
- B.
Attribute
- C.
Prompt
- D.
Fact
- 4.All reports in MicroStrategy are made up of a filter and the following object:
- A.
Hierarchies
- B.
Fact
- C.
Template
- 5.This folder contains reports, documents, and other objects that are accessible to you and other users.
- A.
My Subscriptions
- B.
History List
- C.
Shared Reports
- D.
My Reports
- 6.
- A.
Documents cannot be prompted
- B.
A prompt may have a default answer already selected when you first view it.
- C.
All prompts are displayed the same way.
- 7.This type of report or document already has all of the content defined at run time.
- A.
Static
- B.
Predefined
- C.
Prompted
- 8.Which type of prompt display option enables users to enter a single value? (For example, number, text, or date).
- A.
Pull Down
- B.
Text Box
- C.
Option Button
- D.
Check Box
- 9.Which of the following views can you use to display reports?
- A.
Grid
- B.
Graph
- C.
Grid and Graph
- D.
All of the above
- 10.After you run a report, what report manipulation enables you to view data at levels other than the original level of the report?
- A.
Drilling
- B.
Advanced Sorting
- C.
Data Pivoting
- D.
Outline Mode
- 11.This functionality enables a report to be divided into separate pages for viewing purposes based on an object, such as an attribute or metric.
- A.
Outline Mode
- B.
Banding
- C.
Drilling
- D.
Page-by
- 12.
- A.
Grouping in documents is similar to the page-by axis in reports
- B.
You can change the order of the data elements in the Grouping field.
- C.
You can add additional data elements to the Grouping field.
- 13.
- A.
Quick sort enables you to sort by one row or column at a time
- B.
You can perform an advanced sort using the sort buttons
- C.
Advanced sort enables you to sort sequentially by up to three rows or columns at a time.
- 14.
- A.
Clicking on a hyperlinked attribute element name
- B.
Right-clicking and using the Drill menu
- C.
Dragging an attribute to the Drill panel
- D.
Using the Drill panel
- 15.In MicroStrategy Web, a document can be displayed in which of the following view modes?
- A.
Dynamic
- B.
Interactive
- C.
Static
- D.
Simplified
- 16.You have a report that shows weekly regional performance based on sales. For any region that generated less than $50,000 in sales, the report displays its sales value in bold type and red font color. This type of display is called:
- A.
Autostyle
- B.
Banding
- C.
Thresholds
- D.
Number formatting
- 17.
- A.
You use Quick Switch to switch from one document to another in the View Mode
- B.
You use Quick Switch for changing the display of a grid to a graph and vice versa in a document
- C.
You use Quick Switch for converting a graph into a Flash widget
- D.
All of the above
- 18.
- A.
Flip through panels in a panel stack
- B.
Select attribute elements to display in a grid or a graph
- C.
Select metrics to display in a grid or a graph
- D.
All of the above
- 19.After running a prompted report, you are interested in selecting different prompt answers; what feature will enable you to carry out this task?
- A.
Clicking the Undo button
- B.
Clicking the Re-prompt button
- C.
Clicking the Rerun button
- 20.
- A.
Subscriptions are useful for reports or documents that you routinely execute at specific times or for ones that take longer to process
- B.
When you subscribe to a report or document, you are requesting that the administrator execute the report or document based on a schedule that you select
- C.
You can create your own schedules and then use them to subscribe to reports and documents
- 21.Which folder allows you to access reports or documents that ran automatically using schedules?
- A.
My Subscriptions
- B.
History List
- C.
My Reports
- D.
Shared Reports
- 22.To which of the following applications can you export report results?
- A.
PDF
- B.
Microsoft Word
- C.
Microsoft Access
- D.
All of the above
- 23.Which of the following features would you use to make all of your reports display results with the same formatting?
- A.
Banding
- B.
Autostyle
- C.
Sorting
- 24.
- A.
It requires MicroStrategy OLAP Services
- B.
It enables an indented, hierarchical display of report results
- C.
To use Outline mode, a report must be sorted first
- 25.
- A.
Thresholds are visual indicators that certain conditions exist in data
- B.
In MicroStrategy Web, you first define the conditions and then format metric values to display in specific ways when those conditions are met
- C.
You do not have the option to toggle thresholds on and off
- 26.If you run a report that originally shows sales data at the country level, what report manipulation can you perform to view sales data at the state level?
- A.
Data Pivoting
- B.
Drilling
- C.
Banding
- D.
Outline Mode
- 27.
- A.
By using a selector, you can determine what data is displayed in grid or graph reports in the document or which panel of a panel stack is displayed
- B.
By using the Quick Switch button, you can quickly switch from one document to another
- C.
You cannot view the document in Full Screen Mode
- 28.
- A.
View filters limit the actual data that is brought back from the data warehouse
- B.
View filters can be saved and reused on other reports
- C.
You can only create view filters based on attributes and metrics in the Report Objects window
- 29.Which of the following statements about reports in MicroStrategy Web is true?
- A.
A report consists of a template, which defines the format and layout, and a filter, which determines the data that is included in the result
- B.
A report cannot have an empty filter
- C.
You cannot create multiple views of the report
- 30.
- A.
You add a metric from the Report Objects window to the template
- B.
You remove an attribute from the Report Objects window
- C.
You create a view filter on an attribute in the Report Objects window
- D.
You create a metric using two metrics that are in the Report Objects window
- 31.
- A.
They are built using existing metrics already in the Report Objects window
- B.
You can save them and re-use them on other reports
- C.
Derived metric funtionality is available only if you have MicroStrategy OLAP Services
- 32.This special type of derived metric allows you to create percent to total and rank calculations based on existing metrics in the report.
- A.
Nested metric
- B.
Shortcut metric
- C.
Complex metric
- D.
Simple metric
- 33.Which of the following statements about data pivoting is true?
- A.
Metrics can be moved only to the rows or columns, not the page-by field
- B.
Pivoting enables you to quickly and easily rearrange data so that you can view it from multiple perspectives
- C.
Data pivoting requires MicroStrategy OLAP Services
- 34.What report manipulation involves moving individual attributes or metrics from rows to columns or columns to rows or the page-by field?
- A.
Sorting
- B.
Data pivoting
- C.
Swap rows and columns
- D.
Exporting
- 35.Which of the following statements about advanced drilling on reports in MicroStrategy Web is true?
- A.
Advanced drills enable you to drill to any attribute in any hierarchy
- B.
Advanced drills can only be performed using the Drill menu
- C.
Advanced drills can only be performed using the Drill panel
- 36.This feature enables you to easily select the data you want to keep for further analysis and then removes the rest of the data from the report display.
- A.
Data pivoting
- B.
Filter on Selections
- C.
Swap rows and columns
- D.
Advanced drilling
- 37.
- A.
A view filter is used to display only a subset of the full result set
- B.
You can create view filters based on any project object, not just report objects
- C.
View filters can contain only one condition
- 38.Which of the following statements about adding totals to a report is true?
- A.
You can define subtotals, which calculate totals at various attribute levels in a report
- B.
You can create your own custom subtotals and use them on a report
- C.
You can either show the grand total or subtotals but not both on a report
- 39.
- A.
You can save the report as static or prompted
- B.
You can choose to keep either the filter or the template as prompted, or both
- C.
You cannot keep your current answers as the default answers
- 40.
- A.
You can subscribe to reports and documents and then use the History List to retrieve the results
- B.
You cannot add them from the wait page as they are executing
- C.
You can add them when you are viewing the result
- 41.You have a report with a large result set. As you scroll down the report, the row and column headers are no longer visible. What feature can you use to ensure that the row and column headers are always visible as you scroll through the report?
- A.
Resize row and column headers
- B.
Enable banding
- C.
Lock row and column headers
- 42.
- A.
It enables you to create metrics inside a report that you can use in other reports
- B.
It enables you to include attributes and metrics in the Report Objects window without displaying them on the template
- C.
It enables you to drill to any object in your project without generating new SQL
- 43.
- A.
They enable you to create your own reports using prompts
- B.
They cannot have a report filter
- C.
The Report Wizard provides a quick and easy way of creating your own report by selecting from predefined templates and filters
- D.
The Report Builder provides a more detailed means for creating your own report. It enables you to select the individual attributes and metrics for the template and to choose the objects and operators that you want to use for the filter qualification
- 44.Which Document Display Mode allows you to view the document results only and provides the best performance.
- A.
Flash mode
- B.
Express mode
- C.
Interactive mode
- 45.Which feature of MicroStrategy is this statement referring to: This feature is the repository for storing all of the information that you want to analyze from disparate source systems.
- A.
Source Systems
- B.
Metadata Database
- C.
Data Warehouse
- D.
ETL Process
- 46.Which one of these objects is NOT a schema object?
- A.
Metric
- B.
Attribute
- C.
Fact
- D.
Hierarchy
- 47.Which of the following statements is true with regard to report creation for a Web Reporter/Analyst?
- A.
This user can create reports from a Predesigned Report and a Prompted Predesigned Report
- B.
This user can create reports from a Predesigned Report, Prompted Predesigned Report and from scratch
- C.
Can create a Document
- 48.If you want to customize your print settings, which of the following components would you use?
- A.
Preferences
- B.
My Reports
- C.
My Subscriptions
- 49.You can only create Derived Elements on a report that is based on a published Intelligent Cube.
- A.
True
- B.
False
- 50.Which formats can you export reports to?
- A.
Excel (with or without formatting)
- B.
CSV (file format recognized by Excel)
- C.
HTML
- D.
Plain text
- E.
All of the above
Back to top
