[Q12-Q31] 2022 Valid Looker-Business-Analyst Dumps for Helping Passing Google Exam!

Rate this post

2022 Valid Looker-Business-Analyst Dumps for Helping Passing Google Exam!

Download Free Google Looker-Business-Analyst Exam Questions & Answer

Google Looker-Business-Analyst Exam Syllabus Topics:

Topic	Details
Topic 1	Apply procedural concepts to design impactful dashboards Apply procedural concepts to curate content for intuitive navigation
Topic 2	Use Looker Explores to query data and create actionable metrics in a given scenario Apply procedural concepts to identify error sources
Topic 3	Determine which visualization settings to use Select appropriate visualizations to illustrate data results
Topic 4	Determine appropriate setups for folders and boards Apply procedural concepts to control content access for security
Topic 5	Utilize appropriate Explores based on audience to prevent data leak Investigate discrepancies by viewing row-level data using Explores
Topic 6	Determine additional metrics needed and construct custom metrics using table calculations Build dashboards to meet business requirements
Topic 7	Assign folders and boards permissions to organize content based on user groups Use Looker to validate data accuracy in a given scenario

NO.12 An analyst wants to schedule a dashboard in a way that makes it easier for viewing on a mobile device or for viewing a printout of the dashboard.
How can the analyst set up a schedule to accomplish this?

Check Use single column layout in the Advanced options section of the scheduler.

Check Expand tables in the Advanced options section of the scheduler.

Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.

Select Run schedule as recipient in the Advanced options section of the scheduler, and edit the recipient’s user attribute preferences to be individual_images.

NO.13 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?

Admins: Manage Access, Edit
Sales analyst: Edit
Sales group: View

Admins: View
Sales analyst: Edit
Sales group: View

Admins: View
Sales analyst: Manage Access, Edit
Sales group: View

Admins: Manage Access, Edit
Sales analyst: Manage Access, Edit
Sales group: View

NO.14 An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error “Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time”.
How can the analyst resolve this error while showing the rank as a column visualization?

Pivot the Explore by the Brand Name dimension.

Select a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.

Pivot the Explore by brand Rank.

Select a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

NO.15 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?

Three dashboards, one for each store

Three schedules filtered by store

Five schedules, one for each visualization

A dashboard with three filters, one for each store

NO.16 An analyst is trying to create a pie chart showing the breakdown of the top sales by brand in an Explore. The analyst selects the Brand Name dimension and a measure for the Count of Items Sold. The analyst then selects the pie chart visualization, but sees the error “Too Many Rows: Pie charts can display a maximum of 50 rows of data.” How can the analyst resolve this error and create a pie chart that will always show the top brands by items sold?

Sort the data by Count of Items Sold descending and apply a row limit of 50.

Sort the data by Brand Name alphabetically and apply a row limit of 50.

Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

Apply a filter on the Count of Items Sold measure that requires the count to be not NULL, sort the data by Count of Items Sold ascending, and apply a row limit of 50.

NO.17 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?

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

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

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

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

NO.18 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.)

The Row Limit chosen in the Look is too high.

There is a table calculation in the Look.

Unlimited results are unsupported by CSV format.

The Row Totals option is turned on in the Look.

There is a Running Total measure in the Look.

The Totals option is turned on in the Look.

NO.19 Two users report seeing different results on the same dashboard.
Which three configurations could explain these discrepancies? (Choose three.)

The time zone setting is different for each user.

Looker caching is affecting results.

The dashboard uses separate Explores for each user.

Dashboard filters are being used

The dashboard was accessed via different boards.

NO.20 An analyst creates a dashboard that shows sales at an aggregate and then an individual level. This dashboard is slow to run, and the analyst sees a warning about how load times may be impacted in dashboards with more than 25 tiles.
What should the analyst create to make sure all data sources in this dashboard are connected but still load quickly?

Dashboard filter to specify which individual data shows

Two dashboards, one with aggregate and one with individual data

Two dashboards with a text tile to hyperlink from one dashboard to the other

Folder with all dashboard tiles for aggregate data and individual data.

NO.21 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?

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.

NO.22 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?

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

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

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

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

NO.23 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?

The filter values of both filters will combine in an additive manner and both filters will apply.

The individual tile’s filter will override the global dashboard filter.

The global dashboard filter will override the individual tile filter.

The dashboard will break and warn the user that there are conflicting filter values

NO.24 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?

Request that the admin user download this Look and share the file.

Change the table calculation to use an offset() function.

Contact the developer to create the percentage as a measure.

Apply a custom limit to the download.

NO.25 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?

X-axis settings

Column settings

Explore settings

Row settings

NO.26 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?

Remove the Number of Museums measure from the Explore

Select the Static Map visualization instead of Interactive

Contact the LookML Developer

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

NO.27 An analyst needs to filter the sum of the sales between 12 complete months ago to the last 9 complete months ago.
How can the analyst create this filter condition?

Custom filter “is in the past” 12 months AND “is before” “relative” 9 months ago

Sales Closing Date “matches advanced” “12 months ago for 3 months”

Sales Closing Date “is in the past” 12 months OR “is before” “relative” 9 months ago

Sales Closing Date “matches advanced” “between 12 months ago and 9 months ago”

Loading …