Google Exam LookML-Developer Topic 9 Question 11 Discussion

Actual exam question for Google's Looker LookML Developer exam

Question #: 11
Topic #: 9

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?

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

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

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

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

Show Suggested Answer

Suggested Answer: C

by Rosio at May 05, 2022, 02:17 AM

Limited Time Offer

25%

Off

Get Premium LookML-Developer Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!