当前位置:MCITP(70-450)题库

问题:

[单选]

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company. SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application developers. A fixed cache file is required by one of the packages. The company will deploy the packages to the production server on completion of development. The production server is available only to the database administrators.  Since you are the technical support, you need to confirm that the project can be deployed successfully to the production server by the application developers.   
Which action will you perform to achieve the goal?()

A . To achieve the goal, the Import and Export Wizard should be utilized to save packages.
B . To achieve the goal, a direct package configuration should be created for each package.
C . To achieve the goal, a deployment utility should be created for the SSIS project. 
D . To achieve the goal, an indirect package configuration should be created for all packages.

通常管理可分为五大职能,即计划、组织、指挥、()和控制。 某人购买了利率14%的国库券,此人要在3年后得到1万元,问他现在需要买多少国库券? You are creating a Web-based application to manage data aggregation for reports. The application connects to a SQL Server 2005 database named DataManager. One page in the application has controls that execute stored procedures in a database named ReportingDatabase. There is an existing Service Broker connection between the DataManager database and ReportingDatabase.You want to add two new message types to the existing service. In each database, you create message types named ProcessReport and SendResult. You need to add the two new message types to the existing service. What should you do first?() Create a queue on each database with the ACTIVATION argument set to DataManager dbo processReport.。 Create a conversation between the databases by using the following Statement BEGIN DIALOG FROM SERVICE ’ProcessReport’ TO SERVICE ’SendResult’。 Create a contract between the services by using the following statement.CREATE CONTRACT processData (ProcessReport SENT BY INITIATOR,SendResult SENT BY TARGET)。 Create services for each database by using the following statement.CREATE SERVICE DataManager on QUEUE ProcessReport。 您需要为连接到西雅图网络的移动用户,设计公司的网络支持VPN需求。您应该执行哪2个操作?() 使用一种密码生成应用程序创建一个预共享密匙,并且分发给所有移动用户。 使用计算机自动注册功能去创建能被用于认证VPN服务器的数字证书。 为各台要建立VPN连接的计算机,从商业CA处获取一个用于SSL的数字证书。 在全部路由与远程访问的服务器上配置需要使用数字证书的IPSec策略。 You have a domain controller named DC1 that runs Windows Server 2008 R2. DC1 is configured  as a DNS server for contoso.com.  You install the DNS Server server role on a member server named Server1 and then you create a  standard secondary zone for contoso.com. You configure DC1 as the master server for the zone.     You need to ensure that Server1 receives zone updates from DC1.     What should you do() On Server1, add a conditional forwarder.。 On DC1, modify the permissions of contoso.com zone.。 On DC1, modify the zone transfer settings for the contoso.com zone.。 Add the Server1 computer account to the DNSUpdateProxy group.。

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 instance of your company is managed by you. There is a team of database administrators in your company. SQL Server 2008 Integration Services (SSIS) packages are created on the test server in a shared project by a team of application developers. A fixed cache file is required by one of the packages. The company will deploy the packages to the production server on completion of development. The production server is available only to the database administrators.  Since you are the technical support, you need to confirm that the project can be deployed successfully to the production server by the application developers.   
Which action will you perform to achieve the goal?()

参考答案:

  参考解析

本题暂无解析

相关题目:

在线 客服