Querying Microsoft SQL Server 2012
I have a question regarding XML knowledge needed for the certification. I have no real-world experience with it, so started studying through the official Training Kit. Something is not clear to me: Do I need to know how to write any XML strings from the scratch? Or knowing its structure and main concepts are enough (Elements, Attributes,namespaces,XSD etc). Aside from knowing OPENXML, FOR XML formatting etc.
Greetings Graciano, I've taken the test once, didn't pass… currently studying for it. I for one was surprised with how many XML q's there were on the test. Concepts and recognition of the elements is crucial… I'm sure other forums can help you out quite a bit in answering your question… this forum is quite dry when it comes to traffic. Try sqlservercentral or stack overflow..
Graciano, have you looked at chapter 7 of the training kit yet? What do you think of it, lots of vocabulary memorization… it's going to take me a few reads through before I'm comfortable with it.
I passed the exam in December and was also surprised about the number of XML questions - 5 in my case. I think the training kit does a good job of explaining what the required skills are but these should be reinforced by practical experimenting to make sure you understand the different ways to query the data.
I initially brushed over this section and thought to myself... oh that's nice, as I have never needed to design a system to store large blocks of XML and have it directly queried via my DAL before. Luckily I changed my mind two days before the exam.
I hope this helps
I have seen a lot of people mentioning about XML. It is new for me.
Prat, it is pretty easy. After you write a select statement either put FOR XML AUTO or FOR XML RAW and your results come back in XML form. There is also FOR XML EXPLICIT and FOR XML PATH. Which are more advanced and may be beyond the scope.
Thanks, John for short and clear explaination. Will post list of new things.
Passed it. Yes, there were XML questions.
Hi everyone. I passed the 70-461 exam today. There were several XML questions. John D.'s comment above is accurate. Read the chapter from the training kit, and do the exercises. Then make up a few queries with XML that are more complex than what is in the training kit.
Just a friendly reminder not to discuss the content of exams as this is in breach of the NDA you agreed too prior to commencing the exam.
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCSE: Business Intelligence & Data Platform
I see you mentioned that we need to learn XML Auto and Raw. I have been using MeasureUp in the answers on that are generally for XML Auto and Path so I have been learning those! I guess I have to forget the Path and learn the Raw (just asking again to double check).
I hope my question is OK as it only repeats what John (who I believe works for MS) mentions and the specifics of MeasureUp.
Dominic, firstly I do not work for Microsoft. I just volunteer to moderate the forum and answer questions. I mainly just try answer generic question or guide people in the right direction. But as Jeff mentioned, I really cannot comment on what might be or might not be on the exam.
However, if you have a question on how something works or how to write code I would be happy to assist in answering.
Is XQuery beyond the scope of the exam? I understand how to create XML data and how to shred it to relational data. However, I saw no mention of XQuery in the skills measured on the microsoft website.
Again, I cannot confirm or deny what is on the exam as that would be against the NDA. If you have a question on how to do XML statements or XQuery statements I would be happy to answer those.
Thank you for your response John. However, I do believe a clear scope should be defined for exams. Without a clear scope, can they not test you on topics that would appear on the 70-462 and 70-463 exam?