nerdexam
IBM

COG-612 · Question #25

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…

The correct answer is B. The author must edit the SQL statement so that the query retrieves an additional data item. See the full explanation below for the reasoning.

Question

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?

Options

  • AThe author must convert the edited SQL back to a query object and then add the data item.
  • BThe author must edit the SQL statement so that the query retrieves an additional data item.
  • CThe author must add the data item to the query from the package displayed on the Source tab.
  • DThe author must add a query reference to the existing query and then add the data item to the referenced query.

How the community answered

(36 responses)
  • A
    3% (1)
  • B
    78% (28)
  • C
    11% (4)
  • D
    8% (3)

Community Discussion

No community discussion yet for this question.

Full COG-612 Practice