Download IBM Cognos Analytics Author V11.C2090-621.Prep4Sure.2019-04-30.44q.vcex

Vendor: IBM
Exam Code: C2090-621
Exam Name: IBM Cognos Analytics Author V11
Date: Apr 30, 2019
File Size: 795 KB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Purchase
Coupon: EXAM_HUB

Discount: 20%

Demo Questions

Question 1
A report author wants to nest a chart within a list and filter the chart data to relate to the row of the list that it is displayed in. 
How can this be done?
  1. Enable share result set on the list object.
  2. Create a join in the Query explorer to merge the data.
  3. Select the list and define a Master detail relationship.
  4. Select the chart and define a Master detail relationship.
Correct answer: D
Question 2
An Active Report contains a data deck with the following values on multi select controls:
  
How many cards would be generated?
  1. 5
  2. 9
  3. 14
  4. 20
Correct answer: D
Question 3
A report author has applied one style in specific cells, and another style for the overall report. 
Which style will be applied?
  1. The style on the specific cell is applied.
  2. The style on the overall report is applied.
  3. The last style in the Conditional styles property is applied.
  4. 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 4
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?
  1. Below Region using a horizontal drop zone.
  2. Above Region using a horizontal drop zone.
  3. To the left of Region using a vertical drop zone.
  4. To the right of Region using a vertical drop zone.
Correct answer: D
Question 5
A report author wants to conditionally format data depending on a parameter value a user specifies at run time. 
How can this be done?
  1. By applying parameters directly in a variable.
  2. By using an HTML item to implement the parameter.
  3. By referencing a query item that uses the parameter.
  4. By applying the parameter in the color and background section of the properties.
Correct answer: A
Question 6
A report author has created this join relationship:
  
The Order number by product query includes only orders that contain a specific product selected at run time. 
What must the report author do to ensure that the joined query will only contain Order numbers that appear in both of the queries?
  1. Select “+” from the Operator drop down list.
  2. Select “=” from the Operator drop down list.
  3. Select “in” from the Operator drop down list.
  4. Select “>=” from the Operator drop down list.
Correct answer: B
Question 7
The sales department has requested the report author to build a report which combines a list with a chart. The list must contain product lines and the chart should show details for each product line. The report author decided to use a Master detail relationship to build this report. 
Which statement about Master detail relationships is true?
  1. Calculations across Master detail queries can be performed.
  2. Parent data in the child frame or child data in the parent frame can be displayed.
  3. Master detail relationships must appear in nested frames to produce the correct results.
  4. When working with an SAP BW Data source, a data item from the master query that contains non-ASCII values can be used.
Correct answer: C
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_create_master_detail_relationship_rel.html
Reference: https://www.ibm.com/support/knowledgecenter/SSEP7J_11.0.0/com.ibm.swg.ba.cognos.ug_cr_rptstd.doc/t_cr_rptstd_modrep_create_master_detail_relationship_rel.html
Question 8
What should a report author do to use data from two tabs of an Excel file (.xlsx) together in a single object in a Dashboard?
  1. Upload each tab as one upload file and merge together within a data module.
  2. Upload each tab as separate upload files and merge together within a data module.
  3. Create separate Excel files for each tab, upload the files as one upload file and merge together within a data module.
  4. Create separate Excel files for each tab, upload the files as separate upload files and merge together within a data module.
Correct answer: C
Question 9
Which statement is true when a report author wants to optimize reports for mobile users?
  1. Set objects to a fixed size.
  2. Use margins between report objects.
  3. Size objects as a percentage of the available space.
  4. Use percentage sizes greater than one hundred percent (100%).
Correct answer: C
Question 10
An author wants to include a corporate graphic in the Dashboard. 
Which image format is supported?
  1. SVG
  2. BMP
  3. TIFF
  4. JPEG
Correct answer: D
Explanation:
Reference: http://www.wou.edu/datawarehouse/files/2016/06/IBM_Cognos_Workspace_Advanced_User_Guide.pdf (page 155)
Reference: http://www.wou.edu/datawarehouse/files/2016/06/IBM_Cognos_Workspace_Advanced_User_Guide.pdf (page 155)
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!