Actualtests4sure Looker-Business-Analyst Dumps Real Exam Questions Test Engine Dumps Training
Google Looker-Business-Analyst exam dumps and online Test Engine
Google Looker-Business-Analyst Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
NEW QUESTION 21
An analyst is building out a company KPI dashboard and creates a blank dashboard. The analyst can either create a new tile or use an existing Look.
What are two use cases for using Look-linked tile instead of building a query tile? (Choose two.)
- A. The analyst wants to use the Look-linked tile in a separate company performance dashboard.
- B. The analyst plans on creating a scheduled report of the associated Look.
- C. The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
- D. The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
Answer: A,B
Explanation:
Reference https://help.looker.com/hc/en-us/articles/360023424054-Look-linked-tiles-versus-query-tiles-on-a-dashboard
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
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 24
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 table calculation to hide values less than 30000.
- C. Add a reference line for 30000.
- D. Add a trend line for 30000.
Answer: D
NEW QUESTION 25
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 26
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 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. 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 28
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 29
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 30
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 31
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 32
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 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
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. Two dashboards, one with aggregate and one with individual data
- D. Folder with all dashboard tiles for aggregate data and individual data.
Answer: A
NEW QUESTION 35
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. Add a table calculation that evaluates location (${cities.city_name})
- B. Contact the LookML Developer
- C. Remove the Number of Museums measure from the Explore
- D. Select the Static Map visualization instead of Interactive
Answer: A
NEW QUESTION 36
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 37
......
Google Looker-Business-Analyst: Selling Looker certifications Products and Solutions: https://www.actualtests4sure.com/Looker-Business-Analyst-test-questions.html
