Looker-Business-Analyst Looker Business AnalystExam Dumps

Sample Question 4

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.

Show Answer Buy Now

---

Sample Question 5

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 Countof Items Sold. The analyst then selects the pie chart visualization, but sees the error “TooMany 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 topbrands by items sold?

A. Sort the data by Count of Items Sold descending and apply a row limit of 50.
B. Sort the data by Brand Name alphabetically and apply a row limit of 50.
C. Apply a filter on the Count of Items Sold measure that requires the count to be greaterthan zero.
D. Apply a filter on the Count of Items Sold measure that requires the count to be notNULL, sort the data by Count of Items Sold ascending, and apply a row limit of 50.

Show Answer Buy Now

---

Sample Question 6

An analyst has created a dashboard that needs to be integrated into the company’s internalsupport portal. The dashboard should match the style of the support portal.How should the analyst display the dashboard in the style of the support portal withoutchanging the style of the tiles in Looker?

A. Copy the dashboard.
B. Edit embed settings.
C. Apply a table theme.
D. Edit HTML on the dashboard.

Show Answer Buy Now

---

Sample Question 7

An analyst works on the data team at an organization that maintains multiple similarExplores. The analyst has access to see every Explore, but knows that employees in thefinance department only have access to explores tagged Finance.There is an Employee Compensation Data Finance Explore that the finance departmenthas access to. The analyst usually uses an All Employee Data Explore that also includespersonally identifiable information.What should the analyst do to ensure proper access if the analyst wants to send anexample visualization to the finance team?

A. Create Merged Results with the Employee Compensation Data Finance Explore and theAll Employee Data Explore, and send the URL of the Merged Results.
B. Use the Employee Compensation Data Finance Explore and send the URL of theExplore to the finance team.
C. Use the All Employee Data Explore, but use Looker’s built-in Send functionality to emailthe visualization.
D. Use the All Employee Data Explore, add a filter to exclude personally identifiableinformation, and send the URL of the Explore to the finance team.

Show Answer Buy Now

---

Sample Question 8

An analyst for a movie producer is making an Explore query to show total box officerevenue by movie. The initial query has three dimensions:Ticket Purchase MonthMovie NameTicket RevenueThe analyst notices that the numbers look a lot smaller than expected and the results aredifficult 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. Addthe Sum Revenue measure.
B. Remove the Ticket Revenue dimension from the query. Add the Sum Revenuemeasure.
C. Add the Sum Revenue measure to the query.
D. Add a table calculation that sums the Ticket Revenue dimension.

Show Answer Buy Now

---

Sample Question 9

An analyst needs to send a Look to an external client in CSV format. When the data isbeing downloaded, the Limit section has the option to select All Results grayed out, withtext 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.

Show Answer Buy Now

---