[Apr 20, 2022] Looker-Business-Analyst Test Prep Training Practice Exam Questions Practice Tests [Q23-Q47]

April 20, 2022 Looker-Business-Analyst, Google 0 Comments

[Apr 20, 2022] Looker-Business-Analyst Test Prep Training Practice Exam Questions Practice Tests [Q23-Q47]

4.6/5 - (14 votes)

[Apr 20, 2022] Looker-Business-Analyst Test Prep Training Practice Exam Questions Practice Tests

Exam Questions Answers Braindumps Looker-Business-Analyst Exam Dumps PDF Questions

Google Looker-Business-Analyst Exam Syllabus Topics:

Topic	Details
Topic 1	Determine how to utilize filters Construct dashboards to meet requirements Interpret error message to identify the source
Topic 2	Determine additional metrics needed and construct custom metrics using table calculations Build dashboards to meet business requirements
Topic 3	Determine which visualization settings to use Select appropriate visualizations to illustrate data results
Topic 4	Determine appropriate report delivery methods Use visualization types to meet analysis requirements in a given scenario
Topic 5	Determine appropriate setups for folders and boards Apply procedural concepts to control content access for security
Topic 6	Assign folders and boards permissions to organize content based on user groups Use Looker to validate data accuracy in a given scenario

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

NO.24 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()

NO.25 An analyst is building out a company KPI dashboard and creates a blank dashboard. The analyst can either create a new tile or use an existing Look.
What are two use cases for using Look-linked tile instead of building a query tile? (Choose two.)

The analyst wants to use the Look-linked tile in a separate company performance dashboard.

The analyst plans on creating a scheduled report of the associated Look.

The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.

The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.

Reference https://help.looker.com/hc/en-us/articles/360023424054-Look-linked-tiles-versus-query-tiles-on-a-dashboard

NO.26 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.27 A company has a Customer Lookup dashboard that can be filtered on a unique customer name. Business users sometimes report unexpected data when they use filters with starts with or contains for the customer name.
How should the analyst ensure that the filter is unique to one customer?

Change the filter type to string.

Enable the setting Limit one filter value.

Use the Matches Advanced filtering option.

Disable the setting Allow multiple filter values.

NO.28 A company has an operational dashboard that needs to display the latest data every 5 minutes on a monitor.
How should the analyst configure the dashboard?

Set the dashboard schedule to run every 5 minutes.

Set the dashboard auto refresh to 5 minutes.

Set the dashboard to run on load every 5 minutes.

Set the dashboard schedule to 5 minutes and “send if the results have changed”.

NO.29 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.30 An analyst needs to display data from two different sources together. There is a Look for each data source, but there is no shared field that can be combined. Both Looks are saved in the Shared folder.
How should the analyst display the data from both sources?

use Merged Results to combine the data sources.

Ask the LookML developer to build a new Explore.

Add both Looks to a dashboard

Pin both Looks to a board.

NO.31 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.32 An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions:
Ticket Purchase Month
Movie Name
Ticket Revenue
The analyst notices that the numbers look a lot smaller than expected and the results are difficult to understand.
What should the analyst do to make the Explore query show the desired metric?

Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

Add the Sum Revenue measure to the query.

Add a table calculation that sums the Ticket Revenue dimension.

NO.33 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.34 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.35 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?

Right-click to hide unwanted rows.

Limit displayed rows.

Use a custom filter.

Hide rows with table calculations.

NO.36 A business analyst is using the Totals check box in an Explore to get the sum of a column of values. The number that appears in the Total row is much higher than the analyst expects, and this number is not the sum of the values in the column.
What is a possible cause of this discrepancy?

There is a row limit applied.

There is a filter on a dimension.

There is a problem with the underlying LookML.

There is a column limit applied.

NO.37 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

NO.38 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

Loading …