Which of the following is NOT a measure type category?

• A. Aggregate measures
• B. Non-aggregate measures
• C. Dynamic measures
• D. Post-SQL measures

Answer: (C)

The choice identifying "Dynamic measures" as NOT a measure type category is appropriate because, in Looker, measures are generally categorized into well-defined types that play specific roles in data modeling.

Aggregate measures and non-aggregate measures are concrete categories. Aggregate measures summarize data across multiple rows (e.g., sums, averages), while non-aggregate measures provide individual data points without summarization. Post-SQL measures are also a recognized category that allows developers to define measures based on SQL snippets that run after the main SQL query.

"Dynamic measures" does not fit into the established classifications used within LookML. While the term could imply some form of measures that change based on user input or conditions, it is not formally defined as a standard category within Looker's documentation or practice. Thus, it distinguishes itself from the commonly recognized types of measures, making it the correct answer to the question.