Free LOOKER-BUSINESS-ANALYST Exam Braindumps (page: 5)

Page 4 of 11

Two users report seeing different results on the same dashboard.
Which three configurations could explain these discrepancies? (Choose three.)

  1. The time zone setting is different for each user.
  2. Looker caching is affecting results.
  3. The dashboard uses separate Explores for each user.
  4. Dashboard filters are being used
  5. The dashboard was accessed via different boards.

Answer(s): C,D,E



An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.



How should the analyst, in addition to selecting the measure Total Sales build the report?

  1. Select the dimension Created Month, and pivot on the dimension Created Year.
  2. Select the dimension Created Year, and pivot on the dimension Created Month.
  3. Select the dimension Created Month Name, and pivot on the dimension Created Year.
  4. Select the dimension Created Year, and pivot on the dimension Created Month Name.

Answer(s): A



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?

  1. Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
  2. Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
  3. Add the Sum Revenue measure to the query.
  4. Add a table calculation that sums the Ticket Revenue dimension.

Answer(s): C



An analyst needs to send a Look to an external client in CSV format.
When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading "All Results Unavailable."
What are three causes of this message? (Choose three.)

  1. The Row Limit chosen in the Look is too high.
  2. There is a table calculation in the Look.
  3. Unlimited results are unsupported by CSV format.
  4. The Row Totals option is turned on in the Look.
  5. There is a Running Total measure in the Look.
  6. The Totals option is turned on in the Look.

Answer(s): A,B,D


Reference:

https://docs.looker.com/sharing-and-publishing/downloading






Post your Comments and Discuss Google LOOKER-BUSINESS-ANALYST exam with other Community members:

LOOKER-BUSINESS-ANALYST Exam Discussions & Posts