Google LookML-Developer Exam Practice Test Instant Access

Question 1

Two developers are working on adding a new view to a project. Once both developers have finished their work in the view, the changes will be pushed to production.

Where should the developers write the LookML for this view?

AIn the master branch, with both users writing to the branch

BIn one user's personal branch, with both users writing to the branch

CIn a new shared branch created from the master branch

DIn each of their personal branches, with each user writing code separately

Answer : C

Question 2

Users report that the main dashboard has been slow to show results.

Which two options should the developer evaluate to improve dashboard performance? (Choose two.)

ANumber of databases used by dashboard elements

BNumber of queries used by the dashboard

CRatio of visualizations to text tiles

DFormat used to deliver these reports

EAmount of data rendered for each query

Answer : B, C

Question 3

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?

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

BChange the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME}

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

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

Answer : C

Question 4

A developer creates a derived table and wants to add persistence to it. Because the table is not used on a frequent basis, the developer wants the table to be cached for 12 hours, but only when a user has queried it.

Which persistence parameter should be added to the derived table's definition in order to satisfy this use case?

Apersist_with: ''12 hours''

Bdatagroup: 12_hours {
max_cache_age: ''12 hours''
}

Cpersist_for: ''12 hours''

Dsql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;

Answer : A

Question 5

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?

AUse 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.

BCreate 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.

CCreate 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.

DUse 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.

Answer : A

Question 6

A LookML developer has created a model with many Explores in it. Business users are having a difficult time locating the Explore they want in the long list displayed.

Which two actions can the LookML developer take to improve the user interface? (Choose two.)

AApply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.

BModify the business users' roles so they do not have this model in their model set.

CCombine the Explores into just a few Explores that each join to many views.

DApply the group_label parameter to organize the Explores under different headings.

EApply the fields parameter so that each Explore has fewer fields in it.

Answer : B, C

Question 7

A developer would like to add a new dimension of type: yesno for the enabled column in their users table. The column is of type: string in the database and returns yes and no values.

How should the developer define the yesno dimension?

AOption A

BOption B

COption C

DOption D

Answer : A

Google Looker LookML Developer LookML-Developer Exam Practice Test