- (Topic 1)
Which command is used to unload data from a Snowflake table into a file in a stage?
Correct Answer:
A
The COPY INTO command is used in Snowflake to unload data from a table into a file in a stage. This command allows for the export of data from Snowflake tables into flat files, which can then be used for further analysis, processing, or storage in external systems.
References:
✑ Snowflake Documentation on Unloading Data
✑ Snowflake SnowPro Core: Copy Into Command to Unload Rows to Files in Named Stage
- (Topic 4)
Which Snowflake data types can be used to build nested hierarchical data? (Select TWO)
Correct Answer:
BC
The Snowflake data types that can be used to build nested hierarchical data are OBJECT and VARIANT. These data types support the storage and querying of semi- structured data, allowing for the creation of complex, nested data structures
- (Topic 2)
What are supported file formats for unloading data from Snowflake? (Choose three.)
Correct Answer:
BCF
The supported file formats for unloading data from Snowflake include JSON, Parquet, and CSV. These formats are commonly used for their flexibility and compatibility with various data processing tools
- (Topic 6)
How can a Snowflake user post-process the result of SHOW FILE FORMATS?
Correct Answer:
A
first run SHOW FILE FORMATS
then SELECT * FROM TABLE(RESULT_SCAN(LAST_QUERY_ID(-1)))
https://docs.snowflake.com/en/sql-reference/functions/result_scan#usage-notes
- (Topic 1)
True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.
Correct Answer:
B
Reader accounts in Snowflake are designed to allow users to read data shared with them but do not have the capability to extract data for use outside of Snowflake. They are intended for consuming shared data within the Snowflake environment only.
