Week 4-SnowPro Core Certification; Questions and Answers Already Passed

Week 4-SnowPro Core Certification; Questions and
Answers Already Passed

Lesson 6: File Formats & the Load Wizard


- Lesson 7: Meet DORA


- Lesson 8: Staging Data


- Level Up: Data Loading


- Level Up: Resource Monitoring


In a load process, data arrives at these Snowflake objects in what sequence?


Pipe -> Stage -> Table


Table -> Stage -> Pipe


Stage -> Pipe -> Table


Table -> Pipe -> Stage


Stage -> Table -> Pipe Correct Ans-Stage -> Pipe -> Table




When deciding whether to use bulk loading or Snowpipe, which factors should you consider?


How often you will load the data


Location of data (local system or cloud)


Data format (structured or semi-structured)

, Week 4-SnowPro Core Certification; Questions and
Answers Already Passed

Number of files you will load at one time Correct Ans-How often you will load the data


Location of data (local system or cloud)


Number of files you will load at one time




Snowflake supports landing data into which locations?


Internal stage on cloud storage platform


External stage on cloud storage platform


Internal stage on your local system Correct Ans-Internal stage on cloud storage platform


External stage on cloud storage platform




When loading data in Snowflake, which statements are true?


All external cloud storage services charge the same price for data transfer.


You can query a portion of data in external cloud storage without loading into Snowflake.


The Snowflake Data Load wizard has a limitation on file size.


The COPY INTO command cannot be used to load single files. Correct Ans-You can query a

portion of data in external cloud storage without loading into Snowflake.