Which of the following are true about the variant data type in Snowflake?
Select all that apply. ✔️Ans - -Optimized storage based on repeated
elements\
-Can be queried using JSON path notation
True or false: A table in Snowflake can only be queried using the Virtual
Warehouse used to load the data. ✔️Ans - FALSE
Which type of Data Integration tools leverage Snowflake's scalable compute
for data transformation? Select the best answer. ✔️Ans - ELT
True or False: All interactions with data are initialized through the services
layer? ✔️Ans - True
True or False: Multi-Cluster Warehouses support high concurrency? ✔️Ans
- True
True or False: Snowflake's security and authentication includes Multi-Factor
authentication? ✔️Ans - True
which true? Zero-copy cloning ✔️Ans - At the instance a clone is created,
all micro-partitions in the original table and the clone are fully shared.
Which of the following DML commands isn't supported by Snowflake
✔️Ans - Upsert
Customer no longer need to do with snowflake ✔️Ans - -installing and
configuring hardware
-patching software
-maintining metadata and statistics
Snowflake recommended loading data methods ✔️Ans - Load data in
Batch.
Snowflake's metadata is stored in ✔️Ans - cloud services layer