nerdexam
Microsoft

70-432 · Question #207

You administer a SQL Server 2008 instance. A database developer named User1 needs to view the definitions of all database objects in a database and read data from all user-defined tables, views, and…

The correct answer is B. Option B. See the full explanation below for the reasoning.

Question

You administer a SQL Server 2008 instance. A database developer named User1 needs to view the definitions of all database objects in a database and read data from all user-defined tables, views, and table-valued functions. You need to set the required permissions for User1. Which Transact-SQL statements should you execute?

Exhibit

70-432 question #207 exhibit

Options

  • AOption A
  • BOption B
  • COption C
  • DOption D

How the community answered

(32 responses)
  • A
    13% (4)
  • B
    78% (25)
  • C
    6% (2)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-432 Practice