LookML-Developer by Google Actual Free Exam Questions And Answers

Question 1

A developer has a persistent derived table view called user_facts that contains aggregated data for each user. The developer needs to query the data from this table in another derived table view called user_region_facts.
Which strategy should the developer use to write the query for user_region_facts that will leverage the existing derived table?

A. Writhe the query form user_facts into a common table expression (WITH user_facts AS...).

B. Write a subquery in the FROM clause and alias with ${user_facts}.

C. Copy the name of the database table in the scratch schema for the user_facts derived table.

D. Use ${user_facts.SQL_TABLE_NAME} to reference the user_facts derived table.

Discussion 0

Correct Answer: A Vote an answer

Question 2

The developer has moved the orders Explore (shown below) from model_a to model_b, where both models are in the same project, and all users have access to both models.
Connection: "demo"
include: ".view"
explore: orders {}
What will happen after making this change?

A. Dashboard tiles and Looks will be automatically pointed to the orders Explore in model_b.

B. Dashboard tiles and Looks that rely on this Explore will return an error.

C. Dashboard tiles and Looks will redirect to the new database connection.

D. Dashboard tiles and Looks that rely on this Explore will be deleted.

Discussion 0

Correct Answer: D Vote an answer

Question 3

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?

A. In the master branch, with both users writing to the branch

B. In one user's personal branch, with both users writing to the branch

C. In each of their personal branches, with each user writing code separately

D. In a new shared branch created from the master branch

Discussion 0

Correct Answer: D Vote an answer

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?

A. persist_for: "12 hours"

B. datagroup: 12_hours {
max_cache_age: "12 hours"
}

C. sql_trigger_value: SELECT FLOOR{UNIX_TIMESTAMP{} / {6*60*60}} ;;

D. persist_with: "12 hours"

Discussion 0

Correct Answer: D Vote an answer

Question 5

A user reports that a query run against the orders Explore takes a long time to run. The query includes only fields from the users view. Data for both views is updated in real time. The developer runs the following query in SQL Runner and quickly receives results:
SELECT * FROM users.
What should the developer do to improve the performance of the query in the Explore?

A. Create an ephemeral derived table from the user's query.

B. Add persist_for: "24 hours" to the orders Explore.

C. Create a persistent derived table from the user's query.

D. Create an Explore with users as the base table.

Discussion 0

Correct Answer: D Vote an answer

Question 6

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