exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1285 discussion

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

When unloading Snowflake relational data to a Parquet file format, why should the PARTITION BY clause be used?

  • A. It will provide a mechanism to encrypt each micro-partition with a unique key.
  • B. It will guarantee data integrity by splitting the data into smaller, manageable chunks.
  • C. It will increase storage efficiency by automatically compressing data based on access patterns.
  • D. It will optimize query performance by filtering relevant partitions without scanning the entire dataset.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
37ceea2
2 weeks, 4 days ago
Selected Answer: C
https://docs.snowflake.com/en/user-guide/ui-snowsight-activity In Query Profile section, DML Operators, we can see: "Unload Represents a COPY operation that exports data from a table into a file in a stage. Attributes: Location - the name of the stage where the data is saved." Answer is C
upvoted 1 times
37ceea2
2 weeks, 3 days ago
Here is the real reply for question 1285: https://www.snowflake.com/guides/what-parquet/#:~:text=Parquet%20is%20an%20open%20source,wide%20variety%20of%20encoding%20types. "Parquet is an open source file format built to handle flat columnar storage data formats. Parquet operates well with complex data in large volumes.It is known for its both performant data compression and its ability to handle a wide variety of encoding types." Based on this I propose C.
upvoted 1 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 ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago