Question 250
A bucket owner's team needs request-level access records for object operations made against a specific S3 bucket where logging was enabled. Which source is most targeted?
- Azure Activity Log
- Amazon CloudWatch Logs
- Microsoft Entra sign-in logs
- Amazon S3 server access logs
Explanation
Correct Answer
D:S3 server access logging records qualifying bucket requests to a designated logging destination, on a best-effort delivery basis. It differs from aggregate network flow logs and may not be complete or immediate.
Incorrect Answers
A:Using Azure Activity Log may record Azure Resource Manager control-plane operations at subscription scope; it cannot independently examine a bucket's HTTP request activity.
B:Although Amazon CloudWatch Logs can collect and retain workload log messages in AWS log groups, it does not examine a bucket's HTTP request activity.
C:Microsoft Entra sign-in logs may record cloud identity sign-in attempts and outcomes, but here we must examine a bucket's HTTP request activity.
Question 251
An Azure subscription experienced suspicious resource deletions and investigators need subscription control-plane event records. Which Azure telemetry is the primary choice?
- Azure Activity Log
- Amazon S3 server access logs
- Amazon CloudWatch Logs
- AWS VPC Flow Logs
Explanation
Correct Answer
A:Azure Activity Log contains subscription-level control-plane events such as resource modifications and administrative operations. It is not the sign-in history of every user or the full contents of guest operating-system logs.
Incorrect Answers
B:Amazon S3 server access logs can generate bucket request records for S3 server access logging; analysts instead need to reconstruct deletion of an Azure resource.
C:Amazon CloudWatch Logs is suited to collect and retain workload log messages in AWS log groups, but not to reconstruct deletion of an Azure resource.
D:Using AWS VPC Flow Logs may summarize traffic metadata for AWS virtual network interfaces; it cannot independently reconstruct deletion of an Azure resource.
Question 252
An identity might have authenticated to a cloud application from an unusual region, and investigators need the sign-in outcome and conditional-access context. Which record family should be queried?
- Microsoft Entra sign-in logs
- Amazon CloudWatch Logs
- AWS CloudTrail management events
- Amazon S3 server access logs
- Azure Activity Log
- AWS VPC Flow Logs
Explanation
Correct Answer
A:Entra sign-in logs expose identity authentication activity and associated context according to permissions and retention. Their coverage is distinct from Azure resource management events.
Incorrect Answers
B:Amazon CloudWatch Logs may collect and retain workload log messages in AWS log groups; these events do not determine whether a user account authenticated to a cloud app.
C:AWS CloudTrail management events can capture logged AWS control-plane API requests and identities; this case requires investigators to determine whether a user account authenticated to a cloud app.
D:Amazon S3 server access logs can generate bucket request records for S3 server access logging; this will not determine whether a user account authenticated to a cloud app.
E:Azure Activity Log can record Azure Resource Manager control-plane operations at subscription scope; analysts instead need to determine whether a user account authenticated to a cloud app.
F:AWS VPC Flow Logs is suited to summarize traffic metadata for AWS virtual network interfaces, but not to determine whether a user account authenticated to a cloud app.
Question 253
An investigation requires records of a database principal reading a sensitive table where auditing was configured. Which evidence mechanism is designed to capture such events?
- MySQL general query log
- SQL Server Audit
- Database application audit trail
- MySQL slow query log
Explanation
Correct Answer
B:SQL Server Audit can record configured server- and database-level action groups to target files or logs. Absence of a record must be evaluated against the audit specification and retention.
Incorrect Answers
A:For MySQL general query log, the operation is to record received SQL statements and connections in MySQL when enabled; what matters here is to find audited access to a sensitive database table.
C:Database application audit trail helps document application-level business actions by authenticated users; it does not find audited access to a sensitive database table.
D:MySQL slow query log may record MySQL queries meeting slow-execution criteria, yet cannot establish how to find audited access to a sensitive database table.
Question 254
An examiner seeks limited historical SQL Server configuration or object-change events on an older instance with default trace enabled. Which source may supply them?
- MySQL general query log
- SQLite rollback journal
- SQL Server default trace
- SQL Server Audit
Explanation
Correct Answer
C:The SQL Server default trace can contain selected server events and rolls over quickly; it is a legacy diagnostic mechanism. It should not be equated with a complete query audit.
Incorrect Answers
A:To recover selected older server change events from a legacy trace, MySQL general query log is insufficient: it can record received SQL statements and connections in MySQL when enabled.
B:SQLite rollback journal is intended to store original SQLite page versions used to roll back in-progress transactions; it will not recover selected older server change events from a legacy trace.
D:For SQL Server Audit, the operation is to record selected SQL Server actions performed by database principals; what matters here is to recover selected older server change events from a legacy trace.
Question 255
A MySQL investigation needs statements received by the server, and it is known that general query logging was enabled during the incident. Which log type best matches?
- SQL Server default trace
- MySQL general query log
- Database application audit trail
- SQL Server Audit
- MySQL slow query log
Explanation
Correct Answer
B:The general query log records client connections and statements received according to configuration. It can be voluminous and sensitive, and existence of a statement does not by itself prove successful transaction commit.
Incorrect Answers
A:Although SQL Server default trace can retain a limited rotating set of SQL Server configuration and object events, it does not inspect statements submitted to a MySQL server.
C:Database application audit trail can document application-level business actions by authenticated users; the objective is to inspect statements submitted to a MySQL server.
D:To inspect statements submitted to a MySQL server, SQL Server Audit is insufficient: it can record selected SQL Server actions performed by database principals.
E:MySQL slow query log is intended to record MySQL queries meeting slow-execution criteria; it will not inspect statements submitted to a MySQL server.
Question 256
Server administrators preserved a log of SQL statements exceeding a configured execution-time threshold. Which source would contain that performance-oriented subset?
- SQL Server default trace
- Database application audit trail
- SQL Server Audit
- MySQL slow query log
Explanation
Correct Answer
D:The slow query log captures qualifying expensive or slow statements under configured conditions. It is unsuitable as a comprehensive record of all queries because faster statements may never appear.
Incorrect Answers
A:SQL Server default trace can retain a limited rotating set of SQL Server configuration and object events; analysts instead need to locate statements exceeding the configured time threshold.
B:Database application audit trail is suited to document application-level business actions by authenticated users, but not to locate statements exceeding the configured time threshold.
C:Using SQL Server Audit may record selected SQL Server actions performed by database principals; it cannot independently locate statements exceeding the configured time threshold.
Question 257
A database application used rollback-journal mode during an interrupted transaction and the examiner finds a journal companion file. What artifact may contain original pages required to undo incomplete changes?
- Database application audit trail
- MySQL slow query log
- SQLite rollback journal
- SQL Server Audit
Explanation
Correct Answer
C:SQLite rollback journals may preserve pre-change pages for transaction recovery under certain journaling modes. Their presence and recoverable content depend on transaction state and deletion behavior.
Incorrect Answers
A:Database application audit trail may document application-level business actions by authenticated users; these events do not investigate incomplete writes in rollback-journal mode.
B:MySQL slow query log can record MySQL queries meeting slow-execution criteria; this case requires investigators to investigate incomplete writes in rollback-journal mode.
D:SQL Server Audit can record selected SQL Server actions performed by database principals; analysts instead need to investigate incomplete writes in rollback-journal mode.
Question 258
An application exposes business-level logs of who approved a record, while database logs only show technical SQL connections. Which source best ties the approval to the app workflow?
- SQL Server default trace
- MySQL slow query log
- Database application audit trail
- MySQL general query log
- SQLite rollback journal
- SQL Server Audit
Explanation
Correct Answer
C:Application audit trails can capture authenticated users, actions and object identifiers at the business layer if correctly designed. They should be corroborated with identity and database evidence rather than accepted as infallible.
Incorrect Answers
A:SQL Server default trace describes how to retain a limited rotating set of SQL Server configuration and object events; it does not attribute an approval action within the application workflow.
B:MySQL slow query log helps record MySQL queries meeting slow-execution criteria; it does not attribute an approval action within the application workflow.
D:MySQL general query log may record received SQL statements and connections in MySQL when enabled; these events do not attribute an approval action within the application workflow.
E:SQLite rollback journal can store original SQLite page versions used to roll back in-progress transactions; this case requires investigators to attribute an approval action within the application workflow.
F:SQL Server Audit can record selected SQL Server actions performed by database principals; this will not attribute an approval action within the application workflow.
Question 259
A messaging app retains local conversation tables inside its private app data directory, and lawful file-system access has been obtained. Which artifact type should be examined?
- Apple KnowledgeC database
- Android app SQLite store
- Android UsageStats
- SIM ICCID
Explanation
Correct Answer
B:Android applications commonly store structured records in SQLite files, sometimes with WAL sidecars. Access is constrained by sandboxing and device encryption, so acquisition completeness must be documented.
Incorrect Answers
A:Apple KnowledgeC database is intended to store selected Apple device activity and contextual event records; it will not examine local chat tables from an app sandbox.
C:For Android UsageStats, the operation is to record Android application usage intervals and state changes; what matters here is to examine local chat tables from an app sandbox.
D:SIM ICCID describes how to identify a physical subscriber identity card with an issuer-assigned value; it does not examine local chat tables from an app sandbox.
Question 260
A device's available records may indicate when applications moved into foreground use, but do not reveal all user actions inside them. Which Android artifact category helps?
- SIM ICCID
- iOS encrypted backup
- Android UsageStats
- Apple KnowledgeC database
Explanation
Correct Answer
C:UsageStats can report app usage state transitions and related aggregates depending on version and retention. It supports activity timing but is not a substitute for detailed application logs.
Incorrect Answers
A:SIM ICCID may identify a physical subscriber identity card with an issuer-assigned value, but here we must identify approximate foreground application use.
B:iOS encrypted backup can preserve selected iOS data through a password-protected computer backup; the objective is to identify approximate foreground application use.
D:Apple KnowledgeC database is intended to store selected Apple device activity and contextual event records; it will not identify approximate foreground application use.