MicroStrategy Web

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Gregbutler
G
Gregbutler
Community Contributor
Quizzes Created: 1 | Total Attempts: 4,716
| Attempts: 4,716 | Questions: 50
Please wait...
Question 1 / 50
0 %
0/100
Score 0/100
1. Which of the following objects enables users to select the information to be included in a report or document at run time?

Explanation

A prompt is an object that allows users to select the information they want to include in a report or document at the time it is being run. It provides a user interface where users can input their preferences or criteria, such as selecting specific data or applying filters, which then determines the content of the report or document. Prompts are commonly used in reporting and document generation tools to give users flexibility and control over the output they receive.

Submit
Please wait...
About This Quiz
MicroStrategy Web - Quiz

Multiple Choice (2pts each).
Please select the best answer for each of the following questions. There is only ONE correct answer.

2. Which of the following views can you use to display reports?

Explanation

All of the above is the correct answer because the question is asking about the different views that can be used to display reports. The options provided include Grid, Graph, and Grid and Graph, which cover all possible views for displaying reports. Therefore, selecting "All of the above" encompasses all the available options for viewing reports.

Submit
3. Which of the following objects provides descriptive information from the data warehouse that can be displayed on a report?

Explanation

Attributes in a data warehouse provide descriptive information about the data. They describe the characteristics or properties of the objects in the data warehouse. When displayed on a report, attributes provide additional context and details about the data, helping users understand and analyze the information more effectively. Therefore, attributes are the objects that provide descriptive information from the data warehouse for display on a report.

Submit
4. After you run a report, what report manipulation enables you to view data at levels other than the original level of the report?

Explanation

Drilling is a report manipulation technique that allows you to view data at different levels than the original level of the report. It enables users to navigate through the report hierarchy by expanding or collapsing data to reveal more detailed or summarized information. This allows for a deeper analysis of the data and the ability to explore different dimensions and levels of granularity.

Submit
5. After running a prompted report, you are interested in selecting different prompt answers; what feature will enable you to carry out this task?

Explanation

Clicking the Re-prompt button will enable you to select different prompt answers after running a prompted report. This feature allows you to modify your initial prompt selections and generate a new report based on the updated criteria.

Submit
6. Which of the following features would you use to make all of your reports display results with the same formatting?

Explanation

Autostyle is the feature that can be used to make all of the reports display results with the same formatting. This feature automatically applies a consistent style to the reports, ensuring that they have a uniform appearance. By using autostyle, users can save time and effort in manually formatting each report, and also ensure that all reports have a professional and cohesive look.

Submit
7. Which formats can you export reports to?

Explanation

The correct answer is "All of the above" because the question asks about the formats in which you can export reports. The given options include Excel (with or without formatting), CSV (recognized by Excel), HTML, and plain text. Since all of these options are listed, it means that you can export reports to all of these formats.

Submit
8. This folder contains reports, documents, and other objects that are accessible to you and other users.

Explanation

The correct answer is "Shared Reports" because this folder contains reports, documents, and other objects that are accessible to both the user and other users. This suggests that the folder is meant for sharing information and collaborating with others.

Submit
9. Which of the following statements about prompts is true?

Explanation

A prompt may have a default answer already selected when you first view it. This means that when you are presented with a prompt, there may already be a suggested answer or option chosen for you. This can be helpful as it saves time and effort for the user, as they can simply accept the default answer if it is appropriate. However, it is important to note that not all prompts have default answers and it ultimately depends on the specific prompt and its design.

Submit
10. This functionality enables a report to be divided into separate pages for viewing purposes based on an object, such as an attribute or metric.

Explanation

Page-by functionality enables a report to be divided into separate pages for viewing purposes based on an object, such as an attribute or metric. This means that the report can be organized and presented in a more organized and structured manner, making it easier for users to navigate and understand the information presented. By dividing the report into separate pages, users can focus on specific sections or elements of the report, enhancing the overall user experience and making it more efficient to analyze the data.

