What does the LATERAL modifier for the FLATTEN function do?
A.
Casts the values of the flattened data
B.
Extracts the path of the flattened data
C.
Joins information outside the object with the flattened data
D.
Retrieves a single instance of a repeating element in the flattened data
The Answer Is:
C
This question includes an explanation.
Explanation:
The LATERAL modifier for the FLATTEN function allows joining information outside the object (such as other columns in the source table) with the flattened data, creating a lateral view that correlates with the preceding tables in the FROM clause2345. References: [COF-C02] SnowPro Core Certification Exam Study Guide
SnowPro-Core PDF/Engine
Printable Format
Value of Money
100% Pass Assurance
Verified Answers
Researched by Industry Experts
Based on Real Exams Scenarios
100% Real Questions
Get 60% Discount on All Products,
Use Coupon: "8w52ceb345"