You should check SQL1.log
You should check SQLAGENT.OUT
You should check log_xx.trc
You should check ERRORLOG
第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 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?()
第2题:
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? ()
第3题:
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.You must make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force index creation and avoidance of data fragmentation. So what action should you perform to achieve this goal?()
第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 Service in the instance. There is a database user who is named ServiceGreatUser. A SQL Server login named ServiceGreatLogin maps to ServiceGreatUser in the Service database. According to the requirement of the company CIO, the database user can only perform the two tasks below: the database user executes all stored procedures that currently exist in the Sales database and executes all stored procedures that will be created in the Sales database. So what should you do to ensure this? ()
第5题:
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. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the OrderId column. The first partition contains integer values greater than 100,000, while the second partition contains integer values between 1 and 100,000. You have to add a new partition. The new partition should contain integer values greater than 200,000. What should you do? ()
第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. On DB1, quite few logged operations are performed. Now according to the requirement of the company CIO, you must validate that the database can be restored to a specific point in time. So what action should you perform to achieve this goal? ()
第7题:
You should use SQLServer:Buffer Manager
You should use SQLServer:Memory Manager
You should use SQLServer:Databases
You should use SQLServer:Access Methods
第8题:
For the database, you should turn on the TRUSTWORTHY database option
For the database, the PAGE_VERIFY database option should be set to CHECKSUM
For the database, the database compatibility level option should be set to 10
For the model database, the PAGE_VERIFY database option should be set to TORN_PAGE_DETECTION.
第9题:
You should check SQL1.log
You should check SQLAGENT.OUT
You should check log_xx.trc
You should check ERRORLOG
第10题:
You should use database snapshots
You should use database backup and restore
You should use database backup and restore along with compression
You should use schema-bound views in a read-only database. The database resides on the same instance.
第11题:
For the AdventureWorks database, enable Server Auditing
First you should set the appropriate trace flags as a startup parameter, and then restart the SQL Server instance
You should configure the data collector and make it capture the deadlock graphs
You should configure a SQL Profiler trace, and make it capture the deadlock graphs
第12题:
You should use local Service account
You should use network Service account
You should use domain account
You should use local System account
第13题:
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 computer which hosts several applications in your company. The instance runs on the computer. A job named DiliveryList is created by you. This job requires a file to be written to a file server. But because the job cannot access the file server, it fails to run. You intend to configure the SQL Server Agent service so that only the SQL Server Agent service has read and write access to the file server. Which account type should you use? ()
第14题:
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. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You must make sure that your failure recovery plan performs backup of the use of the trace flags. So what action should you perform to achieve this goal? ()
第15题:
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 which is named Sellings in the instance. The Sellings database contains a table named Productions. The table is used to stores information about all types of products. The Productions table is often queried by users on the basis of the RadioSize column. The RadioSize column contains the NULL value for all products other than Radios. Currently no index exists on the RadionSize column. According to the requirement of the company CIO, you have to optimize the query performance and reduce the effect on the disk space to the least. So what action should you perform to achieve this goal?()
第16题:
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. Today you notice that applications that run on the server have poor performances. You doubt that this has something to do with table scans. You have to capture the appropriate information by using an appropriate Windows System Monitor object. In the options below, which performance object should you use? ()
第17题:
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. Now your company CIO assigns a task to you. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTREAM for file I/O streaming access; remote client computers must be able to have streaming access to FILESTREAM data. You must make sure that FILESTREAM data is enabled. Which service should you configure? ()
第18题:
In the cluster quorum drive, install the encryption certificate
In the SQL Server shared disk, install the encryption certificate
in the cluster group, install the encryption certificate.
On each individual node, install the encryption certificate
第19题:
You should allow failback only during non-business hours
You should immediately allow failback
You should prevent automatic failback
You should allow failback only during business hours
第20题:
To meet the requirements,one certificate from the public trusted certification authority should berequested for web.wiikigo.com.
To meet the requirements,separate certificates from the public trusted certification authority should berequested for www.wiikigo.com and webmail.wiikigo.com.
To meet the requirements,a self-signed certificate should be generated for web.wiikigo.com.
To meet the requirements,separate domain certificates should be generated for www.wiikigo.com andwebmail.wiikigo.com.
第21题:
You should verify that the simple recovery model is used by the database.
You should verify that the full recovery model is used by the database.
You should verify that the checksum page verify option is used by the database.
You should verify that the bulk-logged recovery model is used by the database.
第22题:
You should use the Database Engine Tuning Advisor.
In Microsoft SQL Server Management Studio, you should create a maintenance plan
You should use the SQL Server Configuration Manager
In Microsoft SQL Server Management Studio, you should create a policy
第23题:
You should backup the master database
You should backup the default.trc file
You should backup the SQL Server registry hive.
You should backup the resource database
第24题:
You should configure SQL Server VSS Writer
You should configure Distributed File System
You should configure SQL Server
You should configure SQL Server Full Text