아직도 IBM C2020-645 (IBM Cognos 10 BI Multidimensional Author)시험준비를 어떻게 해야 할지 망설이고 계시나요? 고객님의 IT인증시험준비길에는 언제나 Pass4Test가 곁을 지켜주고 있습니다. Pass4Test시험공부자료를 선택하시면 자격증취득의 소원이 이루어집니다. IBM C2020-645 (IBM Cognos 10 BI Multidimensional Author)시험덤프는Pass4Test가 최고의 선택입니다.
NO.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 values for 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 dimension is implied.
Answer: D
NO.2 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?
A. Using these dimensional methods will not work with an OLAP data source.
B. The mapped string values will not 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.
Answer: D
NO.3 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
Answer: A
NO.4 When a report author inserts Revenue into the Measures area of a blank crosstab report,
which of the following 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. The report 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.
Answer: A
NO.5 When would a report author define a set?
A. To create a slicer to focus on a specific number of years of data in a report.
B. To change the crosstab node member properties for a level.
C. To use as a summary function to return the total of the specified members.
D. To return members from different hierarchies of the same dimension.
Answer: A
NO.6 Which of the following are dimensional objects?
A. Sets and query calculation
B. Query subject and relationship cardinality
C. Slicer and string function
D. Level and member
Answer: B
NO.7 What kind of authoring style uses the filter function?
A. Relational
B. Conformed
C. Dimensional
D. DMR
Answer: C
NO.8 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.
Answer: A