Exam SnowPro Advanced Architect All QuestionsBrowse all questions from this exam
Question 31

An Architect needs to allow a user to create a database from an inbound share.

To meet this requirement, the user’s role must have which privileges? (Choose two.)

    Correct Answer: A, C

    To allow a user to create a database from an inbound share, the user's role must have the privileges to import the share and create the database. The 'IMPORT SHARE' privilege is necessary to view inbound shares and create databases from them. Additionally, the 'CREATE DATABASE' privilege is required to actually create the database from the share. Thus, the correct privileges are 'IMPORT SHARE' and 'CREATE DATABASE'.

Discussion
victorleonisOptions: AC

IMPORT SHARE Privilege If the IMPORT SHARE privilege is granted to a role, any user with the role can perform the following tasks: View all INBOUND shares (shared by provider accounts) and create databases for the shares. View all OUTBOUND shares owned by the role.

serg_kharOptions: AC

https://docs.snowflake.com/en/user-guide/data-share-consumers#step-1-create-a-database-from-the-share Create a database from the share using CREATE DATABASE … FROM SHARE. Executing this command requires a role with the global CREATE DATABASE and IMPORT SHARE privileges.

jjordanOptions: AC

AC is correct.

hillcat111Options: AC

Answer is A,C and is validated

callipso21Options: BC

https://docs.snowflake.com/en/user-guide/data-share-consumers Allow users to access objects in a share by granting the IMPORTED PRIVILEGES privilege on a shared database to one or more roles in your account.