Submit
11. 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?

Explanation

Drilling is the correct answer because it allows you to navigate through different levels of data hierarchy. By drilling down from the country level to the state level, you can view sales data at a more granular level. This manipulation helps in gaining a deeper understanding of sales performance in specific states.

Submit
12. Which of the following statements about reports in MicroStrategy Web is true?

Explanation

A report in MicroStrategy Web is composed of a template and a filter. The template determines the format and layout of the report, while the filter determines the data that will be included in the result. This means that the report can be customized in terms of its appearance and the data it displays by modifying the template and adjusting the filter criteria. Therefore, the statement that a report consists of a template and a filter is true.

Submit
13. 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:

Explanation

The report displays the sales value in bold type and red font color for any region that generated less than $50,000 in sales. This indicates that there is a certain threshold set at $50,000, and any region below this threshold is highlighted in a specific way. Therefore, the type of display used in this report is called "Thresholds."

Submit
14. If you want to customize your print settings, which of the following components would you use?

Explanation

To customize print settings, the appropriate component to use would be "Preferences." This option allows users to modify their settings according to their preferences, including print settings such as paper size, orientation, and quality. By selecting "Preferences," users can access a range of options to tailor their print experience to their specific needs and requirements.

Submit
15. Which of the following statements best describes the MicroStrategy Metadata?

Explanation

The MicroStrategy Metadata is a repository that stores the definition of reports and all the objects that are included in those reports. This includes information about the structure, layout, and formatting of the reports, as well as the data sources and calculations used in generating the reports. By storing this information, the metadata allows users to easily access and analyze the data from various business systems in a consistent and organized manner.

Submit
16. 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.

Explanation

This feature allows users to choose specific data they want to retain for further analysis, while eliminating the remaining data from the report display. It provides a way to filter and narrow down the dataset based on user selections, helping to focus on relevant information and simplify the analysis process.

Submit
17. Which of the following statements about view filters is true?

Explanation

A view filter is used to display only a subset of the full result set. This means that it allows users to narrow down the data they see by applying specific conditions or criteria. By using view filters, users can focus on specific subsets of data that are relevant to their analysis or reporting needs. This helps in gaining insights and making informed decisions based on a more targeted view of the data.

Submit
18. Which of the following statements about viewing documents in Interactive Mode is true?

Explanation

In Interactive Mode, users have the ability to customize their view of the document. One way to do this is by using a selector, which allows them to choose what data is displayed in grid or graph reports, or which panel of a panel stack is shown. This statement correctly describes the functionality of selectors in Interactive Mode. The other options are not relevant to the question and are therefore incorrect.

Submit
19. Which one of these objects is NOT a schema object?

Explanation

A metric is not a schema object because it is a measurement or a value that represents a specific aspect of data, such as sales revenue or customer satisfaction. Schema objects, on the other hand, are the structures that define the organization and relationships of data within a database, such as tables, views, indexes, and constraints. Metrics are typically derived from schema objects and are used to analyze and measure the data stored in those objects.

Submit
20. Which of the following statements about data pivoting is true?

Explanation

Pivoting enables you to quickly and easily rearrange data so that you can view it from multiple perspectives. This means that you can change the layout of the data by moving metrics to different rows or columns, allowing you to analyze and compare the data in different ways. Data pivoting does not require MicroStrategy OLAP Services, as it is a common feature in many data analysis and visualization tools.

Submit
21. 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?

Explanation

To ensure that the row and column headers are always visible as you scroll through the report, you can use the feature of "Lock row and column headers". This feature allows you to freeze the headers in place so that they remain visible even when scrolling through a large result set. By locking the headers, you can easily refer to the column and row labels, providing better context and understanding of the data being presented in the report.

Submit
22. Which type of prompt display option enables users to enter a single value? (For example, number, text, or date).

Explanation

The text box prompt display option enables users to enter a single value. This is because a text box allows users to input any type of text, such as numbers, letters, or dates, in a single field. Pull down, option button, and check box are not suitable for entering a single value as they are used for selecting from predefined options or multiple choices.

