A database administrator needs a tool to document and explain the relationships between data in an organization's database. Which of the following is the best tool to accomplish this task?

• A.Text editor
• B.UML editor
• C.Word processor
• D.SQL query

Comment: *

Name: *

Email: *

Verification: *

A new retail store employee needs to be able to authenticate to a database. Which of the following commands should a database administrator use for this task?

• A.INSERT USER
• B.ALLOW USER
• C.CREATE USER
• D.ALTER USER

Comment: *

Name: *

Email: *

Verification: *

Which of the following types of RAID, if configured with the same number and type of disks, would provide the best write performance?

• A.RAID 3
• B.RAID 5
• C.RAID 6
• D.RAID 10

Comment: *

Name: *

Email: *

Verification: *

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

• A.Split the load size into many transactions.
• B.Split the load size in half and run simultaneously.
• C.Batch into small loads and run in parallel.
• D.Batch large loads into one transaction.

Comment: *

Name: *

Email: *

Verification: *

A database administrator manages a database server that is running low on disk space. A lot of backup files are stored on the server's disks.
Which of the following is the best action for the administrator to take?

• A.Move all the backup files to external disks.
• B.Delete all the backup files containing data that is rated as classified.
• C.Delete all the backup files that are not required by the backup retention policy.
• D.Delete all the backup files except for the most recent one.

Comment: *

Name: *

Email: *

Verification: *