exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 377 discussion

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

Which snowflake objects will incur both storage and cloud compute charges? (Choose two.)

  • A. Materialized view
  • B. Sequence
  • C. Secure view
  • D. Transient table
  • E. Clustered table
Show Suggested Answer Hide Answer
Suggested Answer: AE 🗳️

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
SV1122
Highly Voted 1 year, 4 months ago
Selected Answer: AE
I think it is A and E. Clustered table needs to undergo clustering as the data changes and Materialized view also undergoes changes every time the underlying data changes or when the view is set to refresh.
upvoted 10 times
...
Mitchdu
Most Recent 4 months, 1 week ago
Selected Answer: AD
There is no such object type as Clustered table in snowflake, clustering is a feature - not an object type. Thus Materialized view (A) and Transient table (D)
upvoted 2 times
...
MultiCloudIronMan
9 months, 2 weeks ago
Selected Answer: AE
correct
upvoted 1 times
...
EmiB
1 year, 2 months ago
The question doesn't say in which situation incur compute cost. Storage cost - Permanent, Temporary, Transient, MV Compute - creation, maintanance, query ?
upvoted 2 times
...
fahfouhi94
1 year, 3 months ago
Selected Answer: AE
normally, transient table also
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