1、微软认证 70-228模拟试卷 3及答案与解析 1 You are the administrator of two Microsoft Windows 2000 advanced server computers. On these servers, you are configuring a database that will store accounting information for your company. The data must be available at all times. Interruptions in data connectivity should no
2、t last longer than five minutes. Any changes to the database should not require you to reconfigure the client computers. How should you configure the database? （ A） Configure the database on the two servers as a SQL Server 2000 cluster. （ B） Configure the database on one server, and then configure a
3、 standby database on the second server. （ C） Configure the database on each server. Use Microsoft Distributed Transaction Coordinator to keep the two servers perfectly synchronized. （ D） Configure the database as a federated database, and then partition half the data on each server. 2 You are the ad
4、ministrator of a SQL server 2000 computer that contains a database named Acct. The database contains 1.5 GB of data. The server has one 9-GB hard disk that is configured as shown in the Exhibit. You need to import data into the database without adversely affecting database performance. The data will
5、 require an additional 2GB of storage space.What should you do? （ A） Add another data file on drive E, and then add the file to the PRIMARY filegroup. （ B） Move the transaction log file to drive E, and set the file growth of Acc_Data.mdf by selecting the Unrestricted file growth option. （ C） Rebuild
6、 all clustered indexes so that they have a fill factor of 100. （ D） Compress drive D. 3 You are the administrator of a SQL Server 2000 computer. You create a Data Transformation Services (DTS) package. The package is stored as a local package on the server. The package exports data from an online tr
7、ansaction processing (OLTP) database system to an online analytical processing (OLAP) database system that is located on a second SQL Server 2000 computer. You want the package to execute automatically each evening at 8:00 P.M. What should you do? （ A） Use SQL Server Enterprise Manager to create a n
8、ew job Create a CmdExec job step that runs the dtsrun utility Schedule the job to run each night at 8:00 P.M. （ B） Use SQL Server Enterprise Manager to create a new job Create a Transact-SQL job step to query data from the OLTP database Create a second Transact-SQL job step to launch the DTS package
9、 Schedule the job to run each night at 8:00 P.M. （ C） Create a batch file that runs the dtsrun utility Use the Microsoft Windows Task Scheduler to run the job each night at 8:00 P.M. Configure the Windows Task Scheduler to use the local system account （ D） Move the DTS package to the repository Conf
10、igure the SQLServerAgent service on the OLAP database server to update the package each night at 8:00 P.M. 4 You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of Oracle relatio
11、nal database management system (RDBMS) server. This server is used to store your companys financial information. The financial information is updated frequently throughout the day. You need to create a series of reports that combine the service contract information and the financial information. The
12、se reports will be updated several times a day. You want to create reports on the SQL Server computer by using the minimum amount of disk space. What should you do? （ A） Set up SQL server replication to replicate the data from the oracle server to the SQL server computer. （ B） Set up the oracle serv
13、er as a linked server. Create a view that joins the service contract information and the financial information. （ C） Set up data transformation services (DTS) package that imports and transforms the database from the oracle server to the SQL server computer. Use SQL server agent to execute the DTS p
14、ackage throughout the day as needed. （ D） Set up Microsoft ActiveX script that connects to the oracle server and imports the financial information into SQL server temporary table. Create a view that joins the service contract information and the temporary table. 5 You are the administrator of a new
15、Microsoft Windows 2000 server computer named HQSQL5. HQSQL5 is a member server in your companys Windows NT 4.0 domain, which is named HQMAIN. After installing SQL Server 2000 on HQSQL5, you configure the MSSQLServer service account to use the HQMAINsqladmin user account, which is a member of the loc
16、al administrators group on HQSQL5. You can use the HQMAINsqladmin user account to log on the HQSQL5. However, the MSSQLServer service fails to start. You need to start the service. What should you do? （ A） Revoke Log on interactivity rights for the HQMAINsqladmin user account. （ B） Add the HQMAINsql
17、admin user account to the HQMAINDomain Admins group. （ C） Select the Password Never Expires check box for the HQMAINsqladmin user account. （ D） Grant Log on as a service rights to the HQMAINsqladmin user account. 6 You are the administrator of a SQL Server 2000 computer. You want to set up snapshot
18、replication on the server. The server will serve as Publisher and Distributor for a minimum of 40 Subscribers. Currently, you want to publish 3GB of data, but the data is expected to grow over time. Subscribers will receive a new snapshot each month. You want to minimize the workload on the Publishe
19、r/Distributor. Which two actions should you take to configure snapshot replication? (Each correct answer presents part of the solution. Choose two) （ A） Store the snapshot in the default folder on the Publisher/Distributor. （ B） Store the snapshot in an alternative folder on the Publisher/Distributo
20、r. （ C） Store the snapshot in a shared folder on a file server. （ D） Create pull subscriptions. （ E） Create push subscriptions. 7 You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. In this database, the Parts table has a primary key that is used
21、to identify each part stored in the companys warehouse. Each part has a unique UPC code that your companys accounting department uses to identify it. The database is configured as shown in the exhibit.You want to maintain the referential integrity between the Parts table and the OrderDetails table.
22、You want to minimize the amount of physical I/O that is used within the database.Which two Transact-SQL statements should you execute? (Each correct answer represents part of the solution. Choose two.)A. CREATE UNIQUE INDEX IX_UPC On Parts(UPC)B. CREATE UNIQUE INDEX IX_UPC On OrderDetails(UPC)C. CRE
23、ATE TRIGGER UPCRI On OrderDetails FOR INSERT, UPDATE As If Not Exists (Select UPC From Parts Where Parts.UPC = inserted.UPC) BEGIN ROLLBACK TRAN ENDD. CREATE TRIGGER UPCRI On Parts FOR INSERT, UPDATE As If Not Exists (Select UPC From Parts Where OrderDetails.UPC = inserted.UPC) BEGIN ROLLBACK TRAN E
24、NDE. ALTER TABLE dbo.OrderDetails ADD CONSTRAINT FK_OrderDetails_Parts FOREIGN KEY(UPC) REFERENCES dbo.Parts(UPC)F. ALTER TABLE dbo.Parts ADD CONSTRAINT FK_Parts_OrderDetails FOREIGN KEY (UPC) REFERENCES dbo.Parts(UPC) 微软认证 70-228模拟试卷 3答案与解析 1 【正确答案】 A 【试题解析】 Explanation: SQL Server 2000 failover cl
25、ustering provides high availability support by allowing us to configure one failover cluster to automatically, with no manual configuration, fail over to any other node in the failover cluster configuration. In this way, we minimize system downtime and provide high server availability during an oper
26、ating system failure or a planned upgrade. Before SQL Server 2000 failover clustering can be set up, we must install Windows NT 4.0, Enterprise Edition, Windows 2000 Advanced Server or Windows 2000 Datacenter Server, and the Microsoft Cluster Service (MSCS). In this scenario a cluster would be prefe
27、rred to a standby server because it would be available immediately. A standby server on the other would require manual configuration and more time to become online. Incorrect Answers: B: A standby server would require you to reconfigure clients to allow it to connect to the standby server when the m
28、ain server goes down. It would require at least several minutes of manual administration before the standby server would be operational. But the scenario requires that no reconfiguration of the client computers should be necessary. Therefore we should use a SQL Server 2000 cluster not a standby serv
29、er. Note: A standby server is a second server that contains a copy of the databases on the primary server and that can be brought online in the event of a primary server failure or due to scheduled maintenance on the primary server. This allows users to continue working with databases when the prima
30、ry server becomes unavailable. When the primary server becomes available again, any changes to the standby servers copies of databases must be restored back to the primary server. C: The Microsoft Distributed Transaction Coordinator coordinates distributed transactions, but would not increase availa
31、bility. Note: The Microsoft Distributed Transaction Coordinator (MS DTC) is a transaction manager that allows client applications to include several different sources of data in one transaction. MS DTC coordinates committing the distributed transaction across all the servers enlisted in the transact
32、ion. An installation of SQL Server 2000 can participate in a distributed transaction by calling stored procedures on remote servers running SQL Server, automatically or explicitly promoting the local transaction to a distributed transaction and enlist remote servers in the transaction, and making di
33、stributed updates that update data on multiple OLE DB data sources. If these OLE DB data sources support the OLE DB distributed transaction interface, SQL Server 2000 can also enlist them in the distributed transaction. The MS DTC service coordinates the proper completion of the distributed transact
34、ion to ensure that either all of the updates on all the servers are made permanent, or, in the case of errors, all erased. D: With Federated SQL Server 2000 servers, SQL Server 2000 databases can be spread across a group of autonomous database servers. These are capable of supporting the processing
35、growth requirements of the largest Web sites and enterprise data-processing systems built with Microsoft Windows DNA, which divides the processing units of a data processing system into logical tiers. This however does not improve availability. 2 【正确答案】 A 【试题解析】 Explanation: We must take precautions
36、 so that the import process of 2 GB data will run. We add a new file to drive E, which has 3 GB free disk space. By placing the new file in the primary file group we ensure that new data added to the database will be added to new data file. The primary file group is the default file group and new da
37、ta is automatically added to it. Incorrect Answers: B: Moving the transaction log from Drive D to Drive would free up 800MB. This would leave 1.3GB of free disk space on drive D. But the import process will require another 2GB so we will not have enough free disk space. C: Rebuilding the clustered i
38、ndexes with a fill factor of 100 makes that the index pages full. This would degrade performance during the import process due to page splits. D: Compressing a partition which is used by SQL Server is not a good idea. It would, if at all possible, degrade performance. 3 【正确答案】 A 【试题解析】 Explanation:
39、Transfers can be defined and stored in a DTS package, which can then be run from a command line using the dtsrun utility (DTSRUN.EXE). CmdExec job steps are operating system commands or executable programs ending with .bat, .cmd, .com, or .exe. In this scenario we create a job consisting of a single
40、 cmdexec job step which runs the DTS package using the dtsrun utility. Incorrect answers: B: Only one job, not two, has to be created at the OLTP database server. C: If the Task Scheduler is running as the local system account it wouldnt be able to access the remote OLAP database server. D: The DTS
41、export package should be run at the OLTP database server, not at the OLAP database server. The DTS package is exported from the OLTP server to the OLAP server. 4 【正确答案】 B 【试题解析】 Explanation: SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to
42、an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements. Each distributed query can reference multiple linked se
43、rvers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to
44、query data in Oracle databases. Incorrect Answers: A: Replication allows for the coping, distribution, and modification of data across an enterprise. This involves the copying of database data from one server to another. This is not the best solution in this scenario as this will require frequent re
45、plication because the reports must be updated several times a day. C: Data Transformation Services is a set of graphical tools and programmable objects that allows for the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scena
46、rio, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate. D: Microsoft ActiveX scripts can be used to add functionality to Data Transformation Services packages, which is a set of graphical tools and programmable objects that allows for
47、 the extraction, transformation, and consolidation of data from disparate sources into single or multiple destinations. In this scenario, however, the Oracle database needs to be included in a query. Hence, Data Transformation Services are inappropriate. 5 【正确答案】 D 【试题解析】 Explanation: On Windows NT
48、and Windows 2000 operating systems, SQL Server 2000 and SQL Server Agent are started and run as Windows services. Windows services require Log on as a service rights, which allow a security principal to log on as a service, as a way of establishing a security context. The Local System account on the
49、 Windows computer always retains the right to log on as a service. Any service that runs under a separate account must be granted this right. Incorrect Answers: A: The log on interactively should only be applied to user accounts that runs services. Revoking it for the HQMAINsqladmin would make the MSSQLServer service to start. B: The Domain Admins global group can represent the users who have broad administrative rights in a domain. Windows 2000 Server places all users with an Administrator account into this group automatically. This group is responsible for administration and
