查询Microsoft SQL Server 2012/2014 –准备考试70-461

所需技能 (Skills Required)

70-461考试包括以下领域的问题：

Create database objects (20–25%)
创建数据库对象（20–25％）
Work with data (25–30%)
处理数据（25–30％）
Modify data (20–25%)
修改数据（20–25％）
Troubleshoot and optimize (25–30%)
故障排除和优化（25–30％）

实践测试 (Practice Test)

您可以参加Microsoft Official Practice Test (not free), to help you prepare better for the actual exam. I was very satisfied with the quality of the questions in the Practice Test, and it helped me to identify areas where I had to focus upon. All the questions had detailed explanations for the answer options mentioned, which aided me in revising the skills required for this exam. Overall the practice tests did help me to prep up for the exam and gain confidence, but I must say that the actual 70-461 was a lot tougher than the practice exam. Microsoft provides special offers on the Certification exams – in the form of an additional retake or even a practice test. It might not be a bad decision to improve your exam odds, by adding an extra retake. It’s always a good feeling to have the cushion of an extra attempt to pass the exam. You can learn more about the certification and exam offers Microsoft官方实践考试（免费），以帮助您更好地为实际考试做准备。我对实践测试中的问题质量非常满意，它帮助我确定了我必须关注的领域。所有问题都对所提到的答案选项进行了详细说明，这有助于我提高考试所需的技能。总体而言，练习测试确实帮助我为考试做准备并赢得了信心，但我必须说，实际的70-461比练习考试要难得多。 Microsoft提供了额外的重考甚至是实践考试的形式，提供有关认证考试的特别优惠。通过增加额外的重考来提高考试几率可能不是一个坏决定。可以通过一次额外的尝试来保持考试的感觉总是很不错的。您可以here. 在此处了解有关认证和考试优惠的更多信息。

实际认证考试 (Actual Certification Exam)

考试是多项选择题，重新排列语句以形成正确的存储过程/函数/触发器，从下拉列表中选择正确的选项，案例研究等的很好的组合。考试中最难的部分是提问您实际需要编写T-SQL代码的地方–查询，存储过程，触发器，函数等。您在SQL方面的所有动手经验都将在这里发挥作用。但是，如果您发现这8-10个问题集，我建议您不要花很多时间在前面，不要灰心。完成其余问题后，将其标记为待审核，并稍后再返回。您将总是有几个问题，可以立即回答。首先把他们撞倒！

查询Microsoft SQL Server 2012/2014 –准备考试70-461

问题类型和格式 (Type of questions and formats)

在参加考试之前，了解问题模式并熟悉考试界面总是很有帮助的。我在下面列出了您在70-461考试中会发现的不同类别的问题，以帮助您更好地为考试做准备：

Build List There will be a scenario mentioned and 4-5 actions to perform in a sequence. You will need to arrange this list of actions in the correct order to achieve the goal. Basically, it will be a kind of Drag and Drop type question and you need to put your selections in the correct order. To tackle these types of questions it will be great if you can thoroughly practice various T-SQL syntax like Creating/Modifying Constraints and DML Triggers, Creating Stored Procedures and Functions, Error Handling and more. 构建列表将提到一个场景，并按顺序执行4-5个操作。您将需要按照正确的顺序排列此操作列表，以实现目标。基本上，这将是一种拖放类型的问题，您需要按正确的顺序放置选择。为了解决这些类型的问题，如果您能彻底练习各种T-SQL语法（如创建/修改约束和DML触发器，创建存储过程和函数，错误处理等），那就太好了。 Case Studies There will be a Business case with multiple questions associated with it. Make sure you patiently read through the entire business requirement before proceeding to answer the questions. Flipping back and forth between the questions and the case details might take unnecessary time. A helpful tip here will be to read through the various options available in the answer section to quickly understand the intent of the case study. 案例研究将有一个与多个问题相关的业务案例。在继续回答问题之前，请确保您耐心阅读了整个业务需求。在问题和案例详细信息之间来回切换可能会花费不必要的时间。一个有用的提示是通读答案部分中的各种选项，以快速了解案例研究的意图。 Drag and Drop There will be a number of questions which will need you to drag and drop correct answers from the given list of options. This might get tricky sometimes since there might be cases when the same answer option needs to be dragged multiple times to answer correctly. 拖放将有许多问题需要您从给定的选项列表中拖放正确的答案。有时这可能会很棘手，因为在某些情况下，可能需要多次拖动同一答案选项才能正确回答。 Multiple Choice Questions These will be the easiest of all the question types and you will need to select the correct option for the given question. A pro tip will be to ensure that you answer all such questions and not leave any unanswered. Remember that there are no negative marks for wrongly answered questions. If you are not aware of the right answer, try to eliminate wrong options and narrow down the set of probable answers to the question. Once you do that, you can try your luck by guessing the correct answer. 多项选择题这些是所有问题类型中最简单的，您将需要为给定问题选择正确的选项。一个专业的技巧是确保您回答所有此类问题，并且不要让任何问题解答。请记住，对于错误回答的问题，没有负面的评价。如果您不知道正确的答案，请尝试消除错误的选择，并缩小问题的可能答案范围。完成此操作后，您可以通过猜测正确答案来尝试自己的运气。 Writing SQL Code Snippets These will be the toughest questions to *****. A text area will be provided to write the code to resolve a real-life problem. It might be either writing a stored procedure, trigger, user defined function or similar code snippets. SQL Keywords are provided in a separate tab to assist you with writing code. There will be no intelligence when you start writing your code in this text area, so I would say to answer these questions you would need thorough hands on knowledge. There were about 8-9 such questions and took me the most time to answer them correctly. 编写SQL代码段这些将是最难解决的问题。将提供一个文本区域来编写代码以解决实际问题。它可能是编写存储过程，触发器，用户定义的函数或类似的代码片段。 SQL关键字在单独的选项卡中提供，以帮助您编写代码。当您开始在此文本区域中编写代码时，将不会有任何智能，因此我想回答这些问题时，您将需要全面的知识。大约有8-9个这样的问题，我花了最多的时间正确回答了这些问题。

学习资料 (Study Materials)

在线上有很多有用的资源可以帮助您为考试做准备：我强烈建议您阅读本书–“培训工具包（考试70-461）：查询Microsoft SQL Server 2012”。本书涵盖了您通过考试所需的所有主题和技能。确保同时还要进行大量动手查询。 Microsoft Virtual Academy提供了有关70-461所需的各个重点领域的丰富内容和详细的培训材料– Querying Microsoft SQL Server 2012 Databases Jump Start If you are new to SQL Server, then I would suggest you to go through this 查询Microsoft SQL Server 2012数据库快速入门如果您是SQL Server的新手，那么我建议您阅读以下SQL Server Tutorial in YouTube. I found it very beneficial to recap some of the areas where I had minimal hands on experience. You can check out these Pluralsight Courses to get detailed walkthrough on the various areas: SQL Server教程： YouTube。我发现重温一些我经验很少的领域非常有益。您可以查看以下Pluralsight课程，以获得有关各个领域的详细演练：