Get Prepared for Your Looker-Business-Analyst Exam With Actual 40 Questions
Valid Looker-Business-Analyst Test Answers Full-length Practice Certification Exams
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 problem with the underlying LookML.
- B. There is a row limit applied.
- C. There is a column limit applied.
- D. There is a filter on a dimension.
Answer: C
NEW QUESTION 20
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 to run on load every 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 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. Check Use single column layout in the Advanced options section of the scheduler.
- B. 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. Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.
- D. Check Expand tables in the Advanced options section of the scheduler.
Answer: A
NEW QUESTION 22
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. Unlimited results are unsupported by CSV format.
- B. The Totals option is turned on in the Look.
- C. The Row Limit chosen in the Look is too high.
- D. There is a Running Total measure in the Look.
- E. There is a table calculation in the Look.
- F. The Row Totals option is turned on in the Look.
Answer: C,E,F
NEW QUESTION 23
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 filter values of both filters will combine in an additive manner and both filters will apply.
- B. The global dashboard filter will override the individual tile filter.
- C. The individual tile's filter will override the global dashboard filter.
- D. The dashboard will break and warn the user that there are conflicting filter values
Answer: B
NEW QUESTION 24
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. Request that the admin user download this Look and share the file.
- B. Contact the developer to create the percentage as a measure.
- C. Change the table calculation to use an offset() function.
- D. Apply a custom limit to the download.
Answer: D
NEW QUESTION 25
An analyst pins a dashboard from a personal folder to the team board. Other colleagues report that they cannot access the dashboard. There are a few dashboards in the personal folder that are not ready to share yet.
What should the analyst do to enable the team's access?
- A. Give view access to the individual dashboards.
- B. Create a subfolder in the personal folder and given view access to the users from the team.
- C. Give all users view access to the personal folder.
- D. Move the dashboard to a shared folder and provide access only to the users from the team.
Answer: B
NEW QUESTION 26
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. Folder with all dashboard tiles for aggregate data and individual data.
- C. Two dashboards, one with aggregate and one with individual data
- D. Two dashboards with a text tile to hyperlink from one dashboard to the other
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. Add the Sum Revenue measure to the query.
- 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. Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
Answer: A
NEW QUESTION 28
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. Explore settings
- C. X-axis settings
- D. Row settings
Answer: B
NEW QUESTION 29
An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard.
How should the analyst ensure that the PDF shows all available results in the UI dashboard?
- A. Select the All Results option
- B. Select the Expand Tables option.
- C. Select the Paper Size option and specify a large size.
- D. Select the Allow Scroll option and specify each table.
Answer: B
NEW QUESTION 30
An analyst has created a dashboard that needs to be integrated into the company's internal support portal. The dashboard should match the style of the support portal.
How should the analyst display the dashboard in the style of the support portal without changing the style of the tiles in Looker?
- A. Copy the dashboard.
- B. Edit HTML on the dashboard.
- C. Apply a table theme.
- D. Edit embed settings.
Answer: D
NEW QUESTION 31
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. Create a new schedule and modify the schedule filter to be the advanced value "yesterday".
- B. Filter the dashboard for the advanced value "yesterday", and create a new schedule.
- C. Create a new schedule and modify the filter's default value to the previous day's date.
- D. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.
Answer: D
NEW QUESTION 32
Two users report seeing different results on the same dashboard.
Which three configurations could explain these discrepancies? (Choose three.)
- A. The time zone setting is different for each user.
- B. The dashboard was accessed via different boards.
- C. Looker caching is affecting results.
- D. Dashboard filters are being used
- E. The dashboard uses separate Explores for each user.
Answer: B,D,E
NEW QUESTION 33
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. Display row totals for each category.
- B. Transpose table to separate out budgeted spend.
- C. Grouped series positioning on budgeted spend.
- D. Series type customization on budgeted spend.
Answer: B
NEW QUESTION 34
An analyst needs to display data from two different sources together. There is a Look for each data source, but there is no shared field that can be combined. Both Looks are saved in the Shared folder.
How should the analyst display the data from both sources?
- A. use Merged Results to combine the data sources.
- B. Ask the LookML developer to build a new Explore.
- C. Pin both Looks to a board.
- D. Add both Looks to a dashboard
Answer: D
NEW QUESTION 35
......
Click the link below, to get more info about the Google Looker Business Analyst Certification Exam
Official link to the Google Looker Business Analyst Exam
Accurate & Verified 2022 New Looker-Business-Analyst Answers As Experienced in the Actual Test!: https://www.passleader.top/Google/Looker-Business-Analyst-exam-braindumps.html