Exam 70-764 topic 1 question 14 discussion

Actual exam question from Microsoft's 70-764

Question #: 14
Topic #: 1

Note: This question is part of a series of questions that use the same or similar answer choices. An answer choice may be correct for more than one question in the series. Each question is independent of the other questions in this series. Information and details provided in a question apply only to that question.
A company has an on-premises Microsoft SQL Server environment and Microsoft Azure SQL Database instances. The environment hosts a customer database named DB1.
Customers connect to hosted database instances by using line-of-business applications. Developers connect by using SQL Server Management Studio (SSMS).
You need to grant the developers permission to alter views for DB1 while following the principle of least privilege.
Which permission should you grant?

A. DDLAdmin
B. db_datawriter
C. dbcreator
D. dbo
E. View Database State
F. View Server State
G. View Definition
H. sysadmin

Show Suggested Answer

Suggested Answer: A 🗳️
To execute ALTER VIEW, at a minimum, ALTER permission on OBJECT is required.
Members of the db_ddladmin fixed database role can run any Data Definition Language (DDL) command in a database.
References: https://technet.microsoft.com/en-us/library/ms190667(v=sql.90).aspx

by TheSwedishGuy at Jan. 27, 2020, 10:38 a.m.

Comments

Submit Cancel

Chandra111

4 years, 4 months ago

It needs be grant ddl admin permission for Alter View.

upvoted 1 times

...

TheSwedishGuy

5 years, 5 months ago

"Data Definition Language" is basically what comprises the blueprint for the database. To alter the database (and therefore the database's blueprint), you need to be DDLAdmin.

upvoted 2 times

...