Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
SnowPro Advanced: Data Engineer · Snowflake
Select 2 answers.
This question asks for 2 answers, but our data marks only 1. Compare with the community discussion below for the full answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
Snowflake don't support the create of index, You can cluster a table by a cluster key, but this option is not in the list of option. in addition to this in the question is write that You are in DEV environment. So You don't need to have all the data but to know how SF process them.
Why not D? It doesn't say we don't need all the data, so why LIMIT (option A)? Agree with C
there are no indexes in snowflake. And also based on context looks like dev just run this query in some kind of query editor and in such case obviously do not need to return gigabytes of data.