What feature of SQL Server 2005 would help you g

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

(Continued from previous question...)

What feature of SQL Server 2005 would help you get the snapshot transferred?

You are initiating a new replication subscription for one of the remote offices, but don't want to transfer it across the network. The snapshot files are 725MB, too large for your CD burner and there is no tape drive at the remote office. What feature of SQL Server 2005 would help you get the snapshot transferred?

Answer
Compressed Snapshots
Explanation
In SQL Server 2005, you can specify a snapshot to be compressed and it will be compressed using the CAB format. If it compresses enough, you should be able to burn it onto a CD.

(Continued on next question...)

Other Job Interview Questions

• On which port does the dedicated administrator connection listen in SQL Server 2005?
• You have just upgraded your server from a single processor by adding 3 additional processors....
• Which of the following CREATE ASSEMBLY statement WITH PERMISSION_SET clauses sets ...
• What will occur with the following code in SQL Server 2005 if executed by Alice?
• What is a zettabyte?
• How many of these servers can you consolidate?
• You then write a function to use this assembly, but it does not work. What could be the problem?
• What does the Log Reader agent in SQL Server 2005 replication do?
• The Sort component in SQL Server 2005 Integration Services is what type of component?
• How can you ensure that a table named TableB with a field named Fld1 will only have those values in the Fld1 field that are also in the table named TableA with a field named Fld1?
• More...