Computer Hacking Forensic Investigator (CHFI v10) — Question 285

Which of the following is considered as the starting point of a database and stores user data and database objects in an MS SQL server?

Answer options

• A. ibdata1
• B. Application data files (ADF)
• C. Transaction log data files (LDF)
• D. Primary data files (MDF)

Correct answer: D

Explanation

The correct answer is D, Primary data files (MDF), as they are essential for storing the main data and objects within a database. Options A, B, and C do not fulfill this role; ibdata1 is associated with MySQL, Application data files (ADF) are for application-specific data, and Transaction log data files (LDF) are used for logging transactions but do not store user data.