Download SnowPro Core Recertification.VCEPlus.COF-R02.2023-01-09.1e.30q.vcex

File Info

Exam	SnowPro Core Recertification
Number	COF-R02
File Name	SnowPro Core Recertification.VCEPlus.COF-R02.2023-01-09.1e.30q.vcex
Size	17 Kb
Posted	January 09, 2023
Downloads	2

How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Coupon: EXAMFILESCOM
With discount: 20%

Demo Questions

Question 1

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

A: True
B: False

Correct Answer: B

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.

A: More micro-partitions
B: Better query scheduling
C: Double the numbers of servers In the compute duster
D: Higher storage costs

Correct Answer: C

Question 3

Which of the following statement is true of Snowflake?
Select one.

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

Correct Answer: A

Question 4

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

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

Correct Answer: AC

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?

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

Correct Answer: A

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.

A: True
B: False

Correct Answer: A

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

A: Compute
B: Tri-Secret Secure
C: Storage
D: Cloud Services

Correct Answer: ACD

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

Question 8

Which type of table corresponds to a single Snowflake session?

A: Temporary
B: Translent
C: Provisional
D: Permanent

Correct Answer: A

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.