Google LOOKML-DEVELOPER Online Practice Questions and Exam Preparation

Google LOOKML-DEVELOPER Online Questions & Answers

• Question 21:

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

• Question 22:

  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.
  A. Limit the filter suggestions using the suggestions parameter.

• Question 23:

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

• Question 24:

  A developer has User Specific Time Zones enabled for a Looker instance, but wants to ensure that queries run in Looker are as performant as they can be. The developer wants to add a datatype: date parameter to all dimension_group definitions without time data in a table-based view, so that time conversions don't occur for these fields.

  How can the developer determine to which fields this parameter should be applied through SQL Runner?

  A. Open the Explore query in SQL Runner and validate whether removing the conversion from date fields changes the results.
  B. Open the Explore query in SQL Runner to determine which fields are converted.
  C. Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.
  D. Use the Describe feature in SQL Runner to determine which fields include time data.
  C. Use the CAST function in SQL Runner to ensure that all underlying fields are dates and conversions are not applied.

• Question 25:

  A developer needs to add an Explore built off of the orders view, which surfaces only completed orders. An orders Explore exists that contains all order information. Fields from the orders view are also referenced in other existing views such as ${orders.fieldname}.

  How should developer define a new Explore for completed orders and keep all field references working correctly?

  

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

• Question 26:

  Business users report that an ephemeral derived table tile on the dashboard is slow.

  Information about the dashboard includes:

  The dashboard filter is linked to the user attributes.

  This tile usually takes approximately 5 minutes to complete running.

  Which solution should be used to improve the dashboard load time?

  A. Use a conditional WHERE clause for Development Mode.
  B. Build a user attribute filter into the Explore.
  C. Use index distribution_key or sort_key for this derived table.
  D. Persist the derived table.
  D. Persist the derived table.

• Question 27:

  After running the LookML Validator, a developer sees the following error message in the Looker development environment:

  “Measures with Looker aggregations (sum, average, min, max, list types) may not reference other measures”.

  What could be causing this error?

  A. A measure of type: count has a sql parameter defined.
  B. A measure of type: sum adds up other measures in the sql parameter.
  C. A measure of type: sum has a SUM function written in the sql parameter.
  D. A measure of type: number has a SUM function written in the sql parameter.
  A. A measure of type: count has a sql parameter defined.

• Question 28:

  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.
  D. Create three separate datagroups tied to three PDTs that run when a new row is added to the ETL log table.

• Question 29:

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

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