Free COF-C02 Exam Braindumps
SnowPro Core Questions 551–555 (page: 112)

Updated On: 10-Feb-2026

Which role can execute the SHOW ORGANIZATION ACCOUNTS command successfully?

  1. ACCOUNTADMIN
  2. SECURITYADMIN
  3. ORGADMIN
  4. USERADMIN

Answer(s): C



Which data types in Snowflake are synonymous for FLOAT? (Choose two.)

  1. DECIMAL
  2. DOUBLE
  3. NUMBER
  4. NUMERIC
  5. REAL

Answer(s): B,E



What ensures that a user with the role SECURITYADMIN can activate a network policy for an individual user?

  1. A role that has been granted the EXECUTE TASK privilege
  2. A role that has been granted the global ATTACH POLICY privilege
  3. Ownership privilege on only the role that created the network policy
  4. Ownership privilege on both the user and the network policy

Answer(s): D



Which function can be combined with the copy command to unload a relational table into a JSON file?

  1. FLATTEN
  2. LISTAGG
  3. OBJECT_CONSTRUCT
  4. PARSE_JSON

Answer(s): C



A user needs to MINIMIZE the cost of large tables that are used to store transitory data. The data does not need to be protected against failures, because the data can be reconstructed outside of Snowflake.

What table type should be used?

  1. Permanent
  2. Transient
  3. Temporary
  4. External

Answer(s): B



Viewing page 112 of 221
Viewing questions 556 - 560 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!