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, 

题目

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. 
参考答案和解析
正确答案:D
如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You work in a company which is named Wiikigo Corp. The company 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 SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requirement, you must make sure that suspect pages can be detected in the database. So what action should you perform to achieve this goal?()

  • A、For the database, you should turn on the TRUSTWORTHY database option
  • B、For the database, the PAGE_VERIFY database option should be set to CHECKSUM
  • C、For the database, the database compatibility level option should be set to 10
  • D、For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION. 

正确答案:B

第2题:

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; 

正确答案:D

第3题:

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

正确答案:C

第4题:

You work in a company which is named Wiikigo Corp. The company 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 Dworks in the instance. You are log shipping the Adventureworks database to a remote SQL Server 2008 instance. The primary SQL Server instance required a restart during the weekend. But you notice that log shipping has stopped working after the weekend. You have to check log shipping of the Adventureworks database and find out the problem. What should you do? () 

  • A、You should use the EXTENDED_LOGICAL_CHECKS option to execute a DBCC CHECKDB statement on the AdventureWorks database by. 
  • B、You should identify whether the SQL Server Agent is started on the primary server. 
  • C、You should identify whether the AdventureWorks database uses the Simple recovery model. 
  • D、You should identify whether the SQL Server Volume Shadow Copy Service (VSS) Writer is started on the primary server

正确答案:B

第5题:

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;

正确答案:B

第6题:

You work in a company which is named Wiikigo Corp. The company 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. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all the user databases every day. Every quarter the transaction log backup is performed. Every 4 hours a differential backup is occurred. You are going to perform a full backup of DB1 at 11:00. When you perform this back up, you must make sure that the overall backup will not be affected. What';s more, you have to restore procedures for DB1. You must make sure that the backup files are restored in proper sequence.  In the options below, which Transact-SQL statement should you use?()

  • A、BACKUP LOG DB1 TO DISK = 't:/backups/db1.trn'; 
  • B、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH DIFFERENTIAL; 
  • C、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH NOUNLOAD; 
  • D、BACKUP DATABASE DB1 TO DISK = 't:/backups/db1.bak' WITH COPY_ONLY; 

正确答案:D

第7题:

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 inthe instance. You have set the recovery model of DB1 to Full. You deploy a new process. The process modifies 10,000 records from the Accounts table at 18:00 every day. Any modification made by the process to the data must be reverted and database keeps online. You must make sure of this. So which strategy should you implement?()  

  • A、You should implement Differential backup 
  • B、You should implement Database snapshots
  • C、You should implement Primary filegroup backup 
  • D、You should implement Transaction log backup

正确答案:B

第8题:

You work in a company which is named Wiikigo Corp. The company 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 Dworks in the instance. Now you get a report from users saying that DB1 meets deadlock problems. As the technical support, you have to capture the deadlock information to the SQL Server error log. What should you do?()  

  • A、For the AdventureWorks database, enable Server Auditing 
  • B、First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance 
  • C、You should configure the data collector and make it capture the deadlock graphs
  • D、You should configure a SQL Profiler trace, and make it capture the deadlock graphs

正确答案:B

第9题:

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 named Dworks in the instance. The Dworks database has a table named Bills which contains several indexes and a great amount of rows. An enterprise Web environment is supported by the database. Onthe Bills table 28% of the indexes have been fragmented. You have to defragment the indexes, making sure that you reduce the effect on database availability to the least.  In the ALTER INDEX statement, which option should be included?()

  • A、Sort in tempdb 
  • B、Online 
  • C、Fill factor 
  • D、Pad index 

正确答案:B

第10题:

You work in a company which is named Wiikigo Corp. The company 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. In the database, a small percentage of data is modified everyday. Ever day in the morning, you have to create a read-only copy of the database for reporting purposes and make sure that you use as little disk space as possible.  In the options below, which strategy should you use? () 

  • A、You should use database snapshots 
  • B、You should use database backup and restore 
  • C、You should use database backup and restore along with compression 
  • D、You should use schema-bound views in a read-only database. The database resides on the same instance.

正确答案:A

更多相关问题