Exam 70-431: TS: Microsoft SQL Server 2005, Implementation and Maintenance

Leave a comment (6) Go to comments

This is the core entry level certification for SQL Server 2005 who wanted to explore carrer in as core SQL DBA. Candidates for this exam should be experts in following areas:

  • Tools usage
  • UI navigation
  • Wizards usage
  • Writing code in the appropriate language (Transact-SQL, CLR language, and other scripting languages)
  • Code debugging or syntactic issue resolution
  • Troubleshooting
  • Accomplishing specific focused tasks by using code or UI navigation

Microsoft suggest you to go thru with this book to prepare for this exam. “MCTS Self-Paced Training Kit (Exam 70-431): Implementing and Maintaining Microsoft® SQL Server™ 2005″

Click Here to see more information on this on Microsoft.

 

I was shocked, while surfing internet I found that dumps and question papers, which are real exam questions  are available on the internet freely. Considering a copywrite information and microsoft quidelines, I can not copy and paste all those questions. But you are open to get it free on google search. If you find issues in googling, send me an Email, I will help you with right keywords to looks for this. 


But still, I am copying first two questions from those publicaly availbale material. 

QUESTION NO 1:Your application must access data that is located on two SQL Server 2005 computers. One of these servers is named SQL1 and the other is SQL2. You have permissions to create a stored procedure on SQL1 to support your application. However, on SQL2 you only have permissions to select data. 

 You write the stored procedure on SQL1. The stored procedure accesses SQL2 by using the OPENQUERY Transact-SQL statement. However, the query fails when executed. You need to troubleshoot the cause of the error. What should you do? 

 A. Join the two servers by using the four-part syntax of server.database.schema.table.

B. Reference SQL2 by using an alias.

C. Add SQL2 as a remote server to SQL1.

D. Add SQL2 as a linked server to SQL1.

You need to define a linked server for each external data source you want to access and the configure the security context under which your distributed queries will run. After you create a linked server, you can use the Transact-SQL OPENQUERY function to execute your distributed queries.

Answer: D  

Explanation:

You need to define a linked server for each external data source you want to access and the configure the security context under which your distributed queries will run. After you create a linked server, you can use the Transact-SQL OPENQUERY function to execute your distributed queries.
 

  

QUESTION NO: 2 You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal? (Each correct answer presents a complete solution. Choose two.)  

A. Named Pipes

B. TCP/IP

C. Shared Memory 

D. Virtual Interface Adapter (VIA)

E. Multiprotocol

Answer: A,B

Explanation:By default, clients have TCP and Named Pipes as available protocols. You can manipulate the protocol ordering by using the SQL Server Client utility. The client application uses the protocols in the order specified on the client computer. If you are using SQL Server 2005, the protocol order is stored in the ProtocolOrder registry entry under the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SNI9.0

EOF - Exam 70-431: TS: Microsoft SQL Server 2005, Implementation and Maintenance, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

6 Comments.

  1. hi

    need some help with the SQL SERVER 2008 QUESTIONS please

  2. Hi can you please email me the questions regarding SQL SERVER 2008 :grin:

  3. i want the questions for MCTS regarding SQL 2005 so please send me link to find out real questions

  4. i want the real questions for MCTS regarding SQL 2005
    help me out anyway

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.