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, which variable requires the author to create values?

A. Style

B. String

C. Boolean

D. Language

In Report Studio, which report outputs can produce a bookmark?

A. CSV and PDF

B. CSV and Excel

C. HTML and PDF

D. Excel and HTML

In the image below,

the last column calculates the percentage that each Product type contributed to the overall revenue. What is the calculaton in the last column?

A. percentage ([Revenue])

B. percentage ([Revenue] for Product type)

C. percentage ([Product type] for [Revenue])

D. percentage ([Product type])

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

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.

The sales department requires a report that numerically compares the gross proft generated for all product lines in each territory. In Report Studio, which is the most appropriate report type?

A. List

B. Chart

C. Crosstab

D. Map report

In Report Studio, an author wants to use a join object to create a relatonship between two queries. Which of the following is true?

A. The author can use a join object to create either an inner or outer join between the queries.

B. The author can use a join object only if both queries contain data from OLAP data sources.

C. The author can use a join object only if both queries contain data from relatonal sources that has not been modeled dimensionally.

D. Both queries must contain the same number of data items, the data items must be compatble and must appear in the same order.