Google Looker certifications LOOKML-DEVELOPER Questions & Answers

• Question 41:

  A LookML developer has written the following persistent derived table. It references orders_rollup, another persistent derived table that also rebuilds with the same SQL trigger value.

  

  Which change is needed to guarantee that user_facts will always rebuild with the latest data from orders_rollup?

  A. Change the sql_trigger_value parameter of user_facts to select the current date plus one hour, so it triggers an hour after orders_rollup.

  B. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}

  C. Change the sql_trigger_value parameter for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.

  D. Change the orders_rollup view reference to the literal table name from the database's scratch schema.

  Correct Answer: C

• Question 42:

  A retail company wants to limit who can see the financial information in their reports to executives and store managers. The LookML Developer creates a user attribute called leadership with the value “000” for executives and “999” for store managers. The developer creates three access grant objects and one dimension: How should the developer ensure that only authorized users see the data in the Total Revenue dimension?

  

  A. required_access_grants: [can_view_financial_data]

  B. required_access_grants: [leadership]

  C. required_access_grants: [“000”,“999”]

  D. required_access_grants: [total_revenue]

  Correct Answer: A

• Question 43:

  A user is seeing an error in the Explore that indicates the primary key defined for a one-million-row table is not unique.

  How can the developer use SQL Runner to troubleshoot quickly?

  A. Create a query that selects all the fields from the table, and sort by primary key.

  B. Create a query that selects the primary key from the base view, and look for duplicates.

  C. Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count.

  D. Create a query that concatenates two columns to create a compound primary key.

  Correct Answer: D

• Question 44:

  The daily_forecast Explore used by the sales team needs to be cached for 24 hours. All other Explores used by the sales team need to be cached for one hour.

  What is a scalable way to configure this caching logic?

  A. Define two datagroups for the model. Apply persist_with at the model level with the datagroup for 1hour caching, and apply persist_with to daily_forecast with the datagroup for 24-hour caching.

  B. Define max_cache_age on daily_forecast Explores of 24 hours. Define max_cache_age on all other Explores for one hour.

  C. Define two datagroups for the model. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply datagroup_trigger to it using the datagroup for 24-hour caching.

  D. Define for the model one datagroup that caches for 1 hour. Create a persistent derived table (PDT) for the daily_forecast Explore, and apply sql_trigger_value to it selecting the current date.

  Correct Answer: A

• Question 45:

  A LookML developer creates a new model and a test dashboard from the model. The developer shares the link to the new dashboard with users, but the users report that all they see is the “Model Not Found” error.

  What is a possible cause of this issue?

  A. The developer has not pushed the new model to Production Mode.

  B. The developer has not added users to the new model set.

  C. The users do not have permission to access this dashboard.

  D. The new model is missing an Explore definition.

  Correct Answer: B

• Question 46:

  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.

  Correct Answer: A

• Question 47:

  Business users report that they are unable to build useful queries because the list of fields in the Explore is too long to find what they need.

  Which three LookML options should a developer use to curate the business user's experience? (Choose three.)

  A. Add a description parameter to each field with context so that users can search key terms.

  B. Create a separate project for each business unit containing only the fields that the unit needs.

  C. Add a group_label parameter to relevant fields to organize them into logical categories.

  D. Use the hidden parameter to remove irrelevant fields from the Explore.

  E. Use a derived table to show only the relevant fields.

  Correct Answer: ACE

• Question 48:

  A user reports that a query run against the orders Explore takes a long time to run. The query includes only fields from the users view. Data for both views is updated in real time. The developer runs the following query in SQL Runner and quickly receives results:

  SELECT * FROM users.

  What should the developer do to improve the performance of the query in the Explore?

  A. Create an Explore with users as the base table.

  B. Create a persistent derived table from the user's query.

  C. Create an ephemeral derived table from the user's query.

  D. Add persist_for: “24 hours” to the orders Explore.

  Correct Answer: A

• Question 49:

  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.

  Correct Answer: C

• Question 50:

  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

  Correct Answer: C