LOOKML-DEVELOPER Online Practice Questions and Answers

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.

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.

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.

The code below shows a view order_items with its measures total_revenue and user_count

Which code correctly represents a new measure that calculates average revenue per user?

A. Option A

B. Option B

C. Option C

D. Option D

A developer has created a persistent derived table that tracks new or updated orders and they want to cache the results. The cache should be refreshed whenever some new order is available on the underlying datasource table my tablename or at least every 24 hours.

Which datagroup definition will refresh the cache as expected?

A. Option A

B. Option B

C. Option C

D. Option D

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

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.

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.

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

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