Summer Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: ecus65

Google Looker-Business-Analyst - Looker Business AnalystExam

Google Looker-Business-Analyst Premium Access     Download Demo    
Page: 1 / 2
Total 40 questions

An analyst needs to select all users in the query results but only wants to visualize results for users that have more than 100 orders.

Which visualization option should the analyst utilize?

A.

Right-click to hide unwanted rows.

B.

Limit displayed rows.

C.

Use a custom filter.

D.

Hide rows with table calculations.

The sales team has all its Looker content stored in a folder called Sales. Team members are complaining that the Looks and dashboards have been getting moved and edited in unwanted ways. Only the sales analyst should be editing the content in the Sales folder.

Which access settings should be applied to the folder?

A.

Admins: Manage Access, Edit

Sales analyst: Edit

Sales group: View

B.

Admins: View

Sales analyst: Edit

Sales group: View

C.

Admins: View

Sales analyst: Manage Access, Edit

Sales group: View

D.

Admins: Manage Access, Edit

Sales analyst: Manage Access, Edit

Sales group: View

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?

A.

Remove the Number of Museums measure from the Explore

B.

Select the Static Map visualization instead of Interactive

C.

Contact the LookML Developer

D.

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

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?

A.

Add a trend line for 30000.

B.

Add a Tick Density of 30000.

C.

Add a reference line for 30000.

D.

Add a table calculation to hide values less than 30000.

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?

A.

Change the returned orders series to a line type.

B.

Move the returned orders series to a new right axis.

C.

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

D.

Set the x-axis to use a log scale.

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?

A.

Display row totals for each category.

B.

Series type customization on budgeted spend.

C.

Grouped series positioning on budgeted spend.

D.

Transpose table to separate out budgeted spend.

A business analyst is filtering for this year’s data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.

Where should the analyst go to make sure dates are filled in for the future?

A.

X-axis settings

B.

Column settings

C.

Explore settings

D.

Row settings

An analyst has a dashboard with a single filter on Created Date “is in the past year”, but a tile on the dashboard is returning results for only the past 7 days. When the analyst selects “Explore from Here” on the tile, there are filters on both Created Date “is in the past year” and Created Time “is in the past 7 days”.

How should the analyst make sure that only the filter set on the dashboard is applied to the tile?

A.

After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.

B.

After selecting Edit on the tile, add a filter on Created Date and hit Save.

C.

Edit the dashboard Created Date filter to update the tile’s Created Time field under Tiles to Update.

D.

Edit the dashboard Created Date filter to update the tile’s Created Time filter under Filters to Update.

Two users report seeing different results on the same dashboard.

Which three configurations could explain these discrepancies? (Choose three.)

A.

The time zone setting is different for each user.

B.

Looker caching is affecting results.

C.

The dashboard uses separate Explores for each user.

D.

Dashboard filters are being used

E.

The dashboard was accessed via different boards.

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?

A.

Filter the dashboard for the advanced value “yesterday”, and create a new schedule.

B.

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

C.

Create a new schedule and modify the filter’s default value to the previous day’s date.

D.

Create a new schedule and modify the schedule filter to be the advanced value “yesterday”.