IBM C2090-645 Online Practice Questions and Exam Preparation

IBM C2090-645 Online Questions & Answers

• Question 1:

  In a crosstab, Campaign is in the rows area, Order method type is in the columns area, and Quantity is the measure. Campaign and Order method type are specified in the query. The report runs, displaying quantity valuesfor all years. Why does this happen?

  A. The dimension member from that dimension is implied.
  B. The order method member from that dimension is implied.
  C. The aggregate member from that dimension is implied.
  D. The default member from that dimensionis implied.
  D. The default member from that dimensionis implied.

• 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
  B. Dimensional

• Question 3:

  A report author creates the following nestedreport 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?

  A. Replace Expression
  B. Depth Based Expression
  C. Preserve
  D. Replace Item
  C. Preserve

• Question 4:

  A report author uses an OLAP cube to create a crosstab with Revenue as a measure, the Product linelevel in the rows, and the year members (2004-2007) in the columns. How can the report author efficiently determine the difference in revenue between the years 2005 and 2006?

  A. Determine MUNs for the years 2005 and 2006, and then create an expressionusing the MUNs.
  B. Create a new column as a query calculation, and create the expression [2006]-[2005].
  C. Create a set of the 2005 and 2006 members and aggregate it.
  D. Ask the modeler to create a calculated category in Transformer and then use it directly.
  B. Create a new column as a query calculation, and create the expression [2006]-[2005].

• Question 5:

  If the syntax for thehead function is head(set_exp[,index_exp]),then which of the following expressions is correct?

  A. head(members([sales_and_marketing].[Products].[Products].[Product line]),2)
  B. head(([sales_and_marketing].[Products].[Products].[Product line])[,2])
  C. head(order([sales_and_marketing].[Products].[Products].[Product line])2)
  D. head(members([sales_and_marketing].[Products].[Products].[Product line],2))
  A. head(members([sales_and_marketing].[Products].[Products].[Product line]),2)

• Question 6:

  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
  B. Use a prompt

• Question 7:

  Which of the following statements is true about a slicer?

  A. It keeps the summary column in the report, and removes the detail columns.
  B. It affects the values of the cells of the report but not the rows or columns.
  C. It determines which set of members are displayed onthe edges of the report.
  D. It removes all blank rows in the report to make it more focused.
  B. It affects the values of the cells of the report but not the rows or columns.

• Question 8:

  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.
  B. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.

• Question 9:

  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
  B. Level order, level names

• Question 10:

  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
  D. Business key