微软认证考试

Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does

题目

Your company uses a SQL Server 2005 database. Customer data from your trading partners is imported into the Customers table every night. You need to ensure that the customer record is updated if it already exists in the Customers table. If the record does not exist, the data needs to be inserted into the Customers table. What should you do?()

  • A、 Create a FOR trigger. 
  • B、 Create an INSTEAD OF trigger. 
  • C、 Create an AFTER trigger. 
  • D、 Create a DDL trigger.
如果没有搜索结果,请直接 联系老师 获取答案。
如果没有搜索结果,请直接 联系老师 获取答案。
相似问题和答案

第1题:

A brand new network application is required for the Acme Company, and they are considering the use of a connectionless service. What are the characteristics of a connectionless service?()

A. It uses a Reliable transport mechanism.

B. It uses a Non-reliable transport mechanism

C. It is less bandwidth-intensive than connection oriented services

D. it uses handshaking


参考答案:B, C

第2题:

Your company has an Active Directory domain. All computers are members of the domain. Your networkcontains an internal Web site that uses Integrated Windows Authentication. From a computer that runs Windows 7, you attempt to connect to the Web site and are prompted for authentication. You verify that youruser account has permission to access the Web site. You need to ensure that you are automaticallyauthenticated when you connect to the Web site.  What should you do?()

  • A、Create a complex password for your user account.
  • B、Open Credential Manager and modify your credentials.
  • C、Add the URL of the Web site to the Trusted sites zone.
  • D、Add the URL of the Web site to the Local intranet zone.

正确答案:D

第3题:

– () – We are headquartered in Shanghai.

A、How about the departmental structure in the headquarters

B、What is your company profile

C、Where are your headquarters


参考答案:C

第4题:

Your company has an Active Directory forest. The company has servers that run Windows Server   2008 R2 and client computers that run Windows 7. The domain uses a set of GPO administrative  templates that have been approved to support regulatory compliance requirements.   Your partner company has an Active Directory forest that contains a single domain. The company has  servers that run Windows Server 2008 R2 and client computers that run Windows 7.   You need to configure your partner companys domain to use the approved set of administrative  templates.   What should you do()

  • A、Use the Group Policy Management Console (GPMC) utility to back up the GPO to a file. In each site,  import the GPO to the default domain policy.
  • B、Copy the ADMX files from your companys PDC emulator to the PolicyDefinitions folder on the partner  companys PDC emulator.
  • C、Copy the ADML files from your companys PDC emulator to the PolicyDefinitions folder on thepartner  companys PDC emulator.
  • D、Download the conf.adm, system.adm, wuau.adm, and inetres.adm files from the Microsoft Updates  Web site. Copy the ADM files to the PolicyDefinitions folder on the partner companys PDC emulator.

正确答案:B

第5题:

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()

  • A、Configure a Linked Server connection to the application database.
  • B、Write a query that uses an OPENDATASOURCE command.
  • C、Write a query that uses an OPENQUERY command.
  • D、Configure a Remote Server connection to the application database.

正确答案:B

第6题:

A brand new network application is required for the Acme Company, and they are considering the use of a connectionless service. What are the characteristics of a connectionless service?()

  • A、It uses a Reliable transport mechanism.
  • B、It uses a Non-reliable transport mechanism
  • C、It is less bandwidth-intensive than connection oriented services
  • D、it uses handshaking

正确答案:B,C

第7题:

You work as a network technician at Company. Your boss, Mrs.   , is interested in   GLBP. In particular, she wants to know the multicast address that this protocol uses.  What should  you tell her? ()

  • A、 224.0.0.100
  • B、 224.0.0.1
  • C、 224.0.0.102
  • D、 224.0.0.10
  • E、 224.0.0.101
  • F、 None of the other alternatives apply

正确答案:C

第8题:

Your Web site uses custom Themes. Your Web site must support additional Themes based on the user‘s company name. The company name is set when a user logs on to the Web site. The company‘s Theme name is stored in a variable named ThemeName. You need to use this variable to dynamically set the Web site‘s Theme.What should you do?()

A.

B.

C.

D.


参考答案:C

第9题:

Your company has an Active Directory domain. AlI servers run Windows Server 2008. Your company uses an Enterprise Root certificate authority (CA). You need to ensure that revoked certificate information is highly available. What should you do()

  • A、Implement an Online Certificate Status Protocol (OCSP) responder by using Network Load Balancing.
  • B、Implement an Online Certificate Status Protocol (OCSP) responder by using an Internet Security and Acceleration Server array.
  • C、Publish the trusted certificate authorities list to the domain by using a Group Policy Object (GPO).
  • D、Create a new Group Policy Object (GPO) that allows users to trust peer certificates. Link the GPO to the domain.

正确答案:A

第10题:

You are the administrator of ExamSheet.net's network.   Your Windows 2000 Professional computer has a removable disk device installed. The device can use storage modules of varying sizes. You use these storage modules to transfer graphics files between your location and a printing company. The printing company uses Windows 98. You insert a new 100 MB disk device into your computer and format the new disk device as NTFS with the default options. You then place large graphics files on the disk device and deliver it to the printing company. The printing company reports that they are unable to access the files.  You want the printing company to be able to access the graphics files on the new disk device. What should you do?()

  • A、Format the new disk device as NTFS with a 4 KB cluster size.
  • B、Format the new disk device as FAT32 with a 4 KB cluster size.
  • C、Format the new disk device as FAT32 with a 1 KB cluster size.
  • D、Format the new disk device as FAT16 with a 4 KB cluster size.

正确答案:D

更多相关问题