• Description: Designing and Implementing Solutions with Microsoft Commerce Server 2000
• Passing Score: 75%
• Practice Test - Number of questions: 74 questions
• Simulation Test - Number of questions: 74 questions
• Simulation Test Duration: 90 minutes
• Has explanations: No

You are designing the content deployment strategy for a Commerce Server site. You create custom dynamic reports. After these reports are tested in the test environment, they will be deployed to the production environment. You want to automate the deployment process, and you want to minimize custom programming and configuration. How should you deploy the dynamic reports?

Answer(s)

1. Use Commerce Server Site Packager to package and unpack the site. Write a custom script toautomatically run Site Packager.
2. Use Commerce Server Site Packager to move the CSReports.sql file from the testenvironment to the production environment on a scheduled basis.
3. Use a custom Data Transformation Services (DTS) task to export new or modified records inthe Report table of the Data Warehouse from the test environment to the productionenvironment on a scheduled basis.
4. Use Microsoft SQL Server snapshot replication to synchronize the Report table of the DataWarehouse in the test environment and in the production environment.

Use a custom Data Transformation Services (DTS) task to export new or modified records inthe Report table of the Data Warehouse from the test environment to the productionenvironment on a scheduled basis.