C. Error logs contain IP address of SQL Server client connections
The textbook explains that SQL Server error logs include information about client connections, such as IP addresses, which can be useful for forensic investigations and troubleshooting.
SQL Server error logs can include details such as the IP addresses of client connections, which can be useful for forensic investigations. The SQL Server error logs can include details such as the IP addresses of client connections, which can be useful for forensic investigations. The other statements are either incorrect or refer to different functionalities within SQL Server. other statements are either incorrect or refer to different functionalities within SQL Server.
Not B < SQL Server Profiler is used to view the trace files, not the error log file.
C < SQL Server error logs record user-defined events and specific system events. The error logs also contain the IP Address of SQL Server client connections.
“D” is wrong because the “Trace Files” are not in the error logs.
The most correct is the letter “C”. (Module 11 Page 1056 do CHFIv10 book)
I think C is correct.
CHFI v10 book says "The SQL Server error logs record user-defined and specific system events. The error logs also contain the IP address of SQL server-client connections"
So C and D could be correct...
However, according to info-savvy there are 3 files
- Database & logs files
- Trace files records
- SQL Server error logs
So Trace files records are not in the SQL Server error logs and D is not correct.
https://info-savvy.com/determine-the-database-evidence-repositories-and-collect-the-evidence-files/
According to the CHFI v10 book the answer is D, but also C. ..."The SQL Server error logs record user-defined and specific system events. The error logs also contain the IP address of SQL server-client connections. A new error log file is created when a new SQL Server instance occurs."
It's C. The CFHI v10 manual pg 709 says "The SQL Server error logs record user-defined and specific system events. The error logs also contain the IP address of SQL server-client connections."
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
aqeel1506
10Â months agoala76nl
10Â months, 3Â weeks agoElb
1Â year agoElb
1Â year, 1Â month ago91a7fba
1Â year, 2Â months agoMalko59
1Â year, 9Â months agodiomaya
1Â year, 11Â months agojjweust
3Â years, 1Â month agohisham
2Â years agohtsi
3Â years, 5Â months agos_elyon
3Â years, 5Â months agoChaoticda
3Â years, 5Â months ago