Ask Question
Snowflake COF-R02 Practice Test - Questions Answers
Question list
Related questions
Question 1
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
Question 2
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?
Select one.
Question 3
Which of the following statement is true of Snowflake?
Select one.
Question 4
The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html
Question 5
Which of the following statements would be used to export/unload data from Snowflake?
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html
Question 6
True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html
Question 7
What are the three layers that make up Snowflake’s architecture?
Choose 3 answer
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
Question 8
Which type of table corresponds to a single Snowflake session?
Explanation:
Snowflake supports creating temporary tables for storing non-permanent, transitory data (e.g. ETL data, session-specific data). Temporary tables only exist within the session in which they were created and persist only for the remainder of the session.
https://docs.snowflake.com/en/user-guide/tables-temptransient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remainder%20of%20the%20session.
Question 9
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.
Question 10
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.
Question