Looker-Business-Analyst Looker Business Analyst Exam Questions and Answers

Questions 4

An analyst adds a Day dimension and a Signup Count measure to an Explore to show the number of new users added per day. The analyst wants to add a metric that increases by the number of new users per day, on a rolling basis.

How should that metric be calculated?

Options:

Add a Sum measure to the Explore and re-run the query.

Add a table calculation that calls running_portal (${users.signup_count})

Add a custom measure of type: running_total

Add a table calculation that calls ${users.signup_count:total}

Buy Now

Questions 5

The analyst is exploring weekly sales revenue in the last 3 months using a line chart. One requirement is to show the sales target $30,000 in the chart.

Which solution can help the analyst display the sales target?

Options:

Add a trend line for 30000.

Add a Tick Density of 30000.

Add a reference line for 30000.

Add a table calculation to hide values less than 30000.

Buy Now

Questions 6

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?