Google LOOKER-BUSINESS-ANALYST Online Practice Questions and Exam Preparation

Google LOOKER-BUSINESS-ANALYST Online Questions & Answers

• Question 1:

  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.
  A. Add a trend line for 30000.

• Question 2:

  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?

  A. There is a row limit applied.
  B. There is a filter on a dimension.
  C. There is a problem with the underlying LookML.
  D. There is a column limit applied.
  D. There is a column limit applied.

• Question 3:

  An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions: Ticket Purchase Month

  Movie Name

  Ticket Revenue

  The analyst notices that the numbers look a lot smaller than expected and the results are difficult to understand.

  What should the analyst do to make the Explore query show the desired metric?

  A. Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
  B. Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
  C. Add the Sum Revenue measure to the query.
  D. Add a table calculation that sums the Ticket Revenue dimension.
  C. Add the Sum Revenue measure to the query.

• Question 4:

  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?

  A. Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago
  B. Sales Closing Date "matches advanced" "12 months ago for 3 months"
  C. Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago
  D. Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"
  A. Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago

• Question 5:

  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?

  A. Filter the dashboard for the advanced value "yesterday", and create a new schedule.
  B. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.
  C. Create a new schedule and modify the filter's default value to the previous day's date.
  D. Create a new schedule and modify the schedule filter to be the advanced value "yesterday".
  B. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.

• Question 6:

  An analyst needs to analyze the ecommerce quarter-over-quarter order growth. Two fields are given: Order Created Quarter and Order Count. Which table calculation function should the analyst use to calculate the quarter-over-quarter order growth?

  A. pivot_offset()
  B. lookup()
  C. offset_list()
  D. offset()
  D. offset()

• Question 7:

  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?

  A. The filter values of both filters will combine in an additive manner and both filters will apply.
  B. The individual tile's filter will override the global dashboard filter.
  C. The global dashboard filter will override the individual tile filter.
  D. The dashboard will break and warn the user that there are conflicting filter values.
  C. The global dashboard filter will override the individual tile filter.

• Question 8:

  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.
  B. Schedule the dashboard with the PDF format Use single column layout.

• Question 9:

  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, Edit Sales analyst: Edit Sales group: View
  B. Admins: View Sales analyst: Edit Sales group: View
  C. Admins: View Sales analyst: Manage Access, Edit Sales group: View
  D. Admins: Manage Access, Edit Sales analyst: Manage Access, Edit Sales group: View
  A. Admins: Manage Access, Edit Sales analyst: Edit Sales group: View

• Question 10:

  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}
  A. Add a Sum measure to the Explore and re-run the query.