ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 569 - SAA-C03 discussion

Report
Export

A company has deployed its application on Amazon EC2 instances with an Amazon RDS database. The company used the principle of least privilege to configure the database access credentials. The company's security team wants to protect the application and the database from SQL injection and other web-based attacks.

Which solution will meet these requirements with the LEAST operational overhead?

A.
Use security groups and network ACLs to secure the database and application servers.
Answers
A.
Use security groups and network ACLs to secure the database and application servers.
B.
Use AWS WAF to protect the application. Use RDS parameter groups to configure the security settings.
Answers
B.
Use AWS WAF to protect the application. Use RDS parameter groups to configure the security settings.
C.
Use AWS Network Firewall to protect the application and the database.
Answers
C.
Use AWS Network Firewall to protect the application and the database.
D.
Use different database accounts in the application code for different functions. Avoid granting excessive privileges to the database users.
Answers
D.
Use different database accounts in the application code for different functions. Avoid granting excessive privileges to the database users.
Suggested answer: B

Explanation:

AWS WAF is a web application firewall that helps protect web applications from common web exploits that could affect application availability, compromise security, or consume excessive resources. AWS WAF allows users to create rules that block, allow, or count web requests based on customizable web security rules. One of the types of rules that can be created is an SQL injection rule, which allows users to specify a list of IP addresses or IP address ranges that they want to allow or block. By using AWS WAF to protect the application, the company can prevent SQL injection and other web-based attacks from reaching the application and the database.

RDS parameter groups are collections of parameters that define how a database instance operates. Users can modify the parameters in a parameter group to change the behavior and performance of the database. By using RDS parameter groups to configure the security settings, the company can enforce best practices such as disabling remote root login, requiring SSL connections, and limiting the maximum number of connections.

The other options are not correct because they do not effectively protect the application and the database from SQL injection and other web-based attacks. Using security groups and network ACLs to secure the database and application servers is not sufficient because they only filter traffic at the network layer, not at the application layer. Using AWS Network Firewall to protect the application and the database is not necessary because it is a stateful firewall service that provides network protection for VPCs, not for individual applications or databases. Using different database accounts in the application code for different functions is a good practice, but it does not prevent SQL injection attacks from exploiting vulnerabilities in the application code.

AWS WAF

How AWS WAF works

Working with IP match conditions

Working with DB parameter groups

Amazon RDS security best practices

asked 16/09/2024
Aparecido Lemos
34 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first