exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1208 discussion

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

Use of what parameter will allow files to be loaded even if the file metadata has expired?

  • A. MATCH_BY_COLUMN_NAME = CASE_INSENSITIVE
  • B. ENFORCE_LENGTH = TRUE
  • C. PURGE = TRUE
  • D. LOAD_UNCERTAIN_FILES = TRUE
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
Billhardy
1 week, 6 days ago
Selected Answer: D
The LOAD_UNCERTAIN_FILES = TRUE copy option instructs Snowflake’s COPY INTO command to load files whose load‑history metadata has expired (older than the 64‑day retention period). By default, Snowflake skips these “uncertain” files to prevent possible duplicates, but enabling this parameter forces their ingestion despite expired metadata
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