IBM C2020-612 Online Practice Questions and Exam Preparation

IBM C2020-612 Online Questions & Answers

• Question 41:

  In Report Studio, an author wants to conditionally format a list report according to the revenue generated by each product line. The Revenue data item does not appear in the list report but is contained in Query1. Which of the following must the author do in order to apply this conditional formatting?

  A. Make the Revenue data item a property of Query1.
  B. Make the Revenue data item a property of the List object.
  C. Make the Revenue data item a property of the Page object.
  D. Make the Revenue data item a property of the Variable object.
  B. Make the Revenue data item a property of the List object.

• Question 42:

  In Report Studio, an author wants to use a join object to create a relationship between two queries. Which of the following is true?

  A. The author can use a join object to create eitheran inner or outer join between the queries.
  B. The author can use a join object only if both queries contain data from OLAP data sources.
  C. The author can use a join object only if both queries contain data from relational sources that has not been modeled dimensionally.
  D. Both queries must contain the same number of data items, the data items must be compatible and must appear in the same order.
  A. The author can use a join object to create eitheran inner or outer join between the queries.

• Question 43:

  In the report shown in the image,

  

  users click on the Retailer name in theleft and see the related data on the right. What is the technique used to create this report?

  A. Master-detail relationship where the master and the detail is in a separate list
  B. Drill-through definition where one column in a list drills through toa separate list in the same report
  C. Master-detail relationship where the master and the detail is in the same list
  D. Drill-through definition where one column in a list drills through to the same list in the same report
  B. Drill-through definition where one column in a list drills through toa separate list in the same report

• Question 44:

  An author creates a report for bursting. In Report Studio, the author sets the burst type for the report to Directory entries. In Cognos Connection, the author sets the run options to burst the report and send the report by email. If the email addresses for the burst recipients are accessible by IBM Cognos BI, whatis the expected result?

  A. The report is burst to email addresses only.
  B. The report is burst to both email addresses and directory entries.
  C. The report is burst to directory entries only.
  D. A warning message appears indicating a conflict in the run options.
  B. The report is burst to both email addresses and directory entries.

• Question 45:

  In Report Studio, anauthor wants the report title to appear in the language in which the report is run. What property of the report header must the author define to create this variable?

  A. Style Variable
  B. String Variable
  C. Render Variable
  D. Text Source Variable
  D. Text Source Variable

• Question 46:

  In Report Studio, a query contains the data item Product Line, which is grouped. Which of the following will add a page break for each Product Line?

  A. Create a section on Product Line.
  B. Add a new page for each Product Line.
  C. Set the rows per page property to Product Line.
  D. Create a page set that is associated with the query.
  D. Create a page set that is associated with the query.

• Question 47:

  The sales department requires a report that numerically compares the gross profitgenerated for all product lines in each territory. In Report Studio, which is the most appropriate report type?

  A. List
  B. Chart
  C. Crosstab
  D. Map report
  C. Crosstab

• Question 48:

  In the report shown,

  

  users click on the Product line link to navigate to the specific product line in the list below.

  Users can also click on the Top link to return to the Product line list at the top of the report.

  Bookmarks are used to control this drill-through behavior. How is each of the drill-throughs defined for this report to function as described?

  A. Product line drill-through: bookmark source type = Text, where Text =Top;Topdrill-through: bookmark source type = Data Item Value, where Data Item = Product line
  B. Product line drill-through: bookmark source type = Data Item Label, where Data Item = Product line;Top drill-through: bookmark source type = Text, where Text =Top
  C. Product line drill-through: bookmark source type = Data Item Value, where Data Item = Product line;Top drill-through: bookmark source type = Text, where Text =Top
  D. Product line drill-through: bookmark source type = Text, where Text = Top;Top drill-through: bookmark source type = Data Item Value, where Data Item = Product line
  C. Product line drill-through: bookmark source type = Data Item Value, where Data Item = Product line;Top drill-through: bookmark source type = Text, where Text =Top

• Question 49:

  In Report Studio, an author notices that the Revenue measure included in a list report has an Aggregate Function property of Total. What does this property mean?

  A. If the Auto Group andSummarize property for the query is set to No, the list displays total revenue values for the lowest level of detail in the report.
  B. If the Auto Group and Summarize property for the query is set to Yes, the list displays total revenue values for the lowest level of detail in the report.
  C. If the Auto Group and Summarize property for the query is set to No, the list displays total revenue values for highest level of detail in the report.
  D. If the Auto Group and Summarize property for the query is set to Yes,the list displays total revenue values for highest level of details in the report.
  B. If the Auto Group and Summarize property for the query is set to Yes, the list displays total revenue values for the lowest level of detail in the report.