C2090-620 Online Practice Questions and Answers

In Report Studio, an author creates a list report containing columns for Staf Name, Order number, and Revenue. The author wants to burst this report to various sales staf members. Each member should see only data relatng to sales they have made. What must the author do to specify that the burst report output will contain only data for the appropriate sales staf member?

A. In the report layout, create a master-detail relatonship on the Staf Name data item.

B. In the report layout, add the Staf Name data item as a property of the List object.

C. In the burst optons for the report, use the Staf Name data item to specify the Burst Recipients.

D. In the burst optons for the report, use the Staf Name data item to specify the Burst Groups.

In Report Studio, when creatng a list report, what is the diference between creatng a secton and creatng a header?

A. Headers appear outside the list.

B. Sectons appear outside the list.

C. Headers appear once at the top of the list.

D. Sectons appear once at the top of the list.

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

How were these rows created?

A. By using a table outside of the list

B. By insertng list row cells in the list header

C. By unlocking cells and insertng text items into the column header

D. By using a block, padding and text items added to the overall header

In the report shown,

users click on the Product line link to navigate to the specifc product line in the list below. Users can also click on the Top link to return to the Product line list at the top of the report. Bookmarks are used to control this drill-through behavior. How is each of the drill-throughs defned for this report to functon as described?

A. Product line drill-through: bookmark source type = Text, where Text =Top;Top drill-through: bookmark source type = Data Item Value, where Data Item = Product line

B. Product line drill-through: bookmark source type = Data Item Label, where Data Item = Product line;Top drill-through: bookmark source type = Text, where Text =Top

C. Product line drill-through: bookmark source type = Data Item Value, where Data Item = Product line;Top drill-through: bookmark source type = Text, where Text =Top

D. Product line drill-through: bookmark source type = Text, where Text = Top;Top drill-through: bookmark source type = Data Item Value, where Data Item = Product line

In Report Studio, a report contains several blocks and tables. To determine if there is sufcient space between objects, what will show how the report looks when it is generated?

A. View a Print Preview.

B. Hide the boundary lines.

C. Unlock the report objects.

D. Open the Page Structure view.

In Report Studio, if an author adds a prompt to a report page containing a list, how can the author prevent an automatcally generated prompt from appearing when the report runs?

A. Add a Statc Choice

B. Specify a Default Selecton

C. Set the Auto-Submit property to Yes

D. Change the Required property to No

In Report Studio, when should authors use a Generated Prompt?

A. They only want the user to be able to choose one opton.

B. They are unsure of the most appropriate prompt type to choose.

C. They want to use the same prompt on a prompt page and a report page.

D. They want the optons to be based on selectons made in another prompt.

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 Quantty sold. The author wants to display the data from 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 Order method data item in Query1 and the Product line data item in Query2.

C. The author must sort the data item in the Query3 that retrieves both Order method and Product line data.

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, an author creates the following report:

The author wants the report to show the total revenue generated by each Product line. How can the author accomplish this?

A. In Query Explorer, change the Rollup Aggregate Functon property for the Revenue data item to Total.

B. In Query Explorer, change the Rollup Aggregate Functon property for the Product line data item to Total.

C. In the layout, group the Product line column and then add an aggregate row showing total revenue values.

D. In the layout, group the Product type column and then add an aggregate row showing total revenue values.

In Report Studio, an author wants to conditonally format a list report according to the revenue generated by each product line. The Revenue data item does not appear in the list report but is contained in Query1.

Which of the following must the author do in order to apply this conditonal formatng?

A. Make the Revenue data item a property of Query1.

B. Make the Revenue data item a property of the List object.

C. Make the Revenue data item a property of the Page object.

D. Make the Revenue data item a property of the Variable object.