exam questions

Exam SnowPro Advanced Architect All Questions

View all questions & answers for the SnowPro Advanced Architect exam

Exam SnowPro Advanced Architect topic 1 question 30 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect
Question #: 30
Topic #: 1
[All SnowPro Advanced Architect Questions]

Which of the following are characteristics of how row access policies can be applied to external tables? (Choose three.)

  • A. An external table can be created with a row access policy, and the policy can be applied to the VALUE column.
  • B. A row access policy can be applied to the VALUE column of an existing external table.
  • C. A row access policy cannot be directly added to a virtual column of an external table.
  • D. External tables are supported as mapping tables in a row access policy.
  • E. While cloning a database, both the row access policy and the external table will be cloned.
  • F. A row access policy cannot be applied to a view created on top of an external table.
Show Suggested Answer Hide Answer
Suggested Answer: ABC 🗳️

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
hillcat111
10 months, 2 weeks ago
Answer is A,B,C and is validated
upvoted 1 times
...
callipso21
1 year, 1 month ago
Selected Answer: ABC
https://docs.snowflake.com/en/user-guide/security-row-intro#external-tables External Tables You can create an external table with a row access policy by executing a CREATE EXTERNAL TABLE statement and apply the policy to the VALUE column. You can apply the row access policy to VALUE column of an existing external table by executing an ALTER TABLE statement on the external table. A row access policy cannot be added to a virtual column directly. Instead, create a view on the external table and apply the row access policy to the columns on the view.
upvoted 1 times
...
serg_khar
1 year, 1 month ago
Selected Answer: ABC
https://docs.snowflake.com/en/user-guide/security-row-intro#external-tables
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