IBM C2090-621 Exam Dumps

IBM C2090-621 Sample Question Answers

Question # 1

A report developer is tasked to create a drill-through definition in a report.Which are the generalized steps? 

A. Create the target report> Add parameter to target report> Save the target report> Set drill-through behavior
B. Set drill-through behavior on each report> Select the correct package> Map parameter values passedto target report> Define source report
C. Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable report variables for drill-through definitions> Save report
D. Create the target report> Create a drill-through definition that will allow users navigate from the targeted report to other created reports> Enable the drill behavior in the source report

Show Answer

Question # 2

A company is using a model that was created in Compatible Query Mode (CQM). There is a report that must reference query subjects from two different packages.How can this be accomplished?

A. The report author cannot create reports that reference multiple Data sources
B. The report author can add multiple packages to the reports as Data sources and create the report as needed. 
C. The report author must use SQL nodes for all queries that reference the data items in the two packages and join them appropriately to get the desired results within the report.
D. The report author can use user-defined SQL to develop the query from one of the packages and the other package to develop the other query and then join them appropriately to get the desired results within the report.

Show Answer

Question # 3

A company distributes a monthly email to the sales managers at the beginning of each month that shows how well they are doing using a tabular formatted report. The report is delivered in Excel format and the sales managers would like the report to be in a Crosstab format.How should the report be changed?

A. Use theconvert list to Crosstab option. Format and sort the Crosstab appropriately. Save the report.
B. Add a Crosstab data container to the report. Format and sort it appropriately. Delete the list data container and save the report.
C. Use the convert list toCrosstab option. Format and sort the Crosstab appropriately. Add a page set that is grouped on sales manager. Save the report. 
D. Add a repeater to the report. Use the convert list to Crosstab option. Format and sort the Crosstab appropriately. Place theCrosstab within the repeater. Create a Master detail relationship between the Crosstab and the repeater on sales manager. Save the report.

Show Answer

Question # 4

Which Data source can a report author connect to directly when creating a Dashboard? 

A. a report
B. a Data set
C. a relational Data source
D. a locally saved Excel file

Show Answer

Question # 5

A report author has applied one style in specific cells, and another style for the overall report.Which style will be applied? 

A. The style on the specificcell is applied.
B. The style on the overall report is applied.
C. The last style in the Conditional styles property is applied. 
D. The first style in the Conditional styles property is applied. 

Show Answer

Question # 6

A report contains multiple queries that are joined to form the report, resulting in poor performance. The company’s policy prohibits the use of user-defined SQL statements within reports.What should be done to improve report performance? 

A. Convert the report touse Native SQL statements
B. Move the appropriate filters to the underling queries.
C. Change the Cross Product allowed property to be “Deny”. 
D. Modify the Query Execution method to Concurrent to ensure that the underlying queries run at the same time

Show Answer