You are a professional level SQL Sever 2008 Database Administrator.
A thirdparty database application will be deployed to the instance. Stored procedures are utilized by the application, and the procedures are developed by utilizing SQL CLR integration. You should set the application to have
the
EXTERNAL_ACCESS code access security setting enabled. Since you are the technical support of the
company,
you should deploy the application to the instance with no loss of functionality.
Which action will you perform first?

• A. Readwrite non-static fields in the code should be replaced with static fields.
• B. The peverify.exe PEVerify tool should be utilized to confirm whether the type-safety requirements are satisfied by the code.
• C. Read-only static fields in the code should be replaced with readwrite static fields.
• D. The regasm.exe assembly registration tool should be utilized to have the assembly registered on the server before deployment.

You are a professional level SQL Sever 2008 Database.
A new database application is hosted by the instance. The security requirements should be designed for the application. A unique login to the SQL Server 2008 server is assigned to each application user. Stored procedures are included by the application database to execute stored procedures in the MSDB database. SQLAgent jobs are scheduled by the stored procedures in the MSDB database.
Since you are the technical support, you are required to confirm that the stored procedures in the MSDB database should be executed by utilizing the security context of the application user.
Which action should you perform?

• A. Each user should be added to the db_dtsltduser database role in the MSDB database.
• B. Each user should be added to the public role in the MSDB database.
• C. The MSDB database should be set to utilize the TRUSTWORTHY option, and then each user should be added to the MSDB database.
• D. The new database should be set to utilize the TRUSTWORTHY option, and then each user should be added to the MSDB database.

You administer a SQL Server 2008 infrastructure.
An instance contains a database that includes a large table named OrderDetails. The application queries
only execute
DML statements on the last three months data. Administrative audits are conducted monthly on data older
than three months.
You discover the following performance problems in the database. The performance of the application
queries against the
OrderDetail table is poor. The maintenance tasks against the database, including index defragmentation,
take a long time.
You need to resolve the performance problems without affecting the server performance.
What should you do?

• A. Create an additional table named OrderDetailsHistory for data older than three months. Create a SQL Server Agent job that runs the following Transact-SQL statement every month. INSERT INTO OrderDetailsHistory SELECT * FROM OrderDetails WHERE DATEDIFF( m,OrderDate,GETDATE ()) > 3
• B. Create an additional table named OrderDetailsHistory for data older than three months. Use the following Transact-SQL statement. CREATE TRIGGER trgMoveData ON OrderDetails AFTER INSERT AS INSERT INTO OrderDetailsHistory SELECT * FROM OrderDetails WHERE DATEDIFF( m,OrderDate,GETDATE ()) > 3
• C. Create a database snapshot for the OrderDetails table every three months. Modify the queries to use the current snapshot.
• D. Create an additional table named OrderDetailsHistory for data older than three months. Partition the OrderDetails and OrderDetailsHistory tables in two parts by using the OrderDatecolumn. Create a SQL Server Agent job that runs every month and uses the ALTER TABLE...SWITCH Transact-SQL statement to move data that is older than three months to the OrderDetailsHistory table.

You are a professional level SQL Sever 2008 Database Administrator.
A database is included by the instance, and a table named EmployeeData is contained by the database.
There is a column named Profile in the EmployeeData table. Microsoft Office Word 2003 documents are stored in the column.
The space utilized by the Profile column should be cut to the least. In addition, a reasonable performance should be maintained to retrieve the content of the column.
Which action will you perform?

• A. The Profile column should be stored by utilizing filestream storage, and the NTFS file system compression should be utilized.
• B. ROW compression should be utilized for the EmployeeData table.
• C. The Profile column should be implemented as a CLR user-defined type.
• D. PAGE LEVEL compression should be utilized for the EmployeeData table.