COF-C02 V2

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

What is the MOST performant file format for loading data in Snowflake?A . CSV (Unzipped) B. Parquet C. CSV (Gzipped) D. ORCView AnswerAnswer: A

What features does Snowflake Time Travel enable?A . Querying data-related objects that were created within the past 365 days B. Restoring data-related objects that have been deleted within the past 90 days C. Conducting point-in-time analysis for Bl reporting D. Analyzing data usage/manipulation over all periods of timeView AnswerAnswer: B...

Which of the following describes external functions in Snowflake?A . They are a type of User-defined Function (UDF). B. They contain their own SQL code. C. They call code that is stored inside of Snowflake. D. They can return multiple rows for each row receivedView AnswerAnswer: A Explanation: External functions...

Which of the following can be executed/called with Snowpipe?A . A User Defined Function (UDF) B. A stored procedure C. A single copy_into statement D. A single insert__into statementView AnswerAnswer: C

Which is the MINIMUM required Snowflake edition that a user must have if they want to use AWS/Azure Privatelink or Google Cloud Private Service Connect?A . Standard B. Premium C. Enterprise D. Business CriticalView AnswerAnswer: D Explanation: https://docs.snowflake.com/en/user-guide/privatelink-azure.html

Will data cached in a warehouse be lost when the warehouse is resized?A . Possibly, if the warehouse is resized to a smaller size and the cache no longer fits. B. Yes. because the compute resource is replaced in its entirety with a new compute resource. C. No. because the...

True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.A . True B. FalseView AnswerAnswer: A Explanation: Query result cache is all about fetching the data from cloud services layer and saving the cost by not running...

True or False: Fail-safe can be disabled within a Snowflake account.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html Separate and distinct from Time Travel, Fail-safe ensures historical data is protected in the event of a system failure or other catastrophic event, e.g. a hardware failure or security breach....

When unloading to a stage, which of the following is a recommended practice or approach?A . Set SINGLE: = true for larger files B. Use OBJECT_CONSTRUCT ( * ) when using Parquet C. Avoid the use of the CAST function D. Define an individual file formatView AnswerAnswer: D