Online Access Free LookML-Developer Practice Test

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

A developer needs to implement three persistent derived tables (PDTs) as described below.
The PDTs need to be refreshed after the daily ETL pipeline adds incremental loads to the underlying tables.
Each PDT is built off of one underlying table in the database (one PDT per table).
The underlying tables for each PDT are updated one after the other, and a new row is added to an ETL log table each time a table is updated.
Due to the unpredictable nature of the ETL pipeline, each PDT does not refresh at the same time from day to day.
Each PDT takes over an hour to build, and to save on compute costs each PDT should only be refreshed once per day.
How can the developer set up the PDTs according to these requirements?

• A.Create one datagroup tied to all three PDTs that parameterizes the view name for each PDT in the SQL trigger condition.
• B.Create three separate datagroups tied to three PDTs that run when a new row is added to the ETL log table.
• C.Create one datagroup tied to all three PDTs that runs when the total row count across all three tables changes.
• D.Create three separate datagroups tied to three PDTs that run when each corresponding table's row count changes.

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?

• A.The users do not have permission to access this dashboard.
• B.The new model is missing an Explore definition.
• C.The developer has not added users to the new model set.
• D.The developer has not pushed the new model to Production Mode.

After validating LookML code, a developer receives the following error message:
"Unknown or Inaccessible Field users.name"
What is causing this error?

• A.There is a missing join.
• B.The join relationship is incorrect.
• C.The field uses incorrect SQL syntax.
• D.The field is set to "hidden".

A developer wants to calculate the ratio of total sales from the orders view and total users from the users view.
Which two methods can be used to create a measure that meets these requirements? (Choose two.)

B)

C)

D)

E)

• A.Option D
• B.Option A
• C.Option E
• D.Option B
• E.Option C