SAP
C_TADM53_70 · Question #19
Every SQL Server database stores its data in various types of operating system files. To administer a database, it is important to understand its physical structure. Which files are always required?…
The correct answer is C. Secondary files are used to store data. D. The primary file is always required. E. Data and log information are never stored in the same file. See the full explanation below for the reasoning.
Question
Every SQL Server database stores its data in various types of operating system files. To administer a database, it is important to understand its physical structure. Which files are always required? (Choose three)
Options
- AAt least one secondary file is always required, because every database always uses at least two
- BThe primary file stores the log information used to recover the database.
- CSecondary files are used to store data.
- DThe primary file is always required.
- EData and log information are never stored in the same file.
How the community answered
(51 responses)- A8% (4)
- B16% (8)
- C76% (39)
Community Discussion
No community discussion yet for this question.