Snowflake Certification Questions || with 100% Errorless Solutions

Which of the below are considered as best practices while loading data into Snowflake? A. Compress the source files B. If format is in CSV, convert them into ORC C. Split large files into smaller files D. Isolate data loading workload into its own virtual warehouse correct answers A. Compress the source files B. Split large files into smaller files C. Isolate data loading workload into its own virtual warehosue how query processing is done in Snowflake? A. It is done using storage layer B. It is done using Snowflake's Virtual warehouses C. It is done using cloud services layer D. It is done through an external compute such as Azure virtual machine or AWS EC2 correct answers B. It is done using Snowflake's Virtual warehouse When cloning a table, if the COPY GRANTS keywords are not included in the CREATE object statement, then the new object does not inherit any explicit access privileges granted on the original table but does inherit any future grants defined for the object type in the schema TRUE FALSE correct answers TRUE Snowpipe is a serverless function (TRUE OR FALSE) correct answers TRUE Which of the two statements are true about the variant data type in Snowflake? A. Can be queried using json path notation B. Stored in a separate file format from structured data C. Requires a custom mapping for each record type D. Optimized storage based on repeated elements correct answers A. Can be queried using json path notation D. Optimized storage based on repeated elements Which file format option would you use when you want to load a JSON file after removing the outer array structure and load the records into separate table rows? A. UNSET_OUTER_ARRAY B. STRIP_OUTER_ARRAY