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.to allow drill up and down on a non-dimensional data source
• D.when the data source is a dimensional or dimensionally-modeled data source

Comment: *

Name: *

Email: *

Verification: *

What is the effect of changing the Default measure property of a Crosstab in a report if a measure is already set by one of the existing edges?

• A.the Default measure is displayed in the Crosstab intersections
• B.the Default measure replaces the existing measure in the Crosstab edges
• C.an error is produced
• D.the Crosstab values remain the same and the Crosstab comer displays the Default measure's name

Comment: *

Name: *

Email: *

Verification: *

A developer may improve the look and feel of a dashboard or story by adding images and shapes from the Widgets panel. Which statement is true when adding widgets to a dashboard?

• A.Images may only be made available by URL reference.
• B.The widgets panel may contain an Image library tab that the administrator made available
• C.Images can be uploaded to the Image through the upload option on the widgets panel.
• D.Text widgets may only be positioned vertically or horizontally.

Comment: *

Name: *

Email: *

Verification: *

Which of the following is an example of when the query cache would avoid roundtrips to the database?

• A.repetitive master-detail requests
• B.drill through reports
• C.reports with multiple queries
• D.drill down reports

Comment: *

Name: *

Email: *

Verification: *

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?

• A.The joined view (a and b) is evaluated and all results are then post-joined to the other table (c).
• B.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).
• C.All queries are collapsed and a standard join across all three tables (a, b, c) is performed.
• D.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.

Comment: *

Name: *

Email: *

Verification: *