CV0-002 · 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. To prevent performance issues and file locking on database files during security scanning, these files must be excluded from an Antivirus solution.
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
(16 responses)- B6% (1)
- C88% (14)
- D6% (1)
Why each option
To prevent performance issues and file locking on database files during security scanning, these files must be excluded from an Antivirus solution.
Intrusion Prevention Systems (IPS) monitor network traffic for threats and do not perform file-level scanning that would lock database files.
Intrusion Detection Systems (IDS) primarily detect suspicious network activity or system events and do not scan local files.
Antivirus software performs file-level scanning on a system to detect and remove malicious code. Scanning active database files can lead to significant performance degradation and file locking, necessitating the addition of database file paths to the Antivirus exclusion list to ensure proper database operation and performance.
Firewalls control network traffic based on rules and do not perform file-level scanning on a server's file system.
Concept tested: Antivirus file exclusion for database performance
Source: https://learn.microsoft.com/en-us/sql/relational-databases/security/antivirus-software-sql-server
Topics
Community Discussion
No community discussion yet for this question.