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?
A. Request that the admin user download this Look and share the file.
B. Change the table calculation to use an offset() function.
C. Contact the developer to create the percentage as a measure.
D. Apply a custom limit to the download.
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"
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?
A. use Merged Results to combine the data sources.
B. Ask the LookML developer to build a new Explore.
C. Add both Looks to a dashboard
D. Pin both Looks to a board.
An analyst has created a line chart with Value Labels enabled, but the values are too long and need to be abbreviated.
Which visualization option should the analyst utilize to alter the display of the value labels?
A. Axis Value Labels
B. Value Format
C. Label Rotation
D. Time Label Format
A business analyst is building a report of predicted sales. The business analyst wants to filter the results to only show dates in the next seven days. This filter should work whenever the results are generated.
Which filter expression should the business analyst use?
A. 7 days from now
B. After Today's Date for 7 days
C. Today for 7 days
D. For 7 days
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:
1.
Number of bananas cleared for consumption the previous week
2.
Number of bananas cleared for consumption the week before that Which process should the analyst follow to show these two metrics in a report?
A. Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile ("last week" and "2 weeks ago" respectively)
B. Create one tile on a dashboard and two dashboard filters ("last week" and "2 weeks ago" respectively). Apply both dashboard filters to the tile.
C. 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.
D. Create two identical looks in the same folder. Add filters on them for "last week" and "2 weeks ago" respectively.
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?
A. Schedule the dashboard as HTML to adjust automatically.
B. Schedule the dashboard with the PDF format Use single column layout.
C. Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
D. Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.
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?
A. Add a Sum measure to the Explore and re-run the query.
B. Add a table calculation that calls running_portal (${users.signup_count})
C. Add a custom measure of type: running_total
D. Add a table calculation that calls ${users.signup_count:total}
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. There is a filter limiting the count in the Total row.
B. There is a faulty logic in the way users relate to clothing departments.
C. A user is only counted once in the total even if the user has purchased from both departments.
D. There are users who have never purchased a clothing item from either department.
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?
A. Create Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.
B. Use the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.
C. Use the All Employee Data Explore, but use Looker's built-in Send functionality to email the visualization.
D. 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.
