Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1109 discussion

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

What step does Snowflake recommend when loading data from a stage?

  • A. Use PURGE when using the COPY INTO command.
  • B. Use REMOVE when using the COPY INTO
  • command.
  • C. Use the LOAD HISTORY function to view the status of loaded files.
  • D. Use the COPY HISTORY function to update the status of loaded files.
  • Show Suggested AnswerHide Answer
    Suggested Answer: A 🗳️

    Comments

    Chosen Answer:
    This is a voting comment (?) , you can switch to a simple comment.
    Switch to a voting comment New
    athir
    1 day, 21 hours ago
    because its only loading data, not Snowpipe, then I think its C. LOAD_HISTORY view: This view does not return the history of data loaded using Snowpipe. For this historical information, query the COPY_HISTORY view instead.
    upvoted 1 times
    ...
    d22770a
    1 month ago
    Selected Answer: C
    C is correct
    upvoted 1 times
    ...
    d22770a
    1 month ago
    Answer for Q #1116 is C external function https://docs.snowflake.com/en/user-guide/unstructured-intro
    upvoted 1 times
    ...
    Lematthew31
    3 months ago
    it's C the correct answer
    upvoted 1 times
    ...
    cybe001
    5 months, 1 week ago
    Correct Answer: C. Use the LOAD HISTORY function to view the status of loaded files. Snowflake recommends using the COPY INTO <table> ... command to load data from a stage into a table. After the data is loaded, the LOAD HISTORY function (which can be accessed via the INFORMATION_SCHEMA.LOAD_HISTORY view or by querying the COPY_HISTORY table function) is used to view the status of loaded files. This helps to ensure that files are loaded correctly and to check for any errors during the load process.
    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.
    Loading ...