nerdexam
IBM

C2040-406 · Question #14

Mitchell wishes to disable transaction logging for a particular database on a server with transaction logging enabled. However, he cannot see the Advanced Database Properties to do so. What is the…

The correct answer is A. He is not in the "Administrators" field on the server document. See the full explanation below for the reasoning.

Question

Mitchell wishes to disable transaction logging for a particular database on a server with transaction logging enabled. However, he cannot see the Advanced Database Properties to do so. What is the cause of this?

Options

  • AHe is not in the "Administrators" field on the server document.
  • BHe cannot selectively turn off transaction logging for individual databases.
  • CTransaction logging can only be disabled per document, not for an entire database.
  • DHe must add the notes.ini parameter to the server: DisableTransLog=[name of database].

How the community answered

(27 responses)
  • A
    70% (19)
  • B
    4% (1)
  • C
    7% (2)
  • D
    19% (5)

Community Discussion

No community discussion yet for this question.

Full C2040-406 Practice