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 31:

    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 auto refresh to 5 minutes.

    C. Set the dashboard to run on load every 5 minutes.

    D. Set the dashboard schedule to 5 minutes and "send if the results have changed".

  • Question 32:

    Users find it difficult to distinguish the dashboards they need for tracking sales performance. There are more than 30 operation-related dashboards in the same folder.

    What should the analyst do to improve the navigation experience?

    A. Pin the dashboards into boards and grant user access to the individual dashboards.

    B. Add descriptions to the dashboards to give more details.

    C. Sort the dashboards in the folder by name.

    D. Show the dashboards in a grid style for displaying the snapshot.

  • Question 33:

    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 filter values of both filters will combine in an additive manner and both filters will apply.

    B. The individual tile's filter will override the global dashboard filter.

    C. The global dashboard filter will override the individual tile filter.

    D. The dashboard will break and warn the user that there are conflicting filter values.

  • Question 34:

    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. Run the Explore again to make sure the results are the same.

    B. Click on the Count measure where it is low to drill in to it.

    C. Click on the Room Type dimension where it is King to drill in to it.

    D. Remove the pivot on the Room Type dimension and re-run the Explore.

  • Question 35:

    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. Change the returned orders series to a line type.

    B. Move the returned orders series to a new right axis.

    C. Change the y-axis height to a higher number of pixels.

    D. Set the x-axis to use a log scale.

  • Question 36:

    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. Give all users view access to the personal folder.

    B. Move the dashboard to a shared folder and provide access only to the users from the team.

    C. Give view access to the individual dashboards.

    D. Create a subfolder in the personal folder and given view access to the users from the team.

  • Question 37:

    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" "12 months ago for 3 months"

    C. Sales Closing Date "is in the past" 12 months OR "is before" "relative" 9 months ago

    D. Sales Closing Date "matches advanced" "between 12 months ago and 9 months ago"

  • Question 38:

    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. Filter the dashboard for the advanced value "yesterday", and create a new schedule.

    B. Edit the dashboard data filters default value to be the previous day's date, and create a new schedule.

    C. Create a new schedule and modify the filter's default value to the previous day's date.

    D. Create a new schedule and modify the schedule filter to be the advanced value "yesterday".

  • Question 39:

    An analyst creates a table visualization. There is one dimension, a few count type measures, and a percentage table calculation. When the analyst tries to download all 200,000 rows of results in CSV, the option is unavailable. The analyst has been provided permission to download all results.

    Which action should the analyst take to download all results?

    A. Request that the admin user download this Look and share the file.

    B. Change the table calculation to use an offset() function.

    C. Contact the developer to create the percentage as a measure.

    D. Apply a custom limit to the download.

  • Question 40:

    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. Check Use single column layout in the Advanced options section of the scheduler.

    B. Check Expand tables in the Advanced options section of the scheduler.

    C. Select the paper size Tabloid with orientation Landscape in the Advanced options section of the scheduler.

    D. 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.

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.