Question 120
Investigators must associate a remote-access session with the user authenticated by the corporate VPN concentrator. Which log is primary?
- Web proxy access log
- DHCP lease log
- VPN authentication log
- Recursive DNS log
- Firewall accept-deny log
Explanation
Correct Answer
C:VPN authentication and session records can connect account identity, assigned tunnel address and connection times. They should be correlated with endpoint and IdP events because stolen credentials can be used by another person.
Incorrect Answers
A:Web proxy access log can record proxied web requests and access policy outcomes; this misses the need to identify who authenticated to a VPN session.
B:For DHCP lease log, the operation is to associate temporarily leased IP addresses with clients and time periods; what matters here is to identify who authenticated to a VPN session.
D:Recursive DNS log helps record clients' attempted domain lookups at a DNS resolver; it does not identify who authenticated to a VPN session.
E:Firewall accept-deny log may record network access-control decisions for observed traffic, yet cannot establish how to identify who authenticated to a VPN session.
Question 121
A server may have received an inbound connection attempt that a perimeter rule rejected. Which telemetry best shows the rule verdict at that device?
- Web proxy access log
- IDS alert event
- Firewall accept-deny log
- DHCP lease log
Explanation
Correct Answer
C:Firewall logs can record permitted and denied flows, including addresses, ports, interface and matched policy. Such events generally do not prove the application's response or payload content.
Incorrect Answers
A:Web proxy access log can record proxied web requests and access policy outcomes; the objective is to determine whether a perimeter rule blocked an attempted connection.
B:To determine whether a perimeter rule blocked an attempted connection, IDS alert event is insufficient: it can signal traffic matching network intrusion detection rules.
D:DHCP lease log can associate temporarily leased IP addresses with clients and time periods; this misses the need to determine whether a perimeter rule blocked an attempted connection.
Question 122
An organization uses an explicit HTTP proxy and needs the requested URLs and policy outcomes for outbound browser activity. Which source is the best fit?
- DHCP lease log
- Web proxy access log
- Firewall accept-deny log
- Recursive DNS log
Explanation
Correct Answer
B:Proxy access records can show destination URLs or hosts, users and filtering decisions within the proxy's visibility. HTTPS inspection settings determine whether full paths are available.
Incorrect Answers
A:Using DHCP lease log may associate temporarily leased IP addresses with clients and time periods; it cannot independently reconstruct outbound web proxy requests.
C:Firewall accept-deny log may record network access-control decisions for observed traffic, but here we must reconstruct outbound web proxy requests.
D:Recursive DNS log can record clients' attempted domain lookups at a DNS resolver; the objective is to reconstruct outbound web proxy requests.
Question 123
A sensor reports that a network signature matched traffic resembling command injection, but investigators still need to confirm compromise. Which evidence type is this?
- Firewall accept-deny log
- VPN authentication log
- Web proxy access log
- Recursive DNS log
- DHCP lease log
- IDS alert event
Explanation
Correct Answer
F:IDS alerts report detection-rule matches with identifiers, severity and network context. The match is an investigative lead rather than incontrovertible proof that an exploit succeeded.
Incorrect Answers
A:Firewall accept-deny log can record network access-control decisions for observed traffic; this will not classify a signature-generated suspicious traffic event.
B:VPN authentication log can link a remote tunnel session to its authenticated account and assigned address; analysts instead need to classify a signature-generated suspicious traffic event.
C:Web proxy access log is suited to record proxied web requests and access policy outcomes, but not to classify a signature-generated suspicious traffic event.
D:Using Recursive DNS log may record clients' attempted domain lookups at a DNS resolver; it cannot independently classify a signature-generated suspicious traffic event.
E:Although DHCP lease log can associate temporarily leased IP addresses with clients and time periods, it does not classify a signature-generated suspicious traffic event.
Question 124
A SQL Server instance is offline and an examiner must identify the primary data file containing database pages and essential metadata. Which file type is expected?
- InnoDB redo log
- MySQL binary log
- SQL Server primary MDF
- SQLite main database
Explanation
Correct Answer
C:An MDF primary data file stores SQL Server database pages, including system catalog information. A consistent acquisition may also require log and secondary data files to recover an accurate state.
Incorrect Answers
A:InnoDB redo log may support crash recovery of InnoDB data-page modifications, yet cannot establish how to identify the main SQL Server data-file extension.
B:MySQL binary log may retain MySQL change events for replication and recovery; these events do not identify the main SQL Server data-file extension.
D:SQLite main database can store the primary persistent SQLite schema and table pages; this will not identify the main SQL Server data-file extension.
Question 125
A team investigates recent database changes and needs the transaction log associated with an SQL Server database. Which file is most relevant?
- SQLite write-ahead log
- SQL Server transaction LDF
- MySQL binary log
- InnoDB redo log
Explanation
Correct Answer
B:The LDF transaction log records operations needed for recovery and can support reconstruction of changes subject to log retention and reuse. It is distinct from a table's current data-page contents.
Incorrect Answers
A:For SQLite write-ahead log, the operation is to retain newer SQLite page versions awaiting checkpoint; what matters here is to find a database's associated transaction log.
C:MySQL binary log helps retain MySQL change events for replication and recovery; it does not find a database's associated transaction log.
D:InnoDB redo log may support crash recovery of InnoDB data-page modifications, yet cannot establish how to find a database's associated transaction log.
Question 126
The investigator needs a record of database-changing operations or row changes that were logged for MySQL replication and point-in-time recovery. Which log is the primary target?
- InnoDB redo log
- SQLite main database
- MySQL binary log
- SQL Server primary MDF
- SQLite write-ahead log
Explanation
Correct Answer
C:MySQL binary logs record qualifying data changes in statement, row or mixed formats when enabled. Their contents and retention depend on server settings and rotation, so missing entries need careful interpretation.
Incorrect Answers
A:To reconstruct logged MySQL data modifications, InnoDB redo log is insufficient: it can support crash recovery of InnoDB data-page modifications.
B:SQLite main database is intended to store the primary persistent SQLite schema and table pages; it will not reconstruct logged MySQL data modifications.
D:For SQL Server primary MDF, the operation is to contain primary SQL Server data and metadata pages; what matters here is to reconstruct logged MySQL data modifications.
E:SQLite write-ahead log describes how to retain newer SQLite page versions awaiting checkpoint; it does not reconstruct logged MySQL data modifications.
Question 127
A database crash left transactions needing replay to restore durable page changes. Which MySQL InnoDB structure is intended for crash recovery?
- InnoDB redo log
- MySQL binary log
- SQLite write-ahead log
- SQLite main database
Explanation
Correct Answer
A:InnoDB redo logging records changes required to recover modified data pages after a crash. It is not a substitute for the binary log's replication history or a complete user audit trail.
Incorrect Answers
B:MySQL binary log may retain MySQL change events for replication and recovery, but here we must identify the InnoDB crash-recovery mechanism.
C:SQLite write-ahead log can retain newer SQLite page versions awaiting checkpoint; the objective is to identify the InnoDB crash-recovery mechanism.
D:To identify the InnoDB crash-recovery mechanism, SQLite main database is insufficient: it can store the primary persistent SQLite schema and table pages.
Question 128
An app's SQLite main database is missing recent committed records because it uses WAL journaling. Which companion file should be examined first?
- SQLite write-ahead log
- SQL Server primary MDF
- SQLite main database
- SQL Server transaction LDF
Explanation
Correct Answer
A:SQLite's WAL file can hold committed pages not yet checkpointed into the main database. Acquiring main database and sidecars together protects the consistency and currency of the examined state.
Incorrect Answers
B:SQL Server primary MDF is suited to contain primary SQL Server data and metadata pages, but not to recover recently committed uncheckpointed database changes.
C:Using SQLite main database may store the primary persistent SQLite schema and table pages; it cannot independently recover recently committed uncheckpointed database changes.
D:Although SQL Server transaction LDF can record SQL Server transaction activity for recovery purposes, it does not recover recently committed uncheckpointed database changes.
Question 129
A mobile application's message table is to be examined from its central SQLite file rather than from rollback or WAL companions. What is the primary evidence container?
- SQL Server transaction LDF
- SQL Server primary MDF
- MySQL binary log
- SQLite main database
- SQLite write-ahead log
- InnoDB redo log
Explanation
Correct Answer
D:The main SQLite database holds the persistent schema and pages representing its checkpointed state. It should be interpreted alongside available journals to avoid losing newer or uncommitted context.
Incorrect Answers
A:SQL Server transaction LDF may record SQL Server transaction activity for recovery purposes; these events do not identify the central database containing message tables.
B:SQL Server primary MDF can contain primary SQL Server data and metadata pages; this case requires investigators to identify the central database containing message tables.
C:MySQL binary log can retain MySQL change events for replication and recovery; this will not identify the central database containing message tables.
E:SQLite write-ahead log is suited to retain newer SQLite page versions awaiting checkpoint, but not to identify the central database containing message tables.
F:Using InnoDB redo log may support crash recovery of InnoDB data-page modifications; it cannot independently identify the central database containing message tables.
Question 130
An Android app uses SQLite write-ahead logging. A forensic copy must preserve the main checkpointed database plus recent committed pages not yet checkpointed. Which TWO files should be collected together? Choose TWO.
- A SQLite rollback journal from a different database
- A SQL Server .ldf transaction log
- A MySQL binary log
- Its corresponding SQLite -wal file
- The main SQLite database file
Explanation
Correct Answers
D:The write-ahead log can hold newer committed page versions that have not entered the main file. Acquiring it with the database prevents an outdated reconstruction.
E:The database contains the persistent schema and checkpointed table pages. It remains necessary even when the most recent activity has been appended elsewhere.
Incorrect Answers
A:The stated database is in WAL mode, and a journal for another database cannot be substituted for its own current write-ahead pages.
B:LDF logs belong to Microsoft SQL Server databases, not the embedded SQLite database used by the Android application.
C:Binary logs record configured MySQL changes for replication and recovery. They are not the sidecar files of a SQLite WAL-mode database.