ExamGecko
Question list
Search
Search

List of questions

Search

Question 22 - ARA-C01 discussion

Report
Export

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

A.
IMPORT SHARE;
Answers
A.
IMPORT SHARE;
B.
IMPORT PRIVILEGES;
Answers
B.
IMPORT PRIVILEGES;
C.
CREATE DATABASE;
Answers
C.
CREATE DATABASE;
D.
CREATE SHARE;
Answers
D.
CREATE SHARE;
E.
IMPORT DATABASE;
Answers
E.
IMPORT DATABASE;
Suggested answer: C, E

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.

CREATE DATABASE | Snowflake Documentation

Importing Data from a Share | Snowflake Documentation

Importing a Share | Snowflake Documentation

CREATE SHARE | Snowflake Documentation

asked 23/09/2024
carlos soto
36 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first