Free COF-C02 Exam Braindumps
SnowPro Core Questions 591–595 (page: 120)

Updated On: 10-Feb-2026

What information is stored in the ACCESS_HISTORY view?

  1. History of the files that have been loaded into Snowflake
  2. Names and owners of the roles that are currently enabled in the session
  3. Query details such as the objects included and the user who executed the query
  4. Details around the privileges that have been granted for all objects in an account

Answer(s): C



What privilege does a user need in order to receive or request data from the Snowflake Marketplace?

  1. CREATE DATA EXCHANGE LISTING
  2. CREATE SHARE
  3. IMPORT SHARE
  4. IMPORTED PRIVILEGES

Answer(s): C



Which Snowflake database object can be shared with other accounts?

  1. Tasks
  2. Pipes
  3. Secure User-Defined Functions (UDFs)
  4. Stored Procedures

Answer(s): C


Reference:

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



Which identity providers are valid type values for federated authentication on the SAML_IDENTITY_PROVIDER parameter? (Choose two.)

  1. Identity Access Management (IAM)
  2. Microsoft Active Directory Federation Services (AD FS)
  3. OAuth
  4. Okta
  5. PingFederate

Answer(s): B,D



A Snowflake user wants to share data using my_share with account xy12345.

Which command should be used?

  1. grant usage on share my_share to account xy12345;
  2. grant select on share my_share to account xy12345;
  3. alter share my_share add accounts = xy12345;
  4. alter account xy12345 add share my_share;

Answer(s): C



Viewing page 120 of 221
Viewing questions 596 - 600 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!