Free COF-C02 Exam Braindumps
SnowPro Core Questions 341–345 (page: 70)

Updated On: 10-Feb-2026

The bulk data load history that is available upon completion of the COPY statement is stored where and for how long?

  1. In the metadata of the target table for 14 days
  2. In the metadata of the pipe for 14 days
  3. In the metadata of the target table for 64 days
  4. In the metadata of the pipe for 64 days

Answer(s): C



User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.

Which command will show all privileges granted to that schema?

  1. SHOW GRANTS ON ROLE DATA_SCIENCE
  2. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
  3. SHOW GRANTS TO USER INQUISITIVE_PERSON
  4. SHOW GRANTS OF ROLE DATA_SCIENCE

Answer(s): B



Which of the following are characteristics of security in Snowflake?

  1. Account and user authentication is only available with the Snowflake Business Critical edition.
  2. Support for HIPAA and GDPR compliance is available for UI Snowflake editions.
  3. Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher
  4. Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

Answer(s): C



Which of the following objects can be shared through secure data sharing?

  1. Masking policy
  2. Stored procedure
  3. Task
  4. External table

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/data-sharing-intro.html



Which formats does Snowflake store unstructured data in? (Choose two.)

  1. GeoJSON
  2. Array
  3. XML
  4. Object
  5. BLOB

Answer(s): B,D



Viewing page 70 of 221
Viewing questions 346 - 350 out of 1300 questions


Post your Comments and Discuss Snowflake COF-C02 exam prep with other Community members:

AI Tutor AI Tutor 👋 I’m here to help!