Amazon Macie, AWS CloudTrail, and Amazon CloudWatch
Differences between client-side encryption and server-side encryption
When and how to apply cleansing techniques
How to delete data to meet business and legal requirements
Event-driven architecture
How to integrate various AWS services to create ETL pipelines
Appropriate storage solutions to address hot and cold data requirements
How to create a data catalog
Best practices for performance tuning
SQL queries (for example, SELECT statements with multiple qualifiers or JOIN clauses)
Tradeoffs between provisioned services and serverless services
How to use Apache Spark to process data
How to configure AWS services for data pipelines based on schedules or dependencies
Data encryption options available in AWS analytics services (for example, Amazon Redshift, Amazon EMR, AWS Glue)
Principle of least privilege as it applies to AWS security
Methods to protect data from unauthorized access across services