Online Access Free Looker-Business-Analyst Practice Test

An analyst for a movie producer is making an Explore query to show total box office revenue by movie. The initial query has three dimensions:
Ticket Purchase Month
Movie Name
Ticket Revenue
The analyst notices that the numbers look a lot smaller than expected and the results are difficult to understand.
What should the analyst do to make the Explore query show the desired metric?

• A.Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
• B.Add the Sum Revenue measure to the query.
• C.Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
• D.Add a table calculation that sums the Ticket Revenue dimension.

Two weeks into the third quarter, an analyst needs to determine the total order count per month for only the first two quarters.
How should the analyst filter the query?

• A.Created Month "is in the past 2 complete quarters"
• B.Created Month "is in the last 6 months"
• C.Created Month "is in the first 2 quarters"
• D.Created Month "is in the past 2 quarters"

An analyst needs to filter the sum of the sales between 12 complete months ago to the last 9 complete months ago.
How can the analyst create this filter condition?

• A.Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago
• B.Sales Closing Date "matches advanced" "12 months ago for 3 months"
• C.Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago
• D.Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"

The sales team has all its Looker content stored in a folder called Sales. Team members are complaining that the Looks and dashboards have been getting moved and edited in unwanted ways. Only the sales analyst should be editing the content in the Sales folder.
Which access settings should be applied to the folder?

• A.Admins: View
  Sales analyst: Manage Access, Edit
  Sales group: View
• B.Admins: Manage Access, Edit
  Sales analyst: Edit
  Sales group: View
• C.Admins: View
  Sales analyst: Edit
  Sales group: View
• D.Admins: Manage Access, Edit
  Sales analyst: Manage Access, Edit
  Sales group: View

An analyst wants to schedule a dashboard in a way that makes it easier for viewing on a mobile device or for viewing a printout of the dashboard.
How can the analyst set up a schedule to accomplish this?

• A.Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.
• B.Select Run schedule as recipient in the Advanced options section of the scheduler, and edit the recipient's user attribute preferences to be individual_images.
• C.Check Expand tables in the Advanced options section of the scheduler.
• D.Check Use single column layout in the Advanced options section of the scheduler.