exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 1106 discussion

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

Which Snowflake object is supported by both database replication and replication groups?

  • A. Pipes
  • B. Users
  • C. Stages
  • D. Materialized views
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
lphello2020
1 month, 2 weeks ago
Materialized views are database objects that can be replicated using both database replication and replication groups. This makes sense because materialized views contain actual data and query results that need to be consistent across replicated databases. D
upvoted 2 times
...
HICH9173
1 month, 3 weeks ago
Selected Answer: D
D Pipe : supported by both users: only supported by replication groups stages :supported by replication groups but not by db replication Mat.view : supported by both
upvoted 1 times
...
HICH9173
1 month, 3 weeks ago
D Pipe : supported by both users: only supported by replication groups stages :supported by replication groups but not by db replication Mat.view : supported by both
upvoted 1 times
...
MSIDDIQUI18
2 months ago
According to Snowflake documentation both "Pipes" and "Stages" are not replicated with database replication, so which one is correct? Replication and pipes: Snowflake currently supports pipe replication as part of group-based replication (replication and failover groups). Pipe replication is not supported for database replication. Replication and stages: Snowflake currently supports stage replication as part of group-based replication (replication and failover groups). Stage replication is not supported for database replication. https://docs.snowflake.com/en/user-guide/account-replication-considerations
upvoted 1 times
...
d22770a
2 months, 1 week ago
Selected Answer: C
C is correct as it is supported by both database replication and replication groupds.
upvoted 1 times
...
cybe001
6 months, 2 weeks ago
Correct Answer: A. Pipes In Snowflake, pipes are supported by both database replication and replication groups. Pipes are used in the context of Snowpipe, which allows for continuous data ingestion into Snowflake. When you set up database replication or replication groups, pipes can be included in the replication process to ensure that the continuous data loading configurations are replicated along with the data.
upvoted 3 times
d22770a
2 months, 1 week ago
Pipes are not supported in database replication. https://docs.snowflake.com/en/user-guide/account-replication-considerations
upvoted 2 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