Skip to main content

LOOKER-BUSINESS-ANALYST Real Exam Questions

Looker Business Analyst

40 questions available · Page 1 of 4

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

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?

  1. A

    There is a row limit applied.

  2. B

    There is a filter on a dimension.

  3. C

    There is a problem with the underlying LookML.

  4. D

    There is a column limit applied.

Show answer and explanation

Correct answer: D

Question 2 Single choice

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?

  1. A

    Change the returned orders series to a line type.

  2. B

    Move the returned orders series to a new right axis.

  3. C

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

  4. D

    Set the x-axis to use a log scale.

Show answer and explanation

Correct answer: C

Question 3 Single choice

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?

  1. A

    7 days from now

  2. B

    After Today's Date for 7 days

  3. C

    Today for 7 days

  4. D

    For 7 days

Show answer and explanation

Correct answer: B

Question 4 Single choice

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?

  1. A

    Three dashboards, one for each store

  2. B

    Three schedules filtered by store

  3. C

    Five schedules, one for each visualization

  4. D

    A dashboard with three filters, one for each store

Show answer and explanation

Correct answer: D

Question 5 Single choice

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.

What should the analyst do to meet this requirement?

  1. A

    Filter the dashboard for the advanced value "yesterday", and create a new schedule.

  2. B

    Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.

  3. C

    Create a new schedule and modify the filter's default value to the previous day's date.

  4. D

    Create a new schedule and modify the schedule filter to be the advanced value "yesterday".

Show answer and explanation

Correct answer: B

Question 6 Single choice

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?

  1. A

    use Merged Results to combine the data sources.

  2. B

    Ask the LookML developer to build a new Explore.

  3. C

    Add both Looks to a dashboard

  4. D

    Pin both Looks to a board.

Show answer and explanation

Correct answer: C

Question 7 Single choice

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?

  1. A

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

  2. B

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

  3. C

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

  4. D

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

Show answer and explanation

Correct answer: A

Question 8 Single choice

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?

  1. A

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

  2. B

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

  3. C

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

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

Show answer and explanation

Correct answer: C

Question 9 Single choice

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?

  1. A

    Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago

  2. B

    Sales Closing Date "matches advanced" "12 months ago for 3 months"

  3. C

    Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago

  4. D

    Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"

Show answer and explanation

Correct answer: A

Question 10 Single choice

A business analyst is filtering for this year's data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.

Where should the analyst go to make sure dates are filled in for the future?

  1. A

    X-axis settings

  2. B

    Column settings

  3. C

    Explore settings

  4. D

    Row settings

Show answer and explanation

Correct answer: C