Google Looker-Business-Analyst Exam Practice Test Instant Access

Question 1

An analyst works on the data team at an organization that maintains multiple similar Explores. The analyst has access to see every Explore, but knows that employees in the finance department only have access to explores tagged Finance.

There is an Employee Compensation Data Finance Explore that the finance department has access to. The analyst usually uses an All Employee Data Explore that also includes personally identifiable information.

What should the analyst do to ensure proper access if the analyst wants to send an example visualization to the finance team?

ACreate Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.

BUse the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.

CUse the All Employee Data Explore, but use Looker's built-in Send functionality to email the visualization.

DUse the All Employee Data Explore, add a filter to exclude personally identifiable information, and send the URL of the Explore to the finance team.

Answer : B

Question 2

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

Question 3

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 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?

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

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

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

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

Answer : C

Question 5

A business analyst is creating an Explore that shows the number of hotel rooms booked per week, by room type. The analyst is using a Week dimension and a Count measure, and is provisioning on a Room Type dimension. Looking at the results, the Count of King rooms seems unusually low one week.

What should the analyst do to further investigate the low numbers?

ARun the Explore again to make sure the results are the same.

BClick on the Count measure where it is low to drill in to it.

CClick on the Room Type dimension where it is King to drill in to it.

DRemove the pivot on the Room Type dimension and re-run the Explore.

Answer : B

Question 6

An analyst needs to filter the sum of the sales between 12 complete months ago to the last 9 complete months ago.

How can the analyst create this filter condition?

ACustom filter ''is in the past'' 12 months AND ''is before'' ''relative'' 9 months ago

BSales Closing Date ''matches advanced'' ''12 months ago for 3 months''

CSales Closing Date ''is in the past'' 12 months OR ''is before'' ''relative'' 9 months ago

DSales Closing Date ''matches advanced'' ''between 12 months ago and 9 months ago''

Answer : A

Question 7

An analyst is creating a map that colors cities by their population. After adding fields and selecting the Interactive Map visualization, the analyst receives this error message:

''At least one dimension should be of type Location or have a map_layer specified''.

There are currently three fields in the Explore:

City Name (Dimension)

Population (Measure)

Number of Museums (Measure)

What should the analyst do to resolve this error?

ARemove the Number of Museums measure from the Explore

BSelect the Static Map visualization instead of Interactive

CContact the LookML Developer

DAdd a table calculation that evaluates location (${cities.city_name})

Answer : D

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