Google LookML Developer.pdf
Q: 1
A LookML developer is creating a new view with 20 dimensions in Development Mode using the
Create View from Table functionality. Now users want the developer to add only four dimensions
from this new view to an existing Explore.
What can the developer add to the Explore to limit the number of fields from the view that are
accessible to the user in the Explore?
Options
Q: 2
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?
Options
Q: 3
After running the Content Validator, a developer can see the error “Unknown field”.
Which two changes could cause this issue? (Choose two.)
Options
Q: 4
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?
Options
Q: 5
A user reports the following SQL error when selecting the discounted sale price field:
ERROR: column “order_items.sale_price”; must appear in the GROUP BY clause or be used in an
aggregate function.
The developer checks the field definition and finds it to be:
measure: discounted_sale_price {
type: number
sql: ${sale_price} * 0.8 ;;
}
The developer also finds the LookML definition of the sale_price field to be:
dimension: sale_price {
type: number
sql: ${TABLE}.sale_price ;;
}
What is the likely cause of the SQL error?
Options
Q: 6
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)

B)
C)
D)

Options
Q: 7
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?
Options
Q: 8
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?
Options
Q: 9
A developer defines the following measure in the order_items view:
The code must validate without errors.
Which action should the developer take?
The code must validate without errors.
Which action should the developer take?Options
Q: 10
Only users with department attributes of Finance and Executive should be able to access the revenue
view. Only users with the value of Executive for the department user attribute should be able to view
the total_revenue field.
Given the code snippet below:
How should the required access grants be structured to set up this system of access?
How should the required access grants be structured to set up this system of access?Options
Question 1 of 10