ARA-C01 practice question 10 of 25

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.)

Full set: 162 questions
Answer options
A: IMPORT SHARE;
B: IMPORT PRIVILEGES;
C: CREATE DATABASE; Correct answer
D: CREATE SHARE;
E: IMPORT DATABASE; Correct answer
Correct Answer:
C. CREATE DATABASE;; E. IMPORT DATABASE;
Explanation

According to the Snowflake documentation, to create a database from an inbound share, the user’s role must have the following privileges: The CREATE DATABASE privilege on the current account. This privilege allows the user to create a new database in the account1. The IMPORT DATABASE privilege on the share. This privilege allows the user to import a database from the share into the account2. The other privileges listed are not relevant for this requirement. The IMPORT SHARE privilege is used to import a share into the account, not a database3. The IMPORT PRIVILEGES privilege is used to import the privileges granted on the shared objects, not the objects themselves2. The CREATE SHARE privilege is used to create a share to provide data to other accounts, not to consume data from other accounts4.
Reference:
CREATE DATABASE | Snowflake Documentation
Importing Data from a Share | Snowflake Documentation Importing a Share | Snowflake Documentation
CREATE SHARE | Snowflake Documentation

Scroll to Top