ExamTopics Logo
Mail Us[email protected]
Menu
Snowflake Discussions
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam
Go to Exam

Exam SnowPro Core topic 1 question 182 discussion

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

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

  • A. Use the DROP command after the load completes.
  • B. Specify the TEMPORARY option when creating the file format.
  • C. Specify the PURGE copy option in the COPY INTO command.
  • D. Use the REMOVE command after the load completes.
  • E. Use the DELETE LOAD HISTORY command after the load completes.
    • Show Suggested AnswerHide Answer
    Suggested Answer: CD 🗳️
    by Lavpak at Nov. 29, 2022, 7:29 p.m.

    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
    Submit Cancel
    GiselaS
    Highly Voted 1 year, 8 months ago
    Selected Answer: CD
    Purge in COPY INTO command or REMOVE after that process
    upvoted 5 times
    ...
    a8c5bbe
    Most Recent 3 weeks, 2 days ago
    Selected Answer: CD
    purge and remove
    upvoted 1 times
    ...
    sanjithraju39
    3 weeks, 3 days ago
    Selected Answer: CD
    cd is the answer
    upvoted 1 times
    ...
    pranalig
    6 months, 1 week ago
    CD correct
    upvoted 1 times
    ...
    82c6010
    6 months, 2 weeks ago
    C and D
    upvoted 1 times
    ...
    gunasekarantjk1996
    7 months ago
    CD correct
    upvoted 1 times
    ...
    _yyukta
    10 months ago
    Selected Answer: CD
    C and D are correct
    upvoted 1 times
    ...
    Marge23
    1 year, 3 months ago
    A is to delete a stage by using command DROP @mystage;
    upvoted 1 times
    ...
    MultiCloudIronMan
    1 year, 5 months ago
    Selected Answer: CD
    correct
    upvoted 2 times
    ...
    weuz
    1 year, 8 months ago
    PURGE and REMOVE are the correct answer
    upvoted 1 times
    ...
    c0d3g
    1 year, 9 months ago
    Selected Answer: CD
    PURGE and REMOVE
    upvoted 1 times
    ...
    psilvabr
    1 year, 9 months ago
    Selected Answer: CDCDCD
    CD correct answer.
    upvoted 1 times
    ...
    KarBiswa
    1 year, 10 months ago
    CD correct anser for C - https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
    upvoted 1 times
    ...
    baig123
    2 years ago
    C and D should be correct answer.
    upvoted 3 times
    ...
    halol
    2 years ago
    Selected Answer: CD
    d: https://docs.snowflake.com/en/user-guide/data-load-internal-tutorial-remove-data-files.html c: https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy.html#:~:text=Staged%20files%20can%20be%20deleted%20from%20a%20Snowflake,command%20to%20remove%20the%20files%20in%20the%20stage.
    upvoted 4 times
    ...
    db1290
    2 years ago
    C and D
    upvoted 3 times
    ...
    Lavpak
    2 years ago
    Selected Answer: C
    Files that were loaded successfully can be deleted from the stage during a load by specifying the PURGE copy option in the COPY INTO <table> command. https://docs.snowflake.com/en/user-guide/data-load-local-file-system-copy.html#:~:text=Staged%20files%20can%20be%20deleted%20from%20a%20Snowflake,command%20to%20remove%20the%20files%20in%20the%20stage.
    upvoted 3 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.
    exam
    Someone Bought Contributor Access for:
    SY0-701
    London, 1 minute ago