Google Exam Looker-Business-Analyst Topic 8 Question 18 Discussion

Actual exam question for Google's Looker Business Analyst exam

Question #: 18
Topic #: 8

An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions:

Ticket Purchase Month

Movie Name

Ticket Revenue

The analyst notices that the numbers look a lot smaller than expected and the results are difficult to understand.

What should the analyst do to make the Explore query show the desired metric?

ARemove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

BRemove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

CAdd the Sum Revenue measure to the query.

DAdd a table calculation that sums the Ticket Revenue dimension.

Show Suggested Answer

Suggested Answer: C

by Lezlie at May 08, 2022, 07:27 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

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