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

質問 1

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

（A）Ad Hoc Distributed Queries

（B）Agent XPs

（C）Remote access

（D）Remote proc trans

正解：A 解答を投票する

質問 2

You administer a SQL Server 2008 instance that contains a database named DB1.
A table named Sales.Table1 exists in the Sales schema.
You need to move the Sales.Table1 table to a new schema named Billing.
Which Transact-SQL statement should you execute?

（A）ALTER AUTHORIZATION ON Sales.Table1 TO Billing:

（B）ALTER USER Sales WITH DEFAULT_SCHEMA = Billing;

（C）ALTER TABLE Sales.Table1 SWITCH TO Billing.Table1;

（D）ALTER SCHEMA Billing TRANSFER Sales.Table1;

正解：D 解答を投票する

質問 3

You administer a SQL Server 2008 instance. A database developer named User1 views the definitions of all database objects in a database to read data from all user-defined tables, views, and table-valued functions. You need to set the required permissions for User1. You also need to ensure that the same permissions can be granted to other developers by executing minimum number of Transact-SQL statements. Which Transact-SQL statements should you execute?

（A）CREATE ROLE Developers;GRANT VIEW DEFINITION TO Developers;GRANT SELECT TO Developers;EXEC sp_addrolemember 'Developers'. 'User1';

（B）GRANT VIEW ANY DEFINITION TO User1;EXEC sp_addrolemember 'db_datareader', 'User1';

（C）CREATE ROLE Developers;GRANT CONTROL TO Developers;EXEC sp_addrolemember 'Developers', 'User1';

（D）CREATE ROLE Developers;EXEC sp_addrolemember 'sp_dbdatareader'. 'Developers';EXEC sp_addrolemember 'sp_dbddladmin\ 'Developers';EXEC sp_addrolemember 'Developers', 'User1';

正解：A 解答を投票する

質問 4

You troubleshoot the performance of a SQL Server 2008 instance.
You need to identify the longest-running common language runtime (CLR) queries.
Which dynamic management view should you use?

（A）sys.dm_exec_sessions

（B）sys.dm_exec_query_stats

（C）sys.dm_exec_requests

（D）sys.dm_os_wait_stats

正解：B 解答を投票する

質問 5

You are managing your company database. You manage a SQL Server 2005 database called ContractTEST, which is down.
You operate a restore by using the following Transact-SQL script. RESTORE DATABASE ContractTESTFROM contracts_bu_deviceWITH CONTINUE_AFTER_ERROR, CHECKSUM, RECOVERY After the restore, the SQL Server logs show errors in some page restores.
What you should do is to repair the database pages, which are down, and facilitates repair by using the fastest method.
Which is the correct answer?

（A）You should add code: ALTER DATABASE Contracts SET TRUSTWORTHY ON

（B）You should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH TABLOCK

（C）You should add code: DBCC CHECKDB (Contracts, REPAIR_ALLOW_DATA_LOSS) WITH NO_INFOMSGS

（D）You should add code: ALTER DATABASE Contracts SET TORN_PAGE_DETECTION ON

正解：B 解答を投票する

質問 6

You migrate an application named App1 from Microsoft SQL Server 2000 to SQL Server 2008.
You plan to monitor the SQL Server instance.
You need to capture the use of features that will be discontinued.
What should you do?

（A）Create a Data Collector Set that captures the Microsoft-Windows-COMRuntime event trace provider.

（B）Run the SQL Server Profiler and capture the Exception event class.

（C）Create a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.

（D）Run the SQL Server 2008 Upgrade Advisor.

正解：C 解答を投票する

解説: (JPNTest メンバーにのみ表示されます)

質問 7

You manage a SQL Server 2008 instance. You plan to maintain a management data warehouse that collects performance data by using the data collector.
You need to implement a process that routinely gathers and uploads data in the management data warehouse on different schedules.
What data collection process should you implement?

（A）Create a cached data collection.

（B）Create a scheduled non-cached data collection.

（C）Create two different SQL Agent jobs that are scheduled at the same time. One job
creates a data collection and the other job uploads the data collection.

（D）Create an on-demand non-cached data collection.

正解：A 解答を投票する

質問 8

DRAG DROP
You administer a Microsoft SQL Server 2008 R2 database installed along with the default settings.
You want to migrate a database from a SQL Server 2000 server that is being decommissioned. The application executes a number of Windows command-line calls from stored procedures in the database.
You need to configure SQL Server 2008 R2 to allow command-line calls from this database.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

正解：

質問 9

You administer two SQL Server 2008 instances on separate servers named Server1 and Server2.
The AdventureWorks database is set up for synchronous mirroring between the two instances.
You need to configure the database to support automatic failover.
What should you do?

（A）Configure the mirroring session with the SAFETY option set to OFF.

（B）Configure the mirroring session with the SAFETY option set to FULL.

（C）Configure the mirroring session by using the FAILOVER option.

（D）Configure the mirroring session by adding a witness server to it.

正解：D 解答を投票する

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

弊社を連絡する

関連リンク

トップ試験