Snowflake ADA-C01 Exam - Topic 3 Question 9 Discussion

Actual exam question for Snowflake's ADA-C01 exam

Question #: 9
Topic #: 3

A virtual warehouse report_wh is configured with AUTO_RESUME=TRUE and AUTO_SUSPEND=300. A user has been granted the role accountant.

An application with the accountant role should use this warehouse to run financial reports, and should keep track of compute credits used by the warehouse.

What minimal privileges on the warehouse should be granted to the role to meet the requirements for the application? (Select TWO).

AOPERATE

BMODIFY

CMONITOR

DUSAGE

EOWNERSHIP

Show Suggested Answer

Suggested Answer: C, D

According to the Snowflake documentation1, the MONITOR privilege on a warehouse grants the ability to view the warehouse usage and performance metrics, such as the number of credits consumed, the average and maximum run time, and the number of queries executed. The USAGE privilege on a warehouse grants the ability to use the warehouse to execute queries and load data. Therefore, the minimal privileges on the warehouse that should be granted to the role to meet the requirements for the application are MONITOR and USAGE. Option A is incorrect because the OPERATE privilege on a warehouse grants the ability to start, stop, resume, and suspend the warehouse, which is not required for the application. Option B is incorrect because the MODIFY privilege on a warehouse grants the ability to alter the warehouse properties, such as the size, auto-suspend, and auto-resume settings, which is not required for the application. Option E is incorrect because the OWNERSHIP privilege on a warehouse grants the ability to drop the warehouse, grant or revoke privileges on the warehouse, and transfer the ownership to another role, which is not required for the application.

by Vincenza at Mar 15, 2024, 08:59 AM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Gerry

3 months ago

I’m surprised OPERATE isn’t a must-have for running reports.

upvoted 0 times

...

Mammie

3 months ago

Agreed, USAGE and MONITOR make the most sense here!

upvoted 0 times

...

Janna

3 months ago

Wait, why would you need OPERATE? Seems unnecessary.

upvoted 0 times

...

Cristal

4 months ago

I think OPERATE is also important, right?

upvoted 0 times

...

Devorah

4 months ago

Definitely need USAGE and MONITOR for that role.

upvoted 0 times

...

Jordan

4 months ago

I’m leaning towards USAGE and MONITOR as the correct choices, but I wonder if there's a chance OPERATE could be relevant here as well.

upvoted 0 times

...

Keneth

4 months ago

I practiced a similar question, and I feel like OPERATE might be needed too, but I’m not completely confident about it.

upvoted 0 times

...

Melita

4 months ago

I remember something about the MONITOR privilege being important for tracking compute credits, but I can't recall if it's necessary for this scenario.

upvoted 0 times

...

Francesco

5 months ago

I think we need to grant the USAGE privilege for the accountant role to access the warehouse, but I'm not sure about the second one.

upvoted 0 times

...

Dell

5 months ago

I'm not sure about this one. I'll need to review the privilege definitions more carefully to make sure I select the right options.

upvoted 0 times

...

Justine

5 months ago

I'm a bit confused about the difference between OPERATE and USAGE. Do I need both of those to meet the requirements?

upvoted 0 times

...

Johnna

5 months ago

Okay, let's see. The application needs to use the warehouse to run financial reports and track compute credits. I think the key is to identify the minimum privileges required for that.

upvoted 0 times

...

Elroy

5 months ago

Hmm, this looks like a tricky one. I'll need to think carefully about the requirements and the available privileges.

upvoted 0 times

...

Rory

5 months ago

I'm pretty confident I know the answer here. The application needs to be able to run reports and track usage, so MONITOR and USAGE would be the minimum required privileges.

upvoted 0 times

...

Helga

5 months ago

This is a good one. I think the best approach is to implement Salesforce Shield and apply it to the sensitive data. That way, we can be sure the contractor can't access it, even in the sandbox environment.

upvoted 0 times

...

Arlyne

5 months ago

This is a tricky one. I'm leaning towards option C as well. Criticizing him in front of the class could just make the situation worse, and ignoring it won't solve the problem. Talking to him privately seems like the best way to handle it.

upvoted 0 times

...

Matt

5 months ago

This looks like a straightforward question on information security responsibilities in projects. I'll review the options carefully and choose the one that best fits the description.

upvoted 0 times

...

Edison

5 months ago

Okay, I think I've got this. The guaranteed payment from the partnership is subject to self-employment tax, but the S corporation income is not. So the answer should be $50,000.

upvoted 0 times

...

Deonna

5 months ago

I'm a bit confused by the options here. Can we really not use an SSH key-pair? That seems like the most secure approach, but option B is saying we have to use a password instead. I'll need to double-check the requirements on this one.

upvoted 0 times

...

Arthur

2 years ago

I think MONITOR and OWNERSHIP should be granted, as ownership would give complete control over the virtual warehouse report_wh.

upvoted 0 times

...

Carmela

2 years ago

I believe OPERATE and MONITOR should be granted to the role to meet the requirements.

upvoted 0 times

...

Antione

2 years ago

I agree with User1, MONITOR and USAGE seem like the minimal privileges required.

upvoted 0 times

...

Tammy

2 years ago

I think the role should be granted MONITOR and USAGE privileges.

upvoted 0 times

...

Yuki

2 years ago

I believe the role should have the USAGE privilege to access the warehouse for running reports.

upvoted 0 times

...

Eleonora

2 years ago

I agree, MONITOR privilege is essential for tracking compute credits. But I also think the role should be granted the OPERATE privilege to run financial reports.

upvoted 0 times

...

Jackie

2 years ago

I think the role accountant should be granted the MONITOR privilege to track compute credits used.

upvoted 0 times

...