Google Looker-Business-Analyst 問題集

質問 1：
An analyst at a banana quality assurance firm needs to compare performance week over week to make sure the firm stays on track. The analyst needs to show two metrics:
Number of bananas cleared for consumption the previous week
Number of bananas cleared for consumption the week before that
Which process should the analyst follow to show these two metrics in a report?
A. Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile ("last week" and "2 weeks ago" respectively)
B. Create one tile on a dashboard and two dashboard filters ("last week" and "2 weeks ago" respectively). Apply both dashboard filters to the tile.
C. Create two tiles on a dashboard. In the Edit mode of one tile, add a filter for "last week". Add a dashboard filter for "2weeks ago" and apply it to the other tile.
D. Create two identical looks in the same folder. Add filters on them for "last week" and "2 weeks ago" respectively.
正解：C

質問 2：
A business analyst is creating an Explore that shows the number of hotel rooms booked per week, by room type. The analyst is using a Week dimension and a Count measure, and is provisioning on a Room Type dimension. Looking at the results, the Count of King rooms seems unusually low one week.
What should the analyst do to further investigate the low numbers?
A. Run the Explore again to make sure the results are the same.
B. Remove the pivot on the Room Type dimension and re-run the Explore.
C. Click on the Room Type dimension where it is King to drill in to it.
D. Click on the Count measure where it is low to drill in to it.
正解：D

質問 3：
An analyst is creating a map that colors cities by their population. After adding fields and selecting the Interactive Map visualization, the analyst receives this error message:
"At least one dimension should be of type Location or have a map_layer specified".
There are currently three fields in the Explore:
City Name (Dimension)
Population (Measure)
Number of Museums (Measure)
What should the analyst do to resolve this error?
A. Add a table calculation that evaluates location (${cities.city_name})
B. Select the Static Map visualization instead of Interactive
C. Contact the LookML Developer
D. Remove the Number of Museums measure from the Explore
正解：A

質問 4：
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. There is a table calculation in the Look.
B. The Row Totals option is turned on in the Look.
C. There is a Running Total measure in the Look.
D. The Totals option is turned on in the Look.
E. The Row Limit chosen in the Look is too high.
F. Unlimited results are unsupported by CSV format.
正解：A,B,E