Weekend Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = simple70

Home
Google
Looker certifications
Looker-Business-Analyst
Looker Business AnalystExam Questions and Answers

Pass the Google Looker certifications Looker-Business-Analyst Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam Looker-Business-Analyst Premium Access

View all detail and faqs for the Looker-Business-Analyst exam

Go to Exam

361 Students Passed

87% Average Score

97% Same Questions

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Questions # 1:

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?

Options:

Give all users view access to the personal folder.

Move the dashboard to a shared folder and provide access only to the users from the team.

Give view access to the individual dashboards.

Create a subfolder in the personal folder and given view access to the users from the team.

Answer

Explanation

[Reference: https://docs.looker.com/sharing-and-publishing/organizing-spaces, ]

Questions # 2:

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?

Options:

Filter the dashboard for the advanced value “yesterday”, and create a new schedule.

Edit the dashboard data filters default value to be the previous day’s date, and create a new schedule.

Create a new schedule and modify the filter’s default value to the previous day’s date.

Create a new schedule and modify the schedule filter to be the advanced value “yesterday”.

Answer

Questions # 3:

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?

Options:

Admins: Manage Access, Edit

Sales analyst: Edit

Sales group: View

Admins: View

Sales analyst: Edit

Sales group: View

Admins: View

Sales analyst: Manage Access, Edit

Sales group: View

Admins: Manage Access, Edit

Sales analyst: Manage Access, Edit

Sales group: View

Answer

Questions # 4:

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?

Options:

There is a row limit applied.

There is a filter on a dimension.

There is a problem with the underlying LookML.

There is a column limit applied.

Answer

Explanation

[Reference: https://docs.looker.com/exploring-data/exploring-data#features_for_developers, ]

Questions # 5:

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?

Options:

Dashboard filter to specify which individual data shows

Two dashboards, one with aggregate and one with individual data

Two dashboards with a text tile to hyperlink from one dashboard to the other

Folder with all dashboard tiles for aggregate data and individual data.

Answer

Questions # 6:

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.)

Options:

The analyst wants to use the Look-linked tile in a separate company performance dashboard.

The analyst plans on creating a scheduled report of the associated Look.

The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.

The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.

Answer

A, B

Explanation

Reference https://help.looker.com/hc/en-us/articles/360023424054-Look-linked-tiles-versus-query-tiles-on-a-dashboard

Questions # 7:

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?

Options:

Add a trend line for 30000.

Add a Tick Density of 30000.

Add a reference line for 30000.

Add a table calculation to hide values less than 30000.

Answer

Explanation

[Reference: https://docs.looker.com/exploring-data/visualizing-query-results/line-options, ]

Questions # 8:

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?

Options:

7 days from now

After Today’s Date for 7 days

Today for 7 days

For 7 days

Answer

Questions # 9:

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?

Options:

pivot_offset()

lookup()

offset_list()

offset()

Answer

Explanation

[Reference: https://help.looker.com/hc/en-us/articles/360023509454-Calculating-Percent-of-Previous-and-Percent-Change-with-Table-Calculations, ]

Questions # 10:

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?