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

Carline

3 months ago

Wait, is option F the secret answer? Like, 'SSO-powered EC2 instances are the future of Snowflake data loading'? Nah, just kidding. B, D, and E are the obvious winners here.

upvoted 0 times

Dell

2 months ago

Yeah, using internal and external stages in the same region is the way to go for efficient data loading.

upvoted 0 times

...

Iesha

2 months ago

I agree, those options make the most sense given the scenario.

upvoted 0 times

...

Jamal

3 months ago

B, D, and E are definitely the best choices for loading data into Snowflake.

upvoted 0 times

...

Taryn

4 months ago

I'm pretty sure the correct answers are B, D, and E. Internal stages have to be in the same region as the Snowflake deployment, and external stages can be in any AWS or GCP region. Simple as that!

upvoted 0 times

Francesco

2 months ago

Exactly, internal stages must match the region while external stages can be in any AWS or GCP region.

upvoted 0 times

...

Lauran

3 months ago

So, B, D, and E are the correct options for loading data from staged files into target tables.

upvoted 0 times

...

Derick

3 months ago

I think you're right, internal stages need to be in the same region as Snowflake deployment.

upvoted 0 times

...

Micaela

4 months 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

Dino

3 months ago

Yes, B, D, and E are the correct sources for loading data into Snowflake.

upvoted 0 times

...

Ivory

3 months ago

I agree, option F doesn't make sense for loading data into Snowflake.

upvoted 0 times

...

Pauline

4 months 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

4 months 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

4 months 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