COF-C02 exam

Which services does the Snowflake Cloud Services layer manage? (Select TWO).A . Compute resources B. Query execution C. Authentication D. Data storage E. MetadataView AnswerAnswer: C,E Explanation: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html The cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different...

When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:A . Concurrency B. PerformanceView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

What command is used to load files into an Internal Stage within Snowflake?A . PUT B. COPY INTO C. TRANSFER D. INSERTView AnswerAnswer: A Explanation: You must specify an internal stage in the PUT command when uploading files to Snowflake. You must specify the same stage in the COPY INTO...

What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?A . INITTIALLY_SUSPENDED = TRUE/FALSE B. START_AFTCR_CREATE = TRUE/FALSE C. START_TTIME = 60 // (seconds from now) D. START.TIME = CURRENT.DATE()View AnswerAnswer: A

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

What privileges are required to create a task?A . The global privilege create task is required to create a new task. B. Tasks are created at the Application level and can only be created by the Account Admin role. C. Many Snowflake DDLs are metadata operations only, and create task...

What is the minimum Snowflake edition that provides data sharing?A . Standard B. Premier C. Enterprise D. Business Critical EditionView AnswerAnswer: A Explanation: Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#data-sharing

Which statements are true of micro-partitions? Choose 2 answersA . They are approximately 16MB in size B. They are stored compressed only if COMPRESS=TRUE on Table C. They are Immutable D. They are only encrypted in the Enterprise edition and aboveView AnswerAnswer: A,C Explanation: Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1-731ddc983c69

What happens when a Data Provider revokes privileges to a Share on an object in their source database?A . The object immediately becomes unavailable for all Data Consumers B. Any additional data arriving after this point in time will not be visible to Data Consumers C. The Data Consumers stop...

What is the minimum duration charged when starting a virtual warehouse?A . 1 second B. 1 minute C. 1 hour D. 1 dayView AnswerAnswer: B