Snowflake Exam DEA-C01 Topic 1 Question 8 Discussion

Actual exam question for Snowflake's DEA-C01 exam

Question #: 8
Topic #: 1

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? (Select THREE)

AInternal stage on GCP us-central1 (Iowa)

BInternal stage on AWS eu-central-1 (Frankfurt)

CExternal stage on GCP us-central1 (Iowa)

DExternal stage in an Amazon S3 bucket on AWS eu-west-1 (Ireland)

EExternal stage in an Amazon S3 bucket on AWS eu-central 1 (Frankfurt)

FSSO attached to an Amazon EC2 instance on AWS eu-west-1 (Ireland)

Show Suggested Answer

Suggested Answer: B

Please note JavaScript is case sensitive but if we are using a JavaScript UDF in a masking policy,

ensure the data type of the column, UDF, and masking policy match.

by Natalie at Jul 25, 2023, 08:09 AM

Limited Time Offer

25%

Off

Get Premium DEA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Micaela

2 days ago

Haha, option F is just completely off the mark. What does an SSO attached to an EC2 instance have to do with loading data into Snowflake? Clearly, the right answers are B, D, and E.

upvoted 0 times

...

Pauline

5 days ago

Hmm, I'm a bit confused. Isn't there a limit on the number of regions you can use for external stages? I thought it was only two or three. Maybe I'm misremembering that.

upvoted 0 times

...

Stefania

9 days ago

I'm not sure about option F. Can someone explain why an SSO attached to an EC2 instance would be a valid source?

upvoted 0 times

...

Carylon

10 days ago

I'm pretty sure B, D, and E are the valid options here. Snowflake's internal stages have to be in the same region as the Snowflake deployment, and external stages can be in any AWS or GCP region.

upvoted 0 times

...

Cordelia

10 days ago

I agree with Evette. Those options make sense for loading data into target tables.

upvoted 0 times

...

Evette

16 days ago

I think options D, E, and F are valid sources.

upvoted 0 times

...