微软认证70-228模拟试卷9
-
You are the administrator of a SQL Server 2000 database named Articles. A large city newspaper uses this database to store its archived newspaper articles. Journalists query the database as part of their research. You have created full-text indexes so that users can query the articles quickly.
- A hardware failure forces you to restore the entire database from backup. After you restore the database, the journalists report that they can no longer run queries without receiving errors. You want to ensure that the journalists c
- A．Create a new full-text catalog for the Articles database
- B．Rebuild the full-text catalog for the Articles database
- C．Create a new full-text index on the table that holds the text for the articles
- D．Repopulate the full-text index on the table that holds the text for the articles
-
You are the administrator of a SQL Server 2000 computer. The server contains a database named Sales. You perform. full database backups every two days. You also run regular database consistency checks on the server. The most recent check of the Sales database returns the following message.
“CHECKDB found 0 allocation errors and 9 consistency errors in the table 'Orders' (object ID 214575782).”
You want to correct the data integrity errors while minimizing the amount of data lost. What should you do?
- A．Disconnect users from the Sales database. Enable the single user database option. Execute the DBCC CHECKTABLE statement for the Orders table, and specify the REPAIR_REBUILD option.
- B．Disconnect users from the Sales database. Enable the DBO use only database option. Execute the DBCC CHECKTABLE statement for the Orders table, and specify the REPAIR_REBUILD option.
- C．Disconnect users from the Sales database. Execute the RESTORE DATABASE statement for the Sales database
- D．Execute the DBCC CLEANTABLE statement for the Orders table.
- E．Execute the sp_table_validation stored procedure for the Orders table.
-
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.
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.
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.
You want to enable the server in Sydney to connect to the mainframe. database. What should you do?
- A．Change the connection properties in the DTS package so that the package uses new login credentials to connect to the mainframe. database.
- B．Modify the workflow in the DTS package so that the server in Sydney is included.
- C．On the server in Sydney, install an OLE DB provider for the mainframe. database.
- D．On the server in Sydney, delete and then re-create the DTS package.
-
You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. Users report that several storage locations in the UnitsStored field contain negative numbers. You examine the database's table structure. The table properties are configured as shown in the exhibit.
You correct all the negative numbers in the table. You must prevent the database from storing negative numbers. You also want to minimize use of server resources and physical I/O.
Which transact-SQL statement should you execute?
- A．ALTER TABLE dbo.storagelocations ADD CONSTRAINTS CK_storagelocations_UnitsStored CHECK (UnitsStored>= 0)
- B．CREATE TRIGGER CK_UnitsStored On StorageLocations FOR INSERT, UPDATE AS IF INSERTED, UnitsStored< 0 ROLLBACK TRAN
- C．CREATE TABLE ck_unitsstored As @Units >= 0 GO Sp_bindrule ‘OK_UnitsStored’, ‘StorageLocations, UnitsStored’ GO
- D．CREATE PROC UpdateUnitsStored (StorageLocationID int, @UnitsStored bigint)AS IF @UnitsStored< 0 DATSERROR (50099, 17) ELSE UPDATE storaheLocations SET UnitsStored = @UnitsStored WHERE StorageLocationID = @storageLocationID
2017年微软认证网络工程师模拟试题
2017年微软认证网络工程师模拟试题
2017年微软认证网络工程师模拟试题
微软认证70-210模拟试卷6
微软认证70-210模拟试卷2
微软认证70-210模拟试卷7
微软认证70-210模拟试卷1
微软认证70-210模拟试卷5
微软认证70-210模拟试卷3
微软认证70-210模拟试卷8