IBM IBM Cogno C2090-645 Questions & Answers

• Question 1:

  The following expression is used in a crosstab report: filter([sales_and_marketing]. [Product brand].[Product brand].[Product brand type],[Revenue]<100000000). There are 26 product brand types in the OLAP data source.

  

  Why does the report only return 11 product brand type rows?

  A. A relational function was used to filter on the measure values, not the members.

  B. A dimensional functionwas used to filter on each column.

  C. A relational function was used to filter on the members, not the measure values.

  D. A dimensional function was used to filter on the total of the opposite edge.

  Correct Answer: D

• Question 2:

  A report runs, and is 433pages long, with 19,010 rows. Many of the rows are blank. The report author uses a filter function to filter nulls, and runs the report again. The result is 143 pages, with 6273 rows, and none of the rows are blank. What filtering style did the report author decide to use?

  A. Conventional

  B. Dimensional

  C. Relational

  D. Functional

  Correct Answer: B

• Question 3:

  To display all individual campaigns in a crosstabreport, a report author could use the expression set([TrailChef Campaign],[EverGlow Campaign],[Course Pro Campaign]). Instead, the report author decides to use the parent member of the campaigns in the set expression "children([All Campaigns])".

  Which statement is true about the method that was used?

  A. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.

  B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.

  C. The report author should not have used the method chosen, as the first method is best in this situation.

  D. To be accurate, the report author should avoid using a set expression.

  Correct Answer: B

• Question 4:

  Instead of prompting the user to select any countries in Europe, the report author wants to constrain the user to select one or more countries from the Northern Europe region. What kind of prompt should be used and how can this be achieved?

  A. This is not possible because a prompt must always be populated with all members of a level.

  B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.

  C. Generate a prompt by creating an expression with a parameter on the crosstab edge: children([Northern Europe]->?Country?

  D. Create a tree prompt, and populate it using an expression on the[Northern Europe] member to retrieve its children at the country level.

  Correct Answer: B

• Question 5:

  Based on the diagram,

  

  if the expression firstSibling([2006 Q 1]) is used in the report, what item will be returned?

  A. 2005 Q 1

  B. 2006 Q 4

  C. 2006 Q 1

  D. Nothing, because the return value equals the parameter

  Correct Answer: C

• Question 6:

  What is the default behavior when drilling down on an edge in a crosstab report?

  A. The level drilled on is replaced with the entire level below it.

  B. The edge expression is replaced with the children of the item drilled on.

  C. All edge expressions of the crosstab are replaced with their children.

  D. The edge expression is changed to another item in the query.

  Correct Answer: B

• Question 7:

  A report authorhas created a crosstab report from the data source shown. The Retailer name level has been dragged to the rows and default drilling up and down has been activated.

  

  What will be displayed in the report if the consumer drills up on one of the members of Retailer name?

  A. The parent member of the member drilled on.

  B. The ancestors of the member drilled on from the whole Retailers hierarchy.

  C. The members from the Region level.

  D. The members from the Retailer country level.

  Correct Answer: D

• Question 8:

  The report author creates a query where two items (TopThree and Retailer country) exist in the same member set. The expression for TopThree is: topCount([Retailer country],3,[Revenue]).

  

  What drill behavior should the report author set in order to display the top three children instead of all children on drill down?

  A. Configure TopThree to Change Expression, and configureRetailer country to Preserve.

  B. Configure TopThree to Preserve, and configure Retailer country to Preserve.

  C. Configure TopThree to Preserve, and configure Retailer country to Replace Expression.

  D. Configure TopThree to Ancestor, and configure Retailercountry to Change Expression.

  Correct Answer: C

• Question 9:

  Which of the following statements is true about explicitly defined member sets?

  A. They must have drill behavior defined manually.

  B. They assume the drill behavior from the top member setin the same branch.

  C. They are automatically configured for default drill behavior.

  D. They are too complex to enable drilling.

  Correct Answer: A

• Question 10:

  Why would a report author consider overriding the default drill behavior?

  A. To maintain the behavior of a complex edge expression after drilling, such as one which returns the top 5 members of a set.

  B. To replace all members within a hierarchy when drilling through to a report with more detail.

  C. To drill down to the lowest level of the hierarchy and then drill down again to display only one member.

  D. To drill down on a member and have its children display as details and have the member drilled on display as summary.

  Correct Answer: A