COF-C01

True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-overview.html

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)A . UsersB . TablesC . DatabasesD . Internal StagesView AnswerAnswer: B,C,D

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.A . TrueB . FalseView AnswerAnswer: B

When loading data into Snowflake, the COPY command supports: Choose 2 answersA . JoinsB . FittersC . Data type conversionsD . Column reorderingE . AggregatesView AnswerAnswer: C,D

Which formats are supported for unloading data from Snowflake? Choose 2 answersA . Delimited (CSV, TSV, etc.)B . AvroC . JSOND . ORCView AnswerAnswer: A,C Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:A . Configure the Maximum Clusters setting to “Auto-Scale”B . Set the Warehouse type to “Auto”C . Set the Minimum Clusters and Maximum Clusters settings to the same valueD . Set the Minimum Clusters and Maximum Clusters settings to the...

How a Snowpipe charges calculated?A . Per-second/per Warehouse sizeB . Per-second/per-core granularityC . Number of Pipes in accountD . Total storage bucket sizeView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-load-snowpipe-billing.html

Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):A . SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMINB . SECURITYADMIN ACCOUNTADMIN, SYSADMINC . SECURITYADMIN, ACCOUNTADMIND . ACCOUNTADMINView AnswerAnswer: D Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

True or False: Data in Fail-safe can be deleted by a user or the Snowflake team before it expires.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://blog.knoldus.com/ksnow-time-travel-and-fail-safe-in-snowflake/

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)A . CustomB . EconomyC . OptimizedD . StandardView AnswerAnswer: B,D Explanation: Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance