exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 564 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 564
Topic #: 1
[All SnowPro Core Questions]

How do managed access schemas help with data governance?

  • A. They log all operations and enable fine-grained auditing.
  • B. They provide centralized privilege management with the schema owner.
  • C. They enforce identical privileges across all tables and views in a schema.
  • D. They require the use of masking and row access policies across every table and view in the schema.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
qiyan1982
Highly Voted 1 year, 2 months ago
B is correct answer With managed access schemas, object owners lose the ability to make grant decisions. Only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant privileges on objects in the schema, including future grants, centralizing privilege management.
upvoted 6 times
...
ShagunMittal
Highly Voted 1 year, 2 months ago
Selected Answer: B
https://docs.snowflake.com/en/user-guide/security-access-control-configure#creating-managed-access-schemas
upvoted 5 times
...
PrasantSadangi
Most Recent 4 weeks ago
Selected Answer: B
Apart from creating Schema in Snowflake , there a feature to Create schema with managed access . Managed access schemas centralize privilege management with the schema owner. In regular schemas, the owner of an object (i.e. the role that has the OWNERSHIP privilege on the object) can grant further privileges on their objects to other roles. In managed schemas, the schema owner manages all privilege grants, including future grants, on objects in the schema. Object owners retain the OWNERSHIP privileges on the objects; however, only the schema owner can manage privilege grants on the objects.
upvoted 1 times
...
Franzoz
5 months ago
Ans is B
upvoted 1 times
...
MultiCloudIronMan
9 months, 2 weeks ago
Selected Answer: B
correct
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago