2. Application developers in your company create an assembly that contains a CLR function. This CLR function
reads data from a spreadsheet, performs some calculations, and returns the data to a SQL Server 2005 computer.
You need to register the assembly with SQL Server 2005 by using the CREATE ASSEMBLY statement and the
least privileged security permission set. Which permission set should you use?
A. Default
B. SAFE
C. EXTERNAL_ACCESS
D. UNSAFE
Answer: C
3. Your company has two SQL Server 2005 computers named SQL1 and SQL2. A user in your company named
Eric writes many ad hoc queries against the company databases. Eric has access to the Customer database on
SQL1. He does not have access to the Sales database on SQL2. You need to ensure that Eric can write queries that
join information from both servers. What should you do first?
A. Create a linked server on SQL1 to SQL2. Configure the linked server to use impersonation.
B. Create a linked server on SQL1 to SQL2. Configure the linked server to use mapped logins.
C. Instruct Eric to write the queries on SQL2 by using the OPENQUERY statement and specifying SQL1 as the
server name.
D. Instruct Eric to specify SQL Server object names by using four-part notation.
Answer: B
4. You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy
requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local
computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most
likely cause of the connection issues. What should you do first?
A. Ensure that port 1433 is open in your firewall.
B. Ensure that port 443 is open in your firewall.
C. Ensure that client computers connect by using Shared Memory protocol.
D. Ensure that the server is not paused.
Answer: A
5. You are moving a SQL Server 2005 database named Timesheet to a new database server. The Timesheet
database is used by the TimeEntry application. You need to minimize the amount of time that the TimeEntry
application is unavailable while you move the database. What should you do?
A. Move the database to the new server by using the SQL Management Object method in the Copy Database
Wizard.
B. Detach the current database. Copy the data files to the new server. Attach the files.
C. Back up the database. Copy the backup file to the new server. Restore the database.
D. Move the data files. Specify the new location by using ALTER DATABASE.
Answer: B