A database administrator needs to provide access to data from two different tables to multiple group users in order to facilitate ongoing reporting. However, some columns in each table are restricted, and users should not be able to see the values in these columns.
Which of the following is the best action for the administrator to take?
Which of the following resources is the best way to lock rows in SQL Server?
Which of the following is part of logical database infrastructure security?
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?
An on-premises application server connects to a database in the cloud. Which of the following must be considered to ensure data integrity during transmission?
