EMT Practice Test

1. Question Content...

---

Question1: A company has upgraded all of the models & packages to use Dynamic Query Mode (DQM). There is a report that must reference query subjects from two different packages.
How can this be accomplished?

Question2: A report author is using the Quantity fact data item multiple times in a list report. The desired outcome is to prevent double counting and provide predictable results.
From which location should the additional Quantity fact data be selected?

Question3: A report author wants to filter a report on two data items, and has decided to use a combined filter rather than two custom filters.
Why has the report author decided to use a combined filter?

Question4: The sales department has requested the report author to build a report which combines a list with a chart.
The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report.
Which statement about Master detail relationships is true?

Question5: A report author wants to generate an Active Report with a Chart, and allow the user to highlight a column within the Chart when a radio button is selected.

How should the report be created?

Question6: A report author has applied one style in specific cells, and another style for the overall report.
Which style will be applied?

Question7: A report author uploads files into Cognos Analytics - Reporting.
Which file formats are supported? (Choose two.)

Question8: A customer has a bar chart in a report that displays a steady increase in revenue by product line over time.
The requirement is to graphically illustrate this progression in the data series without significantly the report.
How can this be done?

Question9: A report author is building an Active Report for mobile use on an iPad. The report contains a list object.
The report author wants to ensure the entire list has a consistent size so that it does not affect the report layout.
Which techniques should be used to ensure this? (Choose two.)

Question10: A report author is asked to create a list report and add data by loading it in Cognos Analytics - Reporting.
Which option can be loaded?

Question11: An Active Report contains a data deck with the following values on multi select controls:

How many cards would be generated?

Question12: A report author was asked to create a report that displays Order method data within a List with a guide pointing to each Order method.
How can this be accomplished?

Question13: A report author has created a report as shown below:

What has been defined during the building of this report?

Question14: Which statement is true when a report author wants to optimize reports for mobile users?

Question15: An author wants to set a single value that will filter all other visualizations affected by its value.
Which visualization type should be used?

Question16: An author has created a dashboard and added a filter. The author anticipated this filter to be applied to all visualizations on the dashboard but it was only on some of them.
Why did this happen?

Question17: A report author needs the label in a List column title to be dynamic.
How can this be implemented with a dynamic value?

Question18: A report author wants to ensure a complete mobile experience on an iPad tablet by enabling swipe gesturing between pages of a Data deck.
What must be done to achieve this?

Question19: An author wants to add a visualization to a Dashboard that emphasizes the magnitude of change in data over time.
Which type of visualization should be used?

Question20: A company would like to distribute reports to users via an email address or a directory entry.
How should the burst table be defined for this to work appropriately?

Question21: A report author wants to conditionally format data depending on a parameter value a user specifies at run time.
How can this be done?

Question22: A customer wants to report the product types with the largest average revenue. In addition, the total revenue should be shown and all product types with revenue less than three percent (>3%) in a single bar.
Targeting this result:

How can this be done?

Question23: A report author wants to add calculations that were created in the published package to a report.
Where can this be done?

Question24: A report author created a crosstab as shown below:

The crosstab report, when run, shows the following data:

The author wants to split the revenue for each region by year.
Where should the year data item be added?

Question25: An author wants to include a corporate graphic in the Dashboard.
Which image format is supported?

Question26: What should a report author do to use data from two tabs of an Excel file (.xlsx) together in a single object in a Dashboard?

Question27: A report author has created this join relationship:

The Order number by product query includes only orders that contain a specific product selected at run time.
What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?

Question28: A report author needs to verify that the cardinality is set correctly in order to properly group a list report.
What is the correct setting?

Question29: A report author wants to provide a filter in a report on a data item that has a very large number of distinct values and the users may not know the complete names of the district values.
What type of prompt should be used?

Question30: A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in.
How can this be done?

Question31: A report author has the following filter in a report:
[Product line] in ?pline?
The report author adds a Value prompt based on the existing parameter 'pline'. After adding the prompt, the Auto-submit property is defaulted to 'No' and cannot be changed to 'Yes'.
What is the cause of this?

Question32: A report author is considering which SQL syntax to use for accessing various Data sources.
What is the advantage of using one type of SQL syntax above another?

Question33: A user is creating a Dashboard from an uploaded file and an additional Data source is needed.
From which source can the additional data be used directly?

Question34: A report author wants to create an Active Report with a Data deck that only prompts for Product line and Year. For each card created, the Order method type broken down by revenue should be shown.
What needs to be done to ensure the data on each card reflects the correct year and Product line?

Question35: A report author would like to reuse a logo across all existing reports.
Which object should be used?

Question36: A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.
How should the report be changed?

Question37: When using a SQL object, what is the property SQL syntax by default?

Question38: A report author wants to display the report name on the report page.
Which type of calculation should be used?

Question39: A report author requires two conditional styles to be both of which are used on a column.
How can the order in which to evaluate the conditions be specified?

Question40: A report author wants to show a value that is independent from the rest of the values in the report. For example, the total revenue value in the header of each page in a report.
Which type of object should be used?

Question41: A report author is asked to create a page break on a List.
What are the initial steps to be taken?

Question42: A report author has a requirement to create a data set from an available spreadsheet. Prior to uploading the data, the author needs to customize the data to show only the columns needed.
What option would be used?

Question43: The sales department has requested a change to a tabular account report and wants to be able to analyze the monthly amount of each Account name by Year. The report author changed the original report on left to the report on the right.


How was this done?

Question44: A report needs to modify the Interactive Behavior within an Active Report.
Which button can be used?
A:

B:

C:

D: