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

单选题What is a feature of the Integration Framework?（）A Allow bulk importing of XML or flat files. B Allow bulk importing from Excel spreadsheets.C Allow bulk importing from external/legacy system.D Allow bulk importing from one database platform to another

题目
单选题
What is a feature of the Integration Framework?（）
A

Allow bulk importing of XML or flat files. 

B

Allow bulk importing from Excel spreadsheets.

C

Allow bulk importing from external/legacy system.

D

Allow bulk importing from one database platform to another.

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

第1题：

When importing or exporting routing information using routing policy, the import or export is always done from which point of view?()

A. routing table

B. forwarding table

C. routing protocol

D. neighbor or peer


参考答案：A

第2题：

Cargoes that might leak from containers are known as ______．

A.Dirty cargoes

B.Caustic cargoes

C.Wet cargoes

D.Bulk cargoes


正确答案：C

第3题：

Importing and exporting is transferring goods from one country to another while _______ attention to the laws and requirements of bringing goods out or into that country.

A、to pay

B、paying

C、being paid


参考答案：B

第4题：

Which two statements are true about the Cisco Classic （CBAC） IOS Firewall set？（）

  • A、It can be used to block bulk encryption attacks
  • B、It can be used to protect against denial of service attacks
  • C、Traffic originating from the router is considered trusted， so it is not inspected
  • D、Based upon the custom firewall rules， an ACL entry is statically created and added to theexisting ACL permanently
  • E、Temporary ACL entries that allow selected traffic to pass are created and persist for theduration of the communication session

正确答案:B,E

第5题：

（）(散货) is carried on the bulk carrier.

  • A、Dangerous cargo
  • B、Dry cargo
  • C、Dry bulk cargo
  • D、Bulk cargo

正确答案:D

第6题：

You are the administrator of a new multiprocessor SQL Server 2000 computer. You are migrating data from other database management systems to this server. You need to load data from two data files into a new table on the server. The table is empty and has no indexes.

You want to complete the data load as quickly as possible. What should you do? (Each correct answer represents part of the solution. Choose all that apply.)

A．Apply a bulk update lock to the table.

B．Use separate client connections to load the files into the table simultaneously.

C．Create a clustered index on the table.

D．Specify the Full Recovery model for the database.

E．Specify the Bulk-Logged Recovery model for the database.


正确答案：ABE
解析：Explanation:
A: Bulk update locks are taken when bulk copying data into a table and either the TABLOCK hint is specified, or the table lock on bulk load table option is set using sp_tableoption. Bulk update locks allow processes to bulk copy data concurrently into the same table while preventing other processes that are not bulk copying data from accessing the table. In this scenario the bulk update lock would meet the requirement that data should be loaded as quickly as possible.

B: SQL Server 2000 allows data to be bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement. This can improve the performance of data load operations. To bulk copy data into an instance of SQL Server in parallel, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.

E: By specifying the Bulk-Logged Recovery model, the logging for all SELECT INTO, CREATE INDEX, and bulk loading data operations will be minimal and will therefore require less log space while also improving performance.

Incorrect Answers:
C: When data is bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement to improve the performance of data load operations, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.

D: When data is bulk copied into a single table from multiple clients in parallel using the bcp utility or BULK INSERT statement to improve the performance of data load operations, the database must be set to Bulk-Logged Recovery, the TABLOCK hint must be specified, and the table must not have any indexes.

第7题：

The international shore connection required on a ship is designed to ______．

A.Permit discharge of waste oil

B.Allow hook up of fire fighting water from a dock or another vessel

C.Satisfy pollution prevention requirements

D.Allow emergency use of the fire main for deballasting


正确答案：B

第8题：

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information:

BULK INSERT finance.dbo.customers

FROM ‘di\bulk\accts143_10141000.txt’

WITH DATAFILETYPE = ‘char’,

FIELD/TERMINATOR = ‘\t’,

ROWTERMINATOR = ‘\n,’

TABLOCK

You want to ensure that response times do not slow when new account information is added to the database. What should you do?

A．Drop the indexes for the customers table before the data load, and then re-create the indexes after the data load is complete.

B．Remove the TABLOCK option from the BULK INSERT statement.

C．Add the BATCHSIZE option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.

D．Add the ROWS_PER_BATCH option to the BULK INSERT statement and then set the option equal to 10 percent of the number of rows to be loaded.


正确答案：B
解析：Explanation: The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.

Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior. that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.

Incorrect Answers:
A: The recommendation to perform. the bulk copy operation with the indexes in place depends on the amount of data to be copied into the table compared to the amount of existing data already in the table. The large the amount of data to be loaded into a table, relative to the amount of data already in the table, the more efficient it is to drop all indexes on the table, perform. the bulk copy operation, and then re-create the indexes after the data is loaded

C: The BATCHSIZE option of the BULK INSERT statement is used to specify that SQL Server 2000 must treat each batch of rows inserted into the table as a separate transaction. This is useful when errors occur in the bulk copy operation, which would cause the transaction to be rolled back. By specifying the BATCHSIZE option, only the current transaction will be rolled back if an error occurs and the destination table still contains the other batches of rows that were successfully inserted.

D: The ROWS_PER_BATCH option of the BULK INSERT statement SQL Server can be used to
indicate the approximate number of rows in a batch. SQL Server 2000 then optimizes the load automatically, according to the batch size value, which may result in better performance. Although accuracy in the clause is not critical, the larger the batch size is, the better the performance of the bulk copy operation.

第9题：

（）must be kept away from dry cargo.

  • A、Light cargo
  • B、Wet cargo
  • C、Heavy cargo
  • D、Bulk cargo

正确答案:B

第10题：

What is the purpose of the cisco Vlan Trunking protocol?（）

  • A、to provide a mechanism to dynamically assign vlan membership to switch ports
  • B、to allow traffic to be carried from multiple vlans over a single link between switches
  • C、to allow native vlan information to be carried over a trunk link
  • D、to provide a mechanism to manually assign vlan membership to switch ports
  • E、to allow for managing the additions,deletions,and changes of vlans between switchs

正确答案:E

更多相关问题
相关内容