CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Snowflake
  5. COF-R02

Free COF-R02 Exam Braindumps (page: 3)

Page 2 of 83
PDF with 330 Questions

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

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

Answer(s): A


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.

  1. True
  2. False

Answer(s): A


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

  1. Compute
  2. Tri-Secret Secure
  3. Storage
  4. Cloud Services

Answer(s): A,C,D


Reference:

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



Which type of table corresponds to a single Snowflake session?

  1. Temporary
  2. Translent
  3. Provisional
  4. Permanent

Answer(s): 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.


Reference:

https://docs.snowflake.com/en/user-guide/tables-temp- transient.html#:~:text=Snowflake%20supports%20creating%20temporary%20tables,the%20remaind er%20of%20the%20session.






Post your Comments and Discuss Snowflake COF-R02 exam with other Community members:

COF-R02 Discussions & Posts