Microsoft TS:MS SQL Server 2008,Implementation and Maintenance

문제1
You administer a SQL Server 200S instance. A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked. Which tool should you use?

A. The Activity Monitor tool in Microsoft SQL Server Management Studio

B. The Windows System Monitor tool

C. The Job Activity Monitor tool in Microsoft SQL Server Management Studio

D. The Database Engine Tuning Advisor tool

정답: A

문제2
You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 by using transactional replication. A full backup of each database is performed every night. Transaction log backups are performed every hour.
Replication latency is typically less than two minutes. One afternoon, the Sales database on SQLTEST1 becomes corrupted.
You are unable to repair the database. The Sales database on SQLTEST2 is unaffected. You need to return the Sales database on SQLTEST1 to normal operation as quickly as possible.
You must ensure a minimum loss of data and minimal impact to users of either server. What should you do?

A. You should reserve the most recent full database backup and the whole transaction logs made since the past backup could be made.

B. You should reserve a full database backup on SQL2. Reserve the backup to SQL1.

C. You should reserve only the newest transaction log backup.

D. You should detach the Sales database on SQL2. Copy the database file to SQL1, and link the database on both servers.

정답: B

문제3
You are mastering the company database; you should use the SQL Server 2005 database which enables business users to operate both ad hoc and predefined searches. Youdoubt that some searched will cost too many resources. You should clarify which searches cost the most resources. You decide to finish this aim as quickly as possible. Which is the correct answer?

A. You should utilize the DBCC INPUTBUFFER requirements

B. You should utilize the sys.dm_exec_query_stats dynamic management view (DMV).

C. You should utilize the sqldiag function

D. You should utilize the SHOWPLAN session selection.

정답: B

문제4
You administer a SQL Server 2008 instance. You need to allow users on instance to query remote data sources by using the OPENROWSET() sp_configure configuration option should you configure?

A. Ad Hoc Distributed Queries

B. Agent XPs

C. remote access

D. remote proc trans

정답: A

문제5
You maintain a SQL Server 2008 instance that contains a database named Finance. The Finance database currently contains 100 GB of data. On an average, 1 GB of data is modified or inserted daily.
The recovery model of the Finance database is set to Simple. Business requirements specify that data loss of more than two hours worth of transactions during business hours is unacceptable.
You need to select a backup strategy that uses the least amount of disk space by adhering to the business requirements.
What should you do?

A. Perform a full database backup once daily.
Perform a differential backup every two horns during business hours.

B. Perform a full database backup once daily.

C. Perform a full database backup once daily.
Perform a transaction log backup every two hours during business hours.

D. Perform a full database backup once every week.
Perform a differential backup once daily.
Perform a transaction log backup every two hours during business hours.

정답: A

문제6
You maintain a SQL Server 2008 instance that runs on a computer that hosts several applications. You configure the SQL Server Agent service to run by using the SERVER1\AGENT account. You create a job named MailingList that requires a file to be written to a file server. The job fails to run because it does not have appropriate access to the file server. You plan to configure the SQL Server Agent service.
You need to perform the configuration such that only the SQL Server Agent service has read and write access to the file server.
Which account type should you use?

A. Local Service account

B. Domain account

C. Network Service account

D. Local System account

정답: A

문제7
You administer a SQL Server 2008 instance. You use an internal application based on SQL Server 2008. The application uses Analysis Services and Reporting Services. Company security policy requires that the surface area for all the deployed components of SQL Server 2008 be configured.
You need to implement the security policy and devise a method to evaluate the security policy against other database servers.
What should you do?

A. Create policies based on the appropriate facets. Apply the policies against a server group that includes the database servers that need to be configured.

B. Create a Transact-SQL script based on the sp_configure stored procedure. Use a configuration server to rim the script against a server group that includes the database servers that need to be configured

C. Use the SQL Server Best Practices Analyzer (BPA) to analyze your database servers. Implement the recommendations of the BPA.

D. Edit the RSReportServer.config configuration file. Distribute the file to all database servers that need to be configured

정답: A

