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. Ancestors and descendants
B. Dimensional functions and slicers
C. Detail filters and summary filters
D. Use Members directly
正解:B
質問 2:
What is a key difference between the total function and the aggregate function?
A. The aggregate function is dimensional, and the total function is relational.
B. The aggregate function will summarize only the currentMeasure, and the total function will summarize any specified measure.
C. The aggregate function can only summarize within a set, and the total function can accept separate members.
D. 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.
正解:D
質問 3:
In the data source shown, what dimensional component is selected?
A. Level
B. Namespace
C. Dimension
D. Hierarchy
正解:D
質問 4:
A report runs, and is 433 pages 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. Relational
B. Conventional
C. Functional
D. Dimensional
正解:D
質問 5:
Which of the following is true if a report author nests members in a crosstab report?
A. The inner member must be on the level immediately below the outer member.
B. Nested members are also known as complex members.
C. Nested members must be members of hierarchies, not of the Measures folder.
D. It is possible to nest members from different dimensions.
正解:D
質問 6:
Which of the following are dimensional objects?
A. Level and member
B. Slicer and string function
C. Query subject and relationship cardinality
D. Sets and query calculation
正解:C