nerdexam
Snowflake

COF-C02 · Question #495

Which statements reflect valid commands when using secondary roles? (Select TWO).

The correct answer is C. USE SECONDARY RLES ALL E. Use SECONDARY ROLES NONE. USE SECONDARY ROLES ALL: Activates all granted secondary roles for the current session. USE SECONDARY ROLES NONE: Deactivates all active secondary roles for the current session. Incorrect Commands: The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in…

Account Access and Security

Question

Which statements reflect valid commands when using secondary roles? (Select TWO).

Options

  • AUse SECONDARY ROLES RESUME
  • BUSE SECONDARY ROLES SUSPEND
  • CUSE SECONDARY RLES ALL
  • DUSE SECONDARY ROLES ADD <Role Name>
  • EUse SECONDARY ROLES NONE

How the community answered

(38 responses)
  • A
    5% (2)
  • B
    3% (1)
  • C
    89% (34)
  • D
    3% (1)

Explanation

USE SECONDARY ROLES ALL: Activates all granted secondary roles for the current session. USE SECONDARY ROLES NONE: Deactivates all active secondary roles for the current session. Incorrect Commands: The options referencing "RESUME", "SUSPEND", and "ADD" are not valid commands in the context of secondary roles.

Topics

#Secondary Roles#Access Control#Roles#SQL Commands

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice