Crucial Exams

ISC2 Certified Secure Software Lifecycle Professional (CSSLP) Practice Question

During a security assessment of a microservices payment platform, you find the order-processing service connects to a PostgreSQL instance using a role that has SELECT, INSERT, UPDATE, and DELETE on every table. The service only needs to read order-status data. Which remediation best enforces least privilege?

  • Force the service to rotate its database credentials every 30 days while keeping current role privileges unchanged.

  • Deploy a web application firewall in front of the service to filter malicious input before it reaches the database.

  • Move the database to an isolated virtual private cloud (VPC) and maintain the existing role permissions.

  • Create a new database role for the service restricted to SELECT privileges on the required order-status tables only.

ISC2 Certified Secure Software Lifecycle Professional (CSSLP)
Secure Software Concepts
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot