Готовлюсь в экзамену 228. Имею две версии тесткинга - пораньше и попозже. И вижу такую картину - вопрос один и тот же, варианты ответа одни и те же, но правильный ответ другой и объяснения логичные. Кому верить? Помогите разобраться, а?
1.
2.
3.
4.
5.
6.
You are the administrator of a SQL server computer. The server is running SQL Server 6 . 5 and SQL Server 7 . 0 . You install a named instance of SQL Server 2000 , and then run the SQL server upgrade wizard. On the database selection screen, some of the SQL Server 6 . 5 databases are not listed. You cancel the SQL Server upgrade wizard. You need to ensure that the SQL Server 6 . 5 databases are listed in the wizard. What should you do?
A. Uninstall SQL Server 7 . 0 , and then rerun the SQL Server upgrade wizard.
B. Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
C. Create a data transformation services package that imports the databases from SQL Server 6 . 5 to SQL Server
2000 , and then execute the package.
D. Uninstall SQL Server 2000 , and then reinstall SQL Server 2000 as the default instance.
В более ранней версии тесткинга:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
Ответ D
Объяснение:
Explanation: To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server 2000 installed on your computer.
References:
BOL: Working with Instances and Versions of SQL Server
BOL: Upgrading Databases from SQL Server 6 . 5 (Upgrade Wizard)
Incorrect Answers:
A: It is not necessary to uninstall SQL Server 7 . 0 . Just install SQL Server 2000 as the default instance.
We cannot run the SQL Server upgrade wizard unless SQL Server 2000 is installed.
B: To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server 2000 installed on your computer.
C: We want to ensure that the SQL Server 6 . 5 databases are listed in the SQL Server 2000 installation wizard. To create DTS transformation packages that upgrade SQL Server 6 . 5 databasees to SQL Server 2000 databases we must install SQL Server 2000 first.
в более поздней версии тесткинга:
1.
2.
3.
4.
5.
6.
Ответ B.
Объяснение:
Explanation: We want to see the SQL Server 6 . 5 databases when we run the SQL Server upgrade wizard. Wemust use version switching and switch from SQL 2000 / 7 . 0 to SQL Server 6 . 5 before we start the SQL Server upgrade wizard. Note: SQL Server 2000 can be installed on the same computer with Microsoft SQL Server version 6 . 5 , but only one version can be active at one time. To perform a version upgrade of SQL Server 6 . 5 to SQL Server 2000 , you must run the SQL Server Upgrade Wizard from a computer on which you have installed SQL Server 2000 . To run the SQL Server Upgrade Wizard, you must have a default instance of Microsoft SQL Server 2000 installed on your computer. References: BOL: Working with Instances and Versions of SQL Server BOL: Upgrading Databases from SQL Server 6 . 5 (Upgrade Wizard)
Incorrect Answers:
A: It is not necessary to uninstall SQL Server 7 . 0 . Just install SQL Server 2000 as the default instance. We cannot run the SQL Server upgrade wizard unless SQL Server 2000 is installed.
C: We want to ensure that the SQL Server 6 . 5 databases are listed in the SQL Server 2000 installation wizard. To create DTS transformation packages that upgrade SQL Server 6 . 5 databases to SQL Server 2000 databases we must install SQL Server 2000 first.
D: We must switch version to SQL Server 6 . 5 before we start the SQL Server upgrade wizard.
