Snowflake ADA-C01 Exam - Topic 2 Question 35 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 35
Topic #: 2

What roles or security privileges will allow a consumer account to request and get data from the Data Exchange? (Select TWO).

ASYSADMIN

BSECURITYADMIN

CACCOUNTADMIN

DIMPORT SHARE and CREATE DATABASE

EIMPORT PRIVILEGES and SHARED DATABASE

Show Suggested Answer

Suggested Answer: C, D

According to the Accessing a Data Exchange documentation, a consumer account can request and get data from the Data Exchange using either the ACCOUNTADMIN role or a role with the IMPORT SHARE and CREATE DATABASE privileges. The ACCOUNTADMIN role is the top-level role that has all privileges on all objects in the account, including the ability to request and get data from the Data Exchange. A role with the IMPORT SHARE and CREATE DATABASE privileges can also request and get data from the Data Exchange, as these are the minimum privileges required to create a database from a share. The other options are incorrect because:

* A. The SYSADMIN role does not have the privilege to request and get data from the Data Exchange, unless it is also granted the IMPORT SHARE and CREATE DATABASE privileges. The SYSADMIN role is a pre-defined role that has all privileges on all objects in the account, except for the privileges reserved for the ACCOUNTADMIN role, such as managing users, roles, and shares.

* B. The SECURITYADMIN role does not have the privilege to request and get data from the Data Exchange, unless it is also granted the IMPORT SHARE and CREATE DATABASE privileges. The SECURITYADMIN role is a pre-defined role that has the privilege to manage security objects in the account, such as network policies, encryption keys, and security integrations, but not data objects, such as databases, schemas, and tables.

* E. The IMPORT PRIVILEGES and SHARED DATABASE are not valid privileges in Snowflake. The correct privilege names are IMPORT SHARE and CREATE DATABASE, as explained above.

by Jessenia at Mar 24, 2025, 10:48 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Remedios

2 months ago

SYSADMIN definitely has the access needed!

upvoted 0 times

...

Jaclyn

2 months ago

Wait, can a consumer account really do that?

upvoted 0 times

...

Gerald

3 months ago

Not sure about E, seems off to me.

upvoted 0 times

...

Bea

3 months ago

I think D could be a valid option too.

upvoted 0 times

...

Herminia

3 months ago

A and C are the right choices!

upvoted 0 times

...

Ivan

3 months ago

I feel like SECURITYADMIN might be relevant, but I also think it could be more about the specific privileges like IMPORT SHARE.

upvoted 0 times

...

Luz

4 months ago

I practiced a similar question where ACCOUNTADMIN was definitely one of the roles, but I’m not confident about the second one.

upvoted 0 times

...

Jesusa

4 months ago

I remember something about IMPORT PRIVILEGES being important for accessing shared data, but I can't recall if it's the right answer here.

upvoted 0 times

...

Meghann

4 months ago

I think SYSADMIN and ACCOUNTADMIN are the ones that can request data, but I'm not entirely sure about the specifics of the Data Exchange.

upvoted 0 times

...

Rodney

4 months ago

I'm feeling pretty confident about this one. Based on my understanding of Snowflake security, I think the SECURITYADMIN and IMPORT SHARE and CREATE DATABASE roles are the most likely to allow a consumer account to access the Data Exchange.

upvoted 0 times

...

Selma

4 months ago

Okay, I've got a strategy for this. I'll start by eliminating the options that don't seem relevant, then focus on the ones that seem more likely to grant the necessary access.

upvoted 0 times

...

Quinn

5 months ago

Hmm, I'm a bit unsure about this one. I'll need to review my notes on Snowflake security and permissions to try to figure out the right answer.

upvoted 0 times

...

Dallas

5 months ago

This looks like a tricky security question. I'll need to think carefully about the different roles and privileges that could allow a consumer account to access the Data Exchange.

upvoted 0 times

...

Val

10 months ago

D) IMPORT SHARE and CREATE DATABASE - bingo! Time to get my data on and impress the boss. Wait, is that a mic in the ceiling?

upvoted 0 times

Tammara

9 months ago

E) IMPORT PRIVILEGES and SHARED DATABASE

upvoted 0 times

...

Tijuana

9 months ago

D) IMPORT SHARE and CREATE DATABASE

upvoted 0 times

...

Gerry

9 months ago

C) ACCOUNTADMIN

upvoted 0 times

...

Stephanie

9 months ago

C) ACCOUNTADMIN

upvoted 0 times

...

Chauncey

10 months ago

A) SYSADMIN

upvoted 0 times

...

Lacey

10 months ago

A) SYSADMIN

upvoted 0 times

...

Theodora

10 months ago

A) SYSADMIN - psh, that's overkill. I bet the developers just want to keep us regular folk out of their precious data. Typical.

upvoted 0 times

...

Elli

10 months ago

B) SECURITYADMIN - really? I thought that was just for managing user accounts, not accessing data. This exam is tricky!

upvoted 0 times

...

Dean

11 months ago

E) IMPORT PRIVILEGES and SHARED DATABASE - hmm, that seems like the more appropriate answer. Who uses SYSADMIN these days anyway? Too much power, am I right?

upvoted 0 times

...

Kristal

11 months ago

D) IMPORT SHARE and CREATE DATABASE - that sounds about right, as the consumer account would need those privileges to request and get data from the Data Exchange.

upvoted 0 times