Google Looker-Business-Analyst Exam Practice Test Instant Access

Question 1

An analyst pins a dashboard from a personal folder to the team board. Other colleagues report that they cannot access the dashboard. There are a few dashboards in the personal folder that are not ready to share yet.

What should the analyst do to enable the team's access?

AGive all users view access to the personal folder.

BMove the dashboard to a shared folder and provide access only to the users from the team.

CGive view access to the individual dashboards.

DCreate a subfolder in the personal folder and given view access to the users from the team.

Answer : D

Question 2

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

How should the analyst, in addition to selecting the measure Total Sales build the report?

ASelect the dimension Created Month, and pivot on the dimension Created Year.

BSelect the dimension Created Year, and pivot on the dimension Created Month.

CSelect the dimension Created Month Name, and pivot on the dimension Created Year.

DSelect the dimension Created Year, and pivot on the dimension Created Month Name.

Answer : A

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

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

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 7

An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.

Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?

ADisplay row totals for each category.

BSeries type customization on budgeted spend.

CGrouped series positioning on budgeted spend.

DTranspose table to separate out budgeted spend.

Answer : D

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