Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-621

IBM C2090-621 Exam Practice Questions (P. 3)

  • Full Access (105 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
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. A
    Below Region using a horizontal drop zone.
  2. B
    Above Region using a horizontal drop zone.
  3. C
    To the left of Region using a vertical drop zone.
  4. D
    To the right of Region using a vertical drop zone.

Correct Answer:
D

Question #12
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. A
    By applying parameters directly in a variable.
  2. B
    By using an HTML item to implement the parameter.
  3. C
    By referencing a query item that uses the parameter.
  4. D
    By applying the parameter in the color and background section of the properties.

Correct Answer:
A

Question #13
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. A
    Select "+" from the Operator drop down list.
  2. B
    Select "=" from the Operator drop down list.
  3. C
    Select "in" from the Operator drop down list.
  4. D
    Select ">=" from the Operator drop down list.

Correct Answer:
B

Question #14
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. A
    Calculations across Master detail queries can be performed.
  2. B
    Parent data in the child frame or child data in the parent frame can be displayed.
  3. C
    Master detail relationships must appear in nested frames to produce the correct results.
  4. D
    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
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 #15
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. A
    Upload each tab as one upload file and merge together within a data module.
  2. B
    Upload each tab as separate upload files and merge together within a data module.
  3. C
    Create separate Excel files for each tab, upload the files as one upload file and merge together within a data module.
  4. D
    Create separate Excel files for each tab, upload the files as separate upload files and merge together within a data module.

Correct Answer:
D

Previous Questions Next Questions

All Pages