A Data Engineer is working on a Snowflake deployment in AWS eu-west-1 (Ireland). The Engineer is planning to load data from staged files into target tables using the COPY INTO command. Which sources are valid? (Choose three.)
A.
Internal stage on GCP us-central1 (Iowa)
B.
Internal stage on AWS eu-central-1 (Frankfurt)
C.
External stage on GCP us-central1 (Iowa)
D.
External stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)
E.
External stage in an Amazon S3 bucket on AWS eu-central-1 (Frankfurt)
F.
SSD attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)
Internal stages are created in the same region as the Snowflake account so their location can't be different. External stages can be in any region since they are external.
With internal stages, we can't specify any location information because they are managed by
Snowflake and do not require any external credentials or URLs.
Last and not least, an internal stage is created and managed by Snowflake and is not accessible to the user directly.
A and B are not correct. Named internal stage (or table/user stage): You can unload data from a table (or query) into one or more files in a named internal stage. These files can then be downloaded from the stage/location using the GET command.
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.
stopthisnow
Highly Voted 1 year, 9 months agoaba2s
Most Recent 10 months, 3 weeks agoojoa
11 months, 3 weeks agorbeam
1 year, 4 months agoclaudiamilena11
1 year, 4 months agoclaudiamilena11
1 year, 4 months agostopthisnow
1 year, 8 months ago