Try Microsoft : 070-432 valid & accurate questions and answers

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

The following DDL has been run on the database:
CREATE PARTITION FUNCTION FUNC_FG (INT)
AS RANGE LEFT FOR VALUES (1, 100, 1000);
You need to create a partition scheme that will place all data to the SECONDARY filegroup.
What should you do?

• A. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
• B. Remove the clustered index from the table.
• C. 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.
• D. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
• E. 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.
• F. Use the ALTER TABLEstatement to remove the COLLATEoption.
• G. Create a new partition function.
  Create a new partition scheme.
  Add a clustered index to place the data onto the partition scheme.
• H. Run the following statement:
  EXECUTE sp_tableoption
  @TableNamePattern ='OrderItem3',
  @OptionName= 'PartltionByYear';
  @OptionValue= 'true';
• I. Run the following statement:
  CREATE PARTITION SCHEME SEC_FG
  AS PARTITION FUNC_FG
  ALL TO (SECONDARY);
• J. 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.

You administer multiple SQL Server 2008 instances.
You plan to install a SQL Server 2008 mission-critical cluster on two cluster-ready nodes. The mission-critical cluster requires constant availability.
You need to configure the SQL Server cluster to failover by ensuring that the service disruption is minimized.
Which failover option should you use?

• A. Prevent automatic failback
• B. Allow failback only during business horns
• C. Immediately allow failback
• D. Allow failback only during non-business hours

You are mastering the company database; there are 15 retail stores in your company. On its own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a database table called Saling. The Saling table also includes sales information from other stores to enable customer returns to any of the 15 retail stores. You could refresh the data in the main office to every retail store every hour. You should use trigger called trg_Coupon to produce sales coupons based on customer sales and buying patterns. Through using the fewest number of steps, you should set replication between the server in every retail store and a middle server in the mainoffice. in real time. You should not have the Replication. Which is the correct answer?

• A. Snapshot replication should be utilized. You should set the trg_Coupon trigger on the server in every store to utilize the NOT FOR REPLICATION option.
• B. You should build multiple merge publications, one at every store and one in the main office.
• C. You should utilize merge replication. You should set the trg_Coupon trigger on the server in each retail store to use the NOT FOR REPLICATION option.
• D. You should utilize transactions log between the server in each retail store and the central server in the main office.

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 only the newest transaction log backup.
• B. You should detach the Sales database on SQL2. Copy the database file to SQL1, and link the database on both servers.
• C. You should reserve the most recent full database backup and the whole transaction logs made since the past backup could be made.
• D. You should reserve a full database backup on SQL2. Reserve the backup to SQL1.

You administer a SQL Server 2008 cluster in a high security environment.
You plan to configure and use encrypted connections for the clustered virtual SQL Server.
You need to install the certificate that will be used for encryption.
What should you do?

• A. Install the encryption certificate in the cluster quorum drive.
• B. Install the encryption certificate in the SQL Server shared disk.
• C. Install the encryption certificate on each individual node.
• D. Install the encryption certificate in the cluster group.