Google LOOKML-DEVELOPER Online Practice Questions and Exam Preparation

Google LOOKML-DEVELOPER Online Questions & Answers

• Question 1:

  Two developers are working on adding a new view to a project. Once both developers have finished their work in the view, the changes will be pushed to production. Where should the developers write the LookML for this view?

  A. In the master branch, with both users writing to the branch
  B. In one user's personal branch, with both users writing to the branch
  C. In a new shared branch created from the master branch
  D. In each of their personal branches, with each user writing code separately
  C. In a new shared branch created from the master branch

• Question 2:

  A developer is defining the users table within a view file in Looker. The users table will be available as an individual Explore and it will also be joined into other Explores, such as the products Explore. The developer needs to limit the fields visible in the products Explore without affecting the visibility of the fields in the users Explore.

  How should the developer meet this requirement?

  A. Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.
  B. Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.
  C. Create two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.
  D. Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.
  A. Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.

• Question 3:

  A user reports that, when a date dimension is filtered to “before now” results are returned that consistently include tomorrow. Dimension fill has been ruled out as a cause of the issue. Which LookML parameter should be used to resolve this issue?

  A. Week_start_day
  B. Convert_tz
  C. Datatype
  D. Fiscal_month_offset
  D. Fiscal_month_offset

• Question 4:

  A developer wants to calculate the ratio of total sales from the orders view and total users from the users view. Which two methods can be used to create a measure that meets these requirements? (Choose two.)

  

  

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  E. Option E
  A. Option A
  C. Option C

• Question 5:

  A developer has the dimensions enrollment_month and graduation_month already defined in the view. Both were created as part of dimension_groups of type: time. The developer need to use these two dimensions in the sql_start and

  sql_end parameters of a dimension group of type: duration.

  Which LookML should be used to calculate the number of month and years between enrollment month and graduation month?

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

• Question 6:

  A developer defines the following measure in the order_items view:

  

  The code must validate without errors. Which action should the developer take?

  A. Join order_items and inventory_items in a derived table.
  B. Join order_items and inventory_items in the same Explore.
  C. Copy the cost definition from inventory_items to the order_items view file.
  D. Add the following to the order_items view file: include: “inventory_items,view.lkml”
  A. Join order_items and inventory_items in a derived table.

• Question 7:

  A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.

  Which LookML parameter should the developer use to meet this requirement?

  A. access_grant
  B. always_filter
  C. access_filter
  D. sql_always_where
  A. access_grant

• Question 8:

  A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis, the developer wants the table to be cached for 12 hours, but only when a user has queried it. Which persistence parameter should be added to the derived table's definition in order to satisfy this use case?

  A. persist_with: “12 hours”
  B. datagroup: 12_hours { max_cache_age: “12 hours” }
  C. persist_for: “12 hours”
  D. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;
  A. persist_with: “12 hours”

• Question 9:

  A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes. What does this indicate?

  A. A change has been deployed to a shared branch.
  B. A change has been committed in another developer's personal branch.
  C. A change has been committed in another shared branch.
  D. A change has been deployed to production.
  B. A change has been committed in another developer's personal branch.

• Question 10:

  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
  A. Option A