QuestionQ42

VerifiedData Security and Governance

A company keeps customer data containing personally identifiable information (PII) in an Amazon Redshift cluster. The company's marketing, claims, and analytics teams require access to the customer data.

The marketing team must be able to access obfuscated claim information while retaining full access to customer contact information. The claims team must have access to customer information for every claim the team processes. The analytics team must have access only to obfuscated PII data.

Which solution will enforce these data-access requirements with the LEAST administrative overhead?

Explanation

Amazon Redshift dynamic data masking can obscure, redact, or pseudonymize sensitive column values at query time and can be applied separately to database roles. Role-specific masking policies, including conditional masking where needed, allow the marketing, claims, and analytics roles to receive their required level of customer and claim-data visibility while retaining one underlying dataset. This avoids the operational overhead of separate clusters, copied datasets, or multiple team-specific views.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!