DS0-001

DS0-001 practice questions, page 5 of 6, with answer review and explanations.

Question 21

A database administrator needs to ensure database backups are occurring on a daily basis and at scheduled times. Which of the following actions should the administrator take?

  1. Query the database to observe entries.
  2. Check the database schema.
  3. Review the backup media.
  4. Review the server logs for entries.

Question 22

Which of the following is a result of an on-path attack on a system?

  1. A Wi-Fi network that redirects to clones of legitimate websites
  2. A website that has crashed and is no longer accessible
  3. An email from an unknown source requesting bank account details
  4. A web application that returns the addresses of its customers

Question 23

Which of the following is the best way to migrate a large data load from one table to another, considering total time and blocking?

  1. Split the load size into many transactions.
  2. Split the load size in half and run simultaneously.
  3. Batch into small loads and run in parallel.
  4. Batch large loads into one transaction.

Question 24

Following a security breach, a database administrator needs to ensure users cannot change data unless a request is approved by the management team. Which of the following principles addresses this issue?

  1. Open access
  2. Least resistance
  3. Elevated privilege
  4. Least privilege

Question 25

A programmer wants to configure a database to only allow read or write access when requests are coming from specific IP addresses. Which of the following can be used to configure IP addresses to allow access to the database?

  1. Static IP address
  2. Firewall
  3. Dynamic IP address
  4. DNS