Extractor， ID Resolver， XML Transformer， Mass Loader
ID Resolver， Text Transformer， Mass Loader
Text Transformer， XML Transformer， ID Resolver， Mass Loader
XML Transformer， ID Resolver， Mass Loader
XML Transformer， Mass Loader， ID Resolver
第1题：
You are the administrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit.
You need to import data into the database without adversely affecting database performance. The data will require an additional 2GB of storage space.
What should you do?
A．Add another data file on drive E, and then add the file to the PRIMARY filegroup.
B．Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option.
C．Rebuild all clustered indexes so that they have a fill factor of 100.
D．Compress drive D.
第2题：
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）
第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.
第4题：
Which WebSphere Commerce catalog management tool creates an XML file and DTD file from CSV formatted data？（）
第5题：
When a staging server is used as an environment for testing new data in a default WebSphere Commerce installation， which of the following are true about the staging server？（）
第6题：
In the event of a failure， what would be the MOST complete method for recovering the WebSphere Commerce database？（）
第7题：
WebSphere Commerce has been successfully installed and tested. WebSphere Commerce Analyzer has been installed and the extraction programs have run with no errors but there is no data in any reports when viewed from the WebSphere Commerce Accelerator. What could be the cause of this problem？（）
第8题：
You are the administrator of a SQL Server 2000 computer. You are creating a data transformation services package. As the first step in this process, you need to load data from text files into a database table. These text files contain data on new stores that join your franchise. The text files list the data columns in the following format StoreID, StoreName, Address, City, State, PostalCode, ManagerID, StoreTypeID, FacilityID.
The destination table is configured as shown in the exhibit.
You want to load the data into the table as quickly as possible. What should you do?
A．Use a Bulk Insert Task to read the data into a temporary table. Use an Execute SQL task to import the appropriate data into the destination table.
B．Create and edit a format file to select the columns you want to import. Use a Bulk Insert Task, and then specify the format file to import the appropriate data into the destination table.
C．Use a transform. data task to import the data. Use Microsoft ActiveX transformation scripts to write the appropriate data to the appropriate columns in the destination table.
D．Create and edit a format file to select the columns you want to import. Use a transform. data task, and then specify the format file to import the appropriate data into the destination table.
第9题：
Which WebSphere Commerce catalog management tool replaces symbols in an XML file with the appropriate numeric values for new or existing records in the WebSphere Commerce database？（）
第10题：
A product manager has prepared catalog data using a spreadsheet and has exported the data to a file in CSV format. What is the correct sequence to execute the Loader Package tools to import the data into the WebSphere Commerce database？（）