Google Looker-Business-Analyst Exam Practice Test Instant Access

Question 1

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?

AThere is a row limit applied.

BThere is a filter on a dimension.

CThere is a problem with the underlying LookML.

DThere is a column limit applied.

Answer : D

Question 2

A CEO wants to receive a daily email with the existing executive dashboard to review on a mobile device on the way to the office.

What should the analyst do to optimize the dashboard for mobile viewing?

ASchedule the dashboard as HTML to adjust automatically.

BSchedule the dashboard with the PDF format Use single column layout.

CCreate a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.

DSchedule the dashboard with PDF paper size set to Fit Page to Dashboard.

Answer : B

Question 3

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?

APivot the Explore by the Brand Name dimension.

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

CPivot the Explore by brand Rank.

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

Answer : D

Question 4

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?

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

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

CContact the developer to create the percentage as a measure.

DApply a custom limit to the download.

Answer : D

Question 5

Two users report seeing different results on the same dashboard.

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

AThe time zone setting is different for each user.

BLooker caching is affecting results.

CThe dashboard uses separate Explores for each user.

DDashboard filters are being used

EThe dashboard was accessed via different boards.

Answer : C, D, E

Question 6

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

AThe Row Limit chosen in the Look is too high.

BThere is a table calculation in the Look.

CUnlimited results are unsupported by CSV format.

DThe Row Totals option is turned on in the Look.

EThere is a Running Total measure in the Look.

FThe Totals option is turned on in the Look.

Answer : A, B, D

Question 7

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?

Apivot_offset()

Blookup()

Coffset_list()

Doffset()

Answer : D

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