ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 641 - SAA-C03 discussion

Report
Export

A company wants to analyze and troubleshoot Access Denied errors and Unauthonzed errors that are related to 1AM permissions The company has AWS CloudTrail turned on Which solution will meet these requirements with the LEAST effort?

A.
Use AWS Glue and write custom scripts to query CloudTrail logs for the errors
Answers
A.
Use AWS Glue and write custom scripts to query CloudTrail logs for the errors
B.
Use AWS Batch and write custom scripts to query CloudTrail logs for the errors
Answers
B.
Use AWS Batch and write custom scripts to query CloudTrail logs for the errors
C.
Search CloudTrail logs with Amazon Athena queries to identify the errors
Answers
C.
Search CloudTrail logs with Amazon Athena queries to identify the errors
D.
Search CloudTrail logs with Amazon QuickSight. Create a dashboard to identify the errors.
Answers
D.
Search CloudTrail logs with Amazon QuickSight. Create a dashboard to identify the errors.
Suggested answer: C

Explanation:

This solution meets the following requirements:

It is the least effort, as it does not require any additional AWS services, custom scripts, or data processing steps. Amazon Athena is a serverless interactive query service that allows you to analyze data in Amazon S3 using standard SQL. You can use Athena to query CloudTrail logs directly from the S3 bucket where they are stored, without any data loading or transformation. You can also use the AWS Management Console, the AWS CLI, or the Athena API to run and manage your queries.

It is effective, as it allows you to filter, aggregate, and join CloudTrail log data using SQL syntax. You can use various SQL functions and operators to specify the criteria for identifying Access Denied and Unauthorized errors, such as the error code, the user identity, the event source, the event name, the event time, and the resource ARN. You can also use subqueries, views, and common table expressions to simplify and optimize your queries.

It is flexible, as it allows you to customize and save your queries for future use. You can also export the query results to other formats, such as CSV or JSON, or integrate them with other AWS services, such as Amazon QuickSight, for further analysis and visualization.

Querying AWS CloudTrail Logs - Amazon Athena

Analyzing Data in S3 using Amazon Athena | AWS Big Data Blog

Troubleshoot IAM permisson access denied or unauthorized errors | AWS re:Post

asked 16/09/2024
jim eagleton
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first