Google Looker LookML Developer Exam LookML-Developer Question # 2 Topic 1 Discussion

Google Looker LookML Developer Exam LookML-Developer Question # 2 Topic 1 Discussion

LookML-Developer Exam Topic 1 Question 2 Discussion:
Question #: 2
Topic #: 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.

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


B.

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


C.

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


D.

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


Get Premium LookML-Developer Questions

Contribute your Thoughts:


Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.