70-432無料問題集「Microsoft TS:MS SQL Server 2008,Implementation and Maintenance」

質問 1

You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing application.
You need to ensure that the database allows full-text searches on the Customers table.
You also need to ensure that the full-text index is ready for use by the users.
You execute a Transact-SQL statement to create the full-text index on the Customers table
by using the CHANGE_TRACKING
OFF and NO POPULATION clauses in the CREATE FULLTEXT INDEX statement.
You execute an ALTER FULLTEXT INDEX.
Which command or commands should you use next?

（A）Option D

（B）Option B

（C）Option C

（D）Option A

正解：A 解答を投票する

質問 2

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'. 1 ;GORECONFIGURE;GOsp_configure 'common criteria compliance 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）sp_configure 'show advanced options', l:GORECONFIGURE:GOsp_configure 'default trace enabled'. 1 ;GORECONFIGUREGO

（D）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

正解：B 解答を投票する

質問 3

You administer a Microsoft SQL Server 2008 R2 instance. You need to check the physical consistency of the database. What should you do?

（A）Execute sp_helpfile.

（B）Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.

（C）Examine the msdb..suspect_pagestable.

（D）Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.

（E）Execute DBCC CHECKDB along with the REPAIR_REBUILDcla.se

（F）Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any differential and log backups. Create a new log backup and then restore the new log backup.

（G）Execute DBCC CHECKD

（H）Execute DBCC CHECKDBalong with the REPAIR_FASTclause.

（I）Restore the database from the most recent full backup. Apply any differential and log backups.

正解：G 解答を投票する

質問 4

You maintain a SQL Server 2008 instance. You create a new SQL Agent job that includes a Windows PowerShell job step.
The PowerShell job step uses the SQLCmd utility to transfer data between servers.
You need to ensue that an operator named ResponseTeam is notified by an e-mail message if the job fails.
What should you do?

（A）Create the ResponseTeam operator.
Assign the ResponseTeam operator as the failCsafe operator.
Enable the job.

（B）Create the ResponseTeam operator.
Configure the job step proxy account to use the ResponseTeam operator account.
Select the proxy account for the e-mail profile.

（C）Enable Notifications.
Create the ResponseTeam operator.
Direct the Notification to the ResponseTeam operator on failure of the Powershell job step.

（D）Enable Notifications.
Create the ResponseTeam operator.
Direct the Notification to the ResponseTeam operator on job failure.

正解：D 解答を投票する

質問 5

You maintain a SQL Server 2008 instance.
The SQL Server instance is configured to use the -T1222 and -T1204 trace flags during
startup.
You need to ensure that your failure recovery plan backs up the use of the trace flags.
What should you do?

（A）Backup the default.trc file.

（B）Backup the resource database.

（C）Backup the master database.

（D）Backup the SQL Server registry hive.

正解：D 解答を投票する

質問 6

You administer a Microsoft SQL Server 2008 instance that contains two databases named Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses the Latin1_General_100_CI_AI collation.
Each database has an Orders table that has the following definition: You need to return records from WorkHistory.dbo.Orders that exist in Work.dbo.Orders. Which Transact-SQL query should you use?

（A）Option D

（B）Option B

（C）Option C

（D）Option A

正解：B 解答を投票する

質問 7

You administer a Microsoft SQL Server 2008 R2 instance.
The database has been marked as suspect.
You need to place the database into an EMERGENCY state for troubleshooting.
What should you do?

（A）Execute sp_helpfile.

（B）Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.

（C）Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.

（D）Examine the msdb..suspect_pagestable.

（E）Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.

（F）Use the RESTORE DATABASEstatement along with the PAGESclause. Apply any differential and log backups. Create a new log backup and then restore the new log backup.

（G）Execute DBCC CHECKD

（H）Execute DBCC CHECKDBalong with the REPAIR_FASTclause.

（I）Restore the database from the most recent full backup. Apply any differential and log backups.

正解：E 解答を投票する

質問 8

You maintain a SQL Server 2008 instance that contains a database named Finance. The data file and the transaction log file are located on the E: drive. The E: drive has only 5 percent available space.
You need to move both files to the V: drive.
Which procedure should you use?

（A）Stop the SQL Server Service. 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'Finance', @filename1 = N'v:\SQLServer\Finance_Data.mdf', @filename2 = N'v:\SQLServer\Finance_Log.ldf';

（B）Run the following Transact-SQL statement. ALTER DATABASE Finance 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 Finance MODIFY FILE (NAME = Finance_Data, FILENAME = 'v:\SQLServer\Finance_Data.mdf'); ALTER DATABASE Finance MODIFY FILE (NAME = Finance_Log, FILENAME = 'v:\SQLServer\Finance_Log.ldf'); ALTER DATABASE Finance SET ONLINE;

（C）Run the following Transact-SQL statement. ALTER DATABASE Finance 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 Finance MODIFY FILE ( NAME = Finance_Data, FILENAME = 'v:\SQLServer\Finance_Data.mdf'); ALTER DATABASE Finance SET MULTI_USER;

（D）Stop the SQL Server service. 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'Finance', @physname = N'v:\SQLServer\Finance_Data.mdf';

正解：B 解答を投票する

質問 9

You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company's written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges.
You need to configure the SQL Server service torun under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?

（A）Under the context of the local system account

（B）Under the context of the local service account

（C）Under the context of the local Administrator account

（D）Under the context of the domain user account

正解：D 解答を投票する

質問 10

You maintain a SQL Server 2008 instance that contains a database named AdventureWorks.
The AdventureWorks database contains a table named OrderSpecs. The OrderSpecs table has a clustered primary key named OrderId on the OrderId column. The OrderSpecs table has a single XML column named ProductSpecs that stores XML data, and there is an XML index on the same XML column.
You add a new column named ProductId to the OrderSpecs table.
You need to include ProductId in the primary key.
What should you do?

（A）Move the XML data to a temporary table. Clear the XML data from the original table by setting the ProductSpecs column to NULL. Modify the primary key. Repopulate the ProductSpecs column.

（B）Alter the XML index and set the ALLOW_ROW_LOCKS = OFF option. Alter the primary key and set the ALLOW_ROW_LOCKS = ON option.

（C）Disable the XML index on the ProductSpecs column. Modify the primary key. Enable the XML index on the ProductSpecs column.

（D）Drop the XML index on the table. Modify the primary key. Recreate the XML index.

正解：D 解答を投票する

70-432 無料問題集「Microsoft TS:MS SQL Server 2008,Implementation and Maintenance」

弊社を連絡する

関連リンク

トップ試験