Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-621

Free IBM C2090-621 Exam Questions (page: 12)

Page 5 of 27
PDF with 104 Questions

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.

Answer(s): B



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.

Answer(s): C


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



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.

Answer(s): D



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%).

Answer(s): A



Viewing page 12 of 27



Post your Comments and Discuss IBM C2090-621 exam prep with other Community members:

C2090-621 Exam Discussions & Posts