An analyst needs to send a Look to an external client in CSV format. When the data is being downloaded, the Limit section has the option to select All Results grayed out, with text reading "All Results Unavailable." What are three causes of this message? (Choose three.)

The Row Limit chosen in the Look is too high.

There is a table calculation in the Look.

The Row Totals option is turned on in the Look.

The Row Limit chosen in the Look is too high.

There is a table calculation in the Look.

Unlimited results are unsupported by CSV format.

The Row Totals option is turned on in the Look.

There is a Running Total measure in the Look.

The Totals option is turned on in the Look.

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?

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}

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?

Check Use single column layout in the Advanced options section of the scheduler.

Check Expand tables in the Advanced options section of the scheduler.

Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.

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.

A business analyst is creating an Explore that shows the number of hotel rooms booked per week, by room type. The analyst is using a Week dimension and a Count measure, and is provisioning on a Room Type dimension. Looking at the results, the Count of King rooms seems unusually low one week.What should the analyst do to further investigate the low numbers?

Click on the Count measure where it is low to drill in to it.

Run the Explore again to make sure the results are the same.

Click on the Count measure where it is low to drill in to it.

Click on the Room Type dimension where it is King to drill in to it.

Remove the pivot on the Room Type dimension and re-run the Explore.

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?

Select a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

Pivot the Explore by the Brand Name dimension.

Select a measure to include in the Explore, then create a table calculation that multiplies the dimension by 1.0 using the syntax ${dimension}*1.0. Then hide the measure from the Explore.

Pivot the Explore by brand Rank.

Select a measure to include in the Explore, then create a table calculation that adds the Rank dimension to the measure multiplied by zero using the syntax ${dimension} + (${measure}*0). Then hide the measure from the Explore.

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?

A dashboard with three filters, one for each store

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 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 Allow Scroll option and specify each table.

Select the Paper Size option and specify a large size.

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?

Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.

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 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 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.

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?

Sort the dashboards in the folder by name.

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.

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?

Add a reference line for 30000.

Add a table calculation to hide values less than 30000.

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?

Admins: Manage Access, EditSales analyst: EditSales group: View

Admins: ViewSales analyst: EditSales group: View

Admins: ViewSales analyst: Manage Access, EditSales group: View

Admins: Manage Access, Edit Sales analyst: Manage Access, EditSales group: View

A company has an operational dashboard that needs to display the latest data every 5 minutes on a monitor.How should the analyst configure the dashboard?

Set the dashboard schedule to run every 5 minutes.

Set the dashboard auto refresh to 5 minutes.

Set the dashboard to run on load every 5 minutes.

Set the dashboard schedule to 5 minutes and "send if the results have changed".

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?

Disable the setting Allow multiple filter values.

Change the filter type to string.

Enable the setting Limit one filter value.

Use the Matches Advanced filtering option.

Disable the setting Allow multiple filter values.

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.

A CEO wants to receive a daily email with the existing executive dashboard to review on a mobile device on the way to the office.What should the analyst do to optimize the dashboard for mobile viewing?

Schedule the dashboard with the PDF format Use single column layout.

Schedule the dashboard as HTML to adjust automatically.

Schedule the dashboard with the PDF format Use single column layout.

Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.

Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.

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 y-axis height to a higher number of pixels.

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.

An analyst is creating a map that colors cities by their population. After adding fields and selecting the Interactive Map visualization, the analyst receives this error message:"At least one dimension should be of type Location or have a map_layer specified".There are currently three fields in the Explore:City Name (Dimension)Population (Measure)Number of Museums (Measure)What should the analyst do to resolve this error?

Add a table calculation that evaluates location (${cities.city_name})

Remove the Number of Museums measure from the Explore

Select the Static Map visualization instead of Interactive

Add a table calculation that evaluates location (${cities.city_name})

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:

Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile ("last week" and "2 weeks ago" respectively)

Number of bananas cleared for consumption the previous week

Number 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 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 column limit applied.

There is a filter on a dimension.

There is a problem with the underlying LookML.

There is a column limit applied.

Two users report seeing different results on the same dashboard.Which three configurations could explain these discrepancies? (Choose three.)

The dashboard uses separate Explores for each user.

Dashboard filters are being used

The dashboard was accessed via different boards.

The time zone setting is different for each user.

Looker caching is affecting results.

The dashboard uses separate Explores for each user.

Dashboard filters are being used

The dashboard was accessed via different boards.

The query below shows how many uses purchased an item from each of two clothing departments. Why are the total and sum of the rows unequal?

A user is only counted once in the total even if the user has purchased from both departments.

There is a filter limiting the count in the Total row.

There is a faulty logic in the way users relate to clothing departments.

A user is only counted once in the total even if the user has purchased from both departments.

There are users who have never purchased a clothing item from either department.

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 global dashboard filter will override the individual tile filter.

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.

An analyst is trying to create a pie chart showing the breakdown of the top sales by brand in an Explore. The analyst selects the Brand Name dimension and a measure for the Count of Items Sold. The analyst then selects the pie chart visualization, but sees the error "Too Many Rows: Pie charts can display a maximum of 50 rows of data." How can the analyst resolve this error and create a pie chart that will always show the top brands by items sold?

Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

Sort the data by Count of Items Sold descending and apply a row limit of 50.

Sort the data by Brand Name alphabetically and apply a row limit of 50.

Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.

Apply a filter on the Count of Items Sold measure that requires the count to be not NULL, sort the data by Count of Items Sold ascending, and apply a row limit of 50.

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit. How should the analyst, in addition to selecting the measure Total Sales build the report?

Select the dimension Created Month, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

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?

Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.

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.

An analyst needs to select all users in the query results but only wants to visualize results for users that have more than 100 orders.Which visualization option should the analyst utilize?

Right-click to hide unwanted rows.

Hide rows with table calculations.

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?

Custom filter "is in the past" 12 months AND "is before" "relative" 9 months ago

Sales Closing Date "matches advanced" "12 months ago for 3 months"

Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago

Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"

An analyst creates a table visualization. There is one dimension, a few count type measures, and a percentage table calculation. When the analyst tries to download all 200,000 rows of results in CSV, the option is unavailable. The analyst has been provided permission to download all results.Which action should the analyst take to download all results?

Apply a custom limit to the download.

Request that the admin user download this Look and share the file.

Change the table calculation to use an offset() function.

Contact the developer to create the percentage as a measure.

Apply a custom limit to the download.

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 MonthMovie NameTicket RevenueThe 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?

Add the Sum Revenue measure to the query.

Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.

Add the Sum Revenue measure to the query.

Add a table calculation that sums the Ticket Revenue dimension.

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 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 taggedFinance.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?

Use the Employee Compensation Data Finance Explore and send the URL of the Explore 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 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?

Transpose table to separate out budgeted 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 pins a dashboard from a personal folder to the team board. Other colleagues report that they cannot access the dashboard. There are a few dashboards in the personal folder that are not ready to share yet.What should the analyst do to enable the team's access?

Create a subfolder in the personal folder and given view access to the users from the team.

Give all users view access to the personal folder.

Move the dashboard to a shared folder and provide access only to the users from the team.

Give view access to the individual dashboards.

Create a subfolder in the personal folder and given view access to the users from the team.

Google Looker Business Analyst Practice Test 1 - Free Online Exam Questions 1-40

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"

Comment (0)

Google Looker Business Analyst Practice Test 1

Question

Google Looker Business Analyst Practice Tests

Practice Tests