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 728 discussion

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

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?

  • 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;
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
MultiCloudIronMan
Highly Voted 1 year, 4 months ago
Selected Answer: A
I think is A, because windows file system use back slash
upvoted 6 times
...
nehanovigo
Most Recent 2 months, 3 weeks ago
it is A
upvoted 1 times
...
Rameez1
4 months, 1 week ago
Selected Answer: B
https://docs.snowflake.com/en/sql-reference/sql/get#required-parameters Windows:-You must include the drive and backslash in the path (e.g. file://C:tempload). If the directory path includes special characters, the entire file URI must be enclosed in single quotes. Note that the drive and path separator is a forward slash (/) in enclosed URIs (e.g. 'file://C:/temp/load data' for a path in Windows that includes a directory named load data).
upvoted 2 times
...
nexerSnow
9 months ago
Selected Answer: B
B correct
upvoted 1 times
...
Valcon_doo
12 months ago
Selected Answer: B
https://docs.snowflake.com/en/sql-reference/sql/get#required-parameters
upvoted 2 times
...
ASK_123
1 year ago
Selected Answer: B
B is correct. Syntax: GET internalStage file://<local_directory_path> [ PARALLEL = <integer> ] [ PATTERN = '<regex_pattern>'' ] You must include the drive and backslash in the path (e.g. file://C:tempload). If the directory path includes special characters, the entire file URI must be enclosed in single quotes. Note that the drive and path separator is a forward slash (/) in enclosed URIs (e.g. 'file://C:/temp/load data' for a path in Windows that includes a directory named load data).
upvoted 3 times
...
Pradeep_7869
1 year ago
Why B in windows machine \ is used for path then it must be A
upvoted 2 times
...
Heetec
1 year, 1 month ago
Selected Answer: B
B correct
upvoted 1 times
...
kayuhanbiduk
1 year, 1 month ago
Selected Answer: B
B. https://docs.snowflake.com/en/sql-reference/sql/get#required-parameters
upvoted 4 times
...
jAtlas7
1 year, 1 month ago
Selected Answer: B
Just like WSL or other Unix systems accessing Windows, path has Unix separators to access a mounted windows drive as such. /c/folder with space/
upvoted 2 times
...
sid1604
1 year, 1 month ago
Selected Answer: A
A is correct
upvoted 2 times
...
JG1984
1 year, 2 months ago
Selected Answer: A
The internal stage is @%TBL_EMPLOYEE, which is the stage for the table named TBL_EMPLOYEE. The local directory path is file://C:\folder with space\. The space in the folder name must be escaped with a backslash (\).
upvoted 4 times
...
singhks
1 year, 3 months ago
Selected Answer: B
https://docs.snowflake.com/en/sql-reference/sql/get If the directory path includes special characters, the entire file URI must be enclosed in single quotes. Note that the drive and path separator is a forward slash (/) in enclosed URIs (e.g. 'file://C:/temp/load data' for a path in Windows that includes a directory named load data).
upvoted 4 times
ZMF_2023
1 year, 1 month ago
verified from https://docs.snowflake.com/en/sql-reference/sql/get
upvoted 2 times
...
...
Marcusbraga
1 year, 3 months ago
A because is local machine..... \ . it was linux /
upvoted 2 times
...
Eitan
1 year, 4 months ago
A is correct https://docs.snowflake.com/en/user-guide/data-unload-snowflake#
upvoted 2 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 ...