- (Topic 3)
If file format options are specified in multiple locations, the load operation selects which option FIRST to apply in order of precedence?
Correct Answer:
D
When file format options are specified in multiple locations, the load operation applies the options in the following order of precedence: first, the COPY INTO TABLE statement; second, the stage definition; and third, the table definition1
- (Topic 4)
How can a dropped internal stage be restored?
Correct Answer:
D
Once an internal stage is dropped in Snowflake, it cannot be recovered or restored using Time Travel or UNDROP commands. The only option is to recreate the dropped stage
- (Topic 4)
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
Correct Answer:
BC
The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT. These data types support the storage and querying of semi- structured data, allowing for the creation of complex, nested data structures
- (Topic 2)
Which columns are part of the result set of the Snowflake LATERAL FLATTEN command? (Choose two.)
Correct Answer:
BD
The LATERAL FLATTEN command in Snowflake produces a result set that includes several columns, among which PATH and INDEX are includedPATH indicates the path to the element within a data structure that needs to be flattened, and INDEX represents the index of the element if it is an array2.
- (Topic 2)
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Correct Answer:
D
The minimum edition of Snowflake required to use a SCIM security integration is the Enterprise Edition. SCIM integrations are used for automated management of user identities and groups, and this feature is available starting from the Enterprise Edition of Snowflake. References: [COF-C02] SnowPro Core Certification Exam Study Guide