• Description:Microsoft SQL Server 2005 - Implementation
• Passing Score:0%
• Practice Test - Number of questions:98 questions
• Simulation Test - Number of questions:98 questions
• Simulation Test Duration:120 minutes
• Has explanations:Yes

You work as the database administrator at IT department .com. The IT department .com network consists of a single Active Directory domain named IT department .com. IT department .com hosts an online analytical processing (OLAP) system for a customer. The customer requested that IT department .com provide data transformation and load support. They prefer the data load to be schedules to occur at noon every day. You need to accommodate this customer. What should you do?

Answer(s)

1. Create an Integration Services package to provide data transformation and loadsupport.Run the package using the D T ExecUI command.
2. Create an Integration Services package to provide data transformation and loadsupport.Run the package using SQL Server Agent.
3. Create an Integration Services package to provide data transformation and loadsupport.Run the package using SQL Server Import and Export Wizard.
4. Create an Integration Services package to provide data transformation and loadsupport.Run the package using Business Intelligence Development Studio.

Create an Integration Services package to provide data transformation and loadsupport.Run the package using SQL Server Agent.