What operations can be performed while loading a simple CSV file into a Snowflake table using the COPY INTO command? (Select TWO).
Correct Answer: B,D
When loading a simple CSV file into a Snowflake table using the COPY INTO command, you can perform various transformations and adjustments on the data as part of the loading process. Specifically, you can: B . Reorder the columns: Specify the order of columns in the COPY INTO command to match the structure of the target table if it differs from the order of columns in the source CSV file. D . Convert the datatypes: Explicitly convert the datatypes of the data being loaded to match the datatypes of the columns in the target table. This can be necessary when the source data's format does not match the target table's expected datatype. Reference: Snowflake Documentation: Using the COPY INTO Command for Data Loading
Question 512
Which object can be used with Secure Data Sharing?
Correct Answer: A
Views can be used with Secure Data Sharing in Snowflake. Materialized views, external tables, and UDFs are not typically shared directly for security and performance reasons2.