New Year Special Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70percent

Google Looker-Business-Analyst Looker Business AnalystExam Exam Practice Test

Looker Business AnalystExam Questions and Answers

Question 1

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:

A.

pivot_offset()

B.

lookup()

C.

offset_list()

D.

offset()

Question 2

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?

Options:

A.

Request that the admin user download this Look and share the file.

B.

Change the table calculation to use an offset() function.

C.

Contact the developer to create the percentage as a measure.

D.

Apply a custom limit to the download.

Question 3

An analyst needs to send a daily PDF to three different stores and wants it to contain five visualizations of KPI data. 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?

Options:

A.

Three dashboards, one for each store

B.

Three schedules filtered by store

C.

Five schedules, one for each visualization

D.

A dashboard with three filters, one for each store

Question 4

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?

Options:

A.

X-axis settings

B.

Column settings

C.

Explore settings

D.

Row settings

Question 5

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:

A.

Add a trend line for 30000.

B.

Add a Tick Density of 30000.

C.

Add a reference line for 30000.

D.

Add a table calculation to hide values less than 30000.

Question 6

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:

A.

Give all users view access to the personal folder.

B.

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

C.

Give view access to the individual dashboards.

D.

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