exam questions

Exam SnowPro Core Recertification All Questions

View all questions & answers for the SnowPro Core Recertification exam

Exam SnowPro Core Recertification topic 1 question 22 discussion

Actual exam question from Snowflake's SnowPro Core Recertification
Question #: 22
Topic #: 1
[All SnowPro Core Recertification Questions]

When a Snowflake user loads CSV data from a stage, which COPY INTO <table> command guideline should they follow?

  • A. The CSV field delimiter must be a comma character (',').
  • B. The number of columns in each row should be consistent.
  • C. The data file in the stage must be in a compressed format.
  • D. The data file must have the same number of columns as the target table.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
nintendogamer64
1 month, 1 week ago
B is correct. From Doc: ERROR_ON_COLUMN_COUNT_MISMATCH = TRUE | FALSE Boolean that specifies whether to generate a parsing error if the number of delimited columns (i.e. fields) in an input data file does not match the number of columns in the corresponding table. If set to FALSE, an error is not generated and the load continues. If the file is successfully loaded: If the input file contains records with more fields than columns in the table, the matching fields are loaded in order of occurrence in the file and the remaining fields are not loaded. If the input file contains records with fewer fields than columns in the table, the non-matching columns in the table are loaded with NULL values. This option assumes all the records within the input file are the same length (i.e. a file containing records of varying length return an error regardless of the value specified for this option).
upvoted 2 times
...
nipun
2 months, 2 weeks ago
it should be D
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago