单选题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， I

题目
单选题
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

相似考题

1.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.

2.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.

3.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.

4.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.

更多“单选题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， I”相关问题

  • 第1题：

    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, 3
    • B、1, 4, 3, 2
    • C、2, 5, 4, 3, 6
    • D、5, 2, 4, 3, 6
    • E、1, 5, 4, 3, 6, 2

    正确答案:E

  • 第2题：

    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 database
    • C、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.

    正确答案:B,C

  • 第3题：

    Which WebSphere Commerce catalog management tool creates an XML file and DTD file from CSV formatted data？（）

    • A、DTD Generator
    • B、Extractor
    • C、Mass Loader
    • D、Text Transformer
    • E、XML Transformer

    正确答案:D

  • 第4题：

    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.

    正确答案:B,C

  • 第5题：

    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 population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第6题：

    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.

    正确答案:C

  • 第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？（）
    A

    The WebSphere Commerce application server was not started

    B

    The web server was not started

    C

    SSL has not been configured on the web server

    D

    The appropriate listeners were not enabled in Configuration Manager

    E

    The database server was not started


    正确答案： B
    解析： 暂无解析

  • 第8题：

    单选题
    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

     owner

    B

     touser

    C

     attach

    D

     remap_schema


    正确答案： D
    解析： 暂无解析

  • 第9题：

    单选题
    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.
    A

    2, 3, 5

    B

    1, 2, 4

    C

    1, 2, 4, 5

    D

    1, 2, 3, 4, 5


    正确答案： B
    解析： 暂无解析

  • 第10题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第11题：

    单选题
    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，3

    B

    1，4，3，2

    C

    2，5，4，3，6

    D

    5，2，4，3，6

    E

    1，5，4，3，6，2


    正确答案： E
    解析： 暂无解析

  • 第12题：

    单选题
    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.


    正确答案： E
    解析： 暂无解析

  • 第13题：

    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 started
    • B、The web server was not started
    • C、SSL has not been configured on the web server
    • D、The appropriate listeners were not enabled in Configuration Manager
    • E、The database server was not started

    正确答案:D

  • 第14题：

    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 Checker
    • B、DTD Generator
    • C、ID Resolver
    • D、Mass Loader
    • E、XML Transformer

    正确答案:C

  • 第15题：

    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

    正确答案:C

  • 第16题：

    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，3
    • B、 1，4，3，2
    • C、 2，5，4，3，6
    • D、 5，2，4，3，6
    • E、 1，5，4，3，6，2

    正确答案:E

  • 第17题：

    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、 owner
    • B、 touser
    • C、 attach
    • D、 remap_schema

    正确答案:D

  • 第18题：

    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.

    正确答案:C

  • 第19题：

    多选题
    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 database

    C

    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.


    正确答案： A,C
    解析： 暂无解析

  • 第20题：

    单选题
    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.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    单选题
    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，3

    B

    1，4，3，2

    C

    2，5，4，3，6

    D

    5，2，4，3，6

    E

    1，5，4，3，6，2


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    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 population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    Which WebSphere Commerce catalog management tool creates an XML file and DTD file from CSV formatted data？（）
    A

    DTD Generator

    B

    Extractor

    C

    Mass Loader

    D

    Text Transformer

    E

    XML Transformer


    正确答案： C
    解析： 暂无解析

相关内容