[Feb-2022] Free Looker-Business-Analyst Exam Dumps to Improve Exam Score
2022 Realistic Looker-Business-Analyst Dumps Exam Tips Test Pdf Exam Material
NEW QUESTION 11
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 faulty logic in the way users relate to clothing departments.
- B. There is a filter limiting the count in the Total row.
- 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.
Answer: C
NEW QUESTION 12
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.)
- A. The Row Limit chosen in the Look is too high.
- B. Unlimited results are unsupported by CSV format.
- C. The Totals option is turned on in the Look.
- D. There is a Running Total measure in the Look.
- E. The Row Totals option is turned on in the Look.
- F. There is a table calculation in the Look.
Answer: A,E,F
NEW QUESTION 13
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?
- A. Add a Tick Density of 30000.
- B. Add a table calculation to hide values less than 30000.
- C. Add a reference line for 30000.
- D. Add a trend line for 30000.
Answer: D
NEW QUESTION 14
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 All Employee Data Explore, add a filter to exclude personally identifiable information, 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 Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.
Answer: D
NEW QUESTION 15
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?
- A. Sort the data by Count of Items Sold descending and apply a row limit of 50.
- B. Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.
- C. Sort the data by Brand Name alphabetically and apply a row limit of 50.
- D. 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.
Answer: B
NEW QUESTION 16
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?
- A. Use a custom filter.
- B. Limit displayed rows.
- C. Hide rows with table calculations.
- D. Right-click to hide unwanted rows.
Answer: B
NEW QUESTION 17
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 table calculation that calls ${users.signup_count:total}
- B. Add a custom measure of type: running_total
- C. Add a Sum measure to the Explore and re-run the query.
- D. Add a table calculation that calls running_portal (${users.signup_count})
Answer: C
NEW QUESTION 18
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?
- A. Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.
- B. After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.
- C. After selecting Edit on the tile, add a filter on Created Date and hit Save.
- D. Edit the dashboard Created Date filter to update the tile's Created Time field under Tiles to Update.
Answer: A
NEW QUESTION 19
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" "between 12 months ago and 9 months ago"
- C. Sales Closing Date "matches advanced" "12 months ago for 3 months"
- D. Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago
Answer: A
NEW QUESTION 20
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. Today for 7 days
- B. For 7 days
- C. 7 days from now
- D. After Today's Date for 7 days
Answer: D
NEW QUESTION 21
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?
- A. Select the All Results option
- B. Select the Paper Size option and specify a large size.
- C. Select the Allow Scroll option and specify each table.
- D. Select the Expand Tables option.
Answer: D
NEW QUESTION 22
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?
- A. Column settings
- B. Row settings
- C. Explore settings
- D. X-axis settings
Answer: C
NEW QUESTION 23
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?
- A. Set the dashboard to run on load every 5 minutes.
- B. Set the dashboard auto refresh to 5 minutes.
- C. Set the dashboard schedule to 5 minutes and "send if the results have changed".
- D. Set the dashboard schedule to run every 5 minutes.
Answer: D
NEW QUESTION 24
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: Edit
Sales group: View - B. Admins: Manage Access, Edit
Sales analyst: Edit
Sales group: View - C. Admins: Manage Access, Edit
Sales analyst: Manage Access, Edit
Sales group: View - D. Admins: View
Sales analyst: Manage Access, Edit
Sales group: View
Answer: B
NEW QUESTION 25
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 a table calculation that sums the Ticket Revenue dimension.
- C. Add the Sum Revenue measure to the query.
- D. Remove the Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
Answer: C
NEW QUESTION 26
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. Check Expand tables in the Advanced options section of the scheduler.
- C. 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.
- D. Check Use single column layout in the Advanced options section of the scheduler.
Answer: D
NEW QUESTION 27
......
Google Looker-Business-Analyst Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
| Topic 6 |
|
| Topic 7 |
|
| Topic 8 |
|
| Topic 9 |
|
Powerful Looker-Business-Analyst PDF Dumps for Looker-Business-Analyst Questions: https://topexamcollection.pdfvce.com/Google/Looker-Business-Analyst-exam-pdf-dumps.html