Try and practice the latest Google : LookML-Developer real questions & answers

Not sure whether a question bank is worth your money? Actual4Cert offers a free demo of the Google Looker LookML Developer practice questions, so you can judge the quality and the difficulty of the LookML-Developer material before you spend anything.

Google LookML-Developer Exam Overview:

Google LookML-Developer Exam Syllabus Topics:

Common Questions About the Google Looker LookML Developer

Google Looker LookML Developer Sample Questions:

Question 1

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 for both persistent derived tables to a datagroup_trigger parameter, and set them to use the same datagroup.
B. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}
C. 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.
D. Change the orders_rollup view reference to the literal table name from the database's scratch schema.

Question 2

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)

B)

C)

D)

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

Question 3

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: [total_revenue]
C. required_access_grants: ["000","999"]
D. required_access_grants: [leadership]

Question 4

A developer is defining the users table within a view file in Looker. The users 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. Use the fields parameter at the join level for the products Explore to specify which fields should be included and leave the users Explore as is.
B. Use the hidden parameter in the users view file for the fields that should not come over to the products Explore and leave the users Explore as is.
C. Create two view files for the users table. One view file will have all possible fields for the users Explore, and the other will have only the fields required for the products Explore.
D. Create duplicate dimensions and measures, one for the users Explore and one for the products Explore, and use the hidden parameter to modify the visibility of the fields.

Question 5

A developer wants to create 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. Calculate the measure using a derived table, and then join that derived table back into the Explore.
B. Calculate the overall count using table calculations in the Explore.
C. Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter.
D. Create a measure filtered on Category, and make the filter value controlled by a parameter.

Solutions: