Google Looker certifications LOOKML-DEVELOPER Questions & Answers

• Question 21:

  A user reports an error message on an Explore: “Non-unique value/primary key (or sql_distinct_key), value overflow or collision when computing sum”.

  What should the LookML developer check for in the joined views of the Explore?

  A. The sum measure used is defined correctly.

  B. A unique primary key is defined in each view.

  C. Symmetric_aggregates: no is not present in the Explore definition.

  D. No concatenated primary keys are used.

  Correct Answer: C

• Question 22:

  A user reports the following SQL error when selecting the discounted sale price field:

  ERROR: column “order_items.sale_price”; must appear in the GROUP BY clause or be used in an

  aggregate function.

  The developer checks the field definition and finds it to be:

  measure: discounted_sale_price {

  type: number

  sql: ${sale_price} * 0.8 ;;

  }

  The developer also finds the LookML definition of the sale_price field to be:

  dimension: sale_price {

  type: number

  sql: ${TABLE}.sale_price ;;

  }

  What is the likely cause of the SQL error?

  A. The discounted_sale_price field should have a group_by: yes parameter.

  B. The sale_price field should be defined as a measure of type: number, not as a dimension.

  C. The underlying database table does not have a field called sale_price.

  D. The discounted_sale_price field should be defined as a dimension of type: number, not as a measure.

  Correct Answer: B

• Question 23:

  A LookML developer is creating a new view with 20 dimensions in Development Mode using the Create View from Table functionality. Now users want the developer to add only four dimensions from this new view to an existing Explore.

  What can the developer add to the Explore to limit the number of fields from the view that are accessible to the user in the Explore?

  A. Set definition

  B. Join condition

  C. Fields parameter

  D. Hidden parameter

  Correct Answer: B

• Question 24:

  A developer wants to create a new Explore based on the order_items view. The developer creates an

  Explore in the ecommerce model file with the following definition:

  explore: order_items {}

  After saving and validations, the developer receives this LookML validator error:

  Inaccessible view “inventory_items”, “inventory_items” is not accessible in explore” “order_items”. Check

  for typos and missing joins in explore “order_items”.

  What caused this error to appear?

  A. A field in the order_items view references a field in the inventory_items view.

  B. A field in the inventory_items view references a field in the order_items view.

  C. There is an Explore named inventory_items which references the order_items view.

  D. There is another Explore named order_items which references the inventory_items view.

  Correct Answer: A

• Question 25:

  A developer is connecting a LookML project to a remote Git repository. The developer wants to track which users are committing code changes, creating pull requests, or deploying to production when the different Git commands are initiated from within Looker.

  Which type of Git connection should be utilized to meet this business requirement?

  A. A bare Git repository

  B. Multiple account HTTPS

  C. Single account HTTPS

  D. SSH

  Correct Answer: D

• Question 26:

  A developer has a persistent derived table view called user_facts that contains aggregated data for each user. The developer needs to query the data from this table in another derived table view called user_region_facts.

  Which strategy should the developer use to write the query for user_region_facts that will leverage the existing derived table?

  A. Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.

  B. Copy the name of the database table in the scratch schema for the user_facts derived table.

  C. Writhe the query form user_facts into a common table expression (WITH user_facts AS...).

  D. Write a subquery in the FROM clause and alias with ${user_facts}.

  Correct Answer: C

• Question 27:

  Users viewing an Explore should be able to view rows of data only where the value of the product.brand column matches the value of the user's company user attribute.

  Which access filter should the developer use to meet this requirement?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 28:

  A developer is building an e-commerce Explore with the following datasets: orders and users. The business user needs to be able to answer questions about sellers and buyers within the same Explore. Each order in the orders table reports a buyer and seller ID. The users table has the detailed information about the individual buyer and seller.

  How should the Explore be defined to meet this requirement?

  

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: B

• Question 29:

  A LookML developer creates an Explore that joins two views. The base view has information about users’ interactions with the support team. The joined view contains data about the users. The support team using this Explore feels overwhelmed by the amount of data this Explore shows them and decides to just look at open tickets.

  What should the developer add to the Explore in the model to achieve these requirements?

  A. A filtered measure

  B. The hidden parameter

  C. The sql_always_where parameter

  D. A relationship definition

  Correct Answer: D

• Question 30:

  A developer would like to add a new dimension of type: yesno for the enabled column in their users table. The column is of type: string in the database and returns yes and no values.

  How should the developer define the yesno dimension?

  

  A. Option A

  B. Option B

  C. Option C

  D. Option D

  Correct Answer: A