[2022] Looker-Business-Analyst Answers Looker-Business-Analyst Free Demo Are Based On The Real Exam
Looker-Business-Analyst [Jan-2022 Newly Released] Exam Questions For You To Pass
NEW QUESTION 17
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 Month Name, and pivot on the dimension Created Year.
- B. Select the dimension Created Month, and pivot on the dimension Created Year.
- C. Select the dimension Created Year, and pivot on the dimension Created Month.
- D. Select the dimension Created Year, and pivot on the dimension Created Month Name.
Answer: B
NEW QUESTION 18
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 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
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 21
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 22
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. Add both Looks to a dashboard
- B. Ask the LookML developer to build a new Explore.
- C. use Merged Results to combine the data sources.
- D. Pin both Looks to a board.
Answer: A
NEW QUESTION 23
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 24
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 25
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 26
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. 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.
- 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. Pivot the Explore by the Brand Name dimension.
Answer: C
NEW QUESTION 27
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 28
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 29
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 30
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 31
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 32
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. Dashboard filter to specify which individual data shows
- B. Two dashboards with a text tile to hyperlink from one dashboard to the other
- C. Two dashboards, one with aggregate and one with individual data
- D. Folder with all dashboard tiles for aggregate data and individual data.
Answer: A
NEW QUESTION 33
......
New 2022 Realistic Free Google Looker-Business-Analyst Exam Dump Questions and Answer: https://www.practicematerial.com/Looker-Business-Analyst-exam-materials.html
