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

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

Add to Whishlist

List of questions

Question 11

Report Export Collapse

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

Become a Premium Member for full access
  Unlock Premium Member

Question 12

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 13

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 14

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 15

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 16

Report Export Collapse

An analyst has created a dashboard that needs to be integrated into the company's internal support portal. The dashboard should match the style of the support portal.

How should the analyst display the dashboard in the style of the support portal without changing the style of the tiles in Looker?

Become a Premium Member for full access
  Unlock Premium Member

Question 17

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 18

Report Export Collapse

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?

Become a Premium Member for full access
  Unlock Premium Member

Question 19

Report Export Collapse

A CEO wants to receive a daily email with the existing executive dashboard to review on a mobile device on the way to the office.

What should the analyst do to optimize the dashboard for mobile viewing?

Become a Premium Member for full access
  Unlock Premium Member

Question 20

Report Export Collapse

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?

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?