IBM IBM Cogno C2090-645 Questions & Answers

• Question 41:

  A report author can use a slicer to dowhat?

  A. Make the report database smaller and efficient

  B. Provide context to intersection values

  C. Reduce the number of members on the edge of the crosstab.

  D. Generate a zero suppression filter in the rows

  Correct Answer: B

• Question 42:

  A report author is working with an OLAP data source. The reportauthor creates a query that uses a caption function on a member and applies a string function.

  What is a possible consequence of this action?

  A. Using these dimensional methods will not work with an OLAP data source.

  B. The mapped string values willnot pass through to the target report.

  C. There is nothing wrong with this approach.

  D. Mixing dimensional styles and relational styles in a single query can create unexpected results.

  Correct Answer: D

• Question 43:

  The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?

  A. A set expression

  B. An axis title

  C. A percent of base calculation

  D. The hierarchize function

  Correct Answer: A

• Question 44:

  When a report author inserts Revenue into the Measures area of a blank crosstab report, which of thefollowing statements is correct?

  A. The report author has implicitly set the default measure for the crosstab report to be Revenue.

  B. The report author must verify the aggregation properties of Revenue to make sure it will display correctly.

  C. Thereport author has declared a currentMember function to return the Revenue data.

  D. The report author must validate the expression for Revenue to ensure there are no crosstab errors.

  Correct Answer: A

• Question 45:

  In the data source shown,

  

  what dimensional component is selected?

  A. Dimension

  B. Hierarchy

  C. Namespace

  D. Level

  Correct Answer: B

• Question 46:

  Which of the following are dimensional objects?

  A. Sets and query calculation

  B. Query subject andrelationship cardinality

  C. Slicer and string function

  D. Level and member

  Correct Answer: B

• Question 47:

  Which statement is true about MUNs?

  A. They are used to define roll-up properties in a hierarchy.

  B. They are used to retrieve members from the data source.

  C. They change each time the package is published.

  D. They are used to retrieve levels from the data source.

  Correct Answer: B

• Question 48:

  A data source has a Time hierarchy, a Products hierarchy, and a Retailers hierarchy. What are the preferred techniques the report author would use to focus reports for this type of a data source?

  A. Dimensional functions and slicers

  B. Use Members directly

  C. Ancestors and descendants

  D. Detail filters and summary filters

  Correct Answer: A

• Question 49:

  Assuming that Star products and Husky products are sets,

  

  which statement below is correct about the sets in the graphic?

  A. Each set is a grouping of members from different hierarchies.

  B. The report creates a query for each member ofthe set.

  C. The query displays each set as all the members of the level.

  D. Each set can be sorted and aggregated.

  Correct Answer: D

• Question 50:

  A crosstab report has product lines in the rows, years in the columns, and revenue as the measure. In Query Explorer, from the source tree, the report author drags the order method Telephone to the Slicer pane.

  Why does the report author do this?

  A. To help to set the context.

  B. To create an ordered set.

  C. To return only one tuple.

  D. To aggregate the telephone member.

  Correct Answer: A