Google Looker certifications LOOKML-DEVELOPER Questions & Answers

• Question 11:

  A developer needs to build a new dimension that offers an age-based cohort representation of users. Which LookML code should the developer use to meet the requirement?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 12:

  A LookML Developer is working with denormalized tables and needs to create a measure adding up the Order Shipping column in the table below:

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A

• Question 13:

  A LookML developer has a transactions view with several measures that each perform complex calculations involving multiple fields. The LookML developer creates an Explore based on the transactions view. The product team wants to perform further functions on these measures, such as SUM, AVG, MIN, MAX, and RANK. The team wants these further functions to be performed at different levels of detail: weekly, monthly, and yearly.

  How can the LookML developer model these requirements and minimize the amount of code rewriting?

  A. Add measures to the transactions view of type: number to apply the required functions.

  B. Change the existing measures in the transactions view to dimensions, and add measures of the different required types.

  C. Create a constant for each measure so it can be reused across other areas of the LookML project.

  D. Create native derived tables using transactions as the explore_source.

  Correct Answer: D

• Question 14:

  After running the Content Validator, a developer can see the error “Unknown field”. Which two changes could cause this issue? (Choose two.)

  A. View name was changed from users to customers.

  B. Field type was changed from number to string.

  C. Model name was changed from e_commerce to reporting.

  D. Explore label was changed from users to customers.

  E. Field name was changed from id to user_id.

  Correct Answer: BE

• Question 15:

  Users report that every time they change the filter on their Explore, the filters take a very long time to populate.

  How can the developer improve the filtering experience with this Explore?

  A. Limit the filter suggestions using the suggestions parameter.

  B. Add an always_filter parameter to restrict the filter suggestions.

  C. Use an access_filter parameter to automatically apply filters.

  D. Add persistence to the base view of the Explore.

  Correct Answer: A

• Question 16:

  Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.

  Which parameter should be added to the country dimension to create a connection to this other associated Explore?

  A. url_encode

  B. drill_fields

  C. tags

  D. link

  Correct Answer: D

• Question 17:

  A developer commits changes after adding LookML for a new measure. Upon pulling from production, the developer notices the following lines in the LookML:

  

  A. Remove “andlt;<<<<< HEAD”, “======”, and “andgt;>>>>> branch ‘master’”

  B. Remove “andlt;<<<<< HEAD”, “======”, and everything following “======”

  C. Remove everything between “andlt;<<<<< HEAD” and “======”, and “andgt;>>>>> branch ‘master’”

  D. Remove everything between “andlt;<<<<< HEAD” and “andgt;>>>>> branch ‘master’”

  Correct Answer: D

• Question 18:

  A developer needs to model out LookML to convert existing reports into Looker. The existing reports are:

  Report 1: A report with order and order_items data, which finds the order with the largest total value of the order_item prices. Report 2: A report with order and order_items data, which finds the order with the largest total number of

  products ordered.

  Report 3: A report with data on every product, whether or not it has been ordered.

  Each database table used is updated in real time as orders are made.

  How should the developer construct an Explore using the order_items view as the base view?

  A. Create one persistent derived table to calculate Report 1, create one persistent derived table to calculate Report 2, and join in the products view with a full_outer join.

  B. Create one persistent derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

  C. Create one ephemeral derived table to calculate Report 1, create one ephemeral derived table to calculate Report 2, and join in the products view with a left_outer join.

  D. Create one ephemeral derived table to calculate Reports 1 and 2, and join in the products view with a full_outer join.

  Correct Answer: A

• Question 19:

  A developer needs to implement three persistent derived tables (PDTs) as described below.

  The PDTs need to be refreshed after the daily ETL pipeline adds incremental loads to the underlying

  tables.

  Each PDT is built off of one underlying table in the database (one PDT per table).

  The underlying tables for each PDT are updated one after the other, and a new row is added to an ETL log

  table each time a table is updated.

  Due to the unpredictable nature of the ETL pipeline, each PDT does not refresh at the same time from day

  to day.

  Each PDT takes over an hour to build, and to save on compute costs each PDT should only be refreshed

  once per day.

  How can the developer set up the PDTs according to these requirements?

  A. Create one datagroup tied to all three PDTs that runs when the total row count across all three tables changes.

  B. Create one datagroup tied to all three PDTs that parameterizes the view name for each PDT in the SQL trigger condition.

  C. Create three separate datagroups tied to three PDTs that run when each corresponding table's row count changes.

  D. Create three separate datagroups tied to three PDTs that run when a new row is added to the ETL log table.

  Correct Answer: D

• Question 20:

  The developer is creating an Explore that includes the product users, and orders views that will meet the following guidelines.

  Joins between the orders and users views should not incur high performance costs.

  Users of this Explore will primarily be looking at data from the orders view.

  Users of this Explore should only be able to see orders from the retailer “Fashion.ly”.

  The only field the users need from the products view is product.name.

  Which LookML should the developer use?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: D