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

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, 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, 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, a query contains the data item Product Line, which is grouped. Which of the following will add a page break for each Product Line?

A. Create a secton on Product Line.

B. Add a new page for each Product Line.

C. Set the rows per page property to Product Line.

D. Create a page set that is associated with the query.

In Event Studio, which of the following tasks are available to a report author?

A. Run an agent

B. Run an export

C. Run an import

D. Run an index update

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.

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 is using a relatonally modeled package and wants to flter a report to only include three specifc products. If the author is not sure how to spell the product names, what is the fastest way to add the product names to the flter expression?

A. Use a value prompt to have users select the product names.

B. Use the Select Multple Values feature to search for the product names.

C. Add the product names from the Source tab in the Available components pane.

D. Add the product names from the Data Items tab in the Available components pane.

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, which chart lets the report author plot a third measure?

A. Area

B. Bubble

C. Scater

D. Progressive Column

In Report Studio, an author creates a list report and adds four data items. The author then adds a crosstab to the report. Which of the following is true?

A. Report Studio creates a new query for the crosstab report.

B. Report Studio populates the crosstab with the four data items from the list.

C. Report Studio links the crosstab to the same query as the list report.

D. Report Studio automatcally flters on data items that the list is fltered on.

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.