Microsoft
70-432 · Question #136
Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not installed Microsoft Business Intelligence Development Studio (BIDS). You should design a package, which has the…
The correct answer is C. You should create the package by using the Microsoft SQL Server Import and Export Wizard. See the full explanation below for the reasoning.
Question
Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not installed Microsoft Business Intelligence Development Studio (BIDS). You should design a package, which has the following features:
- The package should be transactional.
- The package should be optimized for 10 tables.
- The package should be stored safely in the msdb database of a server
which is remote. Which is correct?
Options
- AYou should create the package by using DTS Designer.
- BYou should create the package by using the Package Migration Wizard.
- CYou should create the package by using the Microsoft SQL Server Import and Export Wizard.
- DOn the Microsoft SQL Server 2005 Integration Services (SSIS) menu,
How the community answered
(45 responses)- A13% (6)
- B2% (1)
- C78% (35)
- D7% (3)
Community Discussion
No community discussion yet for this question.