Google Looker-Business-Analyst 問題集

質問 1：
A company has an operational dashboard that needs to display the latest data every 5 minutes on a monitor.
How should the analyst configure the dashboard?
A. Set the dashboard schedule to 5 minutes and "send if the results have changed".
B. Set the dashboard auto refresh to 5 minutes.
C. Set the dashboard to run on load every 5 minutes.
D. Set the dashboard schedule to run every 5 minutes.
正解：D

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

質問 4：
An analyst creates a dashboard that shows sales at an aggregate and then an individual level. This dashboard is slow to run, and the analyst sees a warning about how load times may be impacted in dashboards with more than 25 tiles.
What should the analyst create to make sure all data sources in this dashboard are connected but still load quickly?
A. Two dashboards with a text tile to hyperlink from one dashboard to the other
B. Two dashboards, one with aggregate and one with individual data
C. Folder with all dashboard tiles for aggregate data and individual data.
D. Dashboard filter to specify which individual data shows
正解：D