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

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

Page: 1 / 4
Total 40 questions

Looker Business AnalystExam Questions and Answers

Question 1

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:

A.

Admins: Manage Access, Edit

Sales analyst: Edit

Sales group: View

B.

Admins: View

Sales analyst: Edit

Sales group: View

C.

Admins: View

Sales analyst: Manage Access, Edit

Sales group: View

D.

Admins: Manage Access, Edit

Sales analyst: Manage Access, Edit

Sales group: View

Question 2

An analyst has created a line chart with Value Labels enabled, but the values are too long and need to be abbreviated.

Which visualization option should the analyst utilize to alter the display of the value labels?

Options:

A.

Axis Value Labels

B.

Value Format

C.

Label Rotation

D.

Time Label Format

Question 3

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:

A.

There is a row limit applied.

B.

There is a filter on a dimension.

C.

There is a problem with the underlying LookML.

D.

There is a column limit applied.

Question 4

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?

Options:

A.

Sort the data by Count of Items Sold descending and apply a row limit of 50.

B.

Sort the data by Brand Name alphabetically and apply a row limit of 50.

C.

Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

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.

Question 5

An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short and it is difficult to compare all the columns visually.

How should the analyst ensure that the differences between returned order counts for each day are more visible?

Options:

A.

Change the returned orders series to a line type.

B.

Move the returned orders series to a new right axis.

C.

Change the y-axis height to a higher number of pixels.

D.

Set the x-axis to use a log scale.

Question 6

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

Page: 1 / 4
Total 40 questions