A developer has a persistent derived table view called user_facts that contains aggregated data for...

Google LookML-Developer Question Answer

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?

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

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

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

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

Google LookML-Developer View All Questions

Google LookML-Developer Summary

Vendor: Google
Product: LookML-Developer
Update on: Jul 30, 2025
Questions: 50

Price: $52.5 ~~$149.99~~

Buy Now LookML-Developer PDF + Testing Engine Pack

Two developers are working on adding a new view to a project.

Summer Special Sale Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: vce65

A developer has a persistent derived table view called user_facts that contains aggregated data for...

The Answer Is:

Google LookML-Developer Summary

Payments We Accept

Contact Us