nerdexam
CompTIA

CV0-003 · Question #332

A tenant has provisioned a new database server. It needs to add the database files in the exclusion list for security scanning, as it allows down the performance and locks the database file. Which…

The correct answer is C. Antivirus. Antivirus software performs local file scanning and can lock database files during scans, degrading performance - making exclusion lists a core antivirus feature.

Security

Question

A tenant has provisioned a new database server. It needs to add the database files in the exclusion list for security scanning, as it allows down the performance and locks the database file. Which of the following solutions must have this exclusion?

Options

  • AIPS
  • BIDS
  • CAntivirus
  • DFirewall

How the community answered

(35 responses)
  • A
    6% (2)
  • B
    3% (1)
  • C
    89% (31)
  • D
    3% (1)

Why each option

Antivirus software performs local file scanning and can lock database files during scans, degrading performance - making exclusion lists a core antivirus feature.

AIPS

An IPS monitors and blocks malicious network traffic in transit and does not perform local file scanning or acquire file locks on the host.

BIDS

An IDS passively monitors network traffic for suspicious patterns and does not interact with files stored on a database server.

CAntivirusCorrect

Antivirus engines actively scan files on disk and can acquire file locks during the process, which directly interferes with database engines that require exclusive or shared access to their data files. Antivirus solutions provide exclusion lists specifically to exempt high-I/O files like database files from real-time scanning, preventing both performance degradation and file locking conflicts.

DFirewall

A firewall controls network-layer traffic flow between segments and has no mechanism to scan or lock local files on a server.

Concept tested: Antivirus exclusion lists for database files

Source: https://learn.microsoft.com/en-us/defender-endpoint/configure-exclusions-microsoft-defender-antivirus

Topics

#antivirus exclusion#database performance#security scanning#file locking

Community Discussion

No community discussion yet for this question.

Full CV0-003 Practice