All pastes #2054177 Raw Edit

Mine

public text v1 · immutable
#2054177 ·published 2011-05-05 11:42 UTC
rendered paste body
In my opinion (not saying im right), the answers for the new questions are:

4.                a. Use dynamic management views

12.              b. Grant the ALTER TRACE permission to the developers.

16.              SELECT TWO:
                  b. Register a server principal name (SPN) for SQLSERVER1 and SQLSERVER2
                  and also
                  d. Create a map for each SQL login from SQLSERVER1 to SQLSERVER2 and use the impersonate option.

21.              a. Drop and recreate the table using the FILESTREAM data type.

24.              I have no idea about this one, page level but which one i dont know.

25.            Select TWO: 
                 c. Set the database recovery model to FULL
                 and
                 e. Set the PAGE_VERIFY database option to TORN_PAGE_DETECTION

26.            a. Disable partition-level lock escalation

28.           c. 64-KB

29.           Not sure but i suspect b. Execute the following command on the server: exec sp_configure 'maximum degree of parrallelism",8

35.          d. create three different non-administrative local user accounts and assign them to each of the services.

28.          b. Kerberos authentication.

40.          c. Enable the nested triggers server configuration option

41.          a. Enable the nested triggers server configuration option. (i think this is the answer, not sure that they would have it twice in the exam though).

42.          b. Use a logon trigger.

43.          a. Set only Execute on SetCustomerStatus

47.          d. Define a SQL server policy and import it on each database server

51.          d. Transactional replication that uses updating subscriptions (im just guessing this one).

54.          b. Configure manual failover role switching.

64.         B(backup server master key) should be the answer 

65.          Two part answer (not 100% sure if this is correct):
               b. Login accounts
               and
               c. Master database

66.          c: Perform a partial restoreof the PRIMARY filegroup and FileGroupA from a partial backup. Perform an online recovery of FileGroupB, and then perform an online restore of FileGroupC