COF-R02: SnowPro Core Recertification - Free download from ExamHUB

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True
False

Correct answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?

Select one.

More micro-partitions
Better query scheduling
Double the numbers of servers In the compute duster
Higher storage costs

Correct answer: C

Explanation:

Which of the following statement is true of Snowflake?

Select one.

It was built specifically for the cloud
it was built as an on-premises solution and then potted to the cloud
It was designed as a hybrid database to allow customers to store data either on premises or in the cloud
It was built for Hadoop architecture
It's based on an Oracle Architecture

Correct answer: A

Explanation:

The number of queries that a Virtual Warehouse can concurrently process is determined by:

Choose 2 answers

The complexity of each query
The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account
The size of the data required for each query
The tool that s executing the query

Correct answer: AC

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/warehouses-overview.html

Which of the following statements would be used to export/unload data from Snowflake?

COPY INTO @stage
EXPORT TO @stage
INSERT INTO @stage
EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Correct answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-unload-considerations.html

True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

True
False

Correct answer: A

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-unload-prepare.html

What are the three layers that make up Snowflake's architecture?

Choose 3 answer

Compute
Tri-Secret Secure
Storage
Cloud Services

Correct answer: ACD

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html

Which type of table corresponds to a single Snowflake session?

Temporary
Translent
Provisional
Permanent

Correct answer: A

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.

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.

True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

True
False

Correct answer: A

Explanation:

True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

True
False

Correct answer: B

Explanation:

Vendor:	Snowflake
Exam Code:	COF-R02
Exam Name:	SnowPro Core Recertification
Date:	Jan 09, 2023
File Size:	17 KB

Download SnowPro Core Recertification.COF-R02.VCEplus.2023-01-09.30q.vcex

How to open VCEX files?

Demo Questions

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Question 7

Question 8

Question 9

Question 10

ProfExam at a 20% markdown