网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report, ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do?()
A

Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.

B

Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables, specifying the same collation as the Dublin database.

C

Modify the format file to specify the same collation as the Dublin database. Import the table again.

D

Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query, specify the same collation as the Dublin database.


参考答案

参考解析
解析: 暂无解析
更多 “单选题You work in Dublin at the main office of TestKing.com. You are responsible for managing a SQL Server 2005 database. The sales department wants a report that compares customer activity in the previous quarter between the main office in Dublin and the branch office in Buenos Aires. They want the data sorted by surname and first name.You restore a recent backup of the Buenos Aires database onto your server. You write queries to build the report, ordering the data by the Surname and FirstName columns. You review the data and notice that the customer list from the Buenos Aires database is sorted differently. The sales department needs the revised data within 15 minutes for a presentation.  You need to implement the fastest possible solution that ensures that the data from both databases is sorted identically. What should you do?()A Use the Copy Database Wizard to copy the data in the Buenos Aires database to a new database with the same collation as the Dublin database.B Use the SQL Server Import and Export Wizard to copy the data from the Buenos Airesdatabase into new tables, specifying the same collation as the Dublin database.C Modify the format file to specify the same collation as the Dublin database. Import the table again.D Modify the query on the Buenos Aires database to use the COLLATE setting in the ORDER BY clause. In the query, specify the same collation as the Dublin database.” 相关考题
考题 You can hardly avoid ____ her if you both work in the same office. A、to meetB、meetC、meetingD、meeting with

考题 Better understanding of team work can make you a more effective employee and give you an extra ______ in your corporate office. A edge ;B badge ;C age

考题 You work as a network engineer at TestKing.com. You are required to allow establishment of a Telnet session with a router TestKingC.Which set command must be configured?() A.B.C.D.E.F.

考题 You are a security administrator for your company. The company has one main office and five branch offices. Network administrators work in the main office and each branch office.    Network administrators in the main office frequently create scripts that automate common  administrative tasks. You review each script to ensure it does not introduce security vulnerabilities. Scripts that do not introduce security vulnerabilities are considered approved. Occasionally, branch office administrators modify these scripts and distribute the modified scripts to other  branch office administrators. Branch office administrators often report that they accidentally run a modified version of a script.    You need to ensure that branch office administrators can verify which scripts are approved scripts.  What should you do?()A、 Maintain a list of the dates that the approved scripts were last modified. lnstruct branch office administrators to verifB、 Digitally sign All approved scripts. Instruct branch office administrators to verify the signature before using a script.C、 Distribute all approved scripts to branch office administrators in an e-mail message.D、 Place all approved scripts on a file server in the main office. Assign All branch office administrators only the Allow -the approved scripts. Instruct administrators to copy scripts from this file server.

考题 Your company has a main office and a branch office. Users in the branch office report that they are unable to access shared resources in the main office. You discover that computers in the branch office have IP addresses in the range of 169.254.x.x you need to ensure that computers can connect to shared resources in both the main office and the branch office. What should you do?()A、Configure a DHCP replay agent on a membe rserver in the main office.B、Configure a DHCP repla yagent on a member server in the branch office.C、Configure the broadcast addres sDHCP serve roptionto include the main offices DHCP server address.D、Configure the resource location servers DHCP serve roption to include the main office serve ipaddresses.

考题 Your company has multiple DNS servers in the main office.You plan to install DNS on a member server in a branch office.You need to ensure that the DNS server in the branch office is able to query any DNS server in the main office, and you need to limit the number of DNS records that are transferred to the DNS server in the branch office.What should you do?()A、Configure a secondary zone on the DNS server in the branch office.B、Configure a stub zone on the DNS server in the branch office.C、Configure a stub zone on the DNS server in the main office.D、Configure a primary zone on the DNS server in the branch office.

考题 Your company has a main office and a branch office. The main office contains two domain  controllers.     You create an Active Directory site named BranchOfficeSite. You deploy a domain controller in  the branch office, and then add the domain controller to the BranchOfficeSite site.  You discover that users in the branch office are randomly authenticated by either the domain  controller in the branch office or the domain controllers in the main office.   You need to ensure that the users in the branch office always attempt to authenticate to the  domain controller in the branch office first.     What should you do()A、Create organizational units (OUs).B、Create Active Directory subnet objects.C、Modify the slow link detection threshold.D、Modify the Location attribute of the computer objects.

