Google Looker-Business-Analyst Exam Practice Test Instant Access

Question 1

The analyst is exploring weekly sales revenue in the last 3 months using a line chart. One requirement is to show the sales target $30,000 in the chart.

Which solution can help the analyst display the sales target?

AAdd a trend line for 30000.

BAdd a Tick Density of 30000.

CAdd a reference line for 30000.

DAdd a table calculation to hide values less than 30000.

Answer : A

Question 2

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 3

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 4

Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.

What should the analyst do to improve the navigation experience?

APin the dashboards into boards and grant user access to the individual dashboards.

BAdd descriptions to the dashboards to give more details.

CSort the dashboards in the folder by name.

DShow the dashboards in a grid style for displaying the snapshot.

Answer : C

Question 5

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?

AAxis Value Labels

BValue Format

CLabel Rotation

DTime Label Format

Answer : B

Question 6

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 7

An analyst needs to send a daily PDF to three different stores and wants it to contain five visualizations of KPI dat

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

AThree dashboards, one for each store

BThree schedules filtered by store

CFive schedules, one for each visualization

DA dashboard with three filters, one for each store

Answer : D

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