Question 77
You use Microsoft SQL Server 2012 to write code for a transaction that contains several statements.
There is high contention between readers and writers on several tables used by your transaction. You need to minimize the use of the tempdb space.
You also need to prevent reading queries from blocking writing queries.
Which isolation level should you use?
Question 78
You have installed the SQL Server Integration Services (SSIS) feature on a server running Windows Server 2008 R2 SP1.
Which of the following features must you install if you want to ensure that you can run packages in 32-bit mode?
Question 79
You are developing a SQL Server Integration Services (SSIS) package.
You need to design a package to change a variable value during package execution by using the least amount of development effort.
What should you use?
Question 80
You administer a Microsoft SQL Server 2012 instance that has several SQL Server Agent jobs configured.
When SQL Server Agent jobs fail, the error messages returned by the job steps are truncated.
The following error message is an example of the truncated error message:
"Executed as user CONTOSO\ServiceAccount....0.4035.00 for 64-bit Copyright (C) Microsoft Corp 1984-
2011. All rights reserveD. Started 63513 PM Error 2012-06-23 183536.87 Code 0XC001000E Source UserImport Description Code 0x00000000 Source Log Import Activity Descript... The package execution fA. .. The step failed. "
You need to ensure that all the details of the job step failures are retained for SQL Server Agent jobs.
What should you do?
Question 81
You have a SQL Server database that contains all of the sales data for your company. Users of the database report the following issues:
* Connections to the database fail when the users first attempt to connect in the morning.
* Inserting new records in the database takes longer than expected.
You need to resolve the issues.
Which two database properties should you modify? To answer, select the appropriate properties in the answer area.
