A table, STUDENTS, is created using this command: An example value for the marks is: Which query will return all of the students ' names and history marks?
Correct Answer: D
Question 262
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
Correct Answer: B,C
When publishing a Snowflake Data Marketplace listing into a remote region, it's important to note that while the listing is replicated into all selected regions automatically, the data itself is not. Therefore, the data must be replicated separately.Additionally, the user must have the ORGADMIN role in at least one account to manage the replication of accounts1.
Question 263
What are valid values for the FIELD_OPTIONALLY_ENCLOSED_BYoption in the copy into < location > command used during data unloading? (Select TWO).
Correct Answer: C,E
Question 264
What are potential impacts of storing non-native values like dates and timestamps in a variant column in Snowflake?
Correct Answer: B
Storing non-native values, such as dates and timestamps, in a VARIANT column in Snowflake can lead to slower query performance and increased storage consumption. VARIANT is a semi-structured data type that allows storing JSON, AVRO, ORC, Parquet, or XML data in a single column. When non-native data types are stored as VARIANT, Snowflake must perform implicit conversion to process these values, which can slow down query execution. Additionally, because the VARIANT data type is designed to accommodate a wide variety of data formats, it often requires more storage space compared to storing data in native, strongly-typed columns that are optimized for specific data types. The performance impact arises from the need to parse and interpret the semi-structured data on the fly during query execution, as opposed to directly accessing and operating on optimally stored data in its native format. Furthermore, the increased storage consumption is a result of the overhead associated with storing data in a format that is less space-efficient than the native formats optimized for specific types of data. References: Snowflake Documentation on Semi-Structured Data: Semi-Structured Data
Question 265
Which of the following are characteristics of security in Snowflake?
Correct Answer: C
One of the security features of Snowflake includes the periodic rekeying of encrypted data, which is available with the Snowflake Enterprise edition and higher2. This ensures that the encryption keys are rotated regularly to maintain a high level of security. References: [ COF-C03 ] SnowPro Core Certification Exam Study Guide
