Questions And Correct Answers (Verified Answers)
Which of the following statements are true regarding how Snowflake
stores table data? Select all that apply. - ANSWER✔✔- Data is stored
in a columnar format
- Data is automatically compressed
- Data is stored in micro-partitions
Which command can be used to download data from an internal stage
to an on-premises system? - ANSWER✔✔GET
- GET is used to download data from internal stage to on-prem, PUT
uploads data from on-prem to internal stage
In Snowflake, all data at rest is encrypted using which encryption
method? - ANSWER✔✔ AES 256 bit
Which of the following statements best describe Snowpark? Select all
that apply. - ANSWER✔✔- Snowpark is a library created by Snowflake
that provides APIs for accessing and processing data in application
written in programming language other than SQL
- Snowpark automatically converts the data-processing programming
constructs to SQL and pushes them down to Snowflake for execution
Snowflake provides which of the following connectors? - ANSWER✔✔-
, Spark
- Python
- Kafka
External tables are a good solution for which of the following is true?
Select all that apply. - ANSWER✔✔- Typically only a subset of data is
accessed
- The data is not accessed frequently
- Data is already in a data lake on a cloud platform
A virtual warehouse provides which of the following resources? Select
all that apply. - ANSWER✔✔- Memory
- CPU
- Temp local storage
Snowflake stores data in fail-safe storage for Transient tables for how
long? - ANSWER✔✔ 0 days
Which of the following are valid sections in a Snowflake Scripting
code? - ANSWER✔✔ Begin, end, exception, declare
True or False. The variant data type can hold up to 16MB of data per
row. - ANSWER✔✔ True
True or False: The data in the views in the INFORMATION_SCHEMA can
have a latency of up to 3 hours. - ANSWER✔✔ False