Exam DP-300 topic 2 question 21 discussion

Actual exam question from Microsoft's DP-300

Question #: 21
Topic #: 2

HOTSPOT -
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:

Show Suggested Answer

Suggested Answer:

Box 1: delete a row from Table1 -
Members of the db_datawriter fixed database role can add, delete, or change data in all user tables.

Box 2: db_datareader -
Members of the db_datareader fixed database role can read all data from all user tables.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles

by wyindualizer at Nov. 12, 2022, 12:29 p.m.

Comments

Submit Cancel

igorclapa

10 months, 1 week ago

DB_DATAWRITER: Members of the db_datawriter fixed database role can add, delete, or change data in all user tables. In most use cases this role will be combined with db_datareader membership to allow reading the data that is to be modified. DB_DATAREADER: Members of the db_datawriter fixed database role can add, delete, or change data in all user tables. In most use cases this role will be combined with db_datareader membership to allow reading the data that is to be modified. https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/database-level-roles?view=sql-server-ver16

upvoted 3 times

...

victorlie

1 year ago

Within the database, db_datawriter allows users with the role to insert, update, or delete data in any user table or view in a database. The db_ddladmin role provides permissions for the user to modify any the schema of a database with Data Definition Language commands. The permissions for these two roles do not overlap.

upvoted 1 times

...

fayNik

1 year, 5 months ago

Members of the db_datawriter fixed database role can add, delete, or change data in all user tables. Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.

upvoted 1 times

...

wyindualizer

1 year, 8 months ago

Members of the db_datawriter fixed database role can add, delete, or change data in all user tables. Members of the db_datareader fixed database role can read all data from all user tables and views. User objects can exist in any schema except sys and INFORMATION_SCHEMA.

upvoted 2 times

...