Online Access Free C2090-620 Practice Test

The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country.

What will the report show if the author creates a detail filter for Revenue>500,000 and applies the filter AFTER auto aggregation?

• A.Only reps who generated total revenue greater than 500,000.
• B.Only countries that generated total revenue greater than 500,000.
• C.Only reps who had individual sales transactions of greater than 500,000.
• D.Only cities that generated total revenue greater than 500,000.

In Report Studio, an author merges Query1 and Query2 into one result set (Query3) using a Union set operator. Query1 contains two data items: Order method and Revenue. Query2 also contains two data items: Product line and Quantity sold. The author wants to display the datafrom Query3 in a list report. How can the author ensure that all the order method results appear together and all product line results appear together in the list report?

• A.The author must add a sort key data item directly to Query3.
• B.The author must sort the data item in the Query3 that retrieves both Order method and Product line data.
• C.The author must sort the Order method data item in Query1 and the Product line data item in Query2.
• D.The author must add a sort key data item to Query1 and to Query2, and then add this sort key data item to Query3.

In Report Studio, when would the author need to unlock cells on a report?

• A.To merge query items into a single column.
• B.To merge a query item into a text item.
• C.To merge report objects in table.
• D.To merge two report types into a single report.

The image below contains two rows of information above the column headers.

How were these rows created?

• A.By using a block, padding and text items added to the overall header
• B.By using a table outside of the list
• C.By unlocking cells and inserting text items into the column header
• D.By inserting list row cells in the list header

In Report Studio, why would an author create Static Choices for a prompt?

• A.To provide prompt options that are not found in the data source.
• B.So that the prompt appears with an option selected by default.
• C.So that the items that appear in the prompt depend on items selected in another prompt.
• D.To provide default values to satisfy a parameter so a prompt page will not appear.