Download IBM Cognos 10 BI Multidimensional Author.C2090-645.PracticeTest.2017-05-04.56q.vcex

Vendor: IBM
Exam Code: C2090-645
Exam Name: IBM Cognos 10 BI Multidimensional Author
Date: May 04, 2017
File Size: 30 KB

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

ProfExam Discount

Demo Questions

Question 1
A report author creates the following nested report using 2 adjacent levels of the same hierachy. Users should be able to drill down on the inner nesting with the outer nesting remaining unchanged. 
What advanced drilling behavior should the report author use to achieve this?
  1. Replace Expression
  2. Depth Based Expression
  3. Preserve
  4. Replace Item
Correct answer: C
Question 2
To display all individual campaigns in a crosstab report, 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?
  1. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.
  2. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.
  3. The report author should not have used the method chosen, as the first method is best in this situation.
  4. To be accurate, the report author should avoid using a set expression.
Correct answer: B
Question 3
Which of the following statements is correct about the order function?
  1. The currentMeasure function must be used with the order function as the sort by criterion.
  2. It arranges members of all sets in the report by ascending or descending values.
  3. Optional parameters allow the author to order the members of a hierarchy without regard of their level.
  4. It arranges members of a set alphabetically by ascending or descending captions.
Correct answer: C
Question 4
To create a report from the data source shown, what entities will the report author use?
  1. Members
  2. Values
  3. Attributes
  4. MUNs
Correct answer: B
Question 5
A report author is working with an OLAP data source. The report author creates a query that uses a caption function on a member and applies a string function. 
What is a possible consequence of this action?
  1. Using these dimensional methods will not work with an OLAP data source.
  2. The mapped string values will not pass through to the target report.
  3. There is nothing wrong with this approach.
  4. Mixing dimensional styles and relational styles in a single query can create unexpected results.
Correct answer: D
Question 6
When must a report author use the caption function?
  1. As the first parameter of the roleValue function.
  2. To return the display name for the specified business key.
  3. To see the string display name for the specified element.
  4. To pass the returned value to a drill-through target report, this expects a matching string as a parameter value.
Correct answer: D
Question 7
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?
  1. This is not possible because a prompt must always be populated with all members of a level.
  2. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.
  3. Generate a prompt by creating an expression with a parameter on the crosstab edge: children([Northern Europe]->?Country?
  4. 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 8
The author has created a complex expression called "Sorted Products" on the row edge, which sorts product line by Revenue for 2006. 
What must the report author do to sort the members when drilling down?
  1. Configure the Ancestor drill behavior on the Sorted Products expression.
  2. Preserve the Sorted Products expression, but replace the underlying Product Set expression.
  3. Nothing, as the default drill behavior is sufficient in this case, to maintain sorting of the children.
  4. Set the behavior to Depth Based Expression, to maintain sorting at a lower level in the data source.
Correct answer: B
Question 9
Which of the following family functions is most similar to the relative time function parallelPeriod?
  1. Cousin
  2. PrevMember
  3. Siblings
  4. OpeningPeriod
Correct answer: A
Question 10
What is a key difference between the total function and the aggregate function?
  1. The aggregate function can only summarize within a set, and the total function can accept separate members.
  2. The aggregate function is dimensional, and the total function is relational.
  3. The aggregate function will summarize only the currentMeasure, and the total function will summarize any specified measure.
  4. The aggregate function follows the rollup rules of the measure defined in the data source, and the total function adds the total of the specified measure.
Correct answer: D
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!