COF-C02 exam

What is the recommended file sizing for data loading using Snowpipe?A . A compressed file size greater than 100 MB, and up to 250 MBB . A compressed file size greater than 100 GB, and up to 250 GBC . A compressed file size greater than 10 MB, and up...

What is the minimum Snowflake edition required to create a materialized view?A . Standard EditionB . Enterprise EditionC . Business Critical EditionD . Virtual Private Snowflake EditionView AnswerAnswer: B Explanation: Materialized views in Snowflake are a feature that allows for the pre-computation and storage of query results for faster query...

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?A . SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;B . SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())C . SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;D ....

In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)A . Bytes scannedB . Bytes sent over the networkC . Number of partitions scannedD . Percentage scanned from cacheE . External bytes scannedView AnswerAnswer: A, C Explanation:...

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?A . Compute layerB . Storage layerC . Cloud infrastructure layerD . Cloud services layerView AnswerAnswer: D Explanation: Query compilation in Snowflake occurs in the Cloud Services layer. This layer is responsible for coordinating and managing all aspects...

Which of the following conditions must be met in order to return results from the results cache? (Select TWO).A . The user has the appropriate privileges on the objects associated with the queryB . Micro-partitions have been reclustered since the query was last runC . The new query is run...

Which statement about billing applies to Snowflake credits?A . Credits are billed per-minute with a 60-minute minimumB . Credits are used to pay for cloud data storage usageC . Credits are consumed based on the number of credits billed for each hour that a warehouse runsD . Credits are consumed...

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)A . Customer-managed encryption keys through Tri-Secret SecureB . Automatic encryption of all dataC . Up to 90 days of data recovery through Time TravelD . Object-level access controlE . Column-level security to apply data masking policies...

Which data types does Snowflake support when querying semi-structured data? (Select TWO)A . VARIANTB . ARRAYC . VARCHARD . XMLE . BLOBView AnswerAnswer: A, B Explanation: https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY. The maximum length...

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command: COPY INTO my__table FROM @my__stage; The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer...