DP-300 Certification Practice Question #84

Question

You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
The database role membership for a user named User1 is shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Accepted Answer

User1 is configured only with the `db_datawriter` database role. Members of `db_datawriter` can perform Data Manipulation Language (DML) write operations (insert, update, delete) on all user tables, which allows User1 to delete a row from `Table1`. They cannot make schema modifications, so they cannot add a column or drop `Table1`. To read or retrieve data from the database, User1 must be granted select permissions, which is done by assigning them to the `db_datareader` role.

More DP-300 practice questions