Google Looker-Business-Analyst 問題集

質問 1：
An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error "Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time".
How can the analyst resolve this error while showing the rank as a column visualization?
A. Select a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.
B. Pivot the Explore by the Brand Name dimension.
C. Pivot the Explore by brand Rank.
D. Select a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.
正解：D

質問 2：
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

質問 3：
An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.
How should that metric be calculated?
A. Add a Sum measure to the Explore and re-run the query.
B. Add a custom measure of type: running_total
C. Add a table calculation that calls running_portal (${users.signup_count})
D. Add a table calculation that calls ${users.signup_count:total}
正解：A

質問 4：
An analyst is building out a company KPI dashboard and creates a blank dashboard. The analyst can either create a new tile or use an existing Look.
What are two use cases for using Look-linked tile instead of building a query tile? (Choose two.)
A. The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
B. The analyst wants to use the Look-linked tile in a separate company performance dashboard.
C. The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
D. The analyst plans on creating a scheduled report of the associated Look.
正解：B,D
解説: (Topexam メンバーにのみ表示されます)