70-432 試験問題を無料オンラインアクセス

You administer a SQL Server 2008 instance. You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail stored procedure is used to send a large volume of reports during business hours. The reports to the manager take a long time to be delivered.
You need to ensure that the reports to the manager are sent as quickly as possible.
What should you do?

• A.Change the Account Retry Attempts option of the Database Mail system properties.
• B.Configure a new Database Mail profile to be used for the reports to the manager.
• C.Use the (@importance = high parameter when you send the reports to the manager.
• D.Add another SMTP account to the existing Database Mail profile.

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains a table named Orders. The Orders table has several indexes and a very large number of rows. The database supports an enterprise Web environment that is constantly used.
Thirty percent of the indexes on the Orders table is fragmented.
You need to defragment the indexes by ensuring that the effect on database availability is minimized.
Which option should you include in the ALTER INDEX statement?

• A.Sort in tempdb
• B.Fill factor
• C.Pad index
• D.Online

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

You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database has a table named Products that stores information about all types of products. Users frequently query the Products table based on the TelevisionSize column. The TelevisionSize column has the NULL value for all products other than Televisions. There is currently no index on the TelevisionSize column. You need to improve the query performance by ensuring that the effect on the disk space is minimized. What should you do?

• A.Create a view on the Products table by filtering on the TelevisionSize column.
• B.Create a unique clustered index on the TelevisionSize column.
• C.Create a filtered index on the TelevisionSize column.
• D.Create a clustered index on the TelevisionSize column.

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

Currently, the table is partitioned by year with each year in its own filegroup.
You need to move the data from the oldest year into a new table in a different Schema to archive the data.
What should you do?

• A.Create a new Filegroup.
  Create a new database File.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
• B.Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
• C.Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= 'PartltionByYear'; @OptionValue= 'true';
• D.Use the ALTER TABLEstatement to remove the COLLATEoption.
• E.Create a new partition function.
  Create a new partition scheme.
  Add a clustered index to place the data onto the partition scheme.
• F.Run the following statement:
  CREATE PARTITION SCHEME SEC_FG
  AS PARTITION FUNC_FG
  ALL TO (SECONDARY);
• G.Create a new filegroup.
  Create a new database file.
  Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
  Use ALTER INDEX REORGANIZE statement.
• H.Create a new table.
  Use the ALTER TABLE statement along with the SWITCH PARTITION clause.
  Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE
  clause.
• I.Execute the DBCC CLEANTABLEcommand on the OrderItems table.
• J.Remove the clustered index from the table.