Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Snowflake ARA-C01 Exam - Topic 5 Question 62 Discussion

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)
A) Shared databases are read-only. and C) Shared databases cannot be cloned. and D) Shared databases are not supported by Time Travel.
B) Shared databases must be refreshed in order for new data to be visible.
E) Shared databases will have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.
F) Shared databases can also be created as transient databases.

Snowflake ARA-C01 Exam - Topic 5 Question 62 Discussion

Actual exam question for Snowflake's ARA-C01 exam
Question #: 62
Topic #: 5
[All ARA-C01 Questions]

How do Snowflake databases that are created from shares differ from standard databases that are not created from shares? (Choose three.)

Show Suggested Answer Hide Answer
Suggested Answer: A, C, D

According to the SnowPro Advanced: Architect documents and learning resources, the ways that Snowflake databases that are created from shares differ from standard databases that are not created from shares are:

Shared databases are read-only. This means that the data consumers who access the shared databases cannot modify or delete the data or the objects in the databases.The data providers who share the databases have full control over the data and the objects, and can grant or revoke privileges on them1.

Shared databases cannot be cloned. This means that the data consumers who access the shared databases cannot create a copy of the databases or the objects in the databases.The data providers who share the databases can clone the databases or the objects, but the clones are not automatically shared2.

Shared databases are not supported by Time Travel. This means that the data consumers who access the shared databases cannot use the AS OF clause to query historical data or restore deleted data.The data providers who share the databases can use Time Travel on the databases or the objects, but the historical data is not visible to the data consumers3.

The other options are incorrect because they are not ways that Snowflake databases that are created from shares differ from standard databases that are not created from shares. Option B is incorrect because shared databases do not need to be refreshed in order for new data to be visible.The data consumers who access the shared databases can see the latest data as soon as the data providers update the data1. Option E is incorrect because shared databases will not have the PUBLIC or INFORMATION_SCHEMA schemas without explicitly granting these schemas to the share.The data consumers who access the shared databases can only see the objects that the data providers grant to the share, and the PUBLIC and INFORMATION_SCHEMA schemas are not granted by default4. Option F is incorrect because shared databases cannot be created as transient databases. Transient databases are databases that do not support Time Travel or Fail-safe, and can be dropped without affecting the retention period of the data.Shared databases are always created as permanent databases, regardless of the type of the source database5.Reference:Introduction to Secure Data Sharing | Snowflake Documentation,Cloning Objects | Snowflake Documentation,Time Travel | Snowflake Documentation,Working with Shares | Snowflake Documentation,CREATE DATABASE | Snowflake Documentation


by Shelba at Apr 02, 2026, 12:24 PM

Limited Time Offer

25%

Off

Get Premium ARA-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Kasandra
2 days ago
I think A, B, and E are correct. Shared databases are read-only, right?
upvoted 0 times
...
Patria
7 days ago
E seems odd. Why would they include those schemas by default?
upvoted 0 times
...
Carey
13 days ago
Wait, D is surprising! No Time Travel for shared ones?
upvoted 0 times
...
Phil
18 days ago
C is correct, you can't clone shared databases.
upvoted 0 times
...
Rusty
2 months ago
I disagree with B. I thought shared databases auto-update.
upvoted 0 times
...
Lasandra
2 months ago
A) Shared databases are read-only. That's a key difference!
upvoted 0 times
...
Felix
3 months ago
I vaguely recall that shared databases have those default schemas like PUBLIC, so option E sounds familiar, but I’m not confident about the others.
upvoted 0 times
...
Joseph
3 months ago
I feel like I saw a question about cloning shared databases in practice, and I think they can't be cloned, which might point to option C.
upvoted 0 times
...
Ashleigh
3 months ago
I remember something about shared databases needing to be refreshed for new data to show up, so maybe option B is correct too?
upvoted 0 times
...
Melinda
4 months ago
I think shared databases are read-only, so I would go with option A, but I'm not completely sure about the others.
upvoted 0 times
...

Save Cancel