单项选择题
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 write a code segment that transfers the first 80 bytes from a stream variable named stream1 into a new byte array named byteArray. You also need to ensure that the code segment assigns the number of bytes that are transferred to an integer variable named bytesTransferred. Which code segment should you use？（）
A.A
B.B
C.C
D.D -
单项选择题
You add an Online Responder to an Online Responder Array. You need to ensure that the new Online Responder resolves synchronization conflicts for all members of the Array. What should you do（）
A.From Network Load Balancing Manager， set the priority ID of the new Online Responder to 1.
B.From Network Load Balancing Manager， set the priority ID of the new Online Responder to 32.
C.From the Online Responder Management Console， select the new Online Responder， and then select Set as Array
D.From the Online Responder Management Console， select the new Online Responder， and then select Synchronize -
单项选择题
Your company has a single Active Directory domain. The domain has servers that run Windows Server 2008 R2. You have a server named NAT1 that functions as a NAT server. You need to ensure that administrators can access a server named RDP1 by using Remote Desktop Protocol (RDP). What should you do？（）
A. Configure NAT1 to forward port 389 to RDP1.
B. Configure NAT1 to forward port 1432 to RDP1.
C. Configure NAT1 to forward port 3339 to RDP1.
D. Configure NAT1 to forward port 3389 to RDP1.
