Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 210 discussion

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

What happens when a cloned table is replicated to a secondary database? (Choose two.)

  • A. A read-only copy of the cloned tables is stored.
  • B. The replication will not be successful.
  • C. The physical data is replicated.
  • D. Additional costs for storage are charged to a secondary account.
  • E. Metadata pointers to cloned tables are replicated.
Show Suggested Answer Hide Answer
Suggested Answer: CD 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
SV1122
Highly Voted 1 year, 10 months ago
Selected Answer: CD
When a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/database-replication-considerations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.
upvoted 8 times
...
Jarturo
Most Recent 3 months, 2 weeks ago
C and D https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloning
upvoted 1 times
...
Mallikharjuna452
4 months ago
A and E are correct
upvoted 1 times
...
_yyukta
8 months, 3 weeks ago
Selected Answer: CD
CD are correct
upvoted 1 times
...
MultiCloudIronMan
1 year, 4 months ago
Selected Answer: CD
Correct
upvoted 1 times
...
Vinit_Agarwal
1 year, 5 months ago
Selected Answer: CD
Answers C&D are correct. For C read this: Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloni For D , read this : Charges based on replication are divided into two categories: data transfer and compute resources. Both categories are billed on the target account (i.e. the account that stores the secondary database or secondary replication/failover group that is refreshed). https://docs.snowflake.com/en/user-guide/account-replication-cost
upvoted 3 times
...
Vinit_Agarwal
1 year, 5 months ago
Answers C&D are correct. For C read this: Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloni For D , read this : Charges based on replication are divided into two categories: data transfer and compute resources. Both categories are billed on the target account (i.e. the account that stores the secondary database or secondary replication/failover group that is refreshed). https://docs.snowflake.com/en/user-guide/account-replication-cost
upvoted 1 times
...
c0d3g
1 year, 6 months ago
Selected Answer: CD
Replication and Cloning Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account. https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloni
upvoted 1 times
...
SatyamKishore
1 year, 6 months ago
Options are not Clear . Going through the link - https://docs.snowflake.com/en/user-guide/account-replication-considerations#replication-and-cloning C is certainly correct , D if we remove secondary from the option
upvoted 2 times
...
DataEngineer7331
1 year, 6 months ago
Selected Answer: CE
Option A, "A read-only copy of the cloned tables is stored," is not entirely correct because the data is replicated, not just stored. Option B, "The replication will not be successful," is not correct because the replication will be successful if it is configured correctly. Option D, "Additional costs for storage are charged to a secondary account," is not correct because the cost of storage is charged to the primary account, not the secondary account.
upvoted 2 times
...
harshagc180
1 year, 11 months ago
Answer is correct
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 ...