無料Looker-Business-Analystサンプル問題で100%カバー率のリアル試験問題（更新された40問あります)
今すぐダウンロード！リアルGoogle Looker-Business-Analyst試験問題集テストエンジン試験問題
質問 14
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. 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.
- C. Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.
- D. Sort the data by Brand Name alphabetically and apply a row limit of 50.
正解: C
質問 15
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. Remove the Number of Museums measure from the Explore
- B. Add a table calculation that evaluates location (${cities.city_name})
- C. Select the Static Map visualization instead of Interactive
- D. Contact the LookML Developer
正解: B
質問 16
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. offset()
- B. lookup()
- C. pivot_offset()
- D. offset_list()
正解: A
質問 17
An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.
What should the analyst do to meet this requirement?
- A. Create a new schedule and modify the filter's default value to the previous day's date.
- B. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.
- C. Create a new schedule and modify the schedule filter to be the advanced value "yesterday".
- D. Filter the dashboard for the advanced value "yesterday", and create a new schedule.
正解: B
質問 18
A company has a Customer Lookup dashboard that can be filtered on a unique customer name. Business users sometimes report unexpected data when they use filters with starts with or contains for the customer name.
How should the analyst ensure that the filter is unique to one customer?
- A. Disable the setting Allow multiple filter values.
- B. Use the Matches Advanced filtering option.
- C. Change the filter type to string.
- D. Enable the setting Limit one filter value.
正解: A
質問 19
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. Pin both Looks to a board.
- C. Ask the LookML developer to build a new Explore.
- D. Add both Looks to a dashboard
正解: D
質問 20
Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.
What should the analyst do to improve the navigation experience?
- A. Add descriptions to the dashboards to give more details.
- B. Pin the dashboards into boards and grant user access to the individual dashboards.
- C. Sort the dashboards in the folder by name.
- D. Show the dashboards in a grid style for displaying the snapshot.
正解: C
質問 21
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 Year, and pivot on the dimension Created Month Name.
- B. Select the dimension Created Year, and pivot on the dimension Created Month.
- C. Select the dimension Created Month, and pivot on the dimension Created Year.
- D. Select the dimension Created Month Name, and pivot on the dimension Created Year.
正解: C
質問 22
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 Totals option is turned on in the Look.
- B. Unlimited results are unsupported by CSV format.
- C. There is a table calculation in the Look.
- D. There is a Running Total measure in the Look.
- E. The Row Limit chosen in the Look is too high.
- F. The Row Totals option is turned on in the Look.
正解: C,E,F
質問 23
A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter values.
What happens in this situation?
- A. The global dashboard filter will override the individual tile filter.
- B. The dashboard will break and warn the user that there are conflicting filter values
- C. The individual tile's filter will override the global dashboard filter.
- D. The filter values of both filters will combine in an additive manner and both filters will apply.
正解: A
質問 24
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. Today for 7 days
- B. For 7 days
- C. 7 days from now
- D. After Today's Date for 7 days
正解: D
質問 25
The query below shows how many uses purchased an item from each of two clothing departments.
Why are the total and sum of the rows unequal?
- A. There are users who have never purchased a clothing item from either department.
- B. There is a faulty logic in the way users relate to clothing departments.
- C. There is a filter limiting the count in the Total row.
- D. A user is only counted once in the total even if the user has purchased from both departments.
正解: D
質問 26
A CEO wants to receive a daily email with the existing executive dashboard to review on a mobile device on the way to the office.
What should the analyst do to optimize the dashboard for mobile viewing?
- A. Schedule the dashboard as HTML to adjust automatically.
- B. Schedule the dashboard with the PDF format Use single column layout.
- C. Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
- D. Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.
正解: B
質問 27
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. Series type customization on budgeted spend.
- B. Transpose table to separate out budgeted spend.
- C. Display row totals for each category.
- D. Grouped series positioning on budgeted spend.
正解: B
質問 28
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. Add the Sum Revenue measure to the query.
- C. Add a table calculation that sums the Ticket Revenue dimension.
- D. Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
正解: B
質問 29
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. Dashboard filter to specify which individual data shows
- B. Two dashboards with a text tile to hyperlink from one dashboard to the other
- C. Folder with all dashboard tiles for aggregate data and individual data.
- D. Two dashboards, one with aggregate and one with individual data
正解: A
質問 30
......
Google Looker-Business-Analyst 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
最新Looker-Business-Analystテスト問題集を試そう！更新されたGoogle試験が合格できます：https://jp.fast2test.com/Looker-Business-Analyst-premium-file.html