為大家收集整理了《微軟認(rèn)證考試70432練習(xí)試題10》供大家參考，希望對(duì)大家有所幫助?。?！
QUESTION 46
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the
database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to
the least. So what action should you perform to achieve this goal?
A.You should restore the full backup
B.You should restore the database snapshot from 16:30 hours.
C.You should restore the database snapshot from 17:30 hours
D.You should restore both the full backup and the differential backup.
Answer: D
QUESTION 47
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. There are data file and the transaction log file on the E: drive. Now you find that There isonly 6% spare space. Both files have to be moved to the V: drive. Which procedure should you
use?
A.You should run the following Transact-SQL statement. ALTER DATABASE DB1 SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and transaction log file to the new
location.Run the following Transact-SQL statements. ALTER DATABASE DB1 MODIFY FILE(NAME = DB1_Data, FILENAME = 'v:\SQLServer\DB1_Data.mdf'); ALTER DATABASE DB1 SET
MULTI_USER;
B.You should terminate the SQL Server Service. Then move the data file and transaction log file to the new location. Start the SQL Server service. Run the following Transact-SQL statement.
EXEC sp_attach_DB @DBname = N'DB1',@filename1 = N'v:\SQLServer\DB1_Data.mdf',@filename2 = N'v:\SQLServer\DB1_Log.ldf';
C.You should run the following Transact-SQL statement. ALTER DATABASE DB1 SET OFFLINE WITH ROLLBACK_IMMEDIATE; Move the data file and transaction log file to the new
location.Run the following Transact-SQL statements. ALTER DATABASE DB1 MODIFY FILE(NAME = DB1_Data, FILENAME = 'v:\SQLServer\DB1_Data.mdf'); ALTER DATABASE DB1
MODIFY FILE(NAME = DB1_Log, FILENAME = 'v:\SQLServer\DB1_Log.ldf'); ALTER DATABASE DB1 SET ONLINE;
D.You should terminate the SQL Server service. Then move the data file to the new location. Start the SQL Server service. Run the following Transact-SQL statement. EXEC
sp_attach_single_file_DB @DBname = N'DB1',@physname = N'v:\SQLServer\DB1_Data.mdf';
Answer: C
QUESTION 48
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a
database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1. In the options below, which Transact-SQL
statement should you use?
A.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak';
B.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION;
C.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL;
D.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION, DIFFERENTIAL;
Answer: B
QUESTION 49
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the
appropriate permissions to the user. So which database permission should you give the user?
A.DELETE
B.CONTROL
C.DROP DATABASE
D.ALTER ANY DATASPACE
Answer: C
QUESTION 50
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. TheDB1 database includes spatial data types. On DB1 databse, you have to perform a database consistency check to include the spatial indexes. Besides this, you must make sure that
you can reduce the effect on the database concurrency to the least. So which Transact-SQL statement should you run?
A.DBCC CHECKCATALOG (DB1);
B.DBCC CHECKALLOC (DB1) WITH TABLOCK;
C.DBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY;
D.DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS;
Answer: D
QUESTION 46
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, and database snapshots were created at 16:30 and at 17:30. The backups and the
database snapshots are stored on a different disk from the database files. At 17:05, the hard disk containing the database files fails at 17:02 hours. You must restore DB1 while reduce data loss to
the least. So what action should you perform to achieve this goal?
A.You should restore the full backup
B.You should restore the database snapshot from 16:30 hours.
C.You should restore the database snapshot from 17:30 hours
D.You should restore both the full backup and the differential backup.
Answer: D
QUESTION 47
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. There are data file and the transaction log file on the E: drive. Now you find that There isonly 6% spare space. Both files have to be moved to the V: drive. Which procedure should you
use?
A.You should run the following Transact-SQL statement. ALTER DATABASE DB1 SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and transaction log file to the new
location.Run the following Transact-SQL statements. ALTER DATABASE DB1 MODIFY FILE(NAME = DB1_Data, FILENAME = 'v:\SQLServer\DB1_Data.mdf'); ALTER DATABASE DB1 SET
MULTI_USER;
B.You should terminate the SQL Server Service. Then move the data file and transaction log file to the new location. Start the SQL Server service. Run the following Transact-SQL statement.
EXEC sp_attach_DB @DBname = N'DB1',@filename1 = N'v:\SQLServer\DB1_Data.mdf',@filename2 = N'v:\SQLServer\DB1_Log.ldf';
C.You should run the following Transact-SQL statement. ALTER DATABASE DB1 SET OFFLINE WITH ROLLBACK_IMMEDIATE; Move the data file and transaction log file to the new
location.Run the following Transact-SQL statements. ALTER DATABASE DB1 MODIFY FILE(NAME = DB1_Data, FILENAME = 'v:\SQLServer\DB1_Data.mdf'); ALTER DATABASE DB1
MODIFY FILE(NAME = DB1_Log, FILENAME = 'v:\SQLServer\DB1_Log.ldf'); ALTER DATABASE DB1 SET ONLINE;
D.You should terminate the SQL Server service. Then move the data file to the new location. Start the SQL Server service. Run the following Transact-SQL statement. EXEC
sp_attach_single_file_DB @DBname = N'DB1',@physname = N'v:\SQLServer\DB1_Data.mdf';
Answer: C
QUESTION 48
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 Enterprise Edition instance. There is a
database named DB1 in the instance. A backup of DB1 is performed every day. You have to minimize the size of the full database backup files of DB1. In the options below, which Transact-SQL
statement should you use?
A.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak';
B.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION;
C.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH DIFFERENTIAL;
D.BACKUP DATABASE DB1 TO DISK = 't:\backups\db1.bak' WITH COMPRESSION, DIFFERENTIAL;
Answer: B
QUESTION 49
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. When you are absent, a user will use a login named Mary to log in and maintain the database snapshots. The user has to delete the database snapshots for DB1, so you have to give the
appropriate permissions to the user. So which database permission should you give the user?
A.DELETE
B.CONTROL
C.DROP DATABASE
D.ALTER ANY DATASPACE
Answer: C
QUESTION 50
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a database named DB1 in
the instance. TheDB1 database includes spatial data types. On DB1 databse, you have to perform a database consistency check to include the spatial indexes. Besides this, you must make sure that
you can reduce the effect on the database concurrency to the least. So which Transact-SQL statement should you run?
A.DBCC CHECKCATALOG (DB1);
B.DBCC CHECKALLOC (DB1) WITH TABLOCK;
C.DBCC CHECKDB (DB1) WITH TABLOCK, PHYSICAL_ONLY;
D.DBCC CHECKDB (DB1) WITH EXTENDED_LOGICAL_CHECKS;
Answer: D