Guide (New 2022) Actual Google Looker-Business-Analyst Exam Questions
Looker-Business-Analyst Exam Dumps Pass with Updated 2022 Certified Exam Questions
NEW QUESTION 19
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 row limit applied.
- B. There is a column limit applied.
- C. There is a filter on a dimension.
- D. There is a problem with the underlying LookML.
Answer: B
NEW QUESTION 20
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. Create Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.
- B. 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.
- C. Use the All Employee Data Explore, but use Looker's built-in Send functionality to email the visualization.
- D. Use the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.
Answer: D
NEW QUESTION 21
The sales team has all its Looker content stored in a folder called Sales. Team members are complaining that the Looks and dashboards have been getting moved and edited in unwanted ways. Only the sales analyst should be editing the content in the Sales folder.
Which access settings should be applied to the folder?
- A. Admins: View
Sales analyst: Edit
Sales group: View - B. Admins: Manage Access, Edit
Sales analyst: Edit
Sales group: View - C. Admins: Manage Access, Edit
Sales analyst: Manage Access, Edit
Sales group: View - D. Admins: View
Sales analyst: Manage Access, Edit
Sales group: View
Answer: B
NEW QUESTION 22
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. Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.
- D. Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
Answer: B
NEW QUESTION 23
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. Sort the dashboards in the folder by name.
- B. Pin the dashboards into boards and grant user access to the individual dashboards.
- C. Show the dashboards in a grid style for displaying the snapshot.
- D. Add descriptions to the dashboards to give more details.
Answer: A
NEW QUESTION 24
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 Month Name, and pivot on the dimension Created Year.
- B. Select the dimension Created Month, and pivot on the dimension Created Year.
- C. Select the dimension Created Year, and pivot on the dimension Created Month.
- D. Select the dimension Created Year, and pivot on the dimension Created Month Name.
Answer: B
NEW QUESTION 25
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 past 2 quarters"
- B. Created Month "is in the last 6 months"
- C. Created Month "is in the first 2 quarters"
- D. Created Month "is in the past 2 complete quarters"
Answer: A
NEW QUESTION 26
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 identical looks in the same folder. Add filters on them for "last week" and "2 weeks ago" respectively.
- B. 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.
- C. Create one tile on a dashboard and two dashboard filters ("last week" and "2 weeks ago" respectively). Apply both dashboard filters to the tile.
- D. Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile ("last week" and "2 weeks ago" respectively)
Answer: B
NEW QUESTION 27
Two users report seeing different results on the same dashboard.
Which three configurations could explain these discrepancies? (Choose three.)
- A. Looker caching is affecting results.
- B. Dashboard filters are being used
- C. The time zone setting is different for each user.
- D. The dashboard was accessed via different boards.
- E. The dashboard uses separate Explores for each user.
Answer: B,D,E
NEW QUESTION 28
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. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.
- B. Create a new schedule and modify the filter's default value to the previous day's date.
- C. Filter the dashboard for the advanced value "yesterday", and create a new schedule.
- D. Create a new schedule and modify the schedule filter to be the advanced value "yesterday".
Answer: A
NEW QUESTION 29
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. pivot_offset()
- C. lookup()
- D. offset_list()
Answer: A
NEW QUESTION 30
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 individual tile's filter will override the global dashboard filter.
- B. The dashboard will break and warn the user that there are conflicting filter values
- C. The global dashboard filter will override the individual tile filter.
- D. The filter values of both filters will combine in an additive manner and both filters will apply.
Answer: C
NEW QUESTION 31
An analyst needs to send a daily PDF to three different stores and wants it to contain five visualizations of KPI dat a. Each store's users must receive only the data filtered for that store. The analyst needs to see all store data in Looker.
What should the analyst build to accommodate these requirements?
- A. Three schedules filtered by store
- B. Three dashboards, one for each store
- C. Five schedules, one for each visualization
- D. A dashboard with three filters, one for each store
Answer: D
NEW QUESTION 32
A business analyst is filtering for this year's data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.
Where should the analyst go to make sure dates are filled in for the future?
- A. Column settings
- B. Row settings
- C. Explore settings
- D. X-axis settings
Answer: C
NEW QUESTION 33
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. Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago
- B. Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"
- C. Sales Closing Date "matches advanced" "12 months ago for 3 months"
- D. Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago
Answer: A
NEW QUESTION 34
An analyst has a dashboard with a single filter on Created Date "is in the past year", but a tile on the dashboard is returning results for only the past 7 days. When the analyst selects "Explore from Here" on the tile, there are filters on both Created Date "is in the past year" and Created Time "is in the past 7 days".
How should the analyst make sure that only the filter set on the dashboard is applied to the tile?
- A. Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.
- B. After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.
- C. After selecting Edit on the tile, add a filter on Created Date and hit Save.
- D. Edit the dashboard Created Date filter to update the tile's Created Time field under Tiles to Update.
Answer: A
NEW QUESTION 35
......
Pass Guaranteed Quiz 2022 Realistic Verified Free Google: https://www.prep4away.com/Google-certification/braindumps.Looker-Business-Analyst.ete.file.html