Latest [Sep 30, 2022] Google Looker-Business-Analyst Exam Practice Test To Gain Brilliante Result
Take a Leap Forward in Your Career by Earning Google Looker-Business-Analyst
NEW QUESTION 16
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 custom measure of type: running_total
- B. Add a table calculation that calls ${users.signup_count: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 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. Limit displayed rows.
- B. Hide rows with table calculations.
- C. Right-click to hide unwanted rows.
- D. Use a custom filter.
Answer: A
NEW QUESTION 18
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. Edit embed settings.
- B. Edit HTML on the dashboard.
- C. Copy the dashboard.
- D. Apply a table theme.
Answer: A
NEW QUESTION 19
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 with the PDF format Use single column layout.
- B. Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.
- C. Schedule the dashboard as HTML to adjust automatically.
- D. Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.
Answer: A
NEW QUESTION 20
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 21
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. X-axis settings
- B. Explore settings
- C. Row settings
- D. Column settings
Answer: B
NEW QUESTION 22
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 Month dimension and the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
- B. Add the Sum Revenue measure to the query.
- C. Add a table calculation that sums the Ticket Revenue dimension.
- D. Remove the Ticket Revenue dimension from the query. Add the Sum Revenue measure.
Answer: B
NEW QUESTION 23
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?
- A. Display row totals for each category.
- B. Series type customization on budgeted spend.
- C. Grouped series positioning on budgeted spend.
- D. Transpose table to separate out budgeted spend.
Answer: D
NEW QUESTION 24
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. Pin both Looks to a board.
- B. Add both Looks to a dashboard
- C. use Merged Results to combine the data sources.
- D. Ask the LookML developer to build a new Explore.
Answer: B
NEW QUESTION 25
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 trend line for 30000.
- B. Add a reference line for 30000.
- C. Add a Tick Density of 30000.
- D. Add a table calculation to hide values less than 30000.
Answer: A
NEW QUESTION 26
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 schedule to run every 5 minutes.
- B. Set the dashboard to run on load every 5 minutes.
- C. Set the dashboard schedule to 5 minutes and "send if the results have changed".
- D. Set the dashboard auto refresh to 5 minutes.
Answer: A
NEW QUESTION 27
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?
- A. Folder with all dashboard tiles for aggregate data and individual data.
- B. Two dashboards with a text tile to hyperlink from one dashboard to the other
- C. Dashboard filter to specify which individual data shows
- D. Two dashboards, one with aggregate and one with individual data
Answer: C
NEW QUESTION 28
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.)
- A. The analyst wants to use the Look-linked tile in a separate company performance dashboard.
- B. The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.
- C. The analyst plans on creating a scheduled report of the associated Look.
- D. The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.
Answer: A,C
Explanation:
Reference https://help.looker.com/hc/en-us/articles/360023424054-Look-linked-tiles-versus-query-tiles-on-a-dashboard
NEW QUESTION 29
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?
- A. Select the dimension Created Year, and pivot on the dimension Created Month.
- B. Select the dimension Created Month Name, and pivot on the dimension Created Year.
- C. Select the dimension Created Month, and pivot on the dimension Created Year.
- D. Select the dimension Created Year, and pivot on the dimension Created Month Name.
Answer: C
NEW QUESTION 30
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. Apply a filter on the Count of Items Sold measure that requires the count to be greater than zero.
- B. Sort the data by Count of Items Sold descending and apply a row limit of 50.
- C. 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.
- D. Sort the data by Brand Name alphabetically and apply a row limit of 50.
Answer: A
NEW QUESTION 31
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?
- A. Pivot the Explore by brand Rank.
- B. Pivot the Explore by the Brand Name dimension.
- C. 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.
- D. 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.
Answer: C
NEW QUESTION 32
......
Authentic Best resources for Looker-Business-Analyst Online Practice Exam: https://www.dumpexams.com/Looker-Business-Analyst-real-answers.html