COF-R02 V1

Which of the following statements are true about Schemas in Snowflake? (Choose two.)A . A Schema may contain one or more Databases B. A Database may contain one or more Schemas C. A Schema is a logical grouping of Database Objects D. Each Schema is contained within a WarehouseView AnswerAnswer:...

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

What are the three things customers want most from their enterprise data warehouse solution? Choose 3 answersA . On-premise availability B. Simplicity C. Open source based D. Concurrency E. PerformanceView AnswerAnswer: B,D,E

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

Which of the following statements would be used to export/unload data from Snowflake?A . COPY INTO @stage B. EXPORT TO @stage C. INSERT INTO @stage D. EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);View AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

When can a Virtual Warehouse start running queries?A . 12am-5am B. Only during administrator defined time slots C. When its provisioning is complete D. After replicationView AnswerAnswer: C Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/

Which type of table corresponds to a single Snowflake session?A . Temporary B. Translent C. Provisional D. PermanentView AnswerAnswer: A Explanation: Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist...

True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide-data-unload.html

True or False: A Virtual Warehouse can be resized while suspended.A . True B. FalseView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse