You start the Setup program by starting the computer from the Windows 2000 Server CD-ROM.
However, you receive the following error message, "You chose to install Windows 2000 on a partition that contains another operating system. Installing Windows 2000 on this partition might cause the operating system to function improperly".
You are unable to perform. the upgrade. What should you do to resolve the problem?
A.Convert the system partition to NTFS.
B.Disable Advanced Configuration and Power Interface (ACPI) support for the computer.
C.Restart the computer, and then run Winnt32.exe from the Windows NT Server 4.0 environment.
D.Remove the Windows 2000 Server CD-ROM and restart the computer by using the setup floppy disks.
第1题
Exhibit:
UPDATE EzonexamConsolidated
SET District = ‘Mexico’
WHERE RtvID = 45
You work as database administrator at Ezonexam.com. You handle one SQL Server 2000 computer and one database.
When users run the query in the exhibit above the receive the following error message:
Server: Mrh3612, Level 16, Stats 1, Line 1
View or function ‘EzonexamConsolidated’ is not updateable because it
contains aggregates:
How should you enable the query to run?
A.Create a non-normalized EzonexamConsolidated table and populate the table with data from the base tables.
B.The appropriate users should be granted UPDATE permissions on each base table.
C.To enable updates on the composite tables create an INSTEAD OF trigger on the view.
D.On each base table add a cascading update trigger.
第2题
d hoc distribution queries against a database that is stored on a SQL Server 2000 computer named SQL2. SQL2 contains several databases, and each of these databases uses a different collation.
You want to ensure that comparisons in distributed queries are evaluated correctly. You also want to minimize administrative overhead.
How should you configure SQL1?
A.Use the ALTER DATABASE statement to change the collation of the databases on SQL1.
B.Add SQL2 as remote server.
C.Add SQL2 as a linked server. Select the Use Remote Collation check box, and do not specify a collation name.
D.Add SQL2 as a linked server. Select the Use Remote Collation check box, and specify a collation name. Repeat this process once for each database on SQL2.
第3题
istrative share on drive C of a server named AppSrv.
What can you do to map the drive?
A.Run thenet share C$=G:\command.
B.Run thenet use G: \\AppSrv\C$command.
C.Browse to AppSrv in Windows Explorer, and map drive G to the C$ share.
D.Browse to AppSrv in My Network Places, and map drive G to the C$ share.
第4题
med inventory. The database has a Parts table that has a field named InStock. When parts are shipped, a table named PartsShipped is updated. When Parts are received, a table names PartsReceived is updated. The relationship of these tables is shown in the exhibit.
You want the database to update the InStock field automatically. What should you do?
A.Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.
B.Create a user-defined function those calculations that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
C.Use a view that creates an InStock as a part of an aggregate query.
D.Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock fielding the parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables.
第5题
You are the network administrator for Ezonexam.
The network includes a Windows 2000 Server computer that contains a single 36-GB hard disk. The drive is configured as a basic disk and has two partitions. Partition C is 4 GB in size and contains the operating system files. Partition D is 32 GB in size and contains user data that is updated frequently.
Both partitions are formatted as NTFS. Both partitions are backed up to a tape every evening at 11:00 P.M.You have a current Emergency Repair Disk (ERD) for the computer, and Recovery Console is installed on the computer.
One day at2:00 P.M., the server fails. You attempt to restart the computer, but you receive the following error message: "Boot disk or operating system not found." You use Recovery Console to discover that the files on partition C are corrupted.
You want to recover the server from the failure as quickly as possible. You also want to recover as much user data as possible.
What should you do?
A.Start the computer by using a Windows 2000 Server compact disc. Select the Repair option in Setup.
B.Install a second hard disk in the computer. Install Windows 2000 Server on the new hard disk. Re-create the shared folders on the first hard disk.
C.Use a Windows 2000 Server boot floppy disk to start the computer. Replace the corrupted files on partition C by copying them from the Emergency Repair Disk.
D.Boot to the Recovery Console. Copy any files that have changed since 11:00 P.M. the previous evening to a second server. Use the most recent tape backup to restore the remaining user data to the second server.
第6题
You are the administrator of a new Microsoft Windows 2000 Server computer named CPSRV1.
CPSRV1 is a member server in your company's Windows NT 4.0 domain, which is named CPDOMAIN. A separate Windows NT domain named CPUSERS contains all of your company's user accounts. A trust relationship exists between the CPDOMAIN domain and the CPUSERS domain.
You are installing SQL Server 2000 on CPSRV1.
You specify a service account for each SQL Server service as shown in the following table:
After the installation is complete, the MSSQLServer service and the SQLServerAgent service do not start. You need to configure the services to start without changing any security settings in either domain.
What should you do?
A.Configure the services to run under the local system account
B.Add CPSRV1 to the CPUSERS domain
C.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the local administrators group on CPSRV1
D.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain Admins groups.
E.Add CPUSERS\sqlsvr and CPUSERS\sqlagent to the CPUSERS\Domain users groups.
第7题
ment. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.
You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.
You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.
What should you do?
A.Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.
B.Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.
C.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.
D.Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.
第8题
ed Ezonexam. The computers have different manufacturers and different hardware abstraction layers (HALs). You plan to use a Windows 2000 Server computer running Remote Installation Services (RIS) to perform. the installation.
After the installation is complete for the first 25 computers, users of those computers report problems. You discover that the latest Windows 2000 service pack resolves those problems.
You want to apply the service pack to the remaining 275 computers during the installation. What should you do?
A.Install the service pack on a reference Windows 2000 Professional computer, and then run the Riprep command on that computer. Use the resulting image for RIS.
B.Install the service pack on the RIS server, and then run the Riprep command on that server. Use the resulting image for RIS.
C.Copy the service pack to the CD-based image shared folder used by RIS.
D.Slipstream the service pack into a new i386 distribution shared folder, and then run the Risetup command to create a new CD-based image for the RIS server.
第9题
server, FLPSQL01, stores order data. You want to be able to use the other two servers, FLPSQL02 and FLPSQL03, to answer queries and run report. The planned network configuration is shown in the exhibit.
You want to use the database Maintenance Plan wizard to configure log shipping from FLPSQL01 to FLPSQL02 and FLPSQL03. You do not want users to add any new data on FLPSQL02 and FLPSQL03, but they must be able to run queries and reports.
Which two actions should you take? (Each correct answer presents part of the solution. Choose two)
A.Set the database load state for each destination server to No recovery mode.
B.Set the database load state for each destination server to standby mode.
C.Enable the allow database to assume primary role option for both destination servers.
D.Enable the allow database to assume primary role option for one destination server and then disable this option for other destination server.
E.Disable the allow database to assume primary role option for both destination servers.
为了保护您的账号安全,请在“上学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!