Free Looker Business Analyst Exam Looker-Business-Analyst Exam Practice Test

A global dashboard filter and the filter on a tile within that dashboard conflict because the global dashboard filter and the individual tile filter are based on the same field with different filter values.What happens in this situation?

• The filter values of both filters will combine in an additive manner and both filters will apply.
  
• The individual tile's filter will override the global dashboard filter.
  
• The global dashboard filter will override the individual tile filter.
  
• The dashboard will break and warn the user that there are conflicting filter values
  

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?

• Created Month ''is in the first 2 quarters''
  
• Created Month ''is in the past 2 complete quarters''
  
• Created Month ''is in the past 2 quarters''
  
• Created Month ''is in the last 6 months''
  

An analyst has a dashboard with table visualizations that display the first few results, and the user can scroll down to see the remaining results. The analyst wants to download a PDF of the dashboard.How should the analyst ensure that the PDF shows all available results in the UI dashboard?

• Select the Expand Tables option.
  
• Select the All Results option
  
• Select the Allow Scroll option and specify each table.
  
• Select the Paper Size option and specify a large size.
  

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?

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

An analyst is building out a company KPI dashboard and creates a blank dashboard. The analyst can either create a new tile or use an existing Look.What are two use cases for using Look-linked tile instead of building a query tile? (Choose two.)

• The analyst wants to use the Look-linked tile in a separate company performance dashboard.
  
• The analyst plans on creating a scheduled report of the associated Look.
  
• The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
  
• The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
  

An analyst at a banana quality assurance firm needs to compare performance week over week to make sure the firm stays on track. The analyst needs to show two metrics:Number of bananas cleared for consumption the previous weekNumber of bananas cleared for consumption the week before thatWhich process should the analyst follow to show these two metrics in a report?

• Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile (''last week'' and ''2 weeks ago'' respectively)
  
• Create one tile on a dashboard and two dashboard filters (''last week'' and ''2 weeks ago'' respectively). Apply both dashboard filters to the tile.
  
• Create two tiles on a dashboard. In the Edit mode of one tile, add a filter for ''last week''. Add a dashboard filter for ''2weeks ago'' and apply it to the other tile.
  
• Create two identical looks in the same folder. Add filters on them for ''last week'' and ''2 weeks ago'' respectively.
  

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?

• X-axis settings
  
• Column settings
  
• Explore settings
  
• Row settings
  

An analyst has created a dashboard that needs to be integrated into the company's internal support 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 without changing the style of the tiles in Looker?

• Copy the dashboard.
  
• Edit embed settings.
  
• Apply a table theme.
  
• Edit HTML on the dashboard.
  

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?

• pivot_offset()
  
• lookup()
  
• offset_list()
  
• offset()
  

Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.What should the analyst do to improve the navigation experience?

• Pin the dashboards into boards and grant user access to the individual dashboards.
  
• Add descriptions to the dashboards to give more details.
  
• Sort the dashboards in the folder by name.
  
• Show the dashboards in a grid style for displaying the snapshot.