You are working as a SOC analyst for a cloud-based service provider that relies on PostgreSQL databases to store critical customer data. During a security review, you discover that logs are not being generated for failed authentication attempts, slow queries, or database errors. This lack of visibility is making it difficult to detect threats and investigate suspicious activity. To ensure PostgreSQL captures and stores logs for centralized monitoring and forensic analysis, which configuration parameter should you enable?
Correct Answer: B
In PostgreSQL, the configuration parameter that enables writing logs to files via the logging collector process islog_collector. When enabled, PostgreSQL can collect stderr output from backend processes and route it into log files, which is foundational for centralized log shipping and retention. From a SOC standpoint, turning on log collection is necessary but not sufficient: you typically also need to configure what gets logged (authentication failures, statement duration thresholds for slow queries, and error verbosity), define log line prefixes for consistent parsing, and set rotation/retention to meet operational and compliance needs. However, the question specifically asks which parameter should be enabled to ensure PostgreSQL captures and stores logs, and log_collector is the correct parameter name and casing. The other options include incorrect naming or formatting. Once enabled, the SOC team can forward PostgreSQL logs to the SIEM to correlate database activity with identity, endpoint, and network signals-critical for detecting brute force attempts, suspicious administrative actions, and anomalous query behavior.
Question 107
A company's SIEM is generating a high number of alerts, overwhelming the SOC team with false positives and irrelevant notifications. This reduces efficiency as analysts struggle to identify genuine incidents. To address this, the security team refines their approach by defining clear threat detection scenarios aligned with their environment and risk profile. This is expected to improve detection accuracy and streamline incident response. Which process is the team implementing?
Correct Answer: A
SIEM use case management is the process of defining, implementing, tuning, and governing detection scenarios (use cases) so that alerts align with the organization's real risks and operating environment. High false positives often result from generic rules not tuned to local baselines, missing context, or unclear detection objectives. Use case management addresses this by documenting what threat is being detected, what data sources are required, what "good" vs "bad" looks like, expected false positives, severity mapping, and response actions. It includes iterative tuning: refining thresholds, adding allowlists, improving parsing /normalization, and validating detections against real activity and test cases. "Security analytics" is a broad term that includes detections and analysis, but the question emphasizes a structured process of defining scenarios aligned to risk-use case management. IT compliance is focused on meeting regulatory requirements, not reducing alert noise through scenario design. Log forensics is deep investigation of events after the fact, not the proactive engineering process of improving detection quality. From a SOC viewpoint, mature use case management is a primary lever for reducing alert fatigue while increasing true-positive detection.
Question 108
Identify the type of attack, an attacker is attempting on www.example.com website.
Correct Answer: A
The scenariodepicted suggests an attacker is injecting a script into the URL of the website "www.example. com" which triggers an alert message. This behavior is characteristic of a Cross-site Scripting (XSS) attack. In XSS attacks, attackers exploit vulnerabilities in web applications to inject malicious scripts into web pages viewed by other users. The injected scripts can steal user data, deface web pages, or redirect users to malicious sites. The specific attack vector here involves the attacker adding a script to the URL that causes the website to display an alert message. This indicates that the website is not properly sanitizing its inputs, which is how the attacker is able to execute the script in the context of the user's browser session. References: TheEC-Council's Certified SOC Analyst (CSA) program covers various types of cyberattacks, including XSS attacks. The CSA course materials and study guides provide detailed information on identifying, mitigating, and preventing such attacks, as well as best practices for securing web applications against them.
Question 109
A SOC team notices malware-related incidents increased over the past six months, primarily targeting endpoints through phishing campaigns. They need to present a report to security leadership to justify investing in advanced email filtering and end-user security training. Which SOC report best supports their case?
Correct Answer: D
A trend analysis report is designed to show how incident frequency, types, severity, and impact change over time, which is exactly what leadership needs for investment decisions. The scenario is about demonstrating an increase in malware incidents over six months and linking them to phishing as an entry vector. A trend report can quantify growth rates, highlight recurring patterns, identify peak periods, compare pre- and post-control effectiveness, and estimate business risk (downtime, remediation hours, affected users). This supports a clear business case for budget: if phishing-driven malware is increasing, investments in email filtering and user training directly address the root cause and should reduce future incident volume. A monitoring summary report may provide a snapshot but often lacks time-series depth. A real-time monitoring report focuses on current status and active alerts, not long-term justification. An incident report is typically focused on a single event and is useful for lessons learned but not for demonstrating systemic trends. From a SOC management perspective, trend analysis aligns technical evidence with strategic decisions, making it the most effective report type to support funding for preventive controls and awareness programs.
Question 110
John, SOC analyst wants to monitor the attempt of process creation activities from any of their Windows endpoints. Which of following Splunk query will help him to fetch related logs associated with process creation?
Correct Answer: B
)ComprehensiveDetailedStepbyStepExplanation:InWindowssecurityeventlogs, EventCode4688signifiesaprocesscreationevent.TheSplunkquery'index=windowsLogName=SecurityEventCode =4688NOT(AccountName=)is used to fetch logs related to process creation activities. This query filters the logs to only show events where a new process has been created, which is indicated by EventCode 4688. The NOT (Account_Name=$)` part of the query excludes any events where the account name ends with a dollar sign, which typically represents a machine or service account. References: The EC-Council's Certified SOC Analyst (CSA) program provides detailed knowledge on security operation center (SOC) operations, including log management and correlation, SIEM deployment, advanced incident detection, and incident response. The CSA course materials and study guides cover the use of Splunk for monitoring and analyzing security events, which would include the creation of such queries for process creation monitoring1
