snowproLeo Snowflake SnowPro Certification questions & answers 2023

snowproLeo Snowflake SnowPro Certification questions & answers 2023 Which of the following are true about the variant data type in Snowflake? Select all that apply. - correct answer -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. - correct answer FALSE Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation? Select the best answer. - correct answer ELT True or False: All interactions with data are initialized through the services layer? - correct answer True True or False: Multi-Cluster Warehouses support high concurrency? - correct answer True True or False: Snowflake's security and authentication includes Multi-Factor authentication? - correct answer True which true? Zero-copy cloning - correct answer 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 - correct answer Upsert Customer no longer need to do with snowflake - correct answer -installing and configuring hardware -patching software -maintining metadata and statistics