クリック」
質問 1：
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
質問 2：
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 must validate the expression for Revenue to ensure there are no crosstab errors.
B. The report author has implicitly set the default measure for the crosstab report to be Revenue.
C. The report author has declared a currentMember function to return the Revenue data.
D. The report author must verify the aggregation properties of Revenue to make sure it will display correctly.
正解：B
質問 3：
Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previous year. They also want to see the total for periods, up to and including the quarter selected.
Which of the following dimensional functions could the report author use to create this report?
A. ParallelPeriod, tuple, periodsToDate, aggregate
B. OpeningPeriod, order, quarter, Firstsibling
C. Ancestor, currentMember, lead, total
D. Cousin, tuple, closingPeriod, aggregate
正解：A
質問 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 statements is true about a slicer?
A. It determines which set of members are displayed on the edges of the report.
B. It affects the values of the cells of the report but not the rows or columns.
C. It keeps the summary column in the report, and removes the detail columns.
D. It removes all blank rows in the report to make it more focused.
正解：B
質問 6：
The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?
A. A set expression
B. A percent of base calculation
C. An axis title
D. The hierarchize function
正解：A
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
質問 2：
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 must validate the expression for Revenue to ensure there are no crosstab errors.
B. The report author has implicitly set the default measure for the crosstab report to be Revenue.
C. The report author has declared a currentMember function to return the Revenue data.
D. The report author must verify the aggregation properties of Revenue to make sure it will display correctly.
正解：B
質問 3：
Consumers want a report to compare the revenue and quantity sold for all product lines in a selected quarter, to the same quarter for the previous year. They also want to see the total for periods, up to and including the quarter selected.
Which of the following dimensional functions could the report author use to create this report?
A. ParallelPeriod, tuple, periodsToDate, aggregate
B. OpeningPeriod, order, quarter, Firstsibling
C. Ancestor, currentMember, lead, total
D. Cousin, tuple, closingPeriod, aggregate
正解：A
質問 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 statements is true about a slicer?
A. It determines which set of members are displayed on the edges of the report.
B. It affects the values of the cells of the report but not the rows or columns.
C. It keeps the summary column in the report, and removes the detail columns.
D. It removes all blank rows in the report to make it more focused.
正解：B
質問 6：
The sales manager requires a crosstab report to display the top 3 sales people for the month. Considering that an OLAP data source is used, what will the report author use when creating this report?
A. A set expression
B. A percent of base calculation
C. An axis title
D. The hierarchize function
正解：A
0 お客様のコメント