- (Topic 4)
What feature of Snowflake Continuous Data Protection can be used for maintenance of historical data?
Correct Answer:D
Snowflake??s Time Travel feature is used for the maintenance of historical data, allowing users to access and restore data that has been changed or deleted within a defined period4.
- (Topic 3)
Which data type can store more than one type of data structure?
Correct Answer:D
The VARIANT data type in Snowflake can store multiple types of data structures, as it is designed to hold semi-structured data. It can contain any other data type, including OBJECT and ARRAY, which allows it to represent various data structures
- (Topic 3)
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?
Correct Answer:D
The VALIDATION_MODE parameter can be used with the COPY command to verify data files without loading them into the specified table. This parameter allows users to check for errors in the files
- (Topic 2)
What is the default file size when unloading data from Snowflake using the COPY command?
Correct Answer:C
The default file size when unloading data from Snowflake using the COPY command is not explicitly stated in the provided resources. However, Snowflake documentation suggests that the file size can be specified using the MAX_FILE_SIZE option in the COPY INTO <location> command2.
- (Topic 2)
Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?
Correct Answer:D
The COPY command is used in Snowflake to load data from files located in an external stage into a table. This command allows for efficient and parallelized data loading from various file formats1.
References = [COF-C02] SnowPro Core Certification Exam Study Guide, Snowflake Documentation