Question 360
An authorized security review documents this behavior: Most application database access uses safe ORM methods, but a developer constructs one raw query by interpolating an untrusted sort parameter. Which mechanism best accounts for the finding?
- Error-based SQL injection
- Stacked query injection
- Dynamic SQL inside stored procedure
- LIKE wildcard misunderstanding
- ORM raw-query misuse
Explanation
Correct Answer
E:ORM frameworks reduce injection risk only when their parameterization guarantees are used; raw SQL interpolation can restore the vulnerable concatenation path. This is why teams should use bound ORM query APIs and allowlisted sort-field identifiers; values can be bound as parameters, while SQL identifiers usually require explicit selection from trusted permitted column names.
Incorrect Answers
A:Error-based SQL injection extracts information through database-generated errors when untrusted input alters SQL syntax and diagnostics reach the client; the events given do not establish this behavior but do support ORM raw-query misuse.
B:Stacked SQL injection relies on executing additional statements in the same request, a capability controlled by database and connector behavior; the reported conditions are characteristic of ORM raw-query misuse, not that path.
C:Stored procedures are not intrinsically injection-safe when they build and execute dynamic SQL using untrusted strings; those prerequisites differ from the ORM raw-query misuse behavior in the record.
D:Parameterization prevents SQL syntax injection, yet LIKE pattern characters can still change matching semantics if the application expects literal user text; this would classify another type of evidence, whereas the actual finding shows ORM raw-query misuse.
Question 361
A controlled investigation yields this observation: An employee leaves the company with a personally owned phone containing a managed work profile and private family photos. How should the team identify the underlying behavior?
- Excessive mobile permissions
- MDM selective wipe
- Android work profile isolation
- Cleartext mobile API traffic
Explanation
Correct Answer
B:Mobile device management can distinguish corporate-managed data from personal content when supported enrollment and separation features are used. The appropriate hardening measure is to use managed-profile selective wipe for departing BYOD employees, since removing organization-managed accounts and content preserves legitimate corporate control without unnecessarily erasing personal data.
Incorrect Answers
A:Overprivileged mobile apps expand the information available after compromise or abuse; the platform permission model should track actual features; the reported conditions are characteristic of MDM selective wipe, not that path.
C:An Android work profile partitions managed applications and data from the personal profile, supporting differentiated security policy on BYOD devices; this would classify another type of evidence, whereas the actual finding shows MDM selective wipe.
D:Cleartext traffic exposes credentials and session data to local network observers or malicious intermediaries because confidentiality and server authentication are absent; the relevant mechanism in the observed workflow is MDM selective wipe instead.
Question 362
An incident analyst is asked to classify this observed activity: The robots.txt file lists a path named /internal-dashboard and the path responds to unauthenticated requests. Which concept is the closest match?
- Public document metadata
- Search operators for exposure
- Internet archive reconnaissance
- Exposed robots instructions
Explanation
Correct Answer
D:Crawler directives tell cooperative bots what not to crawl but remain publicly readable and cannot restrict a human client's direct HTTP request. On affected systems, it is useful to protect listed routes with server-side authentication and authorization; routing secrecy and robots exclusions cannot substitute for a check that the requesting identity is allowed to reach the resource.
Incorrect Answers
A:Document metadata can carry author names, revision details, software identifiers, and filesystem paths omitted from the visible body; those prerequisites differ from the exposed robots instructions behavior in the record.
B:Search operators refine the results a search engine has already indexed; they do not bypass origin authentication to retrieve private content; this would classify another type of evidence, whereas the actual finding shows exposed robots instructions.
C:Historical web snapshots reveal previously published routes and configuration clues that are no longer linked from the live website; the relevant mechanism in the observed workflow is exposed robots instructions instead.
Question 363
A remediation meeting focuses on the following finding: The malware lab needs to evaluate a dangerous invoice attachment's filesystem and outbound behavior without allowing it to communicate with live production systems. Which proposed action best addresses its root cause?
- Limit untrusted extensions and investigate unauthorized collection processes
- Use isolated instrumented sandboxes and corroborate behavior with endpoint telemetry
- Collect process command lines and script telemetry with behavioral detection
- Constrain script execution and detect abnormal parent-child process chains
Explanation
Correct Answer
B:Containment protects production assets, while realistic execution context and external telemetry reduce missed behaviors from samples that detect analysis environments. It targets the actual failure mode: dynamic malware analysis studies execution effects under controlled conditions; evasion and missing environmental triggers can produce incomplete results.
Incorrect Answers
A:Browser and endpoint controls reduce hidden collection channels, while network egress monitoring can identify telemetry sent to unapproved destinations; the tested weakness is sandbox detonation, not the spyware collection configuration addressed here.
C:Observing interpreter behavior and memory-backed execution identifies activity that signature scans of executable files may overlook; the proposed improvement would make sense for fileless memory execution but not as the main fix here; the tested fault instead involves sandbox detonation.
D:Behavioral context catches misuse of approved binaries without incorrectly treating every built-in administration utility as malware; the specific root cause belongs to sandbox detonation, beyond this control's intended scope.
Question 364
A controlled investigation yields this observation: Operations wants to defer a vendor fix on a legacy device until replacement because patching would interrupt a safety-critical process. How should the team identify the underlying behavior?
- Unauthenticated assessment
- Formal risk acceptance
- Risk-based patch prioritization
- Remediation retest
Explanation
Correct Answer
B:Risk acceptance is a documented decision by an authorized risk owner to tolerate residual exposure with an understood rationale and review date. For a production safeguard, operators can document compensating controls, owner approval, and an expiry date; a time-bound exception preserves accountability for unpatched risk and ensures temporary operational constraints do not become an indefinite exemption.
Incorrect Answers
A:Unauthenticated scanning assesses exposed services and observable configuration from a chosen network vantage point, not hidden local state; the relevant mechanism in the observed workflow is formal risk acceptance instead.
C:Exposure and exploit conditions influence practical risk even when the underlying vulnerability ID and published severity match; the case demonstrates formal risk acceptance rather than the alternate mechanism.
D:Remediation status is not equivalent to demonstrated vulnerability removal; deployment failures, missed nodes, or compensating paths can leave exposure; the observed evidence concerns formal risk acceptance instead.
Question 365
The testing team seeks a specific preventive recommendation for this finding: A read-only analytics feature connects with credentials that can drop schemas and grant accounts, making the potential blast radius far larger than its job requires. What should be implemented?
- Change the database service port while retaining its existing grants
- Grant narrow database rights to the application identity
- Encrypt database traffic without changing the account's permission grants
- Rotate the application account password but leave its administrator rights intact
Explanation
Correct Answer
B:Read-only view-level permissions constrain reachable data and avoid unnecessarily permitting schema or identity changes through compromised SQL access. The safeguard responds to the underlying issue: excess database privileges increase impact after SQL injection or credential theft, allowing unwanted modifications beyond the legitimate query purpose.
Incorrect Answers
A:A nondefault listener port does not change what the overprivileged application identity can execute; the overprivileged application database account weakness in the question therefore remains uncorrected.
C:TLS protects in-transit messages and cannot reduce excessive DDL or user-management privileges granted to an identity; the overprivileged application database account weakness in the question therefore remains uncorrected.
D:Credential rotation protects a secret's lifetime but does not remove capabilities the account should never hold; the overprivileged application database account weakness in the question therefore remains uncorrected.
Question 366
The assessment evidence reads as follows: An authorized assessment began with only a public URL and no account credentials, architectural diagrams, or internal configuration details. Which technical concept explains the result?
- White-box assessment
- Risk assessment
- Gray-box assessment
- Black-box assessment
Explanation
Correct Answer
D:Black-box testing models an outside party with little prior knowledge. It emphasizes externally discoverable paths but offers less coverage of privileged or internal behaviors. For a production safeguard, operators can record black-box coverage limitations in the final report; the conclusion should describe the outside-in vantage point; inaccessible authenticated functions cannot be declared secure merely because this test did not reach them.
Incorrect Answers
A:White-box assessment uses extensive design and implementation knowledge to inspect hidden execution paths, business logic, and code-level weaknesses unavailable externally; the case demonstrates black-box assessment rather than the alternate mechanism.
B:Risk incorporates likelihood, business exposure, and impact; technical severity alone does not determine the order of remediation for distinct operational contexts; the observed evidence concerns black-box assessment instead.
C:Gray-box testing combines partial internal knowledge with constrained access; it helps examine authorization boundaries while retaining a realistic nonadministrative perspective; the test record points specifically to black-box assessment, not this separate mechanism.
Question 367
The post-assessment action plan cites this evidence: Compliance auditing flags obsolete encryption settings and unnecessary administrator shares on a fully patched server, but the operator insists that patching alone closes the audit. Which corrective measure should be prioritized?
- Correct hardening drift and retest benchmark controls
- Remediate reachable high-impact instances first while tracking both
- Apply explicit target allowlists and test exclusions before execution
- Map CVEs to affected versions and verified remediation advisories
Explanation
Correct Answer
A:Turning off unnecessary services and tightening audit policies addresses exposure that patch installation alone cannot remove. The specific weakness being corrected is that configuration assessment compares deployed settings to a defined security benchmark; vulnerability risk can result from misconfiguration without a missing software update.
Incorrect Answers
B:Risk-based sequencing addresses likely exploitation paths without treating lower-exposure hosts as permanently exempt from remediation; the exposure here is configuration benchmark assessment, which calls for another protective mechanism.
C:Enforced scope controls keep sensitive or prohibited assets outside the scan regardless of how network ranges are discovered; the action is aimed at assessment exclusions; it leaves the central configuration benchmark assessment condition unresolved.
D:Version matching and vendor guidance establish whether an asset is exposed and which update or workaround addresses that vulnerability; this is relevant to a separate CVE identifier scenario, rather than the identified exposure; the tested fault instead involves configuration benchmark assessment.
Question 368
A defender analyzing an approved exercise sees this pattern: A Windows audit finds that stolen NTLM material can authenticate to a remote service without recovering the plaintext password. Which mechanism is most consistent with it?
- Pass-the-hash authentication
- Offline password hash attack
- SSH authorized-key persistence
- Credential stuffing
Explanation
Correct Answer
A:Pass-the-hash reuses suitable password-derived authentication material directly in NTLM exchanges; it is not the same as decrypting a stored password. This is why teams should limit reusable administrative credentials and reduce NTLM exposure; credential isolation, separate admin accounts, and modern authentication reduce opportunities for a stolen hash to authenticate across hosts.
Incorrect Answers
B:Offline cracking compares computed candidate hashes with stored password verifiers; network account lockouts do not normally constrain the local comparison process; that behavior is distinct from the pass-the-hash authentication finding being classified.
C:SSH public-key authentication trusts allowed public keys in account configuration; adding an unapproved key can preserve remote access independent of password rotation; the scenario identifies pass-the-hash authentication, which has a different triggering condition.
D:Credential stuffing replays stolen username-password pairs at other applications, relying on password reuse rather than creating guesses from a dictionary; the defining symptom in the prompt is associated with pass-the-hash authentication instead.
Question 369
A remediation meeting focuses on the following finding: A compromised workstation contacts other susceptible machines over a vulnerable file-sharing service and creates new infections without requiring users to launch copied attachments. Which proposed action best addresses its root cause?
- Use integrity monitoring and execution controls on trusted binaries
- Patch exploited services and restrict east-west communication
- Enforce signed drivers and use trusted offline or external inspection
- Correlate high-volume failed DNS queries and apply protective DNS
Explanation
Correct Answer
B:Closing the propagation path and segmenting reachable hosts limits autonomous spread faster than relying on employee attachment awareness alone. That correction is linked to the fact that a worm propagates itself through reachable systems or vulnerabilities without requiring each victim to execute a host document manually.
Incorrect Answers
A:File verification and controlled execution help identify infected hosts and interrupt propagation through modified application files; the measure addresses a different trust boundary from the self-replicating worm finding.
C:Kernel integrity protections reduce unauthorized code loading; independent inspection avoids trusting potentially subverted in-host enumeration; its security benefit applies principally to kernel rootkit, not the defect described; the tested fault instead involves self-replicating worm.
D:Unusual query distributions and known algorithmic patterns help detect rotating rendezvous attempts before a successful connection; the exposure here is self-replicating worm, which calls for another protective mechanism.
Question 370
A production hardening ticket was raised after this confirmed observation: The SMTP server expands distribution-list membership for outside requesters, revealing the addresses of employees who are supposed to remain private. Which action best targets the risk?
- Restrict share listing and access through SMB permissions and segmentation
- Restrict SMTP EXPN and directory-list visibility to authorized users
- Protect routing management interfaces and authenticate peer sessions
- Disable anonymous enumeration and review guest or null-session policies
Explanation
Correct Answer
B:A restricted expansion policy preserves legitimate mail flow while avoiding needless disclosure of group membership to external peers. That correction is linked to the fact that SMTP EXPN may reveal distribution-list membership and addresses when the gateway permits expansion to untrusted requesters.
Incorrect Answers
A:Share and NTFS permissions plus network isolation reduce unauthorized resource browsing even when SMB must remain available to staff; this is relevant to a separate SMB share enumeration scenario, rather than the identified exposure; the tested fault instead involves SMTP EXPN group expansion.
C:Restricting management access and securing routing neighbors reduces unwanted disclosure and unauthorized route-policy changes; that safeguard does not directly close the SMTP EXPN group expansion route highlighted by the test.
D:Explicitly limiting unauthenticated SMB and RPC access prevents account and share disclosure while preserving required authenticated service use; the proposed improvement would make sense for SMB null-session exposure but not as the main fix here; the tested fault instead involves SMTP EXPN group expansion.