MicroStrategy Web
Multiple Choice (2pts each).
Please select the best answer for each of the following questions. There is only ONE correct answer.
- 1.
Which of the following statements best describes the MicroStrategy Metadata?
- 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
Correct Answer
B. It contains the definition of reports as well as all of the objects that are included in reports.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.Rate this question:
-
- 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
Correct Answer
B. AttributeExplanation
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.Rate this question:
-
- 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
Correct Answer
C. PromptExplanation
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.Rate this question:
-
- 4.
All reports in MicroStrategy are made up of a filter and the following object:
- A.
Hierarchies
- B.
Fact
- C.
Template
Correct Answer
C. TemplateExplanation
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.Rate this question:
-
- 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
Correct Answer
C. Shared ReportsExplanation
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.Rate this question:
-
- 6.
Which of the following statements about prompts is true?
- 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.
Correct Answer
B. A prompt may have a default answer already selected when you first view it.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.Rate this question:
-
- 7.
This type of report or document already has all of the content defined at run time.
- A.
Static
- B.
Predefined
- C.
Prompted
Correct Answer
A. StaticExplanation
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."Rate this question:
-
- 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
Correct Answer
B. Text BoxExplanation
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.Rate this question:
-
- 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
Correct Answer
D. All of the aboveExplanation
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.Rate this question:
-
- 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
Correct Answer
A. DrillingExplanation
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.Rate this question:
-
- 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
Correct Answer
D. Page-byExplanation
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.Rate this question:
-
- 12.
While viewing a document, which of the following statements about the grouping feature is true?
- 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.
Correct Answer
A. Grouping in documents is similar to the page-by axis in reportsExplanation
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.Rate this question:
-
- 13.
Which of the following statements about sorting report data is false?
- 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.
Correct Answer
B. You can perform an advanced sort using the sort buttonsExplanation
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.Rate this question:
-
- 14.
Which of the following is not a method for performing drilling on a report?
- 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
Correct Answer
C. Dragging an attribute to the Drill panelExplanation
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.Rate this question:
-
- 15.
In MicroStrategy Web, a document can be displayed in which of the following view modes?
- A.
Dynamic
- B.
Interactive
- C.
Static
- D.
Simplified
Correct Answer
B. InteractiveExplanation
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.Rate this question:
-
- 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
Correct Answer
C. ThresholdsExplanation
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."Rate this question:
-
- 17.
Which of the following statements about the Quick Switch feature in documents is true?
- 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
Correct Answer
B. You use Quick Switch for changing the display of a grid to a graph and vice versa in a document -
- 18.
In a document, you can use a selector to perform which of the following manipulations?
- 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
Correct Answer
D. All of the aboveExplanation
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.Rate this question:
-
- 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
Correct Answer
B. Clicking the Re-prompt buttonExplanation
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.Rate this question:
-
- 20.
Which of the following statements about subscriptions in MicroStrategy Web is true?
- 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
Correct Answer
A. Subscriptions are useful for reports or documents that you routinely execute at specific times or for ones that take longer to processExplanation
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.Rate this question:
-
- 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
Correct Answer
B. History ListExplanation
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.Rate this question:
-
- 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
Correct Answer
A. PDFExplanation
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.Rate this question:
-
- 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
Correct Answer
B. AutostyleExplanation
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.Rate this question:
-
- 24.
Which of the following statements about using Outline Mode to display reports is true?
- 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
Correct Answer
B. It enables an indented, hierarchical display of report resultsExplanation
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.Rate this question:
-
- 25.
Which of the following statements about thresholds is true?
- 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
Correct Answer
A. Thresholds are visual indicators that certain conditions exist in dataExplanation
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.Rate this question:
-
- 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
Correct Answer
B. DrillingExplanation
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.Rate this question:
-
- 27.
Which of the following statements about viewing documents in Interactive Mode is true?
- 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
Correct Answer
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 displayedExplanation
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.Rate this question:
-
- 28.
Which of the following statements about view filters is true?
- 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
Correct Answer
C. You can only create view filters based on attributes and metrics in the Report Objects windowExplanation
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.Rate this question:
-
- 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
Correct Answer
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 resultExplanation
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.Rate this question:
-
- 30.
With MicroStrategy OLAP Services, which of the following scenarios requires new SQL to be generated for a report?
- 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
Correct Answer
B. You remove an attribute from the Report Objects windowExplanation
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.Rate this question:
-
- 31.
Which of the following statements about derived metrics is false?
- 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
Correct Answer
B. You can save them and re-use them on other reportsExplanation
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.Rate this question:
-
- 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
Correct Answer
B. Shortcut metricExplanation
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.Rate this question:
-
- 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
Correct Answer
B. Pivoting enables you to quickly and easily rearrange data so that you can view it from multiple perspectivesExplanation
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.Rate this question:
-
- 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
Correct Answer
B. Data pivotingExplanation
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.Rate this question:
-
- 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
Correct Answer
A. Advanced drills enable you to drill to any attribute in any hierarchyExplanation
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.Rate this question:
-
- 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
Correct Answer
B. Filter on SelectionsExplanation
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.Rate this question:
-
- 37.
Which of the following statements about view filters is true?
- 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
Correct Answer
A. A view filter is used to display only a subset of the full result setExplanation
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.Rate this question:
-
- 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
Correct Answer
A. You can define subtotals, which calculate totals at various attribute levels in a reportExplanation
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.Rate this question:
-
- 39.
Which of the following statements about saving prompted reports is false?
- 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
Correct Answer
B. You can choose to keep either the filter or the template as prompted, or bothExplanation
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.Rate this question:
-
- 40.
Which of the following statements about adding reports and documents to the History List is false?
- 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
Correct Answer
B. You cannot add them from the wait page as they are executingExplanation
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.Rate this question:
-
- 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
Correct Answer
C. Lock row and column headersExplanation
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.Rate this question:
-
- 42.
Which of the following statements about MicroStrategy OLAP Services is true?
- 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
Correct Answer
B. It enables you to include attributes and metrics in the Report Objects window without displaying them on the templateExplanation
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.Rate this question:
-
- 43.
Which of the following statements about predesigned reports in MicroStrategy Web is false?
- 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
Correct Answer
B. They cannot have a report filterExplanation
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.Rate this question:
-
- 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
Correct Answer
B. Express modeExplanation
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.Rate this question:
-
- 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
Correct Answer
C. Data WarehouseExplanation
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.Rate this question:
-
- 46.
Which one of these objects is NOT a schema object?
- A.
Metric
- B.
Attribute
- C.
Fact
- D.
Hierarchy
Correct Answer
A. MetricExplanation
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.Rate this question:
-
- 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
Correct Answer
A. This user can create reports from a Predesigned Report and a Prompted Predesigned ReportExplanation
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.Rate this question:
-
- 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
Correct Answer
A. PreferencesExplanation
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.Rate this question:
-
- 49.
You can only create Derived Elements on a report that is based on a published Intelligent Cube.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.Rate this question:
-
- 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
Correct Answer
E. All of the aboveExplanation
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.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Sep 26, 2023Quiz Edited by
ProProfs Editorial Team -
May 15, 2012Quiz Created by
Gregbutler
Back to top