Necro from United States – 10 08 2013, 2:23 PM Report Spam Yes, maybe something is missing but, if that is the case I will stay with AES_256, because is a more computable security option and stronger than a 3 round 56bit (168) encryption. Wing from United States – 09 24 2013, 5:26 PM Report Spam Seems like many of these questions are missing information or the options have nothing to do with the question presented. Has anyone validated this practice exam? Kat from United States – 09 17 2013, 2:43 AM Report Spam Fair enough Necro. Perhaps you can clarify an answer for me. Q. 67 – With the question given I cannot determine why AES_256 is a better answer than TRIPLE_DES_3KEY. Both are viable encryption algorithms. My theory is that part of the question is missing that indicates using the strongest encryption method or some other criteria. This would explain using the 256 bit option over the 192 bit option. Necro from United States – 09 16 2013, 2:39 PM Report Spam 2) Exam A, question 7 The question only says "blocked from updating", but says you still need to read the data. Repeatable Read can allow dirty reads and MS says to only use when necessary. I would pick Serializable. http://technet.microsoft.com/en-us/library/ms173763.aspx —————————————————————Both questions have the same tag about “MS says to only use when necessary" lol this question is not very clear because both isolation level will hold the lock, Serializable restrict to much even if doesn’t allow dirty read, but after this range lock is applied you can’t not only updating you can’t insert either anything that can match the statement of the sp1 and that is a behavior that I will not agree in a e-commerce site like amazon. So just like the question have only "blocked from updating" and don’t said anything about Insert or not allow dirty read I will stay with “repeatable read” Kat from United States – 09 16 2013, 7:53 AM Report Spam Khrun,1) Exam A, question 3. – The question specifies a one-way encryption. One way encryption is a hash, while two way is encryption. SHA-1 is used for performing a hash while AES-256 is for two way encryption. Therefore, SHA-1 should be used here. There is another version of the question that states two way encryption and should use AES-256. 2) Exam A, question 7 The question only says "blocked from updating", but says you still need to read the data. Repeatable Read can allow dirty reads and MS says to only use when necessary. I would pick Serializable.http://technet.microsoft.com/en-us/library/ms173763.aspx 3) Exam A, question 13.I agree with you. The Contact lookup is already performing a Seek, so this answer seems completely wrong to me. The answer should be trying to limit the Index Scan operations, so your answer seems more correct. 4) Exam A, question 18. Views are good for joining many tables together, but do not accept parameters. The question says "for a given sales order" to generate the results and then use the result to perform a join. To get a given sales order you have to accept an OrderID, generate the results, and then allow a join, so A is more correct.http://technet.microsoft.com/en-us/library/ms191007.aspx 5) Exam A, question 70. One of the given requirements is "A table-valued function will be created to search products by type.". Therefore, you are correct D should be the answer rather than B because you need a table-valued function. Khrun Morjov from Russian Federation – 09 05 2013, 2:22 PM Report Spam Thanks for dump.I have several questions. 1) Exam A, question 3.Is it possible to execute such command?CREATE SYMMETRIC KEY Key1WITH ALGORITHM = SHA1ENCRYPTION BY CERTIFICATE Cert1; I'm not sure that we can use SHA1 as algorithm in this case 2) Exam A, question 7"Sp1 is used to read and change the price of all the products sold on e-commerce site. You need to ensure that other transactions are blocked from updating product data while sp1 executing. Which transaction isolation level should you use is sp1?" Is 'repeatable read' not enough for exclusive locking existing rows till the end of transaction with UPDATE ? 3) Exam A, question 13.What for we need index on the 'Contact' table? Is the index on SalesOrderHeader(OrderDate) include (SalesPersonId, SubTotal) not better? 4) Exam A, question 18."For a given sales order, you need to retrieve the OrderID, Quantity, and LineTotal columns for all of the items in the OrderDetails table.The solution must ensure than the results can be joined to other tables.Which code segment should you execute?" Is 'CREATE VIEW…' not correct answer? View is enough for getting all items and join to other tables. 5) Exam A, question 70.The query returns dataset, but not xml data.IMHO answer D looks more suitable.