Snowflake COF-R02 Practice Test - Questions Answers, Page 16
List of questions
Related questions
Question 151

What can be used to view warehouse usage over time? (Select Two).
Question 152

Which Snowflake feature is used for both querying and restoring data?
Explanation:
https://docs.snowflake.com/en/user-guide/dataavailability.html#:~:text=Snowflake%20provides%20powerful%20CDP%20features,days%20through%20Snowflake%20Time%20Travel.
Question 153

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?
Explanation:
https://docs.snowflake.com/en/user-guide/security-mfa.html
Question 154

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?
Explanation:
https://dataterrain.com/how-to-change-tracking-using-table-streams-insnowflake/#:~:text=A%20stream%20is%20a%20Snowflake,as%20metadata%20about%20each%20change.
Question 155

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

What feature can be used to reorganize a very large table on one or more columns?
Explanation:
https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html
Question 157

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

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

What Snowflake role must be granted for a user to create and manage accounts?
Explanation:
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html
Question 160

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