Pass Your Looker-Business-Analyst Dumps as PDF Updated on 2022 With 40 Questions
Google Looker-Business-Analyst Real Exam Questions and Answers FREE
Google Looker-Business-Analyst Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
NEW QUESTION 16
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?
- A. Add a table calculation that evaluates location (${cities.city_name})
- B. Contact the LookML Developer
- C. Remove the Number of Museums measure from the Explore
- D. Select the Static Map visualization instead of Interactive
Answer: A
NEW QUESTION 17
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 18
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 19
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 20
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?
- A. Move the returned orders series to a new right axis.
- B. Change the y-axis height to a higher number of pixels.
- C. Set the x-axis to use a log scale.
- D. Change the returned orders series to a line type.
Answer: B
NEW QUESTION 21
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 week
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 identical looks in the same folder. Add filters on them for "last week" and "2 weeks ago" respectively.
- B. 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.
- C. Create one tile on a dashboard and two dashboard filters ("last week" and "2 weeks ago" respectively). Apply both dashboard filters to the tile.
- D. Create two tiles on a dashboard and two dashboard filters. Apply a different filter to each tile ("last week" and "2 weeks ago" respectively)
Answer: B
NEW QUESTION 22
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?
- A. Click on the Room Type dimension where it is King to drill in to it.
- B. Run the Explore again to make sure the results are the same.
- C. Remove the pivot on the Room Type dimension and re-run the Explore.
- D. Click on the Count measure where it is low to drill in to it.
Answer: D
NEW QUESTION 23
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. Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.
- D. Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
Answer: B
NEW QUESTION 24
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?
- A. Copy the dashboard.
- B. Edit HTML on the dashboard.
- C. Apply a table theme.
- D. Edit embed settings.
Answer: D
NEW QUESTION 25
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?
- A. There is a row limit applied.
- B. There is a column limit applied.
- C. There is a filter on a dimension.
- D. There is a problem with the underlying LookML.
Answer: B
NEW QUESTION 26
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 27
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?
- A. Move the dashboard to a shared folder and provide access only to the users from the team.
- B. Give view access to the individual dashboards.
- C. Create a subfolder in the personal folder and given view access to the users from the team.
- D. Give all users view access to the personal folder.
Answer: C
NEW QUESTION 28
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?
- A. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.
- B. Create a new schedule and modify the filter's default value to the previous day's date.
- C. Filter the dashboard for the advanced value "yesterday", and create a new schedule.
- D. Create a new schedule and modify the schedule filter to be the advanced value "yesterday".
Answer: A
NEW QUESTION 29
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?
- A. The individual tile's filter will override the global dashboard filter.
- B. The dashboard will break and warn the user that there are conflicting filter values
- C. The global dashboard filter will override the individual tile filter.
- D. The filter values of both filters will combine in an additive manner and both filters will apply.
Answer: C
NEW QUESTION 30
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 31
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?
- A. Enable the setting Limit one filter value.
- B. Change the filter type to string.
- C. Disable the setting Allow multiple filter values.
- D. Use the Matches Advanced filtering option.
Answer: C
NEW QUESTION 32
......
Pass Google Looker-Business-Analyst Exam Info and Free Practice Test: https://realpdf.pass4suresvce.com/Looker-Business-Analyst-pass4sure-vce-dumps.html