You are implementing replication across the Inte

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

You are implementing replication across the Internet for a large bank that wishes to move up to date pricing information...

You are implementing replication across the Internet for a large bank that wishes to move up to date pricing information to an analyst's laptop. They are concerned about spoofing of their main site by criminals. What can you do to secure the replication solution with SQL Server 2005?

Answer
Set the encryption level to verify the certificate is issued by a trusted authority.
Explanation
Since you are asked to use replication, a replication solution is to use encryption for the connection and verify the certificate being used is from a trusted authority. Setting the encrpytion level to 2 will do this.

(Continued on next question...)

Other Job Interview Questions

• Which type of XML variable requires a\one and only one root element?
• Which database holds the tables that Database Mail uses to store mail messages and other data in SQL Server 2005?
• Can you call Notification Services APIs from unmanaged code?
• With SQL Server 2005, Oracle servers can be included in your replication topology. How can an Oracle server function?
• What does the DUMP command do?
• What is a performance consideration of having too many indexes on a production online transaction processing (OLTP) table?
• What is the quickest way to get them working?
• A .NET assembly running with UNSAFE permissions can do which of the following?
• What does @@MAX_PRECISION return?
• How many credentials can one login be mapped to?
• More...