File Info
| Exam | IBM Cognos Analytics Author V11 |
| Number | C2090-621 |
| File Name | IBM.C2090-621.PracticeTest.2018-08-17.33q.tqb |
| Size | 1 MB |
| Posted | Aug 17, 2018 |
| Download | IBM.C2090-621.PracticeTest.2018-08-17.33q.tqb |
How to open VCEX & EXAM Files?
Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.
Coupon: MASTEREXAM
With discount: 20%
Demo Questions
Question 1
A report author has applied one style in specific cells, and another style for the overall report.
Which style will be applied?
- The style on the specific cell is applied.
- The style on the overall report is applied.
- The last style in the Conditional styles property is applied.
- The first style in the Conditional styles property is applied.
Correct answer: C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html Reference: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_8.4.0/com.ibm.swg.im.cognos.ug_rptstd_fin.8.4.0.doc/ug_rptstd_fin_id3759cr_rptstd_modrep_highlight_data_con.html
Question 2
A report author has applied a Union set operation on two queries with the resultant query named Main_Query containing the data items: Product line, Order method/Region, Revenue and Unit Sale Price. The report author added the data items to the list, grouped on Product line and Order method/Region. The screenshot below shows the result:
What must the report author do for the report to look like the following?
- Set the detail aggregation property to Automatic for each field.
- Set the detail aggregation property to None for product line and order method. Total for Revenue. Average for Unit Sale Price.
- Set the detail aggregation property to None for only Product Line and Order Method. Automatic for Revenue. Average for Unit Sale Price.
- Set the detail aggregation property to Default for product line and Order method. Default for Revenue and Average for Unit Sale Price.
Correct answer: C
Question 3
A report author created a crosstab as shown below:
The crosstab report, when run, shows the following data:
The author wants to split the revenue for each region by year.
Where should the year data item be added?
- Below Region using a horizontal drop zone.
- Above Region using a horizontal drop zone.
- To the left of Region using a vertical drop zone.
- To the right of Region using a vertical drop zone.
Correct answer: D
