When should a dimensional function be used in a report's Query calculation?

• A.to allow relative date functions to be performed against a non-dimensional data source
• B.to convert a non-dimensional data source into a dimensionally-modeled data source
• C.when the data source is a dimensional or dimensionally-modeled data source
• D.to allow drill up and down on a non-dimensional data source

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

When developing a report, which two should be defined for a JOIN query?

• A.a relationship defining cardinality
• B.only cached results
• C.an expression editor
• D.an intersection of two queries
• E.a reference to two queries

Comment: *

Name: *

Email: *

Verification: *

A developer has a source system provided by another company. One of the columns in a table has spaces before each piece of data and is in uppercase which makes the reports unreadable. How can this be solved in a data module?

• A.using the 'Clean' menu item on the data item
• B.there is no built in capability for this in a data module and the report needs Trim and Lower calculations added to it
• C.using the 'Prepare' menu item on the data item
• D.there is no built in capability for this in a data module and the developer needs to create a calculation for this

Comment: *

Name: *

Email: *

Verification: *

Which of the following can result in poor report performance?

• A.an optimized metadata model
• B.reports with filters
• C.models with outer joins and cross joins
• D.queries with database only processing

Comment: *

Name: *

Email: *

Verification: *