LookML-Developer Google Looker LookML Developer Exam Free Practice Exam Questions (2025 Updated)
Prepare effectively for your Google LookML-Developer Looker LookML Developer Exam certification with our extensive collection of free, high-quality practice questions. Each question is designed to mirror the actual exam format and objectives, complete with comprehensive answers and detailed explanations. Our materials are regularly updated for 2025, ensuring you have the most current resources to build confidence and succeed on your first attempt.
A developer has User Specific Time Zones enabled fora 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 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 inexplore” “order_items”. Check for typos and missing joins in explore “order_items”.
What caused this error to appear?
The code below shows a vieworder_items with its measures total_revenue and user_count
Which code correctly represents a new measure that calculates average revenue per user?
A)
B)
C)
D)
After validating LookML code, a developer receives the following error message:
“Unknown or Inaccessible Field users.name”
What is causing this error?
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 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)
B)
C)
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 touse 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)
B)
C)
D)
Business users reportthat 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 developer is defining the users table within a view file in Looker. Theusers 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 developer commits changes after adding LookML for a new measure. Upon pulling from production, the developer notices the following lines in the LookML:
A user reports an errormessage 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 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)
B)
C)
D)
A developer wants tocreate a measure that shows the item count broken out by category. When a second, more granular dimension is added to the same query, the count broken out by category should still represent the original aggregation and be duplicated on each line. The business wants this “count” in “category” available in the Explore section without any additional work done by the end user. For example:
The Count column represents the count for each combination of Category and Item.
The Count in Category column represents the count for each Category only.
How can the developer address this need with a LookML object?
A user needs to create a report that shows a count of all orders and of orders over $100.
Which solution should the developer implement to meet these requirements?
Users must be able to click on the Country field in their Explore and be redirected to another Explore that shows all countries compared.
Which parameter should be added to the country dimension to create a connection to this other associated Explore?
