Exam SOL-C01 Topic 1 Question 39 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 39
Topic #: 1

You need to implement a data governance strategy that ensures data stewards can only access specific columns within a table to perform data quality checks. The table is `RAW DATA.PUBLIC.CUSTOMER DETAILS' and you want to allow the data stewards to only see the
'CUSTOMER ID', `EMAIL', and 'PHONE NUMBER columns. Which is the most efficient and secure method to grant access?

A. Grant SELECT privilege on the table to a custom role used by the data stewards. Use masking policies to hide the columns they should not see. B. Create a secure view that only includes the `EMAIL ` , and 'PHONE_NUMBER columns. Grant SELECT privilege on the secure view to a custom role used by the data stewards. C. Grant SELECT privilege on the table to the 'PUBLIC' role. Revoke SELECT privilege on the columns they should not see. D. Create a role hierarchy where a data steward role inherits from a higher-level role that has SELECT access on the entire table. E. Create a standard view that only includes the 'CUSTOMER ID', 'EMAIL', and 'PHONE NUMBER columns.Grant SELECT privilege on the view to a custom role used by the data stewards.

Suggested Answer: B Vote an answer

Option B is the most secure and efficient. Secure views provide enhanced security compared to regular views, preventing potential information leakage through side-channel attacks. Secure views guarantee that data stewards only have access to the specified columns, enforcing the principle of least privilege. Masking policies (Option A) can introduce performance overhead.
Granting access to the 'PUBLIC' role (Option C) is generally not recommended for security reasons. Role hierarchy by inheriting privileges on the entire table breaks down security, as the user could switch to the parent role.

by Orville at Dec 07, 2025, 06:17 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

Here are all the actual test exam dumps for IT exams. Most people prepare for the actual exams with our test dumps to pass their exams. So it's critical to choose and actual test pdf to succeed.

RECENT DISCUSSIONS

Useful Links

Contact Us

Our Working Time: ( GMT 0:00-15:00 )
From Monday to Saturday

Support: Contact now

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Disclaimer:
Actual4test doesn't offer Real SANS and GIAC Exam Questions.
Oracle and Java are registered trademarks of Oracle and/or its affiliates
Actual4test material do not contain actual actual Oracle Exam Questions or material.
Actual4test doesn't offer Real Microsoft Exam Questions.
Microsoft®, Azure®, Windows®, Windows Vista®, and the Windows logo are registered trademarks of Microsoft Corporation
Actual4test Materials do not contain actual questions and answers from Cisco's Certification Exams. The brand Cisco is a registered trademark of CISCO, Inc
CFA Institute does not endorse, promote or warrant the accuracy or quality of these questions. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Actual4test does not offer exam dumps or questions from actual exams. We offer learning material and practice tests created by subject matter experts to assist and help learners prepare for those exams. All certification brands used on the website are owned by the respective brand owners. Actual4test does not own or claim any ownership on any of the brands.