Month End Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmaspas7

Easiest Solution 2 Pass Your Certification Exams

Looker-Business-Analyst Google Looker Business AnalystExam Free Practice Exam Questions (2025 Updated)

Prepare effectively for your Google Looker-Business-Analyst Looker Business AnalystExam certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.

Google Looker-Business-Analyst Premium Access     Download Demo    
Page: 1 / 1
Total 40 questions

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?

A.

Pivot the Explore by the Brand Name dimension.

B.

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.

C.

Pivot the Explore by brand Rank.

D.

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.

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?

A.

Give all users view access to the personal folder.

B.

Move the dashboard to a shared folder and provide access only to the users from the team.

C.

Give view access to the individual dashboards.

D.

Create a subfolder in the personal folder and given view access to the users from the team.

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.

B.

Edit embed settings.

C.

Apply a table theme.

D.

Edit HTML on the dashboard.

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?

A.

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

B.

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

C.

Add a custom measure of type: running_total

D.

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

An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard.

How should the analyst ensure that the PDF shows all available results in the UI dashboard?

A.

Select the Expand Tables option.

B.

Select the All Results option

C.

Select the Allow Scroll option and specify each table.

D.

Select the Paper Size option and specify a large size.

An analyst has an Explore query that shows the sum of spend over time. The Explore query has the Sum of Spend measure pivoted by a Category of Spend dimension. The Category of Spend dimension has a value for Budgeted Spend and then categories for each type of unbudgeted spend.

Which visualization feature should the analyst use to separate budgeted spend visually from each category of unbudgeted spend?

A.

Display row totals for each category.

B.

Series type customization on budgeted spend.

C.

Grouped series positioning on budgeted spend.

D.

Transpose table to separate out budgeted spend.

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.

B.

Ask the LookML developer to build a new Explore.

C.

Add both Looks to a dashboard

D.

Pin both Looks to a board.

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?

A.

Sort the data by Count of Items Sold descending and apply a row limit of 50.

B.

Sort the data by Brand Name alphabetically and apply a row limit of 50.

C.

Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

D.

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.

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.

B.

Schedule the dashboard with the PDF format Use single column layout.

C.

Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.

D.

Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.

An analyst works on the data team at an organization that maintains multiple similar Explores. The analyst has access to see every Explore, but knows that employees in the finance department only have access to explores tagged Finance.

There is an Employee Compensation Data Finance Explore that the finance department has access to. The analyst usually uses an All Employee Data Explore that also includes personally identifiable information.

What should the analyst do to ensure proper access if the analyst wants to send an example visualization to the finance team?

A.

Create Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.

B.

Use the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.

C.

Use the All Employee Data Explore, but use Looker’s built-in Send functionality to email the visualization.

D.

Use the All Employee Data Explore, add a filter to exclude personally identifiable information, and send the URL of the Explore to the finance team.

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

A.

The Row Limit chosen in the Look is too high.

B.

There is a table calculation in the Look.

C.

Unlimited results are unsupported by CSV format.

D.

The Row Totals option is turned on in the Look.

E.

There is a Running Total measure in the Look.

F.

The Totals option is turned on in the Look.

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.

B.

Add a Tick Density of 30000.

C.

Add a reference line for 30000.

D.

Add a table calculation to hide values less than 30000.

Google Looker-Business-Analyst Premium Access     Download Demo    
Page: 1 / 1
Total 40 questions
Copyright © 2014-2025 Solution2Pass. All Rights Reserved