IBM IBM Cogno C2090-645 Questions & Answers

• Question 31:

  What functionality will allow the report consumer to focus the report each time it is run?

  A. Filter a MUN

  B. Use a prompt

  C. Build a slicer

  D. Use a dimensional function

  Correct Answer: B

• Question 32:

  When must a report author use the caption function?

  A. As the first parameter of the roleValue function.

  B. To return the display name for thespecified business key.

  C. To see the string display name for the specified element.

  D. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.

  Correct Answer: D

• Question 33:

  The following expression is used to focus OLAP data in the rows of a report: filter([sales_and_marketing].[Order method].[Order method].[Order method type], [Revenue]>150000000).

  

  Which of the following statements describes the purpose of the expression?

  A. To return the set of members whose revenue is less than150000000 for any year.

  B. To return the set of members whose revenue is greater than 150000000 for the sum of the opposite edge.

  C. To filter the cell values by subtracting 150000000 from the revenue for each year and order method type.

  D. To filter the years to show those having revenues greater than 150000000 by order method type.

  Correct Answer: B

• Question 34:

  A report author uses the following expression: lastPeriods(3,[2007/Mar]). What data will be returned when the report is run?

  A. The last 3 months before 2007/Mar

  B. 3 months, including 2007/Mar and the preceeding 2 months

  C. The total of currentMeasure for 3 months including 2007/Mar and the preceeding 2 months

  D. The month March of each of the 3 years 2005, 2006, and 2007

  Correct Answer: B

• Question 35:

  A report author creates a report with a drill-through definition. In the target report the parameter expression is "->?P?".

  What type of data must be passed to the parameter?

  A. A member from the level

  B. Any member from the hierarchy

  C. A value

  D. A business key from the level

  Correct Answer: A

• Question 36:

  The report author creates a source report that containsvalues from "Products" on which the report consumer will drill through for details. The report author has created a target report which expects a member from the source.

  Is this a supported drill-through combination?

  A. Yes, this value-to-member drill-through is a supported combination.

  B. No, this value-to-member drill-through is not a supported combination.

  C. No, this member-to-value drill-through is not a supported combination.

  D. Yes, this member-to-value drill-through is a supported combination.

  Correct Answer: B

• Question 37:

  When the report consumer drills through from a dimensional member to a relational data item, what data type is passed?

  A. Category code

  B. Caption value

  C. Member unique name

  D. Business key

  Correct Answer: D

• Question 38:

  The "Sales" and "Inventory" data stores each have "Products" and "Time"dimensions. For drill-through between the data stores on the "Products" and "Time" dimensions to work, which items in the structures must be identical in the data stores?

  A. Hierarchy names, member values

  B. Level order, level names

  C. Hierarchy names, snowflake schema

  D. Role value, internal keys

  Correct Answer: B

• Question 39:

  A reportauthor creates a crosstab as shown.

  

  What is the default measure of the report?

  A. Mountaineering Equipment

  B. Camping Equipment

  C. Gross profit

  D. Revenue

  Correct Answer: D

• Question 40:

  The report author uses the filter function to focus data in areport, but the results are unexpected. What did the report author overlook when filtering the data?

  A. Relational detail

  B. Products hierarchy

  C. Report context

  D. Root levels

  Correct Answer: C