nerdexam
Microsoft

70-460 · Question #59

You need to restrict access to data in the tables in the data warehouse. What should you do?

The correct answer is C. Create views and grant permissions to the views. See the full explanation below for the reasoning.

Question

You need to restrict access to data in the tables in the data warehouse. What should you do?

Options

  • AConfigure column-level permissions.
  • BConfigure database roles.
  • CCreate views and grant permissions to the views.
  • DConfigure application roles.

How the community answered

(41 responses)
  • A
    15% (6)
  • B
    5% (2)
  • C
    78% (32)
  • D
    2% (1)

Community Discussion

No community discussion yet for this question.

Full 70-460 Practice