You are the database administrator for a banking firm and maintain all the SQL Server 2008 databases of the firm.
The company stores customer-related data in the Cust_details table in a database named Customers.
You havecreated several roles in the database to effectively manage the permissions granted to database users.
The permissions granted to the different roles in the Cust_details table are as follows:

John is a new user in the audit department.
To create reports on the data in the Cust_details table, John isrequired to view the data in this table.
John should be able to add new records to the table and update theexisting data in the table.
You must ensure that John only has the required privileges.
You want to accomplish thiswith the least administrative effort. exhibit What should you do? (Choose all that apply. Each correct answer presents a portion of the solution.)

You are the database administrator of your company. The network contains a SQL Server 2008 computer named SQL1.
You are in the process of creating a SQL Server Agent job that will use an ActiveX script to monitordatabase file sizes.
To ensure that the job runs successfully, you want to configure the job step to use a proxy account that haspermission for the ActiveX Script subsystem of the SQL Server Agent.
To achieve this, you want to create a proxyaccount for the job step. exhibit What must you do before creating a proxy account?

You are the database administrator for your company. The network contains five SQL Server 2008 computers.
One of the servers named MKTGSQL1 is located in a remote branch office.
You want to enable a helpdesk technician in the branch office to create a job for database maintenance on MKTGSQL1.
You want to ensure that when the technician executes the job steps, the output is written to anoperating system file.
To achieve this, you want to assign the helpdesk technician to an appropriate role. exhibit To which role should you assign to the helpdesk technician?

You manage an instance of SQL Server 2008 for your company. The instance contains a database named MarketingDB .
You have been asked to create an alert that will notify you when any user with insufficientpermission attempts to access the database.
You decide to create an alert that will be triggered based on severitylevel. You open the New Alert dialog box to create a new alert.
exhibit Which value should you select for the Type option to create the alert?

You are a database administrator managing all the SQL Server 2008 databases of your company. All thecustomer-related data is stored in the Prod database that is operating in the Full Recovery model. You adhere tothe following backup strategy for the Prod database:

At 4:00 P.M. on Wednesday, the hard disk on which your database files are stored fails. You lose all the datastored on the disk and are required to recover the database from the existing database backups.
To most efficiently recover the database, exhibit which action should you take?

You are the database administrator of your company. The network contains a firewall to secure the corporatenetwork. You are upgrading a SQL Server 2005 server to SQL Server 2008. However, the upgrade fails, and thefollowing error message is displayed:
SQL Server Setup could not connect to the database service for serverconfiguration.
You need to ensure that the upgrade process completes successfully without displaying this error message. What should you do?

You are a database administrator in your company. You create a new database named Prod1 on a SQL Server 2008 instance named Sql1. The users on your company’s LAN should have access to the Prod1 database. All the client computers are running Windows XP Professional and have the SQL Client component installed. The shared memory protocol is also enabled on all the client computers in the SQL Native Client Configuration.
exhibit What could you do to enable clients to connect to Sql1? (Choose all that apply. Each correct answer presents a unique solution.)