Free Snowflake COF-C03 Exam Dumps Questions & Answers

What command is used to export or unload data from Snowflake?

• A.  COPY INTO @mystage
• B.  PUT @mystage
• C.  GET @mystage
• D.  INSERT @mystage

What is the recommended use for the COPY INTO < location > SINGLE = TRUE command?

• A.  To copy data and parse the results into single stages
• B.  To unload a single file from a table into a stage
• C.  To load an individual file
• D.  To load data without duplications

What happens when a suspended virtual warehouse is resized in Snowflake?

• A.  The suspended warehouse is resumed and new compute resources are provisioned immediately.
• B.  It will return a warning.
• C.  It will return an error.
• D.  The additional compute resources are provisioned when the warehouse is resumed.

Which security feature supports the replacement of active keys to enhance key-pair authentication?

• A.  Passkeys
• B.  Authentication
• C.  Rotation
• D.  Time-based one-time passcodes

What information in a secure User-Defined Function, or UDF, is only available to authorized users? Select TWO.

• A.  Parameter types
• B.  Handler language
• C.  The UDF definition code
• D.  List of data imports
• E.  Return type