违法和不良信息举报 联系客服
免费注册 登录

DTS包括（）部分。

题目
多选题
DTS包括（）部分。
A

时间戳产生的过程

B

需加时间戳的文件摘要

C

DTS收到文件的日期和时间

D

DTS的数字签名

如果没有搜索结果或未解决您的问题，请直接 联系老师 获取答案。
相似问题和答案

第1题：

You are the administrator of a SQL Server 2000 computer. Each evening after business hours, you perform. database maintenance tasks. You create a Data Transformation Services package to populate the data warehouse. MAPI is not installed on the server.

You want to schedule the DTS package to run each night. You want to attend to other duties while the DTS package is executing. You also want to be notified if the DTS package fails.

What should you do?

A．Select the DTS packages log package execution to SQL server check box. Create a SQL server event alert to notify you if the package fails.

B．Select the DTS packages write completion status to event log check box. Create a SQL server event alert to notify you if the package fails.

C．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the send mail task to notify you if the package fails.

D．Configure the DTS package to include an on failure precedence constraint and a send mail task. Configure the execute process task to execute a not send command that will notify you if the package fails.


正确答案：B
解析：Explanation:Whenjobsarecompleted(successfullyornot),thesubsystemreturnsaresultstatus(withoptionalmessages)toSQLServerAgent.SQLServerAgentthenrecordsthecompletionstatusinboththeoperatingsystem'sapplicationlogandthejobhistorytableinSQLServerandoptionallysendsane-mailreportoranSQLServereventalertofthejobstatustothedesignatedoperator.IncorrectAnswers:A:Weareinterestedtowhenthepackagehascompleted.Thecompletionstatus,notthelogpackageexecution,shouldbeusedtotrapthecompletionofapackage.TheexecutionstatusconcernsLastruntime,Lastrunstatus,Lastrunmessage,etc.C,D:TheMessagingApplicationProgrammingInterface(MAPI)isn'tinstalled.MAPIisneededforSQLServertosende-mail.Noe-mailcanbesendbySQLServerinthisscenario.

第2题：

DMS的主要功能是（）。
A.SCADA/AGC/PAS, B.SCADA/AGC/EDC/DTS5
C.SCADA/LM/PAS/(AM/FM/GIS)； D.SCADA/LM/PAS/DTS。


答案：C
解析：

第3题：

You are the administrator of a SQL Server 2000 computer. The server contains a Data Transformation Services (DTS) package that queries multiple databases and writes the results to a text file. You run this package by using a Microsoft Windows batch file. The batch file uses the dtsrun utility to execute the DTS package.

You want to ensure that connection properties, such as login names and passwords, cannot be read or modified by users. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)

A．Save the DTS package so that it has an owner password.

B．Save the DTS package so that it has a user password.

C．Encrypt the DTS package details in the command line of the dtsrun utility.

D．Store the DTS package in the Meta. Data Services repository.

E．Store the DTS package as a Microsoft Visual Basic file.


正确答案：AC
解析：Explanation: In this scenario we will use a windows batch file with the owner password for maximum security.

A: When running the Dtsrun utility on a package you must either specify a user password or a package password. Specify a password for the package to protect sensitive user name and server password information in the package from unauthorized users with owner password. If the package has an owner password, the data is encrypted with the standard encryption API. This protects protect sensitive user name and server password information in the package from unauthorized user.
.
C: You can encrypt the command prompt options to be executed by the DTS Run utility, allowing you to create an encrypted dtsrun command for later use. This will ensure that login names, password and other command line options cannot be read or modified by users.

Note: When a package is saved to SQL Server or as a structured storage file, DTS package passwords can be assigned to the package. These passwords are used in addition to the Windows Authentication or SQL Server Authentication passwords to connect to an instance of SQL Server.

There are two types of DTS package passwords that can be set: an owner password and a user password. If an owner password is set, the package user needs the password to edit or run the package and if a user password is set, the package users with access to the user password can run the package.

Incorrect Answers:
B: There is no need to create a user password. The package will be run with an owner password. The owner password will be protected since the command options are encrypted.

