Free Snowflake SnowPro-Core Exam Questions
Absolute Free SnowPro-Core Exam Practice for Comprehensive Preparation
-
Snowflake SnowPro-Core Exam Questions
-
Provided By: Snowflake
- Exam: SnowPro Core Certification (COF-C02)
- Certification: SnowPro Certification
-
Total Questions: 851
-
Updated On: Apr 06, 2025
-
Rated: 4.9 |
-
Online Users: 1702
-
Question 1
-
What statement describes Snowflake data architecture?
Answer: C
-
What statement describes Snowflake data architecture?
-
Question 2
-
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
Answer: D
-
What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?
-
Question 3
-
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON
documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO
command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?
Answer: B
-
A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON
documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO
command was executed:
COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)
The load failed with this error:
Max LOB size (16777216) exceeded, actual size of parsed column is 17894470. How can this issue be resolved?
-
Question 4
-
Which data protection feature should only be used when all other data recovery options have been
attempted?
Answer: D
-
Which data protection feature should only be used when all other data recovery options have been
attempted?
-
Question 5
-
Which steps will help optimize query performance? (Select TWO).
Answer: A,B
-
Which steps will help optimize query performance? (Select TWO).