Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Career
»
Certification
»
70-461
71 posts, Page 7 of 8
««
«
4
5
6
7
8
»»
70-461
Rate Topic
Display Mode
Topic Options
Author
Message
Scott_4
Scott_4
Posted Friday, March 29, 2013 10:40 PM
Grasshopper
Group: General Forum Members
Last Login: 2 days ago @ 7:11 AM
Points: 22,
Visits: 43
Good Evening (at least where I am),
I have a specific question about Certification Exam 70-461. I had studied the MS 70-461 Self Study book religiously - and did very well on the provided self test.
Unfortunately I found the actual Certification Exam to not be much at all like the Self Test from the MS Book! This very much surprised me as I bought Microsoft's book - and figured that the provided self test would be somewhat like the real thing. Not at all though.
The one type of question that I really had issues with were "Build List". I am *not* looking for specific answers here - but I *am* looking for what folks recall in regards to what type of questions were asked in this "Build List" format (it is the one where you have to slid code snippets from a list, and put them in the proper order).
There was one specific question that threw me for a loop - and unfortunately I cannot recall much about it (stress does that to you ;) ).
Hopefully just asking what type of questions are asked using the "Build List" format is not a violation at all in regards to Microsoft's policies. I have no desire to use "brain dumps", etc. - just need a little help with what type of question was asked in this format.
Any help here at all is *very* much appreciated.
Thank you.
Scott
Tucson, AZ
Post #1437179
GilaMonster
GilaMonster
Posted Saturday, March 30, 2013 3:43 AM
SSC-Dedicated
Group: General Forum Members
Last Login: Today @ 2:48 AM
Points: 37,635,
Visits: 29,886
Answering here rather than privately, because then more people can benefit...
You're not going to find a list of what material uses what question types. It's not even consistent, that can and will change as MS adds new questions and new question types to their exams. Plus any discussion of exam contents is in violation of the NDA. Best thing is to know the material well.
With the 'build up an answer' type. When you get those, ignore the answers. Take the scratch paper/board that the exam centre provided and write out a solution to the question. Once you've written out a piece of code that will do what is asked, then look at the snippets given and arrange them to match what you've already got.
Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass
Post #1437189
Koen Verbeeck
Koen Verbeeck
Posted Saturday, March 30, 2013 2:47 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Yesterday @ 6:54 AM
Points: 9,364,
Visits: 6,462
GilaMonster (3/30/2013)
Answering here rather than privately, because then more people can benefit...
You're not going to find a list of what material uses what question types. It's not even consistent, that can and will change as MS adds new questions and new question types to their exams. Plus any discussion of exam contents is in violation of the NDA. Best thing is to know the material well.
With the 'build up an answer' type. When you get those, ignore the answers. Take the scratch paper/board that the exam centre provided and write out a solution to the question. Once you've written out a piece of code that will do what is asked, then look at the snippets given and arrange them to match what you've already got.
I usually take another approach. I study the possible answers and immediately throw away all the ones that are garbage (you can normally spot a few).
With less possible answers, it's easier to construct the correct order.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1437245
KatieAndEmil
KatieAndEmil
Posted Sunday, March 31, 2013 3:00 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:00 AM
Points: 38,
Visits: 116
Hi
For those avoiding brain dumps (I hope everyone! ;) and looking for practice tests which can help you get used to style of Microsoft Exams so you can prepare better I have very good news.
We have decided to create a test has similar style to Microsoft questions. The differences are:
1) It has similar style questions to Microsoft + those that Microsoft doesn't have yet (or have on different exams)
2) Similar level but slightly more difficult as we provide answer in a way that guessing is minimized so normally you will get 10-20% less comparing to exam where educated guesses are possible.
3) We support answers with our tutorials + videos (+ Microsoft links)... this feature is coming soon.
Unfortunately test is paid but affordable... cheaper than Measure up (30£ per 3 full tests with 150 questions) and you can buy "weak points" or min-test from 2£ per 10 questions.
I believe there is demand for this kind of tests (those avoiding brain dumps who just want some practice)
So far we just have 1 test with 10 questions but over the next 2-3 weeks we will have 3 full tests (150 questions)... here is the link
70-461 Exam Practice Test
Hope that helps
Take care
Emil
Post #1437280
Cary Davis
Cary Davis
Posted Monday, April 01, 2013 8:16 AM
Grasshopper
Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:55 PM
Points: 17,
Visits: 278
I used "Querying Microsoft SQL Server 2012 by Itzik Ben-gan; Dejan Sarka; Ron Talmage". It's pretty compreshensive, has exercises, a cd with practice tests and exam simulation etc. I would say the test was significantly more difficult than the practice tests.
Of coure T-SQL is a very broad language so each presentation of the test could be completely different. In my case, there were plenty of questions about xml. You should know xml raw vs auto vs path very well. Seems like MS is very proud of this functionality and push it in testing. Lot's of questions on Views with Schemabinding for some reason. Plenty of questions about Ranking...rank vs dense rank vs row_number. Know how to write these for sure. Merge into also made an appearance or two on the test. There are 14 new functions in 2012 so I would definitely become familiar with all of them.
Again, I was surprised how heavily xml, views with schemabinding and rank/row_number functions were represented in the test, but your experience could be nothing like mine so get a good handle on every concept you can before taking it.
A good thing about using a training kit like the one I listed above is that by taking the self tests you can see where you weak and go explore other resources to build your knowledge.
Don't be nervous, just do your best and everything will be OK.
Post #1437452
prathibha_aviator
prathibha_aviator
Posted Tuesday, April 02, 2013 3:08 PM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, May 09, 2013 7:34 PM
Points: 95,
Visits: 222
KatieAndEmil (3/31/2013)
Hi
For those avoiding brain dumps (I hope everyone! ;) and looking for practice tests which can help you get used to style of Microsoft Exams so you can prepare better I have very good news.
We have decided to create a test has similar style to Microsoft questions. The differences are:
1) It has similar style questions to Microsoft + those that Microsoft doesn't have yet (or have on different exams)
2) Similar level but slightly more difficult as we provide answer in a way that guessing is minimized so normally you will get 10-20% less comparing to exam where educated guesses are possible.
3) We support answers with our tutorials + videos (+ Microsoft links)... this feature is coming soon.
Unfortunately test is paid but affordable... cheaper than Measure up (30£ per 3 full tests with 150 questions) and you can buy "weak points" or min-test from 2£ per 10 questions.
I believe there is demand for this kind of tests (those avoiding brain dumps who just want some practice)
So far we just have 1 test with 10 questions but over the next 2-3 weeks we will have 3 full tests (150 questions)... here is the link
70-461 Exam Practice Test
Hope that helps
Take care
Emil
I have watched your final webinar which is kinda cool... i took the ten questions test from your website too.. Hope you would get us the full version of questions soon...Some of your links in the website are not working.. I wonder if you have to still upload information on those aspects... Look at the Modify data section... Some of your links need to be updated. Good Luck
--Pra
--------------------------------------------------------------------------------
Post #1438103
KatieAndEmil
KatieAndEmil
Posted Wednesday, April 03, 2013 4:37 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:00 AM
Points: 38,
Visits: 116
Hi
I'm glad to hear you liked the Webinar and the Ranking test.
If your are part of our Email Newsletter you will get a voucher next week (Monday 1-2pm GMT/UTC +0) that will allow you to take the first tests we developed (10£ Voucher will be limited to the first several people who use it)
p.s. Thanks for pointing out the broken links.. I have added this to my routine tasks and will check entire website for broken links over the weekend... I fixed modify data for now.
Take care
Emil
Post #1438251
prathibha_aviator
prathibha_aviator
Posted Wednesday, April 03, 2013 12:53 PM
SSC Journeyman
Group: General Forum Members
Last Login: Thursday, May 09, 2013 7:34 PM
Points: 95,
Visits: 222
Thanks for the info.. I am now subscribed to your newsletters..I will wait for monday...
Can you please explain or answer the 1st question in your sample test create database objects... I couldn't figure it out.. I have been trying to solve it since yesterday
--Pra
--------------------------------------------------------------------------------
Post #1438540
KatieAndEmil
KatieAndEmil
Posted Tuesday, April 09, 2013 3:50 AM
SSC Rookie
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 8:00 AM
Points: 38,
Visits: 116
Hi
We now have two
70-461 Practice Tests
available for free* (use voucher code N70461 which is time limited).
I would appreciate your comments on how well do you think this test prepares for the exams and if there is anything that can be improved.
Take care
Emil
Post #1440237
manub22
manub22
Posted Tuesday, May 07, 2013 12:14 PM
SSC Journeyman
Group: General Forum Members
Last Login: Today @ 2:03 AM
Points: 82,
Visits: 557
Do check following site for the preparation of 70-461 exam:
http://sqlwithmanoj.wordpress.com/2012/11/16/passed-70-461-exam-querying-microsoft-sql-server-2012/
~manoj
sqlwithmanoj.wordpress.com
Post #1450288
« Prev Topic
|
Next Topic »
71 posts, Page 7 of 8
««
«
4
5
6
7
8
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.