CompTIA DS0-001 Practice Test - Questions Answers, Page 4

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

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?

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?

A company needs to prepare a document that establishes the responsibilities, metrics, penalties, and other generalities that a provider would have to fulfill for customers to use its platforms.

Which of the following documents meets these requirements?

A DBA left the company, and the DBA's account was removed from the system. Soon after, scheduled jobs began failing.

Which of the following would have most likely prevented this issue?

A database is configured to use undo management with temporary undo enabled. An UPDATE is run on the table.

Which of the following describes where the undo is stored?

Which of the following concepts applies to situations that require court files to be scanned for permanent reference and original documents be stored for ten years before they can be discarded?

Which of the following is a potential issue raised by enterprise database users?

A database administrator is new to a company and wants to create a document that illustrates the interaction between tables. Which of the following should the administrator create?