COF-C02 Question 94

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose C1

  LOAD_MODE is not a standard copy option parameter within the Snowflake native SQL syntax for the COPY INTO <table> statement.

• Chose D1

  The LOAD_MODE parameter in the COPY INTO <table> command controls how unstructured or semi-structured data is handled during loading. Specifically setting LOAD_MODE = FULL_INGEST enables loading of unstructured data (like PDFs, audio, video, images, documents) directly into a VARIANT column in Snowflake