QUESTION: 9

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?

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

Answer(s): C

Reference:

https://docs.looker.com/reference/view-params/sql_trigger_value

Reveal Solution Next Question

QUESTION: 10

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?

required_access_grants: [can_view_financial_data]
required_access_grants: [leadership]
required_access_grants: [“000”,“999”]
required_access_grants: [total_revenue]

Answer(s): A

Reference:

https://community.looker.com/technical-tips-tricks-1021/how-to-use-and-troubleshoot-access-grants-field-permissions-23986

Reveal Solution Next Question

QUESTION: 11

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?

An always_filter parameter
A front-end filter in the Explore
A sql_always_where parameter
A filtered measure

Answer(s): B

Reveal Solution Next Question

QUESTION: 12

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

Apply the hidden parameter with a value of yes to Explores that only exist to power specific Looks, dashboards, or suggestion menus.
Modify the business users’ roles so they do not have this model in their model set.
Combine the Explores into just a few Explores that each join to many views.
Apply the group_label parameter to organize the Explores under different headings.
Apply the fields parameter so that each Explore has fewer fields in it.

Answer(s): B,C

Reveal Solution Next Question

Free LookML Developer Exam Braindumps (page: 3)

QUESTION: 9

Reference:

QUESTION: 10

Reference:

QUESTION: 11

QUESTION: 12