IBM C2020-612 Online Practice Questions and Exam Preparation

IBM C2020-612 Online Questions & Answers

• Question 11:

  In Report Studio, based on the crosstab below,

  

  which of the following is true?

  A. Sales territory is a parent to Quantity and Revenue.
  B. Quantity and Revenue are a child to Gross Profit.
  C. Order method is apeer of Retailer type. Gross Profit is a child to all row and column headers.
  D. Sales territory is a peer of Order method.
  A. Sales territory is a parent to Quantity and Revenue.

• Question 12:

  The image below contains two rows of information above the column headers.

  

  How were these rows created?

  A. By using a table outside of the list
  B. By inserting list row cells in the list header
  C. By unlocking cells and inserting text items into the column header
  D. By using a block, padding and text items added to the overall header
  D. By using a block, padding and text items added to the overall header

• Question 13:

  In Report Studio, an author edits the SQL statement that a query uses to retrieve data for a crosstab. After editing the SQL, the author wants to add a new data item to the query. How can the author add the data item?

  A. The author must convert the edited SQL back to a query object and then add the data item.
  B. The author mustedit the SQL statement so that the query retrieves an additional data item.
  C. The author must add the data item to the query from the package displayed on the Source tab.
  D. The author must add a query reference to the existing query and then add the data item to the referenced query.
  B. The author mustedit the SQL statement so that the query retrieves an additional data item.

• Question 14:

  In Report Studio, which report outputs can produce a bookmark?

  A. CSV and PDF
  B. CSV and Excel
  C. HTML and PDF
  D. Excel and HTML
  C. HTML and PDF

• Question 15:

  In Report Studio, what must an author create to let users view a report as either a list, a crosstab, or a chart?

  A. A string variable
  B. A Boolean variable
  C. A query calculation
  D. A layout calculation
  A. A string variable

• Question 16:

  In Report Studio, an author creates a list report and adds four data items. The author then adds a crosstab to the report. Which of the following is true?

  A. Report Studio creates a new query for the crosstab report.
  B. Report Studio populates the crosstab with the four data items from the list.
  C. Report Studio links the crosstab to the same query as the list report.
  D. Report Studio automatically filters on dataitems that the list is filtered on.
  A. Report Studio creates a new query for the crosstab report.

• Question 17:

  An author wants to create a filter on this report to only show Product line totals larger than 1 billion.

  

  What calculationis used to create this filter?

  A. Detail filter as: [Total (Revenue)] for [Product line] >1000000000Application = After auto aggregation
  B. Detail filter as: [Total (Revenue)]>1000000000Scope = Product line
  C. Summary filter as: [Total(Revenue)]>1000000000Scope = Product line
  D. Summary filter as: [Total(Revenue)] for [Product line]>1000000000)Application = After auto aggregation
  C. Summary filter as: [Total(Revenue)]>1000000000Scope = Product line

• Question 18:

  The following report was created in Report Studio using a relational package and shows revenue by sales rep, city, and country.

  

  What will the report show if the author creates a detail filter for Revenue>500,000 and applies the filter AFTER auto aggregation?

  A. Only reps who generated total revenue greater than 500,000.
  B. Only cities that generated total revenue greater than 500,000.
  C. Only countries that generated total revenue greater than 500,000.
  D. Only reps who had individual sales transactions of greater than 500,000.
  A. Only reps who generated total revenue greater than 500,000.

• Question 19:

  In Report Studio, when should authors use a Generated Prompt?

  A. They only want the user to be able to choose one option.
  B. They are unsure ofthe most appropriate prompt type to choose.
  C. They want to use the same prompt on a prompt page and a report page.
  D. They want the options to be based on selections made in another prompt.
  B. They are unsure ofthe most appropriate prompt type to choose.

• Question 20:

  In Report Studio, which chart lets the report author plot a third measure?

  A. Area
  B. Bubble
  C. Scatter
  D. Progressive Column
  B. Bubble