Labour Day Special - Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: top65certs

Google Looker-Business-Analyst Dumps

Looker Business Analyst Exam Questions and Answers

Question 1

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:

A.

7 days from now

B.

After Today’s Date for 7 days

C.

Today for 7 days

D.

For 7 days

Question 2

Two users report seeing different results on the same dashboard.

Which three configurations could explain these discrepancies? (Choose three.)

Options:

A.

The time zone setting is different for each user.

B.

Looker caching is affecting results.

C.

The dashboard uses separate Explores for each user.

D.

Dashboard filters are being used

E.

The dashboard was accessed via different boards.

Question 3

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?

Options:

A.

Set the dashboard schedule to run every 5 minutes.

B.

Set the dashboard auto refresh to 5 minutes.

C.

Set the dashboard to run on load every 5 minutes.

D.

Set the dashboard schedule to 5 minutes and “send if the results have changed”.

Question 4

An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error “Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time”.

How can the analyst resolve this error while showing the rank as a column visualization?

Options:

A.

Pivot the Explore by the Brand Name dimension.

B.

Select a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.

C.

Pivot the Explore by brand Rank.

D.

Select a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

Question 5

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 6

A company has a Customer Lookup dashboard that can be filtered on a unique customer name. Business users sometimes report unexpected data when they use filters with starts with or contains for the customer name.

How should the analyst ensure that the filter is unique to one customer?

Options:

A.

Change the filter type to string.

B.

Enable the setting Limit one filter value.

C.

Use the Matches Advanced filtering option.

D.

Disable the setting Allow multiple filter values.