Free SnowPro Core Exam Braindumps (page: 19)

Page 18 of 287

Which of the following is true of Snowpipe via REST API? (Choose two.)

  1. You can only use it on Internal Stages
  2. All COPY INTO options are available during pipe creation
  3. Snowflake automatically manages the compute required to execute the Pipe's COPY INTO commands
  4. Snowpipe keeps track of which files it has loaded

Answer(s): C,D



Snowflake recommends, as a minimum, that all users with the following role(s) should be enrolled in Multi-Factor Authentication (MFA):

  1. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
  2. SECURITYADMIN, ACCOUNTADMIN, SYSADMIN
  3. SECURITYADMIN, ACCOUNTADMIN
  4. ACCOUNTADMIN

Answer(s): D


Reference:

https://docs.snowflake.com/en/user-guide/security-mfa.html



When can a Virtual Warehouse start running queries?

  1. 12am-5am
  2. Only during administrator defined time slots
  3. When its provisioning is complete
  4. After replication

Answer(s): C



True or False: Users are able to see the result sets of queries executed by other users that share their same role.

  1. True
  2. False

Answer(s): B


Reference:

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






Post your Comments and Discuss Snowflake SnowPro Core exam with other Community members:

SnowPro Core Discussions & Posts