Which data types optimally store semi-structured data? (Select TWO).
Correct Answer: A,E
In Snowflake, semi-structured data is optimally stored using specific data types that are designed to handle the flexibility and complexity of such data. The VARIANT data type can store structured and semi-structured data types, including JSON, Avro, ORC, Parquet, or XML, in a single column. The ARRAY data type, on the other hand, is suitable for storing ordered sequences of elements, which can be particularly useful for semi-structured data types like JSON arrays. These data types provide the necessary flexibility to store and query semi-structured data efficiently in Snowflake. Reference: Snowflake Documentation: Semi-structured Data Types
Question 62
Who can create and manage reader accounts? (Select TWO).
Correct Answer: A,D
In Snowflake, reader accounts are special types of accounts that allow data sharing with external consumers without them having their own Snowflake account. The creation and management of reader accounts can be performed by users with the ACCOUNTADMIN role or the ORGADMIN role. The ACCOUNTADMIN role has comprehensive administrative privileges within a Snowflake account, including managing other accounts and roles. The ORGADMIN role, which is higher in hierarchy, oversees multiple accounts within an organization and can manage reader accounts across those accounts. : Snowflake Documentation: Creating and Managing Reader Accounts
Question 63
What is a feature of column-level security in Snowflake?
Correct Answer: B
Question 64
What is the MINIMUM size requirement when creating a Snowpark-optimized virtual warehouse?
Correct Answer: B
When creating a Snowpark-optimized virtual warehouse in Snowflake, the minimum size requirement is Small. Snowpark is designed to handle data processing workloads efficiently, and the Small size ensures adequate resources for such tasks. Virtual Warehouse Sizes: Snowflake offers different sizes for virtual warehouses, ranging from X-Small to 6X-Large. Each size corresponds to a specific level of compute resources. Minimum Size Requirement for Snowpark: A Small virtual warehouse is the minimum size required to optimize performance and resource allocation for Snowpark workloads. This ensures that the warehouse has sufficient capacity to handle data processing and transformation tasks efficiently. Snowflake Documentation: Virtual Warehouse Sizes
Question 65
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
