【导读】
不凡考网发布计算机2022历年考试试题试卷(3AA)相关信息，更多计算机2022历年考试试题试卷(3AA)的相关资讯请访问不凡考网计算机类考试频道。
1. [单选题]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.
A. You cancel the SQL Server upgrade wizard.
B. You need to ensure that the SQL Server 6.5 databases are listed in the wizard. What should you do?
C. Uninstall SQL Server 7.0, and then rerun the SQL Server upgrade wizard.
D. Run the Microsoft SQL Server-switch application, and then rerun the SQL Server upgrade wizard.
E. Create a data transformation services package that imports the databases from SQL Server 6.5 to SQL Server 2000, and then execute the package.
F. Uninstall SQL Server 2000, and then reinstall SQL Server 2000 as the default instance.
2. [单选题]You are the administrator of a Windows NT Server 4.0 computer named Ezonexam1. Ezonexam1 is a backup domain controller (BDC), and a member of Ezonexam.com's Windows 2000 Active Directory domain. Ezonexam1 contains five hard disks. Disk 0 and 1 are configured as a Windows NT 4.0 mirror set.The mirror set contains the operating system files and 500 MB of free disk space. Disk 2, 3 and 4 are configured as a Windows NT 4.0 stripe set with parity and contain employee data files. The Windows NT 4.0 stripe set with parity has a maximum capacity of 140 GB and contains 15 GB of free disk space.
A. Ezonexam1 runs an application that is used by 400 company employees. A new version of the application is available. You need to install the new version, but it requires Windows 2000 Server. Also, the application will not run on a domain controller.
B. You need to install the new application on Ezonexam1 as quickly as possible. What should you do first?
C. On Ezonexam1, back up the employee data files. Then format all five disks and perform. a clean installation of Windows 2000 Server. Restore the employee data files.
D. On Ezonexam1, install Windows 2000 Server. Configure Ezonexam1 to use a dual-boot configuration that includes Windows NT Server 4.0 and Windows 2000 Server.
E. Upgrade Ezonexam1 to Windows 2000 Server. During the upgrade, select the option to make Ezonexam1 a member server.
F. Upgrade Ezonexam1 to Windows 2000 Server. During the upgrade, select the option to make Ezonexam1 a domain controller. After the upgrade is complete, demote Ezonexam1.
3. [单选题]You are a database administrator in the Los Angeles branch office of a specialty foods supplier. A mainframe. database at the headquarters contains all company data. Each branch office contains a SQL Server 2000 computer that imports regional data from the mainframe. database.The server in Los Angeles contains a Data Transformation Services (DTS) package that uses OLE DB to connect to the company's mainframe. database. The DTS package extracts and transforms data about buyers and products for that region. The DTS package then writes the data to the SQL Server database in Los Angeles.
A. You need to configure a SQL Server computer for the new branch office in Sydney. You want to copy the Los Angeles package and modify it so that it writes data to the SQL Server database in Sydney.
B. You use the DTS Designer to modify the DTS package so that it imports regional data from the mainframe. database to the server in Sydney. The modified DTS package runs successfully on the server in Los Angeles. You save this DTS package to the server in Sydney, but the server in Sydney cannot connect to the mainframe. database.
C. You want to enable the server in Sydney to connect to the mainframe. database. What should you do?
D. Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.
E. Modify the workflow in the DTS package so that the server in Sydney is included.
F. On the server in Sydney, install an OLE DB provider for the mainframe. database.
G. On the server in Sydney, delete and then re-create the DTS package.
