Google Looker-Business-Analyst Exam Questions Free Practice Test

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Questions # 1:

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?

Options:

Give all users view access to the personal folder.

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

Give view access to the individual dashboards.

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

Questions # 2:

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?

Options:

Custom filter “is in the past” 12 months AND “is before” “relative” 9 months ago

Sales Closing Date “matches advanced” “12 months ago for 3 months”

Sales Closing Date “is in the past” 12 months OR “is before” “relative” 9 months ago

Sales Closing Date “matches advanced” “between 12 months ago and 9 months ago”

Questions # 3:

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?

Options:

Schedule the dashboard as HTML to adjust automatically.

Schedule the dashboard with the PDF format Use single column layout.

Create a mobile-friendly version of the dashboard by rearranging the tiles, and schedule the dashboard.

Schedule the dashboard with PDF paper size set to Fit Page to Dashboard.

Questions # 4:

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?

Options:

Add a trend line for 30000.

Add a Tick Density of 30000.

Add a reference line for 30000.

Add a table calculation to hide values less than 30000.

Questions # 5:

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?

Options:

use Merged Results to combine the data sources.

Ask the LookML developer to build a new Explore.

Add both Looks to a dashboard

Pin both Looks to a board.

Questions # 6:

An analyst needs to compare monthly sales, year over year, based on when an order was created, as shown in the exhibit.

Question # 6

How should the analyst, in addition to selecting the measure Total Sales build the report?

Options:

Select the dimension Created Month, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month.

Select the dimension Created Month Name, and pivot on the dimension Created Year.

Select the dimension Created Year, and pivot on the dimension Created Month Name.

Questions # 7:

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?

Options:

Add a Sum measure to the Explore and re-run the query.

Add a table calculation that calls running_portal (${users.signup_count})

Add a custom measure of type: running_total

Add a table calculation that calls ${users.signup_count:total}

Questions # 8:

An analyst works on the data team at an organization that maintains multiple similar Explores. The analyst has access to see every Explore, but knows that employees in the finance department only have access to explores tagged Finance.

There is an Employee Compensation Data Finance Explore that the finance department has access to. The analyst usually uses an All Employee Data Explore that also includes personally identifiable information.

What should the analyst do to ensure proper access if the analyst wants to send an example visualization to the finance team?

Options:

Create Merged Results with the Employee Compensation Data Finance Explore and the All Employee Data Explore, and send the URL of the Merged Results.

Use the Employee Compensation Data Finance Explore and send the URL of the Explore to the finance team.

Use the All Employee Data Explore, but use Looker’s built-in Send functionality to email the visualization.

Use the All Employee Data Explore, add a filter to exclude personally identifiable information, and send the URL of the Explore to the finance team.

Questions # 9:

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?

Options:

Run the Explore again to make sure the results are the same.

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

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

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

Questions # 10:

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?

Options:

Check Use single column layout in the Advanced options section of the scheduler.

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

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

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.

Viewing page 1 out of 2 pages

Viewing questions 1-10 out of questions

Pass the Google Looker certifications Looker-Business-Analyst Questions and answers with CertsForce