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?
A. In the future, when a campaign is deleted or new ones are added, the unmodified expression will be valid.
B. The report author should not have used the method chosen, as the first method is best in this situation.
C. In the future, when a campaign is deleted or new ones are added, the report author must modify the expression.
D. To be accurate, the report author should avoid using a set expression.
正解:A
質問 2:
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?
A. This is not possible because a prompt must always be populated with all members of a level.
B. Create a multi-select value prompt. Populate it using an expression on the [Northern Europe] member to retrieve its children on the country level.
C. Generate a prompt by creating an expression with aparameter on the crosstab edge:children([Northern Europe]->?Country?
D. Create a tree prompt, and populate it using an expression on the [Northern Europe] member to retrieve its children at the country level.
正解:B
質問 3:
In a crosstab report, the report author wants a column to display a percentage of overall revenue that a particular product contributed to.
Which of the following is a valid dimensional expression for this purpose?
A. [Revenue]/tuple([Revenue],[Products])
B. [Revenue]/([Revenue]*[Products])
C. tuple([Revenue]/[Products]*[Revenue])
D. [Revenue]/total([Revenue]for[Products])
正解:A
質問 4:
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. Role value, internal keys
D. Hierarchy names, snowflake schema
正解:B
質問 5:
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
質問 6:
Can a prompt be used in the expression of a slicer?
A. No, the slicer syntax is not compatible with prompt syntax.
B. Yes, if the correct syntax is used.
C. No, the slicer must be manually created by the report author.
D. Yes, if the slicer is a hierarchy.
正解:B