1. What is Calculated column ? Junior A. an aggregation expression evaluated at query time under the current filters and not stored per row B. an iterator that walks a table row by row, computing an expression on each and totaling the results C. a row-by-row expression evaluated at refresh time and stored physically, consuming model memory D. the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over
2. Which term means: "a row-by-row expression evaluated at refresh time and stored physically, consuming model memory"? Junior A. Calculated column B. Measure C. Filter context D. CALCULATE
3. Which statement is correct? Junior A. Calculated column — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions B. Calculated column — an iterator that walks a table row by row, computing an expression on each and totaling the results C. Calculated column — the evaluation environment that knows the current single row, present in column expressions and iterators D. Calculated column — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
4. What is Measure ? Junior A. the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions B. an iterator that walks a table row by row, computing an expression on each and totaling the results C. an aggregation expression evaluated at query time under the current filters and not stored per row D. a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
5. Which term means: "an aggregation expression evaluated at query time under the current filters and not stored per row"? Junior A. Measure B. Row context C. Calculated column D. SUMX
6. Which statement is correct? Junior A. Measure — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions B. Measure — an aggregation expression evaluated at query time under the current filters and not stored per row C. Measure — an iterator that walks a table row by row, computing an expression on each and totaling the results D. Measure — the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over
7. What is Row context ? Mid A. the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over B. the evaluation environment that knows the current single row, present in column expressions and iterators C. the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions D. an iterator that walks a table row by row, computing an expression on each and totaling the results
8. Which term means: "the evaluation environment that knows the current single row, present in column expressions and iterators"? Mid A. SUMX B. Filter context C. Calculated column D. Row context
9. Which statement is correct? Mid A. Row context — the evaluation environment that knows the current single row, present in column expressions and iterators B. Row context — an aggregation expression evaluated at query time under the current filters and not stored per row C. Row context — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions D. Row context — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
10. What is Filter context ? Mid A. the evaluation environment that knows the current single row, present in column expressions and iterators B. the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over C. an iterator that walks a table row by row, computing an expression on each and totaling the results D. an aggregation expression evaluated at query time under the current filters and not stored per row
11. Which term means: "the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over"? Mid A. Calculated column B. CALCULATE C. Filter context D. Row context
12. Which statement is correct? Mid A. Filter context — an aggregation expression evaluated at query time under the current filters and not stored per row B. Filter context — an iterator that walks a table row by row, computing an expression on each and totaling the results C. Filter context — the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over D. Filter context — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory
13. What is CALCULATE ? Mid A. a row-by-row expression evaluated at refresh time and stored physically, consuming model memory B. the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions C. an iterator that walks a table row by row, computing an expression on each and totaling the results D. the evaluation environment that knows the current single row, present in column expressions and iterators
14. Which term means: "the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions"? Mid A. Filter context B. CALCULATE C. Row context D. Calculated column
15. Which statement is correct? Mid A. CALCULATE — the evaluation environment that knows the current single row, present in column expressions and iterators B. CALCULATE — an iterator that walks a table row by row, computing an expression on each and totaling the results C. CALCULATE — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions D. CALCULATE — the set of filters from slicers, rows, columns, and visuals that constrains which data an expression evaluates over
16. What is SUMX ? Junior A. the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions B. a row-by-row expression evaluated at refresh time and stored physically, consuming model memory C. the evaluation environment that knows the current single row, present in column expressions and iterators D. an iterator that walks a table row by row, computing an expression on each and totaling the results
17. Which term means: "an iterator that walks a table row by row, computing an expression on each and totaling the results"? Junior A. Calculated column B. Row context C. SUMX D. CALCULATE
18. Which statement is correct? Junior A. SUMX — an iterator that walks a table row by row, computing an expression on each and totaling the results B. SUMX — an aggregation expression evaluated at query time under the current filters and not stored per row C. SUMX — a row-by-row expression evaluated at refresh time and stored physically, consuming model memory D. SUMX — the function that evaluates an expression while modifying or replacing the surrounding filters via supplied conditions