ExamGecko
Login
Home / Google / Looker Business Analyst / List of questions
Ask Question

Google Looker Business Analyst Practice Test - Questions Answers, Page 3

Add to Whishlist

List of questions

Question 21

Report Export Collapse

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
Remove the Number of Museums measure from the Explore
Select the Static Map visualization instead of Interactive
Select the Static Map visualization instead of Interactive
Contact the LookML Developer
Contact the LookML Developer
Add a table calculation that evaluates location (${cities.city_name})
Add a table calculation that evaluates location (${cities.city_name})
Suggested answer: D
asked 18/09/2024
Christina Lanaski
43 questions

Question 22

Report Export Collapse

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 previous week
Number of bananas cleared for consumption the week before thatWhich process should the analyst follow to show these two metrics in a report?
Number of bananas cleared for consumption the week before thatWhich 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 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 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 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.
Create two identical looks in the same folder. Add filters on them for "last week" and "2 weeks ago" respectively.
Suggested answer: C
asked 18/09/2024
Manuel Ortega
48 questions

Question 23

Report Export Collapse

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
7 days from now
After Today's Date for 7 days
After Today's Date for 7 days
Today for 7 days
Today for 7 days
For 7 days
For 7 days
Suggested answer: B
asked 18/09/2024
Francisco Sanchez Valdes
44 questions

Question 24

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 25

Report Export Collapse

Two users report seeing different results on the same dashboard.

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

Become a Premium Member for full access
  Unlock Premium Member

Question 26

Report Export Collapse

The query below shows how many uses purchased an item from each of two clothing departments.

Google Looker Business Analyst image Question 26 28247 09182024191235000000

Why are the total and sum of the rows unequal?

Become a Premium Member for full access
  Unlock Premium Member

Question 27

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 28

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 29

Report Export Collapse

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

Google Looker Business Analyst image Question 29 28250 09182024191235000000

How should the analyst, in addition to selecting the measure Total Sales build the report?

Become a Premium Member for full access
  Unlock Premium Member

Question 30

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member
Total 40 questions
Go to page: of 4
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
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?
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?
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?
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.)
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?
An analyst needs to send a daily PDF to three different stores and wants it to contain five visualizations of KPI data. 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?
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?
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?
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?