Exam Details

  • Exam Code
    :LOOKER-BUSINESS-ANALYST
  • Exam Name
    :Looker Business Analyst
  • Certification
    :Looker certifications
  • Vendor
    :Google
  • Total Questions
    :40 Q&As
  • Last Updated
    :May 01, 2024

Google Looker certifications LOOKER-BUSINESS-ANALYST Questions & Answers

  • Question 11:

    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 embed settings.

    C. Apply a table theme.

    D. Edit HTML on the dashboard.

  • Question 12:

    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. After selecting Explore from Here on the tile, remove the filter on Created Time and hit Save.

    B. After selecting Edit on the tile, add a filter on Created Date and hit Save.

    C. Edit the dashboard Created Date filter to update the tile's Created Time field under Tiles to Update.

    D. Edit the dashboard Created Date filter to update the tile's Created Time filter under Filters to Update.

  • Question 13:

    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. Column settings

    C. Explore settings

    D. Row settings

  • Question 14:

    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 Tick Density of 30000.

    C. Add a reference line for 30000.

    D. Add a table calculation to hide values less than 30000.

  • Question 15:

    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 plans on creating a scheduled report of the associated Look.

    C. The analyst is considering dashboard performance, and Look-linked tiles on dashboards lead to faster performance.

    D. The analyst wants the flexibility to export the Look-linked tile results to additional file formats not supported by query tiles.

  • Question 16:

    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.

  • Question 17:

    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.

  • Question 18:

    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. Right-click to hide unwanted rows.

    B. Limit displayed rows.

    C. Use a custom filter.

    D. Hide rows with table calculations.

  • Question 19:

    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. Change the filter type to string.

    B. Enable the setting Limit one filter value.

    C. Use the Matches Advanced filtering option.

    D. Disable the setting Allow multiple filter values.

  • Question 20:

    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 filter on a dimension.

    C. There is a problem with the underlying LookML.

    D. There is a column limit applied.

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Google exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your LOOKER-BUSINESS-ANALYST exam preparations and Google certification application, do not hesitate to visit our Vcedump.com to find your solutions here.