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: 33)

Page 32 of 83
PDF with 330 Questions

User-level network policies can be created by which of the following roles? (Select TWO).

  1. ROLEADMIN
  2. ACCOUNTADMIN
  3. SYSADMIN
  4. SECURITYADMIN
  5. USERADMIN

Answer(s): D,E

Explanation:

By default, Snowflake allows users to connect to the service from any computer or device IP address. A security administrator (or higher) can create a network policy to allow or deny access to a single IP address or a list of addresses. Network policies currently support only Internet Protocol version 4 (i.e. IPv4) addresses.
An administrator with sufficient permissions can create any number of network policies.


Reference:

https://docs.snowflake.com/en/user-guide/network-policies.html#:~:text=A%20security%20administrator%20(or%20higher,any%20number%20of%20network%20policies.



Which command can be used to load data into an internal stage?

  1. LOAD
  2. copy
  3. GET
  4. PUT

Answer(s): D


Reference:

https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal- stages-7121cc3cc9



What happens when an external or an internal stage is dropped? (Select TWO).

  1. When dropping an external stage, the files are not removed and only the stage is dropped
  2. When dropping an external stage, both the stage and the files within the stage are removed
  3. When dropping an internal stage, the files are deleted with the stage and the files are recoverable
  4. When dropping an internal stage, the files are deleted with the stage and the files are not recoverable
  5. When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

Answer(s): A,C



How long is Snowpipe data load history retained?

  1. As configured in the create pipe settings
  2. Until the pipe is dropped
  3. 64 days
  4. 14 days

Answer(s): C

Explanation:

Bulk data load
Stored in the metadata of the target table for 64 days. Available upon completion of the COPY statement as the statement output.


Reference:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#:~:text=Load%20History,-Bulk%20data%20load&text=Stored%20in%20the%20metadata%20of,statement%20as%20the%20sta tement%20output.&text=Stored%20in%20the%20metadata%20of%20the%20pipe%20for%2014%20 days.






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

COF-R02 Discussions & Posts