CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Google
  5. LOOKER-BUSINESS-ANALYST

Free LOOKER-BUSINESS-ANALYST Exam Braindumps (page: 4)

Page 3 of 11
PDF with 40 Questions

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?

  1. The filter values of both filters will combine in an additive manner and both filters will apply.
  2. The individual tile's filter will override the global dashboard filter.
  3. The global dashboard filter will override the individual tile filter.
  4. The dashboard will break and warn the user that there are conflicting filter values

Answer(s): C



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?

  1. Run the Explore again to make sure the results are the same.
  2. Click on the Count measure where it is low to drill in to it.
  3. Click on the Room Type dimension where it is King to drill in to it.
  4. Remove the pivot on the Room Type dimension and re-run the Explore.

Answer(s): B



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?

  1. Display row totals for each category.
  2. Series type customization on budgeted spend.
  3. Grouped series positioning on budgeted spend.
  4. Transpose table to separate out budgeted spend.

Answer(s): D



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. Sort the data by Count of Items Sold descending and apply a row limit of 50.
  2. Sort the data by Brand Name alphabetically and apply a row limit of 50.
  3. Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.
  4. 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.

Answer(s): C


Reference:

https://community.looker.com/dashboards-looks-7/top-5-and-other-10743






Post your Comments and Discuss Google LOOKER-BUSINESS-ANALYST exam with other Community members:

LOOKER-BUSINESS-ANALYST Discussions & Posts