1. What is Context transition ? Mid A. the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression B. an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation C. a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression D. a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
2. Which term means: "the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression"? Mid A. RELATED B. FILTER C. ALL D. Context transition
3. Which statement is correct? Mid A. Context transition — a lookup that pulls a value from the one-side of a relationship into the current many-side row B. Context transition — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table C. Context transition — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression D. Context transition — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
4. What is Time intelligence ? Mid A. a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators B. the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table C. a lookup that pulls a value from the one-side of a relationship into the current many-side row D. an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation
5. Which term means: "the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table"? Mid A. Time intelligence B. ALL C. FILTER D. VAR
6. Which statement is correct? Mid A. Time intelligence — a lookup that pulls a value from the one-side of a relationship into the current many-side row B. Time intelligence — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation C. Time intelligence — a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression D. Time intelligence — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table
7. What is FILTER ? Mid A. an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation B. the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table C. a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators D. a lookup that pulls a value from the one-side of a relationship into the current many-side row
8. Which term means: "an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation"? Mid A. FILTER B. Context transition C. VAR D. ALL
9. Which statement is correct? Mid A. FILTER — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression B. FILTER — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation C. FILTER — a lookup that pulls a value from the one-side of a relationship into the current many-side row D. FILTER — a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
10. What is ALL ? Senior A. a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators B. the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table C. an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation D. the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
11. Which term means: "a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators"? Senior A. Time intelligence B. ALL C. FILTER D. Context transition
12. Which statement is correct? Senior A. ALL — a lookup that pulls a value from the one-side of a relationship into the current many-side row B. ALL — a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators C. ALL — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table D. ALL — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
13. What is RELATED ? Senior A. the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table B. a lookup that pulls a value from the one-side of a relationship into the current many-side row C. a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators D. the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression
14. Which term means: "a lookup that pulls a value from the one-side of a relationship into the current many-side row"? Senior A. Time intelligence B. VAR C. FILTER D. RELATED
15. Which statement is correct? Senior A. RELATED — the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression B. RELATED — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation C. RELATED — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table D. RELATED — a lookup that pulls a value from the one-side of a relationship into the current many-side row
16. What is VAR ? Mid A. the automatic conversion of the current row into an equivalent filter, triggered when an aggregation wraps a row-level expression B. a lookup that pulls a value from the one-side of a relationship into the current many-side row C. a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression D. a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators
17. Which term means: "a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression"? Mid A. Time intelligence B. ALL C. VAR D. FILTER
18. Which statement is correct? Mid A. VAR — an iterator returning a subset of a table where a condition holds, often passed as an argument to reshape evaluation B. VAR — the family of functions like prior-year and year-to-date that shift or accumulate values across a marked date table C. VAR — a function that removes filters from a table or columns, commonly used to compute totals or percentage-of-total denominators D. VAR — a syntax construct that stores an intermediate result under a name for reuse and clarity within an expression