C2090-620 Online Practice Questions and Answers

In Report Studio, which variable requires the author to create values?

A. Style

B. String

C. Boolean

D. Language

An author creates a report in Report Studio. The report contains a parameter for the Product line query item. The author wants to let users drill through to this report from a variety of reports created using the GO Data Warehouse (query) package. To ensure that this target report contains data for the appropriate products, the author wants to limit the report cells that users can drill through from in source reports. What must the author do when creatng the drill-through defniton?

A. Set the Product line query item as the target of the drill-through defniton.

B. Set the Product line query item as the scope of the drill-through defniton.

C. Add a parameter for the Product line query to the drill-through defniton.

D. Delete all data items except for the Product line query item from the drill-through defniton.

In Report Studio, for which task would an author create a query calculaton?

A. Add report run-tme informaton to a report.

B. Apply conditonal formatng to data in a report.

C. Let users choose which flter to apply to a report.

D. Derive additonal informaton from the data source.

An author wants to create a report that displays certain list columns depending on the user's prompt selecton. What property of the list column must the author defne to create this variable?

A. Text source variable

B. String variable

C. Style variable

D. Render variable

In Report Studio, what must an author create to let users view a report as either a list, a crosstab, or a chart?

A. A string variable

B. A Boolean variable

C. A query calculaton

D. A layout calculaton

In Report Studio, where can an author modify a global class to apply a change to all objects that use that class?

A. Page Explorer

B. Query Explorer

C. Conditonal Explorer

D. Page Structure view

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

What will the report show if the author creates a detail flter for Revenue>500,000 and applies the flter

AFTER auto aggregaton?

A. Only reps who generated total revenue greater than 500,000.

B. Only cites that generated total revenue greater than 500,000.

C. Only countries that generated total revenue greater than 500,000.

D. Only reps who had individual sales transactons of greater than 500,000.

In Report Studio, an author wants to change the locaton of the legend in the chart report. What property will accomplish this?

A. Auto Truncaton

B. Axis Assignment

C. Absolute Positon

D. Relatve Alignment

In Report Studio, what is a baseline?

A. A value in a list report that other values are compared against.

B. A constant value that represents the x-axis in a chart.

C. A constant value drawn on a chart to indicate major divisions in the data.

D. A break point that keeps part of a report statonary while the user scrolls.

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.