You administer a SQL Server 2008 instance that contains a database named DB1.
The DB1 database contains the following stored procedure. (Line numbers are included for reference only.)

When a user named User1 attempts to invoke Procedure1, the following exception is raised:
"Msg 262, Level 14, State 1, Procedure Procedure1, Line 5 CREATE TABLE permission denied in database 'DB1'."
You need to provide User1 access to execute Procedure1 by allocating only the required permissions.
What should you do?

• A. Insert the WITH EXECUTE AS 'dbo' clause between lines 01 and 02.
• B. Grant the CREATE TABLE permission and allow User1 to drop the Sales.Table1 table.
• C. Grant the ALTER permission on the Sales schema to User1.
• D. Insert the EXECUTE AS USER = 'dbo' statement between lines 02 and 03.

You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance database. Which Transact-SQL statement should you use?

• A. BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH DIFFERENTIAL:
• B. BACKUP DATABASE FINANCE TO DISK = ,t:\backups\finance.bak' WITH COMPRESSION:
• C. BACKUP DATABASE FINANCE TO DISK = t:\backups\finance.bak*;
• D. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH COMPRESSION- DIFFERENTIAL;

You administer a Microsoft SQL Server 2008 instance that contains two databases named Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses the Latin1_General_100_CI_AI collation.
Each database has an Orders table that has the following definition: You need to return records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL query should you use?

• A. Option C
• B. Option A
• C. Option B
• D. Option D

You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company's written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges.
You need to configure the SQL Server service torun under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?

• A. Under the context of the local system account
• B. Under the context of the local Administrator account
• C. Under the context of the domain user account
• D. Under the context of the local service account

DRAG DROP
You install a Microsoft SQL Server 2008 R2 instance that uses default settings.
You want to add a storage area network (SAN) array. The SAN has two mapped drives: D
and L.
You need to ensure that all new databases meet the following requirements:
- Data files are stored on drive D in the SQLData folder. - Log Files are stored on drive L in the SQLLogs folder.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)