Free COF-R02 Exam Braindumps (page: 40)

Page 39 of 83

A company strongly encourages all Snowflake users to self-enroll in Snowflake's default Multi-Factor Authentication (MFA) service to provide increased login security for users connecting to Snowflake.
Which application will the Snowflake users need to install on their devices in order to connect with MFA?

  1. Okta Verify
  2. Duo Mobile
  3. Microsoft Authenticator
  4. Google Authenticator

Answer(s): B


Reference:

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



Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

  1. Pipes
  2. Streams
  3. Tasks
  4. Procedures

Answer(s): B


Reference:

https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20ch ange.



What tasks can be completed using the copy command? (Select TWO)

  1. Columns can be aggregated
  2. Columns can be joined with an existing table
  3. Columns can be reordered
  4. Columns can be omitted
  5. Data can be loaded without the need to spin up a virtual warehouse

Answer(s): C,D



What feature can be used to reorganize a very large table on one or more columns?

  1. Micro-partitions
  2. Clustering keys
  3. Key partitions
  4. Clustered partitions

Answer(s): B


Reference:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html






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

COF-R02 Discussions & Posts