A.You should allow failback only during non-business hours
B.You should immediately allow failback
C.You should prevent automatic failback
D.You should allow failback only during business hours
您可能感兴趣的试卷
你可能感兴趣的试题
A.You should configure the database for Read Committed Snapshot isolation.
B.You should modify the stored procedure to use the Snapshot isolation level
C.You should configure the database for Auto Update Statistics asynchronously
D.You should modify the stored procedure to use the Repeatable Read isolation level
A.You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances.
B.You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances.
C.You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances.
D.You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
A.You should create a cached data collection
B.You should create an on-demand non-cached data collection
C.You should create a scheduled non-cached data collection.
D.You should create two different SQL Agent jobs. The two jobs are scheduled at the same time. One job uploads the data collection and the other job creates a data collection.
A.You should alter the default resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by SQL Server Management Studio.
B.First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by SQL Server Management Studio.
C.You should alter the default resource pool and set the MAX_CPU_PERCENT option to 20. Then assign this resource pool to the workload group used by the mission-critical applications.
D.First, you should create a new resource pool and set the MAX_CPU_PERCENT option to 80. Then assign this resource pool to the workload group used by the mission-critical applications.
A.The SQL Server 2008 Upgrade Advisor should be used
B.You should use a SQL server-side trace. The trace captures the Deprecation Announcement and Deprecation Final Support event classes
C.You should use the SQL Server Profiler. The profiler captures the SQL:BatchCompleted and Exception event classes
D.You should use a SQL server-side trace. The trace captures the SQL:BatchCompleted and Exception event classes.
A.You should use SQLServer:Buffer Manager
B.You should use SQLServer:Memory Manager
C.You should use SQLServer:Databases
D.You should use SQLServer:Access Methods
A.On the local server, enable the XP_MSVER stored procedure
B.On the remote server, enable the XP_MSVER stored procedure.
C.On the production server, use the dta.exe utility along with an XML input file.
D.You should configure a test server that has a similar hardware configuration. Use the dta.exe utility on the test server along with an XML input file
A.ON LOWER(i.OrganizationName) = LOWER(s.OrganizationName)
B.ON UPPER(i.OrganizationName) = UPPER(s.OrganizationName)
C.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CS_AS
D.ON i.OrganizationName = s.OrganizationName COLLATE SQL_Latin1_General_CP1_CI_AS
A.On the Products table, you should create a view.
B.On the RadioSize column, you should create a clustered index
C.On the RadioSize column, you should create a filtered index
D.On the RadioSize column, you should create a unique clustered index
A.You should run the bulk copy program utility along with an output file and no format file
B.You should run the SQLCmd utility and save the output to a file
C.You should run the SQL Import and Export Data Wizard and save the output to a file.
D.You should run the bulk copy program utility along with a format file and an output file.
最新试题
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？（）
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. For some reason, now the company wants to view the number of users who access the SQL Server instance. The company CIO assigns this task to you. You have to use Windows System Monitor to find out the concrete number.Which performance object should you capture?（）
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 which is named Instance01. Instance01 contains a database which is named SellingHelp. There isthe Products table in the SellingHelp database. Now according to the company requirement, the Products table has to be replicated to the SQL Server instances installed in laptopscomputers. You have to create a Replication topology to perform this. The Products table is updated from Instance01 when the laptops reconnect to the corporate network. The Products table on Instance01 is frequently updated between reconnections. You must make sure that you can implement the Replication topology along with the Subscription type successfully and meanwhile reduce the bandwidth usage to the least. So what action should you perform to achieve this goal?（）
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?（）
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. A new SQL Agent job has been created by you. The job includes a Windows PowerShell job step which transfer data between servers by using the SQLCmd utility. If the job fails, you must make sure that an operator named ReactGroup is informed by receiving an e-mail. So what action should you perform to achieve this goal? （）
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. You create a SQL Server Agent job that execute every 2 minutes. There istext file named SQL.log On the E：drive. The job logs information to the text file. You get a report from users saying that the server doesn'；t make response. You check and find that the SQL Server Agent service does not run and the Agent job doesn'；t function any loner. As the IT support， you have to identify the reason for the failure of the SQL Server Agent service. Which log should you check？ （）
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. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory. Which SQL Server database engine subdirectory should be backed up？（）
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 which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup. So what action should you perform to achieve this goal？（）
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？（）
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 which contains a database. According to the company requirement， you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008. You have to monitor the SQL Server instance to record the use of features. These features will be discontinued. What should you do？ （）