Looker-Business-Analyst Google Looker Business AnalystExam exact Exam Questions

Looker Business AnalystExam

Last Update 19 hours ago Total Questions : 40

The Looker Business AnalystExam content is now fully updated, with all current exam questions added 19 hours ago. Deciding to include Looker-Business-Analyst practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our Looker-Business-Analyst exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these Looker-Business-Analyst sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Looker Business AnalystExam practice test comfortably within the allotted time.

Question # 1

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?

Change the returned orders series to a line type.

Move the returned orders series to a new right axis.

Change the y-axis height to a higher number of pixels.

Set the x-axis to use a log scale.

Question # 2

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?

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

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

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

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.

Question # 3

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?

Run the Explore again to make sure the results are the same.

Click on the Count measure where it is low to drill in to it.

Click on the Room Type dimension where it is King to drill in to it.

Remove the pivot on the Room Type dimension and re-run the Explore.

Question # 4

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.

Question # 5

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?

The filter values of both filters will combine in an additive manner and both filters will apply.

The individual tile’s filter will override the global dashboard filter.

The global dashboard filter will override the individual tile filter.

The dashboard will break and warn the user that there are conflicting filter values

Question # 6

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.

Question # 7

Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters.

How should the analyst filter the query?

Created Month “is in the first 2 quarters”

Created Month “is in the past 2 complete quarters”

Created Month “is in the past 2 quarters”

Created Month “is in the last 6 months”

Question # 8

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?

Select the dimension Created Month, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

Question # 9

An analyst wants to schedule a dashboard in a way that makes it easier for viewing on a mobile device or for viewing a printout of the dashboard.

How can the analyst set up a schedule to accomplish this?

Check Use single column layout in the Advanced options section of the scheduler.

Check Expand tables in the Advanced options section of the scheduler.

Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.

Select Run schedule as recipient in the Advanced options section of the scheduler, and edit the recipient’s user attribute preferences to be individual_images.

Question # 10

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?

Request that the admin user download this Look and share the file.

Change the table calculation to use an offset() function.

Contact the developer to create the percentage as a measure.

Apply a custom limit to the download.