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

Download Exam

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
Download SnowPro Core Recertification.VCEPlus.COF-R02.2023-01-09.1e.30q.vcex

How to open VCEX & EXAM Files?

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

Purchase

Coupon: MASTEREXAM
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.

  • A: True
  • B: False

Correct Answer: A




Question 10

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

  • A: True
  • B: False

Correct Answer: B










CONNECT US

Facebook

Twitter

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files