70-461 Free Practice Test

- (Exam Topic 1)
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?

1. A. SERIALIZABLE
2. B. SNAPSHOT
3. C. READ COMMITTED SNAPSHOT
4. D. REPEATABLE READ

Correct Answer: C
Reference: http://msdn.microsoft.com/en-us/library/ms173763.aspx

- (Exam Topic 2)
You maintain a SQL Server database that is used by a retailer to track sales and salespeople. The database includes two tables and two triggers that is defined by the following Transact-SQL statements:
< ><>>>>>< >
Solution:
Box 1: OFF
Box 2: 0
Only direct recursion of AFTER triggers is prevented when the RECURSIVE_TRIGGERS database option is set to OFF. To disable indirect recursion of AFTER triggers, also set the nested triggers server option to 0.
Note: Both DML and DDL triggers are nested whena trigger performs an action that initiates another trigger. These actions can initiate other triggers, and so on. DML and DDL triggers can be nested up to 32 levels. You can control whether AFTER triggers can be nested through the nested triggers server configuration option.
If nested triggers are allowed and a trigger in the chain starts an infinite loop, the nesting level is exceeded and the trigger terminates.
References:https://msdn.microsoft.com/en-us/library/ms190739.aspx

Does this meet the goal?

1. A. Yes
2. B. No

Correct Answer: A