Google Exam LookML-Developer Topic 2 Question 13 Discussion

Actual exam question for Google's Looker LookML Developer exam

Question #: 13
Topic #: 2

A developer wants to create a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this ''count'' in ''category'' available in the Explore section without any additional work done by the end user. For example:

The Count column represents the count for each combination of Category and Item.

The Count in Category column represents the count for each Category only.

How can the developer address this need with a LookML object?

ACreate a measure filtered on Category, and make the filter value controlled by a parameter.

BCalculate the measure using a derived table, and then join that derived table back into the Explore.

CCreate a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.

DCalculate the overall count using table calculations in the Explore.

Show Suggested Answer

Suggested Answer: B

by Maile at May 07, 2022, 08:17 AM

Limited Time Offer

25%

Off

Get Premium LookML-Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!