nerdexam
Snowflake

ADA-C01 · Question #59

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be…

The correct answer is A. Implement views on top of base tables that exclude or mask sensitive data. B. Implement row access policies and Dynamic Data Masking policies. See the full explanation below for the reasoning.

Question

An Administrator needs to implement an access control mechanism across an organization. The organization users access sensitive customer data that comes from different regions and needs to be accessible for Analysts who work in these regions. Some Analysts need very specific access control depending on their functional roles in the organization. Following Snowflake recommended practice, how should these requirements be met? (Choose two.)

Options

  • AImplement views on top of base tables that exclude or mask sensitive data.
  • BImplement row access policies and Dynamic Data Masking policies.
  • CInclude masking rules as part of data ingestion and transformation pipelines.
  • DUse a third-party tool to share the data.
  • EUse zero-copy cloning to replicate the database schema and provide access as needed.

How the community answered

(42 responses)
  • A
    71% (30)
  • C
    10% (4)
  • D
    2% (1)
  • E
    17% (7)

Community Discussion

No community discussion yet for this question.

Full ADA-C01 Practice