Submit
23. In MicroStrategy Web, a document can be displayed in which of the following view modes?

Explanation

In MicroStrategy Web, a document can be displayed in the Interactive view mode. This mode allows users to interact with the document, explore data, apply filters, and perform various actions such as drilling down into details or changing visualizations. It provides a dynamic and interactive experience for users to analyze and manipulate data within the document.

Submit
24. Which of the following statements about advanced drilling on reports in MicroStrategy Web is true?

Explanation

Advanced drills in MicroStrategy Web allow users to drill down to any attribute in any hierarchy. This means that users can navigate through different levels of data and explore details at various levels of granularity. Advanced drills are not limited to a specific menu or panel, and can be performed using different tools and options available in MicroStrategy Web.

Submit
25. Which of the following statements about adding totals to a report is true?

Explanation

The correct answer is that you can define subtotals, which calculate totals at various attribute levels in a report. This means that in a report, you can choose to calculate subtotals for specific attributes, such as by product category or by region, to get a more detailed breakdown of the total values. This allows for better analysis and understanding of the data.

Submit
26. All reports in MicroStrategy are made up of a filter and the following object:

Explanation

In MicroStrategy, all reports are composed of a filter and a template. The template defines the layout and formatting of the report, including the placement of hierarchies and facts. It allows users to customize the appearance of the report and present the data in a visually appealing manner. The filter is used to specify the criteria for data retrieval, allowing users to narrow down the information displayed in the report. Together, the filter and template form the structure and design of the report in MicroStrategy.

Submit
27. What report manipulation involves moving individual attributes or metrics from rows to columns or columns to rows or the page-by field?

Explanation

Data pivoting involves moving individual attributes or metrics from rows to columns or columns to rows or the page-by field. This allows for a different representation of the data, making it easier to analyze and compare different attributes or metrics. Sorting refers to arranging data in a specific order, while swapping rows and columns is a specific type of data pivoting. Exporting refers to saving data in a different format or location.

Submit
28. You can only create Derived Elements on a report that is based on a published Intelligent Cube.

Explanation

Derived Elements are created based on existing elements in a report. Since Intelligent Cubes contain pre-aggregated data and are already published, they provide a reliable source for creating Derived Elements. Therefore, it is true that you can only create Derived Elements on a report that is based on a published Intelligent Cube.

Submit
29. While viewing a document, which of the following statements about the grouping feature is true?

Explanation

Grouping in documents is similar to the page-by axis in reports. This means that when grouping data in a document, it organizes the data in a similar way as the page-by axis in reports. This allows users to group and organize data based on specific criteria, making it easier to analyze and understand the information presented in the document. Additionally, this statement implies that the grouping feature in documents and the page-by axis in reports serve a similar purpose and function in organizing and presenting data.

Submit
30. In a document, you can use a selector to perform which of the following manipulations?

Explanation

A selector in a document can be used to perform all of the mentioned manipulations. It allows the user to flip through panels in a panel stack, select attribute elements to display in a grid or a graph, and select metrics to display in a grid or a graph. This means that the user has the ability to manipulate and customize the document according to their preferences and needs.

Submit
31. Which of the following statements about using Outline Mode to display reports is true?

Explanation

Outline Mode is a feature in MicroStrategy that allows users to view report results in an indented, hierarchical format. This mode is useful for displaying data in a structured manner, particularly when dealing with hierarchical data such as organizational charts or product categories. It does not require the use of MicroStrategy OLAP Services or any specific sorting of the report before enabling Outline Mode.

Submit
32. This type of report or document already has all of the content defined at run time.

Explanation

A static report or document refers to a type of report or document that has all of its content defined at run time. This means that the content of the report or document is fixed and does not change dynamically. The information presented in the report or document remains the same regardless of any changes in the data or variables. Therefore, the correct answer is "Static."

Submit
33.
Which of the following statements about thresholds is true?

