Google Looker LookML Developer - LookML-Developer FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A LookML developer finishes some LookML work and commits changes in their personal development branch. The developer is asked to Pull and Merge Other Changes.
What does this indicate?

A. A change has been deployed to production. B. A change has been committed in another developer's personal branch C. A change has been deployed to a shared branch. D. A change has been committed in another shared branch.

Discussion 0

Correct Answer: B Vote an answer

Question 2

A LookML developer creates an Explore that joins two views. The base view has information about users' interactions with the support team. The joined view contains data about the users. The support team using this Explore feels overwhelmed by the amount of data this Explore shows them and decides to just look at open tickets.
What should the developer add to the Explore in the model to achieve these requirements?

A. The sql_always_where parameter B. A relationship definition C. A filtered measure D. The hidden parameter

Discussion 0

Correct Answer: B Vote an answer

Question 3

A LookML developer builds a view that contains sensitive information. Only members of the Management group should have access to the view. The developer needs to restrict the view from appearing in the field picker for any Explore where it might be joined for users outside of the Management group.
Which LookML parameter should the developer use to meet this requirement?

A. access_grant B. always_filter C. sql_always_where D. access_filter

Discussion 0

Correct Answer: A Vote an answer

Question 4

A user is seeing an error in the Explore that indicates the primary key defined for a one-million-row table is not unique.
How can the developer use SQL Runner to troubleshoot quickly?

A. Create a query that selects the primary key from the base view, and look for duplicates. B. Create a query that selects all the fields from the table, and sort by primary key. C. Create a query that counts how many occurrences of the primary key value are in the base view, and sort by count. D. Create a query that concatenates two columns to create a compound primary key.

Discussion 0

Correct Answer: D Vote an answer

Question 5

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 the literal table name from the database's scratch schema. C. Change the orders_rollup view reference to ${orders_rollup.DERVIED_TABLE_NAME} D. 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.

Discussion 0

Correct Answer: A Vote an answer

Question 6

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. Create a measure with type: sum_over_dimension, and make the dimension value controlled by a parameter. C. Calculate the overall count using table calculations in the Explore. D. Create a measure filtered on Category, and make the filter value controlled by a parameter.

Discussion 0

Correct Answer: A Vote an answer