10. When should you use an Iterator function instead of a Calculated Column?

A. When you want to create a new dimension in your data.

B. When you want to add the calculation to the Filter, Rows or Columns quadrant of a PivotTable.

C. When you want your data model to be more efficient because no values are stored in the table.

D. When you can bring the data in from your data source.

12. What is the symbol for the "AND" logical operand?

A. || - double pipe symbol.

B. ^^ - double caret symbol.

C. !! - double explanation symbol.

D. && - double ampersand symbol.

13. When creating a measure that includes one of the Filter functions, what should you consider?

A. The speed of the required calculation.

B. The context of the measure so that you apply the formula correctly.

C. The number of records in your data set.

D. The audience using your data set.

14. What is one possible use of the HASONEVALUE function?

A. Provide a test to determine if the PivotTable is filtered to one distinct value.

B. Use it to ignore any filters applied to a PivotTable.

C. Use it to ignore all but one filter applied to a PivotTable.

D. Use it to determine if a column has only one value.