Google Exam LookML-Developer Topic 6 Question 3 Discussion

Actual exam question for Google's Looker LookML Developer exam

Question #: 3
Topic #: 6

A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.

How can the LookML developer model these requirements and minimize the amount of code rewriting?

AAdd measures to the transactions view of type: number to apply the required functions.

BChange the existing measures in the transactions view to dimensions, and add measures of the different required types.

CCreate a constant for each measure so it can be reused across other areas of the LookML project.

DCreate native derived tables using transactions as the explore_source.

Show Suggested Answer

Suggested Answer: D

by Adelina at May 09, 2022, 06:09 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!