COF-C02 exam

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 encryptionB . An HTTPS server with WebDAVC . A Google Cloud storage bucketD . A Windows server file share on AzureView AnswerAnswer: D

What is the purpose of an External Function?A . To call code that executes outside of SnowflakeB . To run a function in another Snowflake databaseC . To share data in Snowflake with external partiesD . To ingest data from on-premises data sourcesView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/sql-reference/external-functions.html

What feature can be used to reorganize a very large table on one or more columns?A . Micro-partitionsB . Clustering keysC . Key partitionsD . Clustered partitionsView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

What is the default File Format used in the COPY command if one is not specified?A . CSVB . JSONC . ParquetD . XMLView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?A . The primary cluster in the virtual warehouseB . The entire virtual warehouseC . The database in which the virtual warehouse residesD . The Queries currently being run on the virtual warehouseView AnswerAnswer: B Explanation: https://docs.snowflake.com/en/user-guide/warehouses-overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual%20clusters %20in%20the%20warehouse.

What is a best practice after creating a custom role?A . Create the custom role using the SYSADMIN role.B . Assign the custom role to the SYSADMIN roleC . Assign the custom role to the PUBLIC roleD . Add__CUSTOM to all custom role namesView AnswerAnswer: B Explanation: When creating roles...

What is a key feature of Snowflake architecture?A . Zero-copy cloning creates a mirror copy of a database that updates with the originalB . Software updates are automatically applied on a quarterly basisC . Snowflake eliminates resource contention with its virtual warehouse implementationD . Multi-cluster warehouses allow users to run...

How often are encryption keys automatically rotated by Snowflake?A . 30 DaysB . 60 DaysC . 90 DaysD . 365 DaysView AnswerAnswer: C

What Snowflake role must be granted for a user to create and manage accounts?A . ACCOUNTADMINB . ORGADMINC . SECURITYADMIND . SYSADMINView AnswerAnswer: A Explanation: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

What data is stored in the Snowflake storage layer? (Select TWO).A . Snowflake parametersB . Micro-partitionsC . Query historyD . Persisted query resultsE . Standard and secure view resultsView AnswerAnswer: B, D