nerdexam
Microsoft

70-282 · Question #369

You work as the network administrator at certways.com. The certways.com network consists of a single Active Directory domain named certways.com. Your duties at certways.com include the installation…

The correct answer is C. Migrate the Microsoft Access database to SQL Server 2005 using the Microsoft SQL Server. See the full explanation below for the reasoning.

Question

You work as the network administrator at certways.com. The certways.com network consists of a single Active Directory domain named certways.com. Your duties at certways.com include the installation and configuration of Windows Small Business Server 2003. At present Active Directory is configured on a server named SR01. The certways.com network consists of 30 Windows XP Professional computers. SR01 is configured to run Windows Small Business Server 2003, Standard Edition and also runs Microsoft Access 97 to support an e-commerce database for certways.com customers. The certways.com customer numbers are growing at an escalating rate and the certways.com management consequently has some concerns regarding the customer database management system. Performance of the database is bound to become problematic and thus the database should be upgraded to SQL server. certways.com management then made a proposal stating that either a new Windows Server 2003 computer be added and configured with SQL Server 2005 or that the SR01 Microsoft Access 97 be upgraded to SQL Server 2000 Service Pack 3a (SP3a) in addition to upgrading to the Premium edition of Microsoft Windows Small Business server 2003. Consequently a decision was taken to add a new Windows Server 2003 computer and configure SQL Server 2005 on it. Now you need to move the existing Microsoft Access database to SQL Server 2005. What should you do?

Options

  • AMigrate the Microsoft Access database to SQL Server 2005 using the PFMigrate Tool.
  • BMigrate the Microsoft Access database to SQL Server 2005 using the SQL Server import and Export
  • CMigrate the Microsoft Access database to SQL Server 2005 using the Microsoft SQL Server
  • DMigrate the Microsoft Access database to SQL Server 2005 using the Active Directory Migration

How the community answered

(29 responses)
  • A
    14% (4)
  • B
    3% (1)
  • C
    79% (23)
  • D
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 70-282 Practice