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 in the 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}.
|
Download Printable PDF. VALID exam to help you PASS. |
 |