Get Instant Access of 100% Real Snowflake COF-C02 Exam Questions with Verified Answers [Q13-Q37]

NO.13 Which Snowflake SQL statement would be used to determine which users and roles have access to a role called MY_ROLE?

NO.14 If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

NO.15 What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

NO.16 What command is used to load files into an Internal Stage within Snowflake?

NO.17 What is the most granular object that the Time Travel retention period can be defined on?

NO.18 True or False: Once created, a micro-partition will never be changed.

NO.19 Which Snowflake tool would be BEST to troubleshoot network connectivity?

NO.20 Which Snowflake function will interpret an input string as a JSON document, and produce a VARIANT value?

NO.21 What is the minimum Snowflake edition that customers planning on storing protected information in Snowflake should consider for regulatory compliance?

NO.22 How would you determine the size of the virtual warehouse used for a task?

NO.23 Which command is used to unload data from a Snowflake table into a file in a stage?

NO.24 Which Snowflake layer is always leveraged when accessing a query from the result cache?

NO.25 True or False: Bulk unloading of data from Snowflake supports the use of a SELECT statement.

NO.26 Which Snowflake technique can be used to improve the performance of a query?

NO.27 To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

NO.28 Assume there is a table consisting of five micro-partitions with values ranging from A to Z.
Which diagram indicates a well-clustered table?

NO.29 Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

NO.30 True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

NO.31 Which statements are true of micro-partitions? Choose 2 answers

NO.32 What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

NO.33 Files have been uploaded to a Snowflake internal stage. The files now need to be deleted.
Which SQL command should be used to delete the files?

NO.34 When loading data into Snowflake, the COPY command supports: Choose 2 answers

NO.35 Which of the following accurately describes shares?

NO.36 A user needs to create a materialized view in the schema MYDB.MYSCHEMA.
Which statements will provide this access?

NO.37 Which Snowflake technique can be used to improve the performance of a query?