Discuss Snowflake ARA-C01 Exam Topic 1 Question 2

An Architect entered the following commands in sequence:

USER1 cannot find the table.

Which of the following commands does the Architect need to run for USER1 to find the tables using the Principle of Least Privilege? (Choose two.)

AGRANT ROLE PUBLIC TO ROLE INTERN;

BGRANT USAGE ON DATABASE SANDBOX TO ROLE INTERN;

CGRANT USAGE ON SCHEMA SANDBOX.PUBLIC TO ROLE INTERN;

DGRANT OWNERSHIP ON DATABASE SANDBOX TO USER INTERN;

EGRANT ALL PRIVILEGES ON DATABASE SANDBOX TO ROLE INTERN;

Suggested Answer: B, C

Get Premium ARA-C01 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

17 comments · newest first

Shawnda 11 months ago

Granting usage on the database is a must!

Shannon 11 months ago

Wait, can USER1 really find the tables with just those commands?

Macy 12 months ago

Granting ALL privileges seems excessive, right?

Estrella 12 months ago

I think B and C are the right choices!

Lonna 12 months ago

USER1 needs access to the schema for sure.

Michael 1 year ago

I believe we should focus on granting usage on both the database and schema. That seems to align with what we practiced before.

Adell 1 year ago

I’m a bit confused about whether granting ownership is the right approach here. It seems too broad for the least privilege principle.

Stevie 1 year ago

I think we had a similar practice question where we had to grant permissions. I feel like granting usage on the schema is definitely necessary.

Chun 1 year ago

I remember we discussed the Principle of Least Privilege, but I'm not sure if granting usage on the database is enough for USER1 to see the tables.

Laura 1 year ago

I vaguely remember that granting ownership is too much for this scenario. I think we should focus on options that limit access, like B and C.

Carman 1 year ago

I’m a bit confused about the roles. Shouldn't USER1 have a role assigned to access the tables? I can't recall if we need to grant usage on both the database and schema.

Billye 1 year ago

I think we practiced a similar question where we had to grant schema access. I feel like option C might be the right choice here.

Omer 1 year ago

I remember we discussed the Principle of Least Privilege, but I'm not sure if granting usage on the database is enough for USER1 to see the tables.

Celestina 1 year ago

Hmm, this looks like a tricky SQL injection question. I'll need to think carefully about the potential security implications of each option.

Bettina 1 year ago

I'm a bit confused by all the TOGAF-specific terminology in this question. As the lead architect, I think I'd want to start by really understanding the business context and needs, rather than jumping straight into the TOGAF framework. Option C, where you clarify the business drivers and requirements with the board, seems like a good place to start. Gotta make sure we're solving the right problems here.

Antonio 1 year ago

I'm a bit confused on this one. I'll need to review the concepts of zoning and redundancy to figure out the best approach.

Lilli 1 year ago

I think it has something to do with IP addresses. Layer 3 devices deal with networking at that level, right?

Snowflake ARA-C01 Exam - Topic 1 Question 2 Discussion