C2090-620 Online Practice Questions and Answers

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, an author creates a weekly sales report and modifes the global class setngs in the report. Which reports will this modifcaton afect?

A. All reports.

B. Reports created using the same package.

C. Reports created within the log on session.

D. Only the current report.

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.

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, a block object contains a text item in the page header. If the author reuses the block in the page footer, which of the following is true?

A. The author can replace the child object with an object of a diferent type.

B. The author must replace the child object with an object of the same type.

C. The author can replace the parent object with an object of the same type.

D. The author must replace the child object with an object of a diferent type.

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 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 the report shown in the image,

users click on the Retailer name in the lef and see the related data on the right. What is the technique used to create this report?

A. Master-detail relatonship where the master and the detail is in a separate list

B. Drill-through defniton where one column in a list drills through to a separate list in the same report

C. Master-detail relatonship where the master and the detail is in the same list

D. Drill-through defniton where one column in a list drills through to the same list in the same report

The following steps are used to create an agent in Event Studio. Which sequence logically orders the items from frst to last?

1.

Add a task

2.

Schedule the agent

3.

Specify an event conditon

4.

Specify the task executon rules

A. 1,2,3,4

B. 1,3,4,2

C. 3,1,4,2

D. 3,4,1,2

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.

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 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, 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.