COF-C02 V5

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)A . Data can be filtered by an optional where clauseB . Incoming data can be joined with other tablesC . Columns can be reorderedD . Columns can be omittedE . Row level access...

Which Snowflake technique can be used to improve the performance of a query?A . ClusteringB . IndexingC . FragmentingD . Using INDEX__HINTSView AnswerAnswer: A Explanation: Clustering is a technique used in Snowflake to improve the performance of queries. It involves organizing the data in a table into micro-partitions based on...

What is a responsibility of Snowflake's virtual warehouses?A . Infrastructure managementB . Metadata managementC . Query executionD . Query parsing and optimizationE . Management of the storage layerView AnswerAnswer: C Explanation: The primary responsibility of Snowflake’s virtual warehouses is to execute queries. Virtual warehouses are one of the key components...

What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)A . The ability to scale up warehousesB . The use of warehouse auto scalingC . The ability to resize warehousesD . Use of multi-clustered warehousesE . The use of warehouse indexingView AnswerAnswer: B, D Explanation: Snowflake’s architecture...

The fail-safe retention period is how many days?A . 1 dayB . 7 daysC . 45 daysD . 90 daysView AnswerAnswer: B Explanation: Fail-safe is a feature in Snowflake that provides an additional layer of data protection. After the Time Travel retention period ends, Fail-safe offers a non-configurable 7-day period...

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?A . STATEMENT_TIMEOUT__IN__SECONDSB . STATEMENT_QUEUED_TIMEOUT_IN_SECONDSC . MAX_CONCURRENCY__LEVELD . QUERY_TIMEOUT_IN_SECONDSView AnswerAnswer: B Explanation: The parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS sets the limit for a query to wait in the queue in order to get...

What is the default character set used when loading CSV files into Snowflake?A . UTF-8B . UTF-16C . ISO S859-1D . ANSI_X3.AView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/intro-summary-loading.html#:~:text=For%20delimited%20files%20(CSV%2C%20TSV,encoding%20to%20use%20for% 20loading. For delimited files (CSV, TSV, etc.), the default character set is UTF-8. To use any other characters sets, you must explicitly specify the...

Which cache type is used to cache data output from SQL queries?A . Metadata cacheB . Result cacheC . Remote cacheD . Local file cacheView AnswerAnswer: B Explanation: The Result cache is used in Snowflake to cache the data output from SQL queries. This feature is designed to improve performance...

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).A . Compute Credits = 50 Credits Cloud Services = 10B . Compute Credits = 80 Credits Cloud Services = 5C . Compute Credits = 10 Credits Cloud Services = 9D . Compute Credits = 120 Credits...

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).A . Internal stagesB . Incremental backupsC . Time TravelD . Zero-copy clonesE . Fail-safeView AnswerAnswer: C, E Explanation: Snowflake’s Continuous Data Protection (CDP) encompasses a set of features that help protect data stored in Snowflake against human...