Administering Relational Databases on Microsoft Azure (DP-300) Test 2

Question : 10 of 40

Marks: +1, -0

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:

User1 can [answer choice]. ______
add a column to Table 1
delete a row from Table1 delete Table1
delete Table1
To ensure that User1 can run queries to retrieve data from DB1, you must assign User1 the [answer choice] database role. ______
db_datareader
db_ddladmin
db_denydatareader
db_denydatawriter

Validate

Go to Question:

Prev Question

Next Question