Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

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 2

An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard.

How should the analyst ensure that the PDF shows all available results in the UI dashboard?

ASelect the Expand Tables option.

BSelect the All Results option

CSelect the Allow Scroll option and specify each table.

DSelect the Paper Size option and specify a large size.

Answer : A

Question 3

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?

AX-axis settings

BColumn settings

CExplore settings

DRow settings

Answer : C

Question 4

An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions:

Ticket Purchase Month

Movie Name

Ticket Revenue

The analyst notices that the numbers look a lot smaller than expected and the results are difficult to understand.

What should the analyst do to make the Explore query show the desired metric?

ARemove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

BRemove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

CAdd the Sum Revenue measure to the query.

DAdd a table calculation that sums the Ticket Revenue dimension.

Answer : C

Question 5

An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.

How should that metric be calculated?

AAdd a Sum measure to the Explore and re-run the query.

BAdd a table calculation that calls running_portal (${users.signup_count})

CAdd a custom measure of type: running_total

DAdd a table calculation that calls ${users.signup_count:total}

Answer : A

Question 6

A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter values.

What happens in this situation?

AThe filter values of both filters will combine in an additive manner and both filters will apply.

BThe individual tile's filter will override the global dashboard filter.

CThe global dashboard filter will override the individual tile filter.

DThe dashboard will break and warn the user that there are conflicting filter values

Answer : C

Question 7

Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters.

How should the analyst filter the query?

ACreated Month ''is in the first 2 quarters''

BCreated Month ''is in the past 2 complete quarters''

CCreated Month ''is in the past 2 quarters''

DCreated Month ''is in the last 6 months''

Answer : C

Google Looker Business Analyst Looker-Business-Analyst Exam Questions