Updated Jul-2022 Looker-Business-Analyst Exam Practice Test Questions [Q21-Q42]

4/5 - (1 vote)

Updated Jul-2022 Looker-Business-Analyst Exam Practice Test Questions

Verified Looker-Business-Analyst dumps Q&As 100% Pass in First Attempt Guaranteed Updated Dump

Google Looker-Business-Analyst Exam Syllabus Topics:

Topic	Details
Topic 1	Utilize appropriate Explores based on audience to prevent data leak Investigate discrepancies by viewing row-level data using Explores
Topic 2	Determine appropriate report delivery methods Use visualization types to meet analysis requirements in a given scenario
Topic 3	Determine appropriate setups for folders and boards Apply procedural concepts to control content access for security
Topic 4	Assign folders and boards permissions to organize content based on user groups Use Looker to validate data accuracy in a given scenario
Topic 5	Apply procedural concepts to design impactful dashboards Apply procedural concepts to curate content for intuitive navigation
Topic 6	Determine how to utilize filters Construct dashboards to meet requirements Interpret error message to identify the source
Topic 7	Determine which visualization settings to use Select appropriate visualizations to illustrate data results
Topic 8	Determine additional metrics needed and construct custom metrics using table calculations Build dashboards to meet business requirements
Topic 9	Utilize Looker’s features to determine the cause of the error Utilize requirements and create queries using fields

NEW QUESTION 21
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.

NEW QUESTION 22
An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.
How should that metric be calculated?

Add a Sum measure to the Explore and re-run the query.

Add a table calculation that calls running_portal (${users.signup_count})

Add a custom measure of type: running_total

Add a table calculation that calls ${users.signup_count:total}

NEW QUESTION 23
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.

NEW QUESTION 24
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.

NEW QUESTION 25
Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.
What should the analyst do to improve the navigation experience?

Pin the dashboards into boards and grant user access to the individual dashboards.

Add descriptions to the dashboards to give more details.

Sort the dashboards in the folder by name.

Show the dashboards in a grid style for displaying the snapshot.

NEW QUESTION 26
An analyst needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count.
Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?

pivot_offset()

lookup()

offset_list()

offset()

NEW QUESTION 27
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.

NEW QUESTION 28
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”

NEW QUESTION 29
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.

NEW QUESTION 30
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.

NEW QUESTION 31
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?

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

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

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

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

NEW QUESTION 32
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?

Axis Value Labels

Value Format

Label Rotation

Time Label Format

NEW QUESTION 33
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.

NEW QUESTION 34
Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters.
How should the analyst filter the query?

Created Month “is in the first 2 quarters”

Created Month “is in the past 2 complete quarters”

Created Month “is in the past 2 quarters”

Created Month “is in the last 6 months”

NEW QUESTION 35
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?

7 days from now

After Today’s Date for 7 days

Today for 7 days

For 7 days

NEW QUESTION 36
An analyst at a banana quality assurance firm needs to compare performance week over week to make sure the firm stays on track. The analyst needs to show two metrics:
Number of bananas cleared for consumption the previous week
Number of bananas cleared for consumption the week before that
Which process should the analyst follow to show these two metrics in a report?

Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile (“last week” and “2 weeks ago” respectively)

Create one tile on a dashboard and two dashboard filters (“last week” and “2 weeks ago” respectively). Apply both dashboard filters to the tile.

Create two tiles on a dashboard. In the Edit mode of one tile, add a filter for “last week”. Add a dashboard filter for “2weeks ago” and apply it to the other tile.

Create two identical looks in the same folder. Add filters on them for “last week” and “2 weeks ago” respectively.

Loading …

Pass Looker certifications Looker-Business-Analyst Exam With 40 Questions: https://www.dumpstorrent.com/Looker-Business-Analyst-exam-dumps-torrent.html

Updated Jul-2022 Looker-Business-Analyst Exam Practice Test Questions [Q21-Q42]

Google Looker-Business-Analyst Exam Syllabus Topics:

admin

Leave a Reply Cancel reply