Google Looker-Business-Analyst Exam Questions Instant Access

Question 1

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 2

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

A CEO wants to receive a daily email with the existing executive dashboard to review on a mobile device on the way to the office.

What should the analyst do to optimize the dashboard for mobile viewing?

ASchedule the dashboard as HTML to adjust automatically.

BSchedule the dashboard with the PDF format Use single column layout.

CCreate a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.

DSchedule the dashboard with PDF paper size set to Fit Page to Dashboard.

Answer : B

Question 5

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.

What should the analyst do to meet this requirement?

AFilter the dashboard for the advanced value ''yesterday'', and create a new schedule.

BEdit the dashboard data filters default value to be the previous day's date, and create a new schedule.

CCreate a new schedule and modify the filter's default value to the previous day's date.

DCreate a new schedule and modify the schedule filter to be the advanced value ''yesterday''.

Answer : B

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

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 7

A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.

Which filter expression should the business analyst use?

A7 days from now

BAfter Today's Date for 7 days

CToday for 7 days

DFor 7 days

Answer : B

Google Looker Business Analyst Looker-Business-Analyst Exam Questions