Exam 312-49v10 topic 1 question 547 discussion

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.

Error logs contain IP address of SQL Server client connections

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."

Answer is C: The error logs also contain the IP address of SQL server-client connections.

https://info-savvy.com/determine-the-database-evidence-repositories-and-collect-the-evidence-files/

Answer is D