070-432 무료 덤프문제 온라인 액세스

You administer a SQL Server 2008 instance that contains a database named AdventureWorks.
You plan to use data compression to conserve disk space. You compress a table named VeryLarge that has a clustered index named Index1 and a non-clustered index named Index2. Both indexes are partitioned.
You execute the following Transact-SQL statement.
ALTER INDEX Index2 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
You need to ensure that all the indexes of the VeryLarge table are compressed by using row-level compression.
You need to accomplish this goal by using minimum resources.
Which Transact-SQL statement should you execute?

• A.ALTER INDEX ALL ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);
• B.ALTER INDEX Index1 ON VeryLarge REORGANIZE WITH (LOB_ COMPACTION = ON);
• C.ALTER INDEX ALL ON VeryLarge REBUILD PARTITION=ALL WITH (DATA_COMPRESSION = ROW);
• D.ALTER INDEX Index1 ON VeryLarge REBUILD WITH (DATA_COMPRESSION = ROW);

You administer three SQL Server 2008 instances on separate servers named Server1, Server2, and Server3.
The AdventureWorks database is configured for mirroring between the instances. In the mirroring session, Server1 and Server2 act as partners and Server3 as the witness.
You have the following requirements:
- All three servers run a maintenance process that requires occasional restart of the computer. - The SQL Server service on each server is shut down only during the actual restart of the computer. - After completion of the maintenance process, re-enable automatic failover and synchronize the mirroring session in minimum possible time.
You need to ensure that automatic failover is disabled during the maintenance process.
What should you do first?

• A.Remove mirroring from the database.
• B.Suspend the mirroring session.
• C.Configure the mirroring session with the SAFETY option set to ON.
• D.Remove the witness server from the mirroring session.

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 sqldiag function
• B.You should utilize the SHOWPLAN session selection.
• C.You should utilize the DBCC INPUTBUFFER requirements
• D.You should utilize the sys.dm_exec_query_stats dynamic management view (DMV).

You administer a Microsoft SQL Server 2008 R2 database instance.
You need to identify queries or stored procedures that are consuming server resources.
You also need to view the query plan that is being used by each of these queries or procedures.
Which Dynamic Management Views (DMVs) should you use to find details about specific queries? (Choose all that apply.)

• A.dm_exec_connections
• B.dm_exec_query_stats
• C.dm_exec_query_plan
• D.dm_exec_sql_text
• E.dm_io_virtual_file_stats

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 transaction log backup every two hours during business hours.
• B.Perform a full database backup once daily.
• C.Perform a full database backup once daily.
  Perform a differential backup every two horns 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.