You work as a database administrator at ABC.com. You are responsible for managing a SQL
Server 2008 database server named ABC-DB01.
You receive instruction that the SQL Server 2008 Reporting Services model needs to be deployed
on ABC-DB01 to support a data source that contains 800 tables for the Marketing division. You
have been tasked with developing a report model.
Which of the following options will make sure that the Marketing division is only able to access 10
tables? (Choose two)
A.
A data source view should be developed.
B.
The marketing division should be denied access to the other tables.
C.
The tables and views the marketing division will not be using should be highlighted.
D.
The tables and views the marketing division will use should be indicated.
E.
The Dynamic Management View should be properly modified.