SnowPro Core Certification — Question 694

Which SQL command will download all the data files from an internal table stage named TBL_EMPLOYEE to a local window directory or folder on a client machine in a folder named folder with space within the C drive?

Answer options

• A. GET @%TBL_EMPLOYEE 'file://C:\folder with space\';
• B. GET @%TBL_EMPLOYEE 'file://C:/folder with space/';
• C. PUT 'file://C:\folder with space\*' @%TBL_EMPLOYEE;
• D. PUT 'file://C:/folder with space/*' @%TBL_EMPLOYEE;

Correct answer: B

Explanation

The correct answer is B because it uses the correct syntax for the GET command to download files from the internal table stage to the specified local directory. Option A incorrectly uses a backslash which can cause issues in path recognition, while options C and D are PUT commands, which do not download files but rather upload them to the internal stage.