Looker-Business-Analyst Looker Business Analyst Exam Questions and Answers

Questions 4

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?

Options:

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

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

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

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

Buy Now

Questions 5

An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short and it is difficult to compare all the columns visually.

How should the analyst ensure that the differences between returned order counts for each day are more visible?

Options:

Change the returned orders series to a line type.

Move the returned orders series to a new right axis.

Change the y-axis height to a higher number of pixels.

Set the x-axis to use a log scale.

Buy Now

Questions 6

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?