- (Exam Topic 1)
Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what? Select one.
Correct Answer:C
- (Exam Topic 3)
Which file formats are supported for unloading data from Snowflake? (Choose two.)
Correct Answer:CE
Reference:
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported File Formats,-Th
comma (i.e. CSV).&text=File format options specify the,the format of th
- (Exam Topic 3)
Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?
Correct Answer:B
- (Exam Topic 1)
True or False: Pipes can be suspended and resumed.
Correct Answer:A
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:
- (Exam Topic 2)
Which stage type can be altered and dropped?
Correct Answer:C
https://docs.snowflake.com/en/user-guide/data-load-local-file-system-create-stage.html#table-stages