单选题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？（）AExtractor， ID Resolver， XML Transformer， Mass LoaderBID Resolver， Text Transformer， Mass LoaderCText Transformer， XML Transformer， ID Resolver， Mass LoaderDXML Transformer， ID Resolver， Mass LoaderEXML Transformer， Mass Loader， ID Resolver
单选题
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？（）
A
Extractor， ID Resolver， XML Transformer， Mass Loader
B
ID Resolver， Text Transformer， Mass Loader
C
Text Transformer， XML Transformer， ID Resolver， Mass Loader
D
XML Transformer， ID Resolver， Mass Loader
E
XML Transformer， Mass Loader， ID Resolver
参考解析
解析：
暂无解析
相关考题：
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.
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.
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.
In the event of a failure， what would be the MOST complete method for recovering the WebSphere Commerce database？（）A、Recreate the database from the staging server.B、Restore a database backup.C、Reload the data using Mass Loader.D、Republish the store archive.E、Republish from WebSphere Catalog Manager.
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?（）A、2, 4, 3B、1, 4, 3, 2C、2, 5, 4, 3, 6D、5, 2, 4, 3, 6E、1, 5, 4, 3, 6, 2
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？（）A、The WebSphere Commerce application server was not startedB、The web server was not startedC、SSL has not been configured on the web serverD、The appropriate listeners were not enabled in Configuration ManagerE、The database server was not started
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？（）A、The database has a subset of the tables in the production server database.B、The database has a copy of selected data from the production databaseC、The database logs changes for later propagation.D、The database is accessed as read-only to prevent data corruption.E、The database includes all user and order data for offline processing.
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？（）A、Data CheckerB、DTD GeneratorC、ID ResolverD、Mass LoaderE、XML Transformer
Which WebSphere Commerce catalog management tool creates an XML file and DTD file from CSV formatted data？（）A、DTD GeneratorB、ExtractorC、Mass LoaderD、Text TransformerE、XML Transformer
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？（）A、Extractor， ID Resolver， XML Transformer， Mass LoaderB、ID Resolver， Text Transformer， Mass LoaderC、Text Transformer， XML Transformer， ID Resolver， Mass LoaderD、XML Transformer， ID Resolver， Mass LoaderE、XML Transformer， Mass Loader， ID Resolver
In RMAN， when the RESYNC CATALOG command is issued， in which two situations does the command file actually perform synchronization？（）A、After the COPY command.B、After adding a data file in the target database.C、After adding a tablespace in the target database.D、After adding a tablespace in the catalog database.E、After dropping a data file in the catalog database.F、After running SQL Loader to load a large amount of data.
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？（）A、 2，4，3B、 1，4，3，2C、 2，5，4，3，6D、 5，2，4，3，6E、 1，5，4，3，6，2
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）A、use the external table populationB、use the Oracle Data Pump export and import utilityC、use the conventional path data load of SQL*Loader utilityD、use the direct path data load of Oracle export and import utility
The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this？（） A、 ownerB、 touserC、 attachD、 remap_schema
You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）A、Import the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.B、Import the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.C、Create a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.D、Create a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（） A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.
单选题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？（）AThe WebSphere Commerce application server was not startedBThe web server was not startedCSSL has not been configured on the web serverDThe appropriate listeners were not enabled in Configuration ManagerEThe database server was not started
多选题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？（）AThe database has a subset of the tables in the production server database.BThe database has a copy of selected data from the production databaseCThe database logs changes for later propagation.DThe database is accessed as read-only to prevent data corruption.EThe database includes all user and order data for offline processing.
单选题The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this？（）A ownerB touserC attachD remap_schema
单选题You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?（）ACreate the database by using a single data file and a single log file.BCreate the database by using a single data file and multiple log files.CCreate the database by using a single log file and multiple filegroups.DCreate the database by using a single log file and a filegroup that has multiple data files.
单选题While performing a regular check on your recovery catalog you realized that the catalog database is running out of space and you do not have options to increase the space. However, you have another database where more space is available and you want to move your existing recovery catalog to this database. The options that can be considered while moving the recovery catalog are as follows:（） 1. Using one of the Oracle expdp utilities to export the catalog data 2. Creating a recovery catalog user and granting the necessary privileges in the other database 3. Creating the recovery catalog using the CREATE CATALOG command 4. Using the corresponding impdp utility to import the catalog data into the other database 5. Registering the target database in the new catalog database using the REGISTER DATABASE command Identify the option with the correct sequence for moving the recovery catalog.A2, 3, 5B1, 2, 4C1, 2, 4, 5D1, 2, 3, 4, 5
单选题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?（）A2，4，3B1，4，3，2C2，5，4，3，6D5，2，4，3，6E1，5，4，3，6，2
单选题You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?（）AImport the data into a staging table by using the OPENROWSET BULK statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.BImport the data into a staging table by using the BULK INSERT statement. Execute a Transact-SQL stored procedure to cleanse the data and to insert the data into the database.CCreate a SQL Server Integration Services （SSIS） package to import， standardize， and cleanse the data.DCreate a CLR stored procedure to import the data into a staging table， to cleanse and standardize the data， and to insert the data into the database.
单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）Ause the external table populationBuse the Oracle Data Pump export and import utilityCuse the conventional path data load of SQL*Loader utilityDuse the direct path data load of Oracle export and import utility
单选题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?（）A2，4，3B1，4，3，2C2，5，4，3，6D5，2，4，3，6E1，5，4，3，6，2
单选题Which WebSphere Commerce catalog management tool creates an XML file and DTD file from CSV formatted data？（）ADTD GeneratorBExtractorCMass LoaderDText TransformerEXML Transformer
单选题In the event of a failure， what would be the MOST complete method for recovering the WebSphere Commerce database？（）ARecreate the database from the staging server.BRestore a database backup.CReload the data using Mass Loader.DRepublish the store archive.ERepublish from WebSphere Catalog Manager.