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

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 works on the data team at an organization that maintains multiple similar Explores. The analyst has access to see every Explore, but knows that employees in the finance department only have access to explores tagged Finance.There is an Employee Compensation Data Finance Explore that the finance department has access to. The analyst usually uses an All Employee Data Explore that also includes personally identifiable information.What should the analyst do to ensure proper access if the analyst wants to send an example visualization to the finance team?

• Create Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.
  
• Use the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.
  
• Use the All Employee Data Explore, but use Looker's built-in Send functionality to email the visualization.
  
• Use the All Employee Data Explore, add a filter to exclude personally identifiable information, and send the URL of the Explore to the finance team.
  

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?

• Three dashboards, one for each store
  
• Three schedules filtered by store
  
• Five schedules, one for each visualization
  
• A dashboard with three filters, one for each store
  

An analyst creates a dashboard that shows sales at an aggregate and then an individual level. This dashboard is slow to run, and the analyst sees a warning about how load times may be impacted in dashboards with more than 25 tiles.What should the analyst create to make sure all data sources in this dashboard are connected but still load quickly?

• Dashboard filter to specify which individual data shows
  
• Two dashboards, one with aggregate and one with individual data
  
• Two dashboards with a text tile to hyperlink from one dashboard to the other
  
• Folder with all dashboard tiles for aggregate data and individual data.
  

An analyst creates a column chart showing the count of total orders and the count of returned orders on each date. The number of returned orders is much smaller than the number of total orders, so the columns for the returned orders are short and it is difficult to compare all the columns visually.How should the analyst ensure that the differences between returned order counts for each day are more visible?

• Change the returned orders series to a line type.
  
• Move the returned orders series to a new right axis.
  
• Change the y-axis height to a higher number of pixels.
  
• Set the x-axis to use a log scale.
  

A business analyst is using the Totals check box in an Explore to get the sum of a column of values. The number that appears in the Total row is much higher than the analyst expects, and this number is not the sum of the values in the column.What is a possible cause of this discrepancy?

• There is a row limit applied.
  
• There is a filter on a dimension.
  
• There is a problem with the underlying LookML.
  
• There is a column limit applied.
  

An analyst needs to display data from two different sources together. There is a Look for each data source, but there is no shared field that can be combined. Both Looks are saved in the Shared folder.How should the analyst display the data from both sources?

• use Merged Results to combine the data sources.
  
• Ask the LookML developer to build a new Explore.
  
• Add both Looks to a dashboard
  
• Pin both Looks to a board.
  

An executive needs to receive a dashboard every morning with data for the previous day only. The dashboard currently has a date filter defined. The executive must receive only the data requested, and the dashboard data needs to remain unchanged for all other users.What should the analyst do to meet this requirement?

• Filter the dashboard for the advanced value ''yesterday'', and create a new schedule.
  
• Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.
  
• Create a new schedule and modify the filter's default value to the previous day's date.
  
• Create a new schedule and modify the schedule filter to be the advanced value ''yesterday''.
  

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 has a dashboard with a single filter on Created Date ''is in the past year'', but a tile on the dashboard is returning results for only the past 7 days. When the analyst selects ''Explore from Here'' on the tile, there are filters on both Created Date ''is in the past year'' and Created Time ''is in the past 7 days''.How should the analyst make sure that only the filter set on the dashboard is applied to the tile?

• After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.
  
• After selecting Edit on the tile, add a filter on Created Date and hit Save.
  
• Edit the dashboard Created Date filter to update the tile's Created Time field under Tiles to Update.
  
• Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.