Ask Question
Snowflake COF-R02 Practice Test - Questions Answers
List of questions
Question 1
True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.
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
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?
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.
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
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html
Question 8
Which type of table corresponds to a single Snowflake session?
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.
Export
If you didn't receive an email within 5 minutes, you should submit a support request to [email protected].
|
BASIC - 1 Month
$
10
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PLUS - 2 Months
$
15
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
PRO - 6 Months
$
40
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
|
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Full latest questions
No CAPTCHA
New Updates
Export to VPLUS
Export to PDF - All questions
Team support
Selling illegal goods, money scams etc.
Serious attack on a group.
Harassing an individual (including doxing)
Threatening or glorifying violence or serious harm, including self-harm
Nudity/Sexual content
Sexually explicit or suggestive imagery or writing involving minors
Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans
Reusing content without attribution (link and blockquotes)
Not in English or has very bad formatting, grammar, and spelling
Author's credential is offensive, spam, or impersonation
Ex. Illegal content, incomplete question...
Question