COF-C01

True or False: You can resize a Virtual Warehouse while queries are running.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.A . TrueB . FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

True or False: During data unloading, only JSON and CSV files can be compressed.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/create-file-format.html

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?A . INITTIALLY_SUSPENDED = TRUE/FALSEB . START_AFTCR_CREATE = TRUE/FALSEC . START_TTIME = 60 // (seconds from now)D . STARE . TIME = CURRENF . DATE()View AnswerAnswer: A

What is the minimum duration charged when starting a virtual warehouse?A . 1 secondB . 1 minuteC . 1 hourD . 1 dayView AnswerAnswer: B

Data storage for individual tables can be monitored using which commands and/or object(s)? Choose 2 answersA . SHOW TABLES;B . SHOW STORAGE BY TABLE;C . Information Schema -> TABLE_STORAGE_METRICSD . Information Schema -> TASLE_HISTORYView AnswerAnswer: A,C

Snowflake is designed for which type of workloads? (Choose two.)A . OLAP (Analytics) workloadsB . OLTP (Transactional) workloadsC . Concurrent workloadsD . On-premise workloadsView AnswerAnswer: A,C

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)A . Is available to all Snowflake EditionsB . Is only available to customers with Business Critical EditionC . Restricts or enables access to specific IP addressesD . Is activated using an “ALTER DATABASE” commandView AnswerAnswer: A,C Explanation:...

True or False: Users are able to see the result sets of queries executed by other users that share their same role.A . TrueB . FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Which of the following are options when creating a virtual Warehouse? Choose 2 answersA . Auto-dropB . Auto resizeC . Auto-resumeD . Auto-suspendView AnswerAnswer: C,D Explanation: Reference: https://help.pentaho.com/Documentation/9.1/Products/Create_Snowflake_warehouse https://www.analytics.today/blog/what-is-a-snowflake-virtual-warehouse