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

Google LOOKER-BUSINESS-ANALYST Online Questions & Answers

• Question 31:

  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.
  C. Add both Looks to a dashboard

• Question 32:

  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?

  A. After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.
  B. After selecting Edit on the tile, add a filter on Created Date and hit Save.
  C. Edit the dashboard Created Date filter to update the tile's Created Time field under Tiles to Update.
  D. Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.
  D. Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.

• Question 33:

  The query below shows how many uses purchased an item from each of two clothing departments.

  

  Why are the total and sum of the rows unequal?

  A. There is a filter limiting the count in the Total row.
  B. There is a faulty logic in the way users relate to clothing departments.
  C. A user is only counted once in the total even if the user has purchased from both departments.
  D. There are users who have never purchased a clothing item from either department.
  C. A user is only counted once in the total even if the user has purchased from both departments.

• Question 34:

  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.
  B. Enable the setting Limit one filter value.
  C. Use the Matches Advanced filtering option.
  D. Disable the setting Allow multiple filter values.
  D. Disable the setting Allow multiple filter values.

• Question 35:

  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?

  A. Select the dimension Created Month, and pivot on the dimension Created Year.
  B. Select the dimension Created Year, and pivot on the dimension Created Month.
  C. Select the dimension Created Month Name, and pivot on the dimension Created Year.
  D. Select the dimension Created Year, and pivot on the dimension Created Month Name.
  A. Select the dimension Created Month, and pivot on the dimension Created Year.

• Question 36:

  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?

  A. Run the Explore again to make sure the results are the same.
  B. Click on the Count measure where it is low to drill in to it.
  C. Click on the Room Type dimension where it is King to drill in to it.
  D. Remove the pivot on the Room Type dimension and re-run the Explore.
  B. Click on the Count measure where it is low to drill in to it.

• Question 37:

  Two users report seeing different results on the same dashboard.

  Which three configurations could explain these discrepancies? (Choose three.)

  A. The time zone setting is different for each user.
  B. Looker caching is affecting results.
  C. The dashboard uses separate Explores for each user.
  D. Dashboard filters are being used
  E. The dashboard was accessed via different boards.
  C. The dashboard uses separate Explores for each user.
  D. Dashboard filters are being used
  E. The dashboard was accessed via different boards.

• Question 38:

  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?

  A. 7 days from now
  B. After Today's Date for 7 days
  C. Today for 7 days
  D. For 7 days
  B. After Today's Date for 7 days

• Question 39:

  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.
  A. The Row Limit chosen in the Look is too high.
  B. There is a table calculation in the Look.
  D. The Row Totals option is turned on in the Look.

• Question 40:

  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?

  A. Three dashboards, one for each store
  B. Three schedules filtered by store
  C. Five schedules, one for each visualization
  D. A dashboard with three filters, one for each store
  D. A dashboard with three filters, one for each store