Get Google Looker-Business-Analyst Exam Practice Questions - Real and Updated

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?

An analyst needs to send a daily PDF to three different stores and wants it to contain five visualizations of KPI dat

a. 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 business analyst is filtering for this year's data in an Explore. There is a requirement to show future dates for this year in the visualization, even though those dates do not yet have associated data.

Where should the analyst go to make sure dates are filled in for the future?

An analyst is trying to rank companies in an Explore and visualize the rank as a column chart. The analyst selects the Brand Name dimension and the Rank dimension. They then select the column chart visualization type, but receive the error ''Measure, time or numeric field required: Column graphs require at least one dimension or for the first dimension field to be of type: number or type: time''.

How can the analyst resolve this error while showing the rank as a column visualization?

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?