COF-C02 exam

How often are encryption keys automatically rotated by Snowflake?A . 30 Days B. 60 Days C. 90 Days D. 365 DaysView AnswerAnswer: A Explanation: All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old. Active keys are retired, and new keys are created. When...

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?A . An FTP server with TLS encryption B. An HTTPS server with WebDAV C. A Google Cloud storage bucket D. A Windows server file share on AzureView AnswerAnswer: D

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?A . Informatica B. Power Bl C. Adobe D. Data RobotView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

What are the default Time Travel and Fail-safe retention periods for transient tables?A . Time Travel - 1 day. Fail-safe - 1 day B. Time Travel - 0 days. Fail-safe - 1 day C. Time Travel - 1 day. Fail-safe - 0 days D. Transient tables are retained in neither...

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.A . True B. FalseView AnswerAnswer: A

Which interfaces can be used to create and/or manage Virtual Warehouses?A . The Snowflake Web Interface (UI) B. SQL commands C. Data integration tools D. All of the aboveView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses.html

Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI) Choose 2 answersA . SnowSQL B. ODBC C. R D. HIVEView AnswerAnswer: A,B Explanation: Reference: https://docs.snowflake.com/en/user-guide/connecting.html

Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answersA . Their default role should be set to SYSTEMADMIN (the lower of the two) B. They should not set up multi_Factor Authentication (MFA)―as administrator they may need to change the MFA settings and those...

When is the result set cache no longer available? (Select TWO)A . When another warehouse is used to execute the query B. When another user executes the query C. When the underlying data has changed D. When the warehouse used to execute the query is suspended E. When it has...

What SQL command would be used to view all roles that were granted to user.1?A . show grants to user USER1; B. show grants of user USER1; C. describe user USER1; D. show grants on user USER1;View AnswerAnswer: A