COF-C02

True or False: When you create a custom role, it is a best practice to immediately grant that role to ACCOUNTADMIN.A . True B. FalseView AnswerAnswer: B Explanation: Reference: https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

Which of the following statements are true about Schemas in Snowflake? (Choose two.)A . A Schema may contain one or more Databases B. A Database may contain one or more Schemas C. A Schema is a logical grouping of Database Objects D. Each Schema is contained within a WarehouseView AnswerAnswer:...

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