Looker-Business-Analyst Practice Exam Tests Latest Updated on Apr-2022
Pass Looker-Business-Analyst Exam in First Attempt Guaranteed Dumps!
NEW QUESTION 13
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 14
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 15
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 16
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 17
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 18
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 19
An analyst creates a table visualization. There is one dimension, a few count type measures, and a percentage table calculation. When the analyst tries to download all 200,000 rows of results in CSV, the option is unavailable. The analyst has been provided permission to download all results.
Which action should the analyst take to download all results?
- A. Change the table calculation to use an offset() function.
- B. Apply a custom limit to the download.
- C. Request that the admin user download this Look and share the file.
- D. Contact the developer to create the percentage as a measure.
Answer: B
NEW QUESTION 20
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 21
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 22
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 23
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 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
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 greater than zero.
- C. Sort the data by Brand Name alphabetically and apply a row limit of 50.
- D. 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.
Answer: B
NEW QUESTION 26
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 27
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
Answer: D
NEW QUESTION 28
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 29
......
Looker certifications Free Certification Exam Material from Test4Cram with 40 Questions: https://www.test4cram.com/Looker-Business-Analyst_real-exam-dumps.html