Free Google Looker-Business-Analyst Exam Dumps Questions & Answers

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.Dashboard filters are being used
• C.Looker caching is affecting results.
• D.The dashboard was accessed via different boards.
• E.The dashboard uses separate Explores for each user.

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 with PDF paper size set to Fit Page to Dashboard.
• B.Schedule the dashboard as HTML to adjust automatically.
• C.Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
• D.Schedule the dashboard with the PDF format Use single column layout.

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?

• A.Transpose table to separate out budgeted spend.
• B.Series type customization on budgeted spend.
• C.Display row totals for each category.
• D.Grouped series positioning on budgeted spend.

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.Click on the Room Type dimension where it is King to drill in to it.
• B.Click on the Count measure where it is low to drill in to it.
• C.Run the Explore again to make sure the results are the same.
• D.Remove the pivot on the Room Type dimension and re-run the Explore.

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.Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.
• B.After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.
• C.After selecting Edit on the tile, add a filter on Created Date and hit Save.
• D.Edit the dashboard Created Date filter to update the tile's Created Time field under Tiles to Update.