Question 600
At Brookside Manufacturing, the industrial security team is conducting a plant safety and IT security assessment under requirements for production continuity and controlled test windows. Following the approved correction, auditors require proof that: A data export permits arbitrary filter expressions that are appended to SQL despite a published fixed set of report filters. Which result BEST demonstrates successful remediation?
Explanation
Correct Answer
Approved filters produce accurate reports and malformed filter expressions cannot alter the query grammar. The observable result demonstrates that the documented condition, A data export permits arbitrary filter expressions that are appended to SQL despite a published fixed set of report filters. has been addressed. The planned remediation is: Replace free-form SQL fragments with a structured allowlisted filter model and bound query values. This is a stronger validation than a saved ticket or unverified claim by Brookside Manufacturing.
Incorrect Answers
Equivalent benign input is handled safely across supported drivers without SQL syntax reinterpretation. That observation would verify another scenario: A search endpoint attempts to escape SQL syntax manually with string replacement and fails under a different database driver. The corrective step for that other scenario is: Use driver-supported prepared statements or bound parameters rather than custom escaping rules. But Brookside Manufacturing is evaluating: A data export permits arbitrary filter expressions that are appended to SQL despite a published fixed set of report filters. The necessary outcome is: Approved filters produce accurate reports and malformed filter expressions cannot alter the query grammar.
The report distinguishes statistically reproducible effects from normal latency and avoids unsupported exploit claims. That observation would verify another scenario: A vulnerability finding claims blind SQL injection solely because one slow response followed a malformed search term. The corrective step for that other scenario is: Use repeatable authorized tests and controlled baselines before attributing timing variation to query manipulation. But Brookside Manufacturing is evaluating: A data export permits arbitrary filter expressions that are appended to SQL despite a published fixed set of report filters. The necessary outcome is: Approved filters produce accurate reports and malformed filter expressions cannot alter the query grammar.
A test account can read intended report records but cannot modify schema or privileged tables. That observation would verify another scenario: An application runs every reporting query with a database administrator identity even though users only need read access. The corrective step for that other scenario is: Use a dedicated least-privilege database account scoped to required tables and operations. But Brookside Manufacturing is evaluating: A data export permits arbitrary filter expressions that are appended to SQL despite a published fixed set of report filters. The necessary outcome is: Approved filters produce accurate reports and malformed filter expressions cannot alter the query grammar.