Explanation

Thresholds are visual indicators that certain conditions exist in data. In MicroStrategy Web, you first define the conditions and then format metric values to display in specific ways when those conditions are met. You do not have the option to toggle thresholds on and off.

Submit
34. Which of the following statements about derived metrics is false?

Explanation

The statement "You can save them and re-use them on other reports" is false. Derived metrics cannot be saved and re-used on other reports.

Submit
35. Which of the following statements about MicroStrategy OLAP Services is true?

Explanation

MicroStrategy OLAP Services allows users to include attributes and metrics in the Report Objects window without displaying them on the template. This feature provides flexibility in organizing and managing the objects within a report, allowing users to easily access and use these objects without cluttering the visual representation of the report.

Submit
36. Which of the following is not a method for performing drilling on a report?

Explanation

Dragging an attribute to the Drill panel is not a method for performing drilling on a report. The other three options mentioned, clicking on a hyperlinked attribute element name, right-clicking and using the Drill menu, and using the Drill panel are all valid methods for performing drilling on a report.

Submit
37. To which of the following applications can you export report results?

Explanation

You can export report results to PDF, Microsoft Word, and Microsoft Access. This means that you have the option to save the report in any of these formats, depending on your preference or the requirements of the application or software you are using.

Submit
38. Which of the following statements about adding reports and documents to the History List is false?

Explanation

When adding reports and documents to the History List, it is false to say that you cannot add them from the wait page as they are executing. In fact, you can add them from the wait page while they are executing. The History List allows you to subscribe to reports and documents and retrieve the results, and you can also add them to the list when you are viewing the result.

Submit
39. Which of the following statements about the Quick Switch feature in documents is true?

Explanation

not-available-via-ai

Submit
40. Which of the following statements about subscriptions in MicroStrategy Web is true?

Explanation

Subscriptions in MicroStrategy Web are beneficial for reports or documents that need to be executed regularly at specific times or take longer to process. By subscribing to a report or document, users can request the administrator to execute it based on a schedule of their choice. Additionally, users have the ability to create their own schedules and use them to subscribe to reports and documents.

Submit
41. Which of the following statements about sorting report data is false?

Explanation

The given statement is false because you cannot perform an advanced sort using the sort buttons. The sort buttons in a report are usually designed to perform a basic sort, such as sorting data in ascending or descending order based on a single column. To perform an advanced sort, which involves sorting data sequentially by multiple rows or columns, you would typically need to use more advanced sorting features or functions provided by the software or application you are using.

Submit
42. Which folder allows you to access reports or documents that ran automatically using schedules?

Explanation

The History List folder allows you to access reports or documents that ran automatically using schedules. This folder keeps a record of all the reports or documents that have been generated and can be accessed for reference or further analysis.

Submit
43. 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.

Explanation

The given statement is referring to the feature of MicroStrategy called "Data Warehouse." A data warehouse is a centralized repository that stores all the information from various source systems. It is specifically designed for data analysis and reporting purposes, allowing users to access and analyze data from different sources in a structured and organized manner. By using a data warehouse, organizations can consolidate and integrate data from disparate systems, enabling more efficient and effective analysis.

Submit
44. With MicroStrategy OLAP Services, which of the following scenarios requires new SQL to be generated for a report?

Explanation

When you remove an attribute from the Report Objects window, it will affect the SQL query generated for the report. This is because the attribute is no longer included in the report, so the SQL query needs to be updated to reflect this change and exclude the removed attribute from the query results.

Submit
45. Which of the following statements about view filters is true?

Explanation

View filters in this context refer to filters that can be applied to a report in order to limit the data that is displayed. The correct answer states that view filters can only be created based on attributes and metrics in the Report Objects window. This means that the filters can only be created using the available attributes and metrics in the report, and cannot be created based on other criteria or conditions.

Submit
46. Which of the following statements about predesigned reports in MicroStrategy Web is false?

Explanation

The given correct answer states that predesigned reports in MicroStrategy Web can have a report filter. This means that the statement "They cannot have a report filter" is false. Predesigned reports in MicroStrategy Web do have the capability to include a report filter, allowing users to further refine the data displayed in the report.

Submit
47. Which Document Display Mode allows you to view the document results only and provides the best performance.

Explanation

Express mode allows you to view the document results only and provides the best performance. This mode is designed for quickly accessing and viewing the document without any additional features or interactivity. It is ideal for situations where speed and efficiency are prioritized over advanced functionality.

Submit
48. Which of the following statements about saving prompted reports is false?

Explanation

The statement "You can choose to keep either the filter or the template as prompted, or both" is true, not false. This means that you have the flexibility to save a prompted report with either the filter or the template as prompted, or even both.

Submit
49. Which of the following statements is true with regard to report creation for a Web Reporter/Analyst?

Explanation

This user can create reports from a Predesigned Report and a Prompted Predesigned Report. This means that the user has the ability to generate reports using pre-existing report templates and also make use of prompted report templates which require user input for customization. However, the statement does not mention the user's ability to create reports from scratch or create documents, so these options cannot be considered as true based on the given statement.

Submit
50. This special type of derived metric allows you to create percent to total and rank calculations based on existing metrics in the report.

Explanation

A shortcut metric is a special type of derived metric that allows you to create percent to total and rank calculations based on existing metrics in the report. It provides a quick and efficient way to perform these calculations without having to manually create complex formulas or calculations.

Submit
View My Results

Quiz Review Timeline (Updated): Sep 26, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Sep 26, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 15, 2012
    Quiz Created by
    Gregbutler
Cancel
  • All
    All (50)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Which of the following objects enables users to select the information...
Which of the following views can you use to display reports?
Which of the following objects provides descriptive information from...
After you run a report, what report manipulation enables you to view...
After running a prompted report, you are interested in selecting...
Which of the following features would you use to make all of your...
Which formats can you export reports to?
This folder contains reports, documents, and other objects that are...
Which of the following statements about prompts is true?
This functionality enables a report to be divided into separate pages...
If you run a report that originally shows sales data at the country...
Which of the following statements about reports in MicroStrategy Web...
You have a report that shows weekly regional performance based on...
If you want to customize your print settings, which of the following...
Which of the following statements best describes the MicroStrategy...
This feature enables you to easily select the data you want to keep...
Which of the following statements about view filters is true?
Which of the following statements about viewing documents in...
Which one of these objects is NOT a schema object?
Which of the following statements about data pivoting is true?
You have a report with a large result set. As you scroll down the...
Which type of prompt display option enables users to enter a single...
In MicroStrategy Web, a document can be displayed in which of the...
Which of the following statements about advanced drilling on reports...
Which of the following statements about adding totals to a report is...
All reports in MicroStrategy are made up of a filter and the following...
What report manipulation involves moving individual attributes or...
You can only create Derived Elements on a report that is based on a...
While viewing a document, which of the following statements about the...
In a document, you can use a selector to perform which of the...
Which of the following statements about using Outline Mode to display...
This type of report or document already has all of the content defined...
Which of the following statements about thresholds is true?
Which of the following statements about derived metrics is false?
Which of the following statements about MicroStrategy OLAP Services is...
Which of the following is not a method for performing drilling on a...
To which of the following applications can you export report results?
Which of the following statements about adding reports and documents...
Which of the following statements about the Quick Switch feature in...
Which of the following statements about subscriptions in MicroStrategy...
Which of the following statements about sorting report data is false?
Which folder allows you to access reports or documents that ran...
Which feature of MicroStrategy is this statement referring to:...
With MicroStrategy OLAP Services, which of the following scenarios...
Which of the following statements about view filters is true?
Which of the following statements about predesigned reports in...
Which Document Display Mode allows you to view the document results...
Which of the following statements about saving prompted reports is...
Which of the following statements is true with regard to report...
This special type of derived metric allows you to create percent to...
Alert!

Advertisement