CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-R02

Free COF-R02 Exam Braindumps (page: 41)

Page 40 of 83
PDF with 330 Questions

What SQL command would be used to view all roles that were granted to user.1?

  1. show grants to user USER1;
  2. show grants of user USER1;
  3. describe user USER1;
  4. show grants on user USER1;

Answer(s): A



Which of the following can be executed/called with Snowpipe?

  1. A User Defined Function (UDF)
  2. A stored procedure
  3. A single copy_into statement
  4. A single insert into statement

Answer(s): C



What Snowflake role must be granted for a user to create and manage accounts?

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

Answer(s): A


Reference:

https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html



When unloading to a stage, which of the following is a recommended practice or approach?

  1. Set SINGLE: = true for larger files
  2. Use OBJECT_CONSTRUCT ( * ) when using Parquet
  3. Avoid the use of the CAST function
  4. Define an individual file format

Answer(s): C






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

COF-R02 Discussions & Posts