- (Topic 5)
What is the only supported character set for loading and unloading data from all supported file formats?

1. A. UTF-8
2. B. UTF-16
3. C. ISO-8859-1
4. D. WINDOWS-1253

Correct Answer: A
UTF-8 is the only supported character set for loading and unloading data from all supported file formats in Snowflake. UTF-8 is a widely used encoding that supports a large range of characters from various languages, making it suitable forinternationalization and ensuring data compatibility across different systems and platforms.
References:
✑ Snowflake Documentation: Data Loading and Unloading

- (Topic 1)
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

1. A. True
2. B. False

Correct Answer: A
Snowflake??s architecture allows for the use of a query result cache that stores the results of queries for a period of time. If the same query is run again and the underlying data has not changed, Snowflake can retrieve the result from this cache without needing to re-run the query on an active warehouse, thus saving on compute resources.

- (Topic 2)
Which of the following statements describe features of Snowflake data caching? (Choose two.)

1. A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
2. B. When the data cache is full, the least-recently used data will be cleared to make room.
3. C. A user can only access their own queries from the query result cache.
4. D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
5. E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

Correct Answer: BE
Snowflake??s data caching features include the ability to clear the least- recently used data when the data cache is full to make room for new data. Additionally, the RESULT_SCAN table function can access and filter the contents of the query result cache, allowing users to retrieve and work with the results of previous queries. The other statements are incorrect: the data cache is not saved on the remote storage layer when a virtual warehouse is suspended, users can access queries from the query result cache that were run by other users, and there is no setting calledUSE_METADATA_CACHE in Snowflake. References: Caching in the Snowflake Cloud Data Platform, Optimizing the warehouse cache

- (Topic 3)
Which kind of Snowflake table stores file-level metadata for each file in a stage?

1. A. Directory
2. B. External
3. C. Temporary
4. D. Transient

Correct Answer: A
The kind of Snowflake table that stores file-level metadata for each file in a stage is a directory table. A directory table is an implicit object layered on a stage and stores file-level metadata about the data files in the stage3.

- (Topic 3)
What internal stages are available in Snowflake? (Choose three.)

1. A. Schema stage
2. B. Named stage
3. C. User stage
4. D. Stream stage
5. E. Table stage
6. F. Database stage

Correct Answer: BCE
Snowflake supports three types of internal stages: Named, User, and Table stages. These stages are used for staging data files to be loaded into Snowflake tables. Schema, Stream, and Database stages are not supported as internal stages in Snowflake. References: Snowflake Documentation1.