D: The Meta. Data Services repository is the storage container for the meta. data used by Analysis Services. Meta. data is stored in tables in a relational database and is used to define the parameters and properties of Analysis server objects. DTS package information can be saved to Meta. Data Services. This saves meta. data information about the databases referenced in the package, which can be viewed though the DTS Browser.

E: When a DTS package is saved as a Visual Basic file, these files can be used as templates, or starting points, for user-implemented Visual Basic packages. The generated code sets all properties of all objects referenced in the package to the initial values they will have when package execution begins. This includes those that are set to their default values.

第4题：

数字时间戳是数字签名技术的一种变种应用，它包括（）

  • A、需加时间戳的文件的摘要
  • B、DDT的发出时间
  • C、DTS收到文件的日期和时间
  • D、DTS的数字签名

正确答案:A,C,D

第5题：

以下不包括数字时间戳内容的是（）。

  • A、需加时间戳的文件的摘要
  • B、DTS收到文件的日期和时间
  • C、DTS的数字签名
  • D、DTS的安全认证

正确答案:D

第6题：

SQL Server 2000提供了数据转换服务(DTS)，利用DTS可以实现不同数据源之间的数据转换与传输。关于DTS的功能，下列说法正确的是

A．DTS可以帮助用户方便、快捷地实现数据的导入和导出操作。但DTS只支持SQL Server 2000数据库之间的导入和导出

B．利用DTS传输数据时，用户不能只传输一个表的部分数据，而必须传输整个表的数据

C．利用DTS传输数据时，可以将数据传输到其他数据库服务器上，而且在传输过程中可以在目标服务器上建立新表，并将数据传输到新表中

D．利用DTS在不同数据库间传输数据时，SQL Server并不对执行传输操作的用户进行权限认证。因此，用户可利用DTS传输数据库中的任何数据


正确答案：C
解析：DTS的源数据和目的数据可以是异构的数据库数据，比如将电子表格数据导人到数据库中等；DTS可以用一条查询语句选择数据源中要传输的数据。

第7题：

灰斗流化风机系统监控画面风机出口上端的PS是指出口压力，DTS是指（），正常情况下，DTS为（），超限报警后显示（）。
入口器温差；绿色；红色
略

第8题：

You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.

The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.

You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.

You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.

You want to enable the server in Sydney to connect to the mainframe. database. What should you do?

A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.

B．Modify the workflow in the DTS package so that the server in Sydney is included.

C．On the server in Sydney, install an OLE DB provider for the mainframe. database.

D．On the server in Sydney, delete and then re-create the DTS package.


正确答案：C
解析：Explanation: OLE DB is an API that allows COM applications to use data from OLE DB data sources, which includes data stored in different formats. An application uses an OLE DB provider to access an OLE DB data source. An OLE DB provider is a COM component that accepts calls to the OLE DB API and performs the necessary processing required by request against the data source. In this scenario the OLE DB source is the company's mainframe. database, which contains all company data. As each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database, all existing and future branch office SQL Server 2000 servers will require an OLE DB provider to access the company's mainframe. database.

Incorrect Answers:
A: The DTS package requires an OLE DB provider to access an OLE DB data source. It needs this provider to connect to the company's mainframe. database. Resetting the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database will not provide the DTS package with the required access to the mainframe. database.

B: A separate DTS package must be created for the Sydney branch office. This DTS package must extract data from the company's mainframe. computer that is relevant to the branch office in Sydney. The existing DTS package used to extract data from the company's mainframe. for the Los Angeles SQL Server 2000 server can be modified to serve the same function for the Sydney office.

D: Re-creating the DTS package on the SQL Server 2000 server in the branch office in Sydney is unnecessary the that SQL Server 2000 server would still require an OLE DB provider to access the company’s mainframe. database. It would require less administrative effort to modify the existing DTS package.

第9题：

DTS作为EMS的有机组成部分，与SCADA系统相连，以方便地使用电网实时数据和历史数据，不能作为独立系统存在。


正确答案:错误

第10题：

Torque引擎提供的ShowToolPro工具的功能包括（）

  • A、查看DTS模型
  • B、将MAX模型导出为DTS模型
  • C、查看DSQ动画效果
  • D、查看MAX模型

正确答案:A,C

更多相关问题
相关内容