A company's database was hit by ransomware, but the administrator was able to restore data from backups. However, the backups were also encrypted because they were stored on a network share that was accessible to the compromised server. The administrator wants to ensure future backups are protected from ransomware. Which backup strategy is MOST effective?

Increase the frequency of backups

Store backups on the same server as the database

Store backups offline or in an isolated environment that is not accessible from the production network

A company wants to protect its database from ransomware attacks. The security team is considering several measures. Which combination of measures is MOST effective in ensuring data can be recovered after a ransomware attack?

User training and strong passwords

Database encryption at rest and network firewalls

Intrusion detection system and antivirus software

Regular backups stored offline and access controls limiting who can modify database files

CompTIADataSys+

Domain 4Objective 5

Threat Mitigation DS0-001 Practice Questions (Page 6)

Part of the Data and database security domain, which accounts for 23% of the DS0-001 exam. CompTIA does not publish an official question count, but from its 90-minute exam (~35–60 total, ~8–14 in this domain), expect 2–3 from this objective — we provide 32 practice questions to prepare you well beyond it. (estimate)

32questions here

7free pages

10concepts

23%of the exam

Questions 26–30

26foundation · easy
What is the primary impact of a ransomware attack on a database system?
Select an answer first
27expert · hard
A company's database was hit by ransomware, but the administrator was able to restore data from backups. However, the backups were also encrypted because they were stored on a network share that was accessible to the compromised server. The administrator wants to ensure future backups are protected from ransomware. Which backup strategy is MOST effective?
Select an answer first
28application · medium
A company wants to protect its database from ransomware attacks. The security team is considering several measures. Which combination of measures is MOST effective in ensuring data can be recovered after a ransomware attack?
Select an answer first
29foundation · easy
A database administrator notices that the database server's CPU usage is at 100% and the number of connections has spiked to thousands, while legitimate users report that queries are timing out. Which type of attack is most likely occurring?
Select an answer first
30foundation · easy
A database administrator notices an unusual pattern in the application logs: a series of requests where the 'user_id' parameter contains values like '1 OR 1=1--'. Which type of attack does this log pattern most likely indicate?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DS0-001

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by CompTIA. “DS0-001” is a trademark of its owner, used for identification only.

Threat Mitigation DS0-001 Practice Questions (Page 6)

Questions 26–30

What is the primary impact of a ransomware attack on a database system?

A company wants to protect its database from ransomware attacks. The security team is considering several measures. Which combination of measures is MOST effective in ensuring data can be recovered after a ransomware attack?

A database administrator notices that the database server's CPU usage is at 100% and the number of connections has spiked to thousands, while legitimate users report that queries are timing out. Which type of attack is most likely occurring?

A database administrator notices an unusual pattern in the application logs: a series of requests where the 'user_id' parameter contains values like '1 OR 1=1--'. Which type of attack does this log pattern most likely indicate?

Keep studying — Data and database security