ExamGecko
Home Home / Google / Looker Business Analyst

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

Question list
Search
Search

List of questions

Search

Related questions











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

A.
The analyst wants to use the Look-linked tile in a separate company performance dashboard.
A.
The analyst wants to use the Look-linked tile in a separate company performance dashboard.
Answers
B.
The analyst plans on creating a scheduled report of the associated Look.
B.
The analyst plans on creating a scheduled report of the associated Look.
Answers
C.
The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
C.
The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
Answers
D.
The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
D.
The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
Answers
Suggested answer: A, B

Explanation:

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

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?

A.
Pin the dashboards into boards and grant user access to the individual dashboards.
A.
Pin the dashboards into boards and grant user access to the individual dashboards.
Answers
B.
Add descriptions to the dashboards to give more details.
B.
Add descriptions to the dashboards to give more details.
Answers
C.
Sort the dashboards in the folder by name.
C.
Sort the dashboards in the folder by name.
Answers
D.
Show the dashboards in a grid style for displaying the snapshot.
D.
Show the dashboards in a grid style for displaying the snapshot.
Answers
Suggested answer: C

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?

A.
Add a trend line for 30000.
A.
Add a trend line for 30000.
Answers
B.
Add a Tick Density of 30000.
B.
Add a Tick Density of 30000.
Answers
C.
Add a reference line for 30000.
C.
Add a reference line for 30000.
Answers
D.
Add a table calculation to hide values less than 30000.
D.
Add a table calculation to hide values less than 30000.
Answers
Suggested answer: A

Explanation:

Reference: https://docs.looker.com/exploring-data/visualizing-query-results/line-options

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?

A.
Admins: Manage Access, EditSales analyst: EditSales group: View
A.
Admins: Manage Access, EditSales analyst: EditSales group: View
Answers
B.
Admins: ViewSales analyst: EditSales group: View
B.
Admins: ViewSales analyst: EditSales group: View
Answers
C.
Admins: ViewSales analyst: Manage Access, EditSales group: View
C.
Admins: ViewSales analyst: Manage Access, EditSales group: View
Answers
D.
Admins: Manage Access, Edit Sales analyst: Manage Access, EditSales group: View
D.
Admins: Manage Access, Edit Sales analyst: Manage Access, EditSales group: View
Answers
Suggested answer: A

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?

A.
Set the dashboard schedule to run every 5 minutes.
A.
Set the dashboard schedule to run every 5 minutes.
Answers
B.
Set the dashboard auto refresh to 5 minutes.
B.
Set the dashboard auto refresh to 5 minutes.
Answers
C.
Set the dashboard to run on load every 5 minutes.
C.
Set the dashboard to run on load every 5 minutes.
Answers
D.
Set the dashboard schedule to 5 minutes and "send if the results have changed".
D.
Set the dashboard schedule to 5 minutes and "send if the results have changed".
Answers
Suggested answer: A

Explanation:

Reference: https://help.singlecomm.com/hc/en-us/articles/115010227127-Standard-Dashboards

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?

A.
Copy the dashboard.
A.
Copy the dashboard.
Answers
B.
Edit embed settings.
B.
Edit embed settings.
Answers
C.
Apply a table theme.
C.
Apply a table theme.
Answers
D.
Edit HTML on the dashboard.
D.
Edit HTML on the dashboard.
Answers
Suggested answer: B

Explanation:

Reference: https://looker.com/platform/blocks/embedded/embed-a-dashboard

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?

A.
Change the filter type to string.
A.
Change the filter type to string.
Answers
B.
Enable the setting Limit one filter value.
B.
Enable the setting Limit one filter value.
Answers
C.
Use the Matches Advanced filtering option.
C.
Use the Matches Advanced filtering option.
Answers
D.
Disable the setting Allow multiple filter values.
D.
Disable the setting Allow multiple filter values.
Answers
Suggested answer: D

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?

A.
use Merged Results to combine the data sources.
A.
use Merged Results to combine the data sources.
Answers
B.
Ask the LookML developer to build a new Explore.
B.
Ask the LookML developer to build a new Explore.
Answers
C.
Add both Looks to a dashboard
C.
Add both Looks to a dashboard
Answers
D.
Pin both Looks to a board.
D.
Pin both Looks to a board.
Answers
Suggested answer: C

Explanation:

Reference: https://docs.looker.com/exploring-data/saving-and-editing-looks

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?

A.
Schedule the dashboard as HTML to adjust automatically.
A.
Schedule the dashboard as HTML to adjust automatically.
Answers
B.
Schedule the dashboard with the PDF format Use single column layout.
B.
Schedule the dashboard with the PDF format Use single column layout.
Answers
C.
Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
C.
Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
Answers
D.
Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.
D.
Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.
Answers
Suggested answer: B

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?

A.
Change the returned orders series to a line type.
A.
Change the returned orders series to a line type.
Answers
B.
Move the returned orders series to a new right axis.
B.
Move the returned orders series to a new right axis.
Answers
C.
Change the y-axis height to a higher number of pixels.
C.
Change the y-axis height to a higher number of pixels.
Answers
D.
Set the x-axis to use a log scale.
D.
Set the x-axis to use a log scale.
Answers
Suggested answer: C
Total 40 questions
Go to page: of 4