Q. What is the 70-442 exam?

A. This certification exam is meant for professional database developers who can design and implement their database solutions. They should have three or more years dedication to database work, which includes writing Transact-SQL queries, designing and implementing programming objects, optimizing databases, designing databases at both the conceptual and logical levels, and implementing databases at the physical level.

Q. What are the prerequisites for the 70-442 exam?

A. If you are planning to take the PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442) exam, you should have a minimum of three years of experience developing databases by using Microsoft SQL Server 2005.

Q. What are the benefits of becoming a Microsoft Certified Technology Specialist (MCTS)?

A. Following are the benefits that will make you an expertise in the following areas:

  • Writing Transact-SQL queries
  • Programming databases
  • Troubleshooting programming objects (stored procedures, triggers, user-defined functions (UDFs), user-defined types (UDTs), and queries)
  • Performing database performance tuning and optimization
  • Designing databases both at the conceptual and logical levels
  • Implementing databases at the physical level
  • Designing and troubleshooting the data access layer of the application

Q. What credit does the PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442) exam provide?

A. This will provide you the credentials to be recognized as Microsoft Certified Technology Specialist (MCTS) certification.

Q. How many questions are asked in the test?

A. There are 55 questions in the exam.

Q. What is the duration of the test?

A. The duration of the exam is 120 minutes.

Q. What is the passing score?

A. The passing score is 700.

Q. What is the test retake policy?

A. Yes there is a retake policy. Take a Second Shot at Certification and Advance Your Career. The Second Shot provides a free retake if you do not pass an IT professional or developer Microsoft Certification exam the first time. You must take both the first and (if necessary) the retake exam before June 30, 2010.

Q. Why should I become certified?

A. To become an expertise in databases and to get a high profile, you should get certified.

Q. Is the PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442) exam right for me?

A.YES, if you want to be recognized as a Microsoft Certified Technology Specialist (MCTS) and want your career to be built in the field of databases, you should be Microsoft certified by taking this test 70-442.

Q. What skills are measured in the PRO: Designing and Optimizing Data Access by Using Microsoft SQL Server 2005 (70-442) exam?

A. Following are the important areas in which an individual should have good knowledge before taking the test 70-442:

  1. Design appropriate data access technologies.
  2. Design an appropriate data access object model.
  3. Design a cursor strategy for a data access technology.
  4. Design caching strategy.
  5. Design client libraries to write applications that administer a SQL Server.
  6. Design queries that use multiple active result sets(MARS).
  7. Design database query strategies.
  8. Write and modify queries.
  9. Design queries for retrieving data from XML sources.
  10. Design a cursor strategy.
  11. Designing error handling routines.
  12. Designing the transaction strategy.
  13. Performance tuning the database and database application.
  14. Optimizing Index strategies.
  15. Scale database application.
  16. Resolve performance problems.

Q. Where can I take the test?

A. You can take this exam in a PROMETRIC CENTER.

Q. How do I register for the 70-442 exam?

A. You can register for the exam through a Prometric Test Center Locator at Prometric. You will have to go through a complete registration process, make payments, and schedule the date and time for the exam.

Q. What can I expect from Microsoft if I pass the 70-442 exam?

A. Microsoft will provide you a credential certificate of Microsoft certified Technology specialist (MCTS) certificate, and if you complete your 3 core exams, Microsoft will provide you the Microsoft certified IT Professional (MCITP) certification.

Q. What is the IC3 Computing Fundamental exam?
A. The IC3 is a certification program that is designed to teach individuals the digital literacy skills associated with basic computer and Internet use. The Computing Fundamental exam deals with hardware, software, and operating systems.

Q. What are the prerequisites for the IC3 Computing Fundamental exam?
A. There are no specific prerequisites for the IC3 Computing Fundamental exam.

Q. What credit does the IC3 Computing Fundamental exam provide?
A. The IC3 Computing Fundamental exam counts as credit towards the IC3 certificate.

Q. What certificate does it provide?
A. The IC3 certificate is awarded to those individuals that take and pass three separate exams, titled Computing Fundamentals, Key Applications, and Living Online.

Q. What is the duration of the test?
A. Candidates are required to attempt all the questions in approximately 45 minutes.

Q. Which type of the test is it? (Adaptive/Linear)
A. The exam IC3 Computing Fundamental exam is in linear format.

Q. What is the passing score?
A. You need a score of 800 to pass the exam.

Q. Why should I become certified?
A. The Internet and Computing Core Certification (IC3) program is the world’s first validated, standards-based training and certification program for basic computing and Internet knowledge and skills. Successful completion of IC3 ensures you have the knowledge and skills required for basic use of computer hardware, software, networks, and the Internet. IC3 is your gateway to advancement in education, employment, or other certification programs.

Q. Is the IC3 Computing Fundamental exam right for me?
A. The IC3 Computing Fundamental exam is intended for anyone, who wishes to demonstrate his or her knowledge of hardware, software, operating system, word processing, electronic spreadsheets, and presentation software. The exam covers how each type of hardware, software, and OS is used.

Q What to expect in the IC3 Computing Fundamental exam?
A. The exam consists of multiple-choice, multiple-answer, matching, and true/false, with performance-based simulations to truly and effective measure an individual’s knowledge and ability to complete simple computing tasks in an application or user interface environment.

Q. What are the skills being measured for the IC3 Computing Fundamental> exam?
A. The IC3 Computing Fundamental exam measures the knowledge of a candidate of word processing, electronic spreadsheets, and presentation software.

Q. Where to take the test?
A. You can take the exam at Certiport testing centers.

Q. What is the exam fee?
A. The exam fee is US$33.