COF-C03 Practice Question: Snowflake AI Data Cloud Features and Architecture

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

• ✗

  CREATE STAGE my_stage URL='s3://mybucket/path/' INTEGRATION=MY_S3_INT;

  Why it's wrong here

  The parameter name is incorrect; Snowflake uses STORAGE_INTEGRATION, not INTEGRATION. Using INTEGRATION will result in a syntax error. The correct parameter is STORAGE_INTEGRATION, which is specifically designed to reference a storage integration object for external stages.

• ✗

  CREATE STAGE my_stage URL='s3://mybucket/path/' STORAGE_INTEGRATION='MY_S3_INT';

  Why it's wrong here

  Although the parameter name is correct, the value is enclosed in single quotes. In Snowflake, the STORAGE_INTEGRATION parameter expects an identifier, not a string literal. Using quotes will cause an error because Snowflake interprets it as a string rather than an object identifier.

• ✓

  CREATE STAGE my_stage URL='s3://mybucket/path/' STORAGE_INTEGRATION=MY_S3_INT;

  Why this is correct

  This statement correctly creates an external stage pointing to the S3 bucket path and references the existing storage integration MY_S3_INT using the STORAGE_INTEGRATION parameter. This allows Snowflake to access the S3 bucket using the IAM role configured in the integration, avoiding the need to embed credentials in the stage definition.

• ✗

  CREATE STAGE my_stage URL='s3://mybucket/path/' CREDENTIALS=(AWS_KEY_ID='...' AWS_SECRET_KEY='...');

  Why it's wrong here

  This statement creates a stage with inline AWS credentials instead of using a storage integration. While it may work, it is less secure and does not leverage the centralized access control provided by storage integrations. The scenario specifies that the storage integration already exists, so it should be used.