考题 You are a network administrator for your company. The network consists of a single Active Directory forest that contains three domains. The functional level of the forest and of all three domains is Window Server 2003. The company has a main office and 30 branch offices. Each branch office is connected to the main office by a 56-Kbps WAN connection. You configure the main office and each branch office as a separate Active Directory site. You deploy a Windows Server 2003 domain controller at the main office and at each branch office. Each domain controller is configured as a DNS server.   You can log on to the network from client computers in the branch offices at any time. However, users in the branch offices report that they cannot log on to the network during peak hours.   You need to allow users to log on to the network from branch office computers. You do not want to affect the performance of the branch office domain controllers. You need to minimize Active Directory replication traffic across the WAN connections.   What should you do? ()A、 Use Active Directory Sites and Services to enable universal group membership caching for each branch office site.B、 Use the DNS console to configure the branch office DNS servers to forward requests to a DNS server in the main office.C、 Use Active Directory Sites and Services to configure each branch office domain controller as a global catalog server.D、 Use the DNS console to configure the branch office DNS servers to use an Active Directory-integrated zone.

考题 Your company has a main office and a branch office. The branch office has an Active Directory  site that contains a read-only domain controller (RODC).   A user from the branch office reports that his account is locked out. From a writable domain  controller in the main office, you discover that the user’s account is not locked out.     You need to ensure that the user can log on to the domain.     What should you do()A、Modify the Password Replication Policy.B、Reset the password of the user account.C、Run the Knowledge Consistency Checker (KCC) on the RODC.D、Restore network communication between the branch office and the main office.

考题 Your company has a main office and a branch office You deploy a read-only domain controller (RODC) that runs Microsoft Windows Server 2008 to the branch office You need to ensure that users at the branch office are able to log on to the domain by using the RODC What should you do()A、Add another RODC to the branch officeB、Configure a new bridgehead server in the main officeC、Configure the Password Replication Policy on the RODCD、Decrease the replication interval for all connection objects by using the Actrve Directory Sites and Services console

考题 Your company has a main office and a branch office. Users in the branch office report that they are unable o access shared resources in the main office. You discover that computers in the branch office have IP addresses in the range of 169.254.x.x you need to ensure that computers can connect to shared resources in both the main office and the branch office. What should you do?()A、 Configure a DHCP relay agent on a member server in the main officeB、 Configure a DHCP relay agent on a member server in the branch officeC、 Configure the Broadcast Address DHCP server option to include the main offices DHCP server addressD、 Configure the Resource Location Servers DHCP server option to include the main offices server ip addresses.

考题 Your company has multiple DNS servers in the main office. You plan to install DNS on a member server in a branch office. You need to ensure that the DNS server in the branch office is able to query any DNS server in the main office, and you need to limit the number of DNS records that are transferred to the DNS server in the branch office. What should you do?()A、 Configure a secondary zone on the DNS server in the branch office.B、 Configure a stub zone on the DNS server in the branch officeC、 Configure a stub zone on the DNS server in the main office.D、 Configure a primary zone on the DNS server in the branch office.

考题 单选题You are a security administrator for your company. The company has one main office and five branch offices. Network administrators work in the main office and each branch office.    Network administrators in the main office frequently create scripts that automate common  administrative tasks. You review each script to ensure it does not introduce security vulnerabilities. Scripts that do not introduce security vulnerabilities are considered approved. Occasionally, branch office administrators modify these scripts and distribute the modified scripts to other  branch office administrators. Branch office administrators often report that they accidentally run a modified version of a script.    You need to ensure that branch office administrators can verify which scripts are approved scripts.  What should you do?()A  Maintain a list of the dates that the approved scripts were last modified. lnstruct branch office administrators to verifB  Digitally sign All approved scripts. Instruct branch office administrators to verify the signature before using a script.C  Distribute all approved scripts to branch office administrators in an e-mail message.D  Place all approved scripts on a file server in the main office. Assign All branch office administrators only the Allow -the approved scripts. Instruct administrators to copy scripts from this file server.

考题 单选题Your company has a main office and two branch offices. The main office is located in Montreal. The branch offices are located in Seattle and Winnipeg. In the Montreal office, you have a server named Server1 that runs Windows Server 2003 Web Edition Service Pack 2 (SP2). Server1 is configured as a VPN router. In the Seattle office, you have a VPN server named Server2. In the Winnipeg office, you have a VPN server named Server3. On Server1, you configure a L2TP/IPSec demand-dial interface for each branch office. On each branch office server, you create a single demand-dial interface that uses L2TP/IPSec to connect to the main office. All demand-dial interfaces are configured to use a pre-shared key. You discover that only one branch office can connect to the main office at a time. You need to ensure that both branch offices can connect to the main office simultaneously.  What should you do?()A Add two more demand-dial interfaces on Server1.B Install a computer certificate on Server1, Server2, and Server3.C Upgrade Server1 to Windows Server 2003 Standard Edition SP2.D Add an additional demand-dial interface on Server2 and Server3.

考题 单选题Your company has multiple DNS servers in the main office. You plan to install DNS on a member server in a branch office. You need to ensure that the DNS server in the branch office is able to query any DNS server in the main office, and you need to limit the number of DNS records that are transferred to the DNS server in the branch office. What should you do?()A  Configure a secondary zone on the DNS server in the branch office.B  Configure a stub zone on the DNS server in the branch officeC  Configure a stub zone on the DNS server in the main office.D  Configure a primary zone on the DNS server in the branch office.

考题 单选题You work at the regional sales office. You are responsible for importing and exporting data in SQL Server 2005 databases. The main office asks you to send them a text file that contains updated contact information for the customers in your region. The database administrator in the main office asks that the data be sorted by the StateProvince,Surname, and FirstName columns.You need to satisfy these requirements by using the least amount of effort. What should you do?()A Specify StateProvince, Surname, and FirstName in the ORDER hint in the bcp out command.B Create a format file for the export operation.C Specify StateProvince, Surname, and FirstName in the ORDER BY clause in the bcp queryout command.D Copy the data into a new table that has a clustered index on StateProvince,Surname,and FirstName. Export the data.

考题 单选题Your company has a single Active Directory directory service forest with multiple domains. The  company has a main office with 1,000 users and a single branch office with 500 users. Each office is aseparate Active Directory site. The main office Active Directory site has two domain controllers with Global  Catalog services. Company employees must be able to work in both offices. You need to plan the  placement and configuration of domain controllers.  What should you do?()A  Deploy two additional domain controllers in the main office Active Directory site.B  Deploy global catalog servers in the branch office Active Directory site.C  Enable change notification on the site link between the main office Active Directory site and the branch office Active Directory site.D  Disable change notification on the site link between the main office Active Directory site and the branch office Active Directory site.

考题 单选题Your company has a main office and a branch office.   You discover that when you disable IPv4 on a computer in the branch office, the computer  authenticates by using a domain controller in the main office. You need to ensure that IPv6-only  computers authenticate to domain controllers in the same site.     What should you do()A Configure the NTDS Site Settings object.B Create Active Directory subnet objects.C Create Active Directory Domain Services connection objects.D Install an Intra-Site Automatic Tunnel Addressing Protocol (ISATAP) router.

考题 单选题You are an administrator in a company that has a Main Office and 5 branch offices.In every branch office exist a Hub Transport server, and only in Main Office exists an Edge server.You add a disclaimer to all internal and external e-mail messages sent by users in the company. You discover that e-mail messages sent from one of Branch Offices do not include the disclaimer.You need to ensure that all e-mail messages include disclaimer.What should you do?()A Restart Microsoft Exchange System AttendantB Modify cache settings of Branch Offices Hub Transport ServerC Force Active Directory replication on the Branch Office Domain ControllerD Export all transport rules from the Hub Transport Server in Main Office import the transport rules in the branch office Hub Transport Server

考题 单选题Certkiller .com has a main office and branch office in another city. You are assigned to deploy and implement a Read-only Domain Controller (RODC) at the branch office. You deploy a RODC that runs Windows Server 2008.  What should you do to ensure that the users at the branch office can log on to the domain using RODC()A Use Password Replication Policy on the RODCB Add RODC to the main officeC Deploy and configure a new bridgehead server in the branch officeD Deploy and configure a Password Replication Policy on the RODC in the main office

考题 单选题Your company has a main office and a branch office. Users in the branch office report that they are unable o access shared resources in the main office. You discover that computers in the branch office have IP addresses in the range of 169.254.x.x you need to ensure that computers can connect to shared resources in both the main office and the branch office. What should you do?()A  Configure a DHCP relay agent on a member server in the main officeB  Configure a DHCP relay agent on a member server in the branch officeC  Configure the Broadcast Address DHCP server option to include the main offices DHCP server addressD  Configure the Resource Location Servers DHCP server option to include the main offices server ip addresses.