문제8
You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance.
The recovery model of the Finance database is set to Full. A full database backup of all the user databases is performed at 02:00 hours daily. The transaction log backup occurs every 15 minutes. A differential backup is performed every 4 hours.
You plan to perform a full backup of the Finance database at 11:00 hours.
You need to ensure that the backup is performed without affecting the overall backup and restore procedures for the Finance database. You also need to ensure that the backup files are restored in proper sequence.
Which Transact-SQL statement should you use?

A. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH COPY_ONLY:

B. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak' WITH NOUNLOAD;

C. BACKUP DATABASE FINANCE TO DISK = 't:\backups\finance.bak` WITH
DIFFERENTIAL;

D. BACKUP LOG FINANCE TO DISK = 't:\backups\finance.trn';

정답: A

문제9
You are reviewing and configuring the security of a SQL Server 2008 instance that contains database DB1.
The security audit policy specifies the following requirements:
Only successful and failed logon attempts are recorded in log files.
The SQL Server instance is shut down if records cannot be written to the log files.
You need to configure the SQL Server instance to comply with the security audit policy.
Which Transact-SQL statements should you run?

A. sp_configure 'show advanced options', l:GORECONFIGURE:GOsp_configure 'default trace enabled'. 1 ;GORECONFIGUREGO

B. CREATE SERVER AUDIT Srv_Audit TO FILE (FILEPATH =`\\MAIN_SERVER\Audit\') WITH (ON_FAILURE = SHUTDOWN);GOCREATE SERVER AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP),ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GOALTER SERVER AUDIT Srv_Audit WITH (STATE=ON);GO

C. CREATE SERVER AUDIT Srv_Audit TO FILE ( FILEPATH ='\\MAIN_SERVER\AuditV ) WITH (ON_FAILURE = SHUTDOWN) ;GOCREATE DATABASE AUDIT SPECIFICATION Audit_SpecificationFOR SERVER AUDIT Srv_Audit ADD (SUCCESSFUL_LOGIN_GROUP).ADD (FAILED_LOGIN_GROUP) WITH (STATE=ON);GO ALTER SERVER AUDIT SrvAucfit WITH (STATE=ON);GO

D. sp_configure 'show advanced options'. 1 ;GORECONFIGURE;GOsp_configure 'common criteria compliance enabled'. 1 ;GORECONFIGUREGO

정답: B

문제10
You are managing a SQL Server 2008 instance which includes a database called TesterDB for Home.com. The data file and the transaction log file which are located on the D: drive that owns only 10 percent useful space. You should make sure that you move both files to the G: drive.
Which is the correct answer?

A. You should implement the statement below: ALTER DATABASE Finance SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and

B. You should utilize the following Transact-SQL statement.

C. ALTER DATABASE TesterDB

D. mdf'); ldf'); ALTER DATABASE TesterDB SET ONLINE;

E. ALTER DATABASE TesterDB SET OFFLINE WITH ROLLBACK_IMMEDIATE;

F. mdf'); ALTER DATABASE Finance SET MULTI_USER;

G. Run the following Transact-SQL statements. ALTER DATABASE Finance MODIFY FILE(NAME = Finance_Data, FILENAME =

정답: G

문제11
You administer a Microsoft SQL Server 2008 R2 instance.
You need to configure mirroring between two servers in high-performance mode.
What should you do?

A. Create mirroring endpoints on both partner servers.
Use the ALTER ENDPOINT statement along with the ENCRYPTION=DISABLED clause.

B. Create mirroring endpoints on both partner servers.
Use Microsoft SQL Server Management Studio on both partner servers to select the High Performance option, and start mirroring.

C. Create mirroring endpoints on both partner servers.
Execute the following stored procedure: Sp_configure 'Lightweight Pooling', 1

D. Create mirroring endpoints on both partner servers.
On the principal server, use the ALTER DATABASE statement along with the PARTNER SAFETY OFF clause.

정답: B

최신Microsoft TS:MS SQL Server 2008,Implementation and Maintenance - 070-432무료샘플문제

KoreaDumps의 제품으로 GO GO GO !

자격증의 중요성:

KoreaDumps 제품의 가치:

무료샘플 받아보기:

완벽한 서비스 제공: