Google Looker certifications LOOKER-BUSINESS-ANALYST Questions & Answers

• Question 21:

  A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.

  Which filter expression should the business analyst use?

  A. 7 days from now

  B. After Today's Date for 7 days

  C. Today for 7 days

  D. For 7 days

  Correct Answer: B

• Question 22:

  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?

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

  B. Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

  C. Add the Sum Revenue measure to the query.

  D. Add a table calculation that sums the Ticket Revenue dimension.

  Correct Answer: C

• Question 23:

  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.)

  A. The Row Limit chosen in the Look is too high.

  B. There is a table calculation in the Look.

  C. Unlimited results are unsupported by CSV format.

  D. The Row Totals option is turned on in the Look.

  E. There is a Running Total measure in the Look.

  F. The Totals option is turned on in the Look.

  Correct Answer: ABD

• Question 24:

  An analyst needs to display data from two different sources together. There is a Look for each data source, but there is no shared field that can be combined. Both Looks are saved in the Shared folder.

  How should the analyst display the data from both sources?

  A. use Merged Results to combine the data sources.

  B. Ask the LookML developer to build a new Explore.

  C. Add both Looks to a dashboard

  D. Pin both Looks to a board.

  Correct Answer: C

• Question 25:

  An analyst has created a line chart with Value Labels enabled, but the values are too long and need to be abbreviated.

  Which visualization option should the analyst utilize to alter the display of the value labels?

  A. Axis Value Labels

  B. Value Format

  C. Label Rotation

  D. Time Label Format

  Correct Answer: B

• Question 26:

  An analyst needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count.

  Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?

  A. pivot_offset()

  B. lookup()

  C. offset_list()

  D. offset()

  Correct Answer: D

• Question 27:

  Two users report seeing different results on the same dashboard.

  Which three configurations could explain these discrepancies? (Choose three.)

  A. The time zone setting is different for each user.

  B. Looker caching is affecting results.

  C. The dashboard uses separate Explores for each user.

  D. Dashboard filters are being used

  E. The dashboard was accessed via different boards.

  Correct Answer: CDE

• Question 28:

  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?

  A. Select the dimension Created Month, and pivot on the dimension Created Year.

  B. Select the dimension Created Year, and pivot on the dimension Created Month.

  C. Select the dimension Created Month Name, and pivot on the dimension Created Year.

  D. Select the dimension Created Year, and pivot on the dimension Created Month Name.

  Correct Answer: A

• Question 29:

  An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.

  Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?

  A. Display row totals for each category.

  B. Series type customization on budgeted spend.

  C. Grouped series positioning on budgeted spend.

  D. Transpose table to separate out budgeted spend.

  Correct Answer: D

• Question 30:

  An analyst is trying to create a pie chart showing the breakdown of the top sales by brand in an Explore. The analyst selects the Brand Name dimension and a measure for the Count of Items Sold. The analyst then selects the pie chart visualization, but sees the error "Too Many Rows: Pie charts can display a maximum of 50 rows of data."

  How can the analyst resolve this error and create a pie chart that will always show the top brands by items sold?

  A. Sort the data by Count of Items Sold descending and apply a row limit of 50.

  B. Sort the data by Brand Name alphabetically and apply a row limit of 50.

  C. Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

  D. Apply a filter on the Count of Items Sold measure that requires the count to be not NULL, sort the data by Count of Items Sold ascending, and apply a row limit of 50.

  Correct Answer: C