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, an author creates a report using Package In Report Studio, an author creates a report using Package A. Users should be able to drill through to target reports created for this package. What must the author do?

A. Enable package drill-through behavior for the report.

B. Add this report as a source report for each target created for the package.

C. Add all drill-through defnitons created for the package as targets for the source report.

D. Add all drill-through defnitons created for the package to the scope of the report.

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

A. Style

B. String

C. Boolean

D. Language

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.

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, why would an author create Statc Choices for a prompt?

A. To provide prompt optons that are not found in the data source.

B. So that the prompt appears with an opton selected by default.

C. To provide default values to satsfy a parameter so a prompt page will not appear.

D. So that the items that appear in the prompt depend on items selected in another prompt.

An author wants to create a flter on this report to only show Product line totals larger than 1 billion.

What calculaton is used to create this flter?

A. Detail flter as: [Total (Revenue)] for [Product line] >1000000000Applicaton = Afer auto aggregaton

B. Detail flter as: [Total (Revenue)]>1000000000Scope = Product line

C. Summary flter as: [Total(Revenue)]>1000000000Scope = Product line

D. Summary flter as: [Total(Revenue)] for [Product line]>1000000000)Applicaton = Afer auto aggregaton

In Report Studio, an author edits the SQL statement that a query uses to retrieve data for a crosstab. Afer editng the SQL, the author wants to add a new data item to the query. How can the author add the data item?

A. The author must convert the edited SQL back to a query object and then add the data item.

B. The author must edit the SQL statement so that the query retrieves an additonal data item.

C. The author must add the data item to the query from the package displayed on the Source tab.

D. The author must add a query reference to the existng query and then add the data item to the referenced query.

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.