更新されたPDF（2022年最新）実際にあるGoogle Looker-Business-Analyst試験問題
検証済みのLooker-Business-Analyst試験問題集PDF[2022年最新] 成功の秘訣はFast2test
Google Looker-Business-Analyst 認定試験の出題範囲：
| トピック | 出題範囲 |
|---|---|
| トピック 1 |
|
| トピック 2 |
|
| トピック 3 |
|
| トピック 4 |
|
| トピック 5 |
|
質問 21
An analyst works on the data team at an organization that maintains multiple similar Explores. The analyst has access to see every Explore, but knows that employees in the finance department only have access to explores tagged Finance.
There is an Employee Compensation Data Finance Explore that the finance department has access to. The analyst usually uses an All Employee Data Explore that also includes personally identifiable information.
What should the analyst do to ensure proper access if the analyst wants to send an example visualization to the finance team?
- A. Use the All Employee Data Explore, add a filter to exclude personally identifiable information, and send the URL of the Explore to the finance team.
- B. Use the All Employee Data Explore, but use Looker's built-in Send functionality to email the visualization.
- C. Use the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.
- D. Create Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.
正解: C
質問 22
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. Click on the Room Type dimension where it is King to drill in to it.
- B. Run the Explore again to make sure the results are the same.
- C. Remove the pivot on the Room Type dimension and re-run the Explore.
- D. Click on the Count measure where it is low to drill in to it.
正解: D
質問 23
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 one tile on a dashboard and two dashboard filters ("last week" and "2 weeks ago" respectively). Apply both dashboard filters to the tile.
- B. Create two identical looks in the same folder. Add filters on them for "last week" and "2 weeks ago" respectively.
- C. Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile ("last week" and "2 weeks ago" respectively)
- D. 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
質問 24
An analyst needs to filter the sum of the sales between 12 complete months ago to the last 9 complete months ago.
How can the analyst create this filter condition?
- A. Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago
- B. Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago
- C. Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"
- D. Sales Closing Date "matches advanced" "12 months ago for 3 months"
正解: B
質問 25
An analyst wants to schedule a dashboard in a way that makes it easier for viewing on a mobile device or for viewing a printout of the dashboard.
How can the analyst set up a schedule to accomplish this?
- A. Check Expand tables in the Advanced options section of the scheduler.
- B. Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.
- C. Check Use single column layout in the Advanced options section of the scheduler.
- D. Select Run schedule as recipient in the Advanced options section of the scheduler, and edit the recipient's user attribute preferences to be individual_images.
正解: C
質問 26
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 adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.
- B. Pivot the Explore by brand Rank.
- C. Pivot the Explore by the Brand Name dimension.
- D. 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.
正解: A
質問 27
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 Ticket Revenue dimension from the query. Add the Sum Revenue measure.
- B. Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
- C. Add a table calculation that sums the Ticket Revenue dimension.
- D. Add the Sum Revenue measure to the query.
正解: D
質問 28
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
正解: B
質問 29
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 auto refresh to 5 minutes.
- B. Set the dashboard schedule to 5 minutes and "send if the results have changed".
- C. Set the dashboard to run on load every 5 minutes.
- D. Set the dashboard schedule to run every 5 minutes.
正解: D
質問 30
The analyst is exploring weekly sales revenue in the last 3 months using a line chart. One requirement is to show the sales target $30,000 in the chart.
Which solution can help the analyst display the sales target?
- A. Add a Tick Density of 30000.
- B. Add a reference line for 30000.
- C. Add a trend line for 30000.
- D. Add a table calculation to hide values less than 30000.
正解: C
質問 31
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. Change the filter type to string.
- B. Use the Matches Advanced filtering option.
- C. Enable the setting Limit one filter value.
- D. Disable the setting Allow multiple filter values.
正解: D
質問 32
A business analyst is using the Totals check box in an Explore to get the sum of a column of values. The number that appears in the Total row is much higher than the analyst expects, and this number is not the sum of the values in the column.
What is a possible cause of this discrepancy?
- A. There is a filter on a dimension.
- B. There is a row limit applied.
- C. There is a column limit applied.
- D. There is a problem with the underlying LookML.
正解: C
質問 33
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. offset()
- C. offset_list()
- D. lookup()
正解: B
質問 34
Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters.
How should the analyst filter the query?
- A. Created Month "is in the first 2 quarters"
- B. Created Month "is in the last 6 months"
- C. Created Month "is in the past 2 quarters"
- D. Created Month "is in the past 2 complete quarters"
正解: C
質問 35
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. Show the dashboards in a grid style for displaying the snapshot.
- B. Sort the dashboards in the folder by name.
- C. Add descriptions to the dashboards to give more details.
- D. Pin the dashboards into boards and grant user access to the individual dashboards.
正解: B
質問 36
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 dashboard will break and warn the user that there are conflicting filter values
- B. The individual tile's filter will override the global dashboard filter.
- C. The filter values of both filters will combine in an additive manner and both filters will apply.
- D. The global dashboard filter will override the individual tile filter.
正解: D
質問 37
......
ベストを体験せよ！Looker-Business-Analyst試験問題トレーニングを提供しています：https://jp.fast2test.com/Looker-Business-Analyst-premium-file.html