Easy To Download Google Looker-Business-Analyst Exam Dumps Updated 40 Questions
New Updated Looker-Business-Analyst Exam Questions 2022
Google Looker-Business-Analyst Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
NEW QUESTION 18
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 19
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 20
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 21
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. Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.
- B. Check Expand tables in the Advanced options section of the scheduler.
- C. 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.
- D. Check Use single column layout in the Advanced options section of the scheduler.
Answer: D
NEW QUESTION 22
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. Pivot the Explore by brand Rank.
- B. 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.
- C. 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. Pivot the Explore by the Brand Name dimension.
Answer: C
NEW QUESTION 23
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 24
An analyst has created a line chart with Value Labels enabled, but the values are too long and need to be abbreviated.
Which visualization option should the analyst utilize to alter the display of the value labels?
- A. Label Rotation
- B. Axis Value Labels
- C. Value Format
- D. Time Label Format
Answer: C
NEW QUESTION 25
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 26
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 27
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 to run on load every 5 minutes.
- B. Set the dashboard auto refresh to 5 minutes.
- C. Set the dashboard schedule to 5 minutes and "send if the results have changed".
- D. Set the dashboard schedule to run every 5 minutes.
Answer: D
NEW QUESTION 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 Ticket Revenue dimension from the query. Add the Sum Revenue measure.
- B. Add a table calculation that sums the Ticket Revenue dimension.
- C. Add the Sum Revenue measure to the query.
- D. Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
Answer: C
NEW QUESTION 29
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 table calculation that calls ${users.signup_count:total}
- B. Add a custom measure of type: running_total
- C. Add a Sum measure to the Explore and re-run the query.
- D. Add a table calculation that calls running_portal (${users.signup_count})
Answer: C
NEW QUESTION 30
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. Transpose table to separate out budgeted spend.
- B. Series type customization on budgeted spend.
- C. Display row totals for each category.
- D. Grouped series positioning on budgeted spend.
Answer: A
NEW QUESTION 31
An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short and it is difficult to compare all the columns visually.
How should the analyst ensure that the differences between returned order counts for each day are more visible?
- A. Move the returned orders series to a new right axis.
- B. Change the y-axis height to a higher number of pixels.
- C. Set the x-axis to use a log scale.
- D. Change the returned orders series to a line type.
Answer: B
NEW QUESTION 32
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 is a faulty logic in the way users relate to clothing departments.
- B. There is a filter limiting the count in the Total row.
- C. A user is only counted once in the total even if the user has purchased from both departments.
- D. There are users who have never purchased a clothing item from either department.
Answer: C
NEW QUESTION 33
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 Row Limit chosen in the Look is too high.
- B. Unlimited results are unsupported by CSV format.
- C. The Totals option is turned on in the Look.
- D. There is a Running Total measure in the Look.
- E. The Row Totals option is turned on in the Look.
- F. There is a table calculation in the Look.
Answer: A,E,F
NEW QUESTION 34
......
Updated Free Google Looker-Business-Analyst Test Engine Questions with 40 Q&As: https://measureup.preppdf.com/Google/Looker-Business-Analyst-prepaway-exam-dumps.html