QUESTION: 17

Which is true about creating a context filter for a crosstab report using a dimensional data source?

it changes the measure values and the items in the rows and columns
it is applied after aggregation and changes the rows and columns
it changes the measure values and suppresses zeros
it filters only the measure values, not the items in the rows and columns

Answer(s): C

Reveal Solution Next Question

QUESTION: 18

What advantage does multidimensional report writing have on query maintenance for complex queries?

There is no need to use calculations as the data source contains all the required data items.
Fewer queries are required and the need for unions of queries is reduced due to the flexibility of MDX.
Unions and Joins are always required for queries making it easier for a developer to understand the query intent.
There is no advantage and multidimensional query constructs should be avoided.

Answer(s): B

Reveal Solution Next Question

QUESTION: 19

In a Data Module a developer creates a joined view from two tables (a and b) and then joins this to another table (c). What would be the execution logic in the database?

All queries are collapsed and a standard join across all three tables (a, b, c) is performed.
The columns used in table (c) are are joined on the key to table (b) first and then the results are post-joined to table (a).
It makes no difference to the execution as a joined view is only used to group data items in a logical manner to help the business user find their data.
The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).

Answer(s): D

Reveal Solution Next Question

QUESTION: 20

What is the significance of 'Clothes' in the following filter expression of a report query? [Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#

'Clothes' is the default text to include in the generated query at runtime.
The string 'Clothes' will precede the text of the prompt value selected at runtime.
The string 'Clothes' will be appended to the end of the text of the prompt value selected at runtime.
'Clothes' is a required value to include in the generated query at runtime.

Answer(s): C

Reveal Solution Next Question

Free C1000-065 Exam Braindumps (page: 5)

QUESTION: 17

QUESTION: 18

QUESTION: 19

QUESTION: 20