Why would you use the FormatDate() function?

There are 2 correct answers to this question.

To modify the format of a string object into a non-standard date format.
To convert a string object into a date object.
To convert a date object into a string object.
To format a date so that it is displayed as a string when it is concatenated with another string.

Answer(s): C,D

Which two statements are true of grouping sets when using smart measures?

Please choose the correct answer.

It is a set of dimensions that generates a result for a measure.
It is a set of measures that generates a result for a dimension.
The generated SQL includes grouping sets for all the aggregations of that dimension that are included in the report.
The generated SQL includes grouping sets for all the aggregations of that measure that are included in the report.

Answer(s): A,D

Which statement is true about calculation contexts?

Please choose the correct answer.

They allow manipulation of reports to change the way the data is displayed.
They allow manipulation of variables to change the way the data is aggregated.
They allow manipulation of universe objects to change the way the data is displayed.
They allow manipulation of universe contexts to change the way the data is aggregated.

Answer(s): B