Online Access Free 70-432 Exam Questions

You administer a SQL Server 2008 instance.
A stored procedure is used as the data source for a report that is frequently executed during business hours. Users report that the data returned by the report is inconsistent. You discover that the
inconsistencies are caused by phantom reads.
You need to ensure that the report returns consistent results without affecting other users.
What should you do?

• A.Modify the stored procedure to use the Repeatable Read isolation level.
• B.Modify the stored procedure to use the Snapshot isolation level.
• C.Configure the database for Read Committed Snapshot isolation.
• D.Configure the database for Auto Update Statistics asynchronously.

You administer a Microsoft SQL Server 2008 R2 instance.
You need to ensure that no suspect pages have been detected in your database.
What should you do?

• A.Examine the msdb..suspect_pagestable.
• B.Execute DBCC CHECKD
• C.Execute sp_helpfile.
• D.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.
• E.Execute DBCC CHECKDBalong with the REPAIR_REBUILDclause.
• F.Use the ALTER DATABASEstatement along with the SET EMERGENCYclause.
• G.Execute DBCC CHECKDBalong with the REPAIR_FASTclause.
• H.Restore the database from the most recent full backup. Apply any differential and log backups.
• I.Use the RESTORE DATABASEstatement along with the PAGESclause. Create a new log backup. Apply all differential and log backups, including the most recent backup.

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.Configure the security settings of the Database Mail system.
• B.Modify the SMTP relay settings.
• C.Modify the parameters of the email that contains the reports.
• D.Create a separate Database Mail profile for the reports.

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 Index1 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 WITH (DATA_COMPRESSION = ROW);
• D.ALTER INDEX ALL ON VeryLarge REBUILD PARTITION=ALL WITH (DATA_COMPRESSION = ROW);

You maintain a SQL Server 2008 instance that contains a database named CustomerDB. The CustomerDB database stores customer data for the company. The customers use a Web application to access their profile data.
You need to protect the customer data such that data files, log files, and subsequent backups are as secure as possible even if the backup media is lost. You want to achieve this goal without affecting the Web application.
What should you do?

• A.Make the CustomerDB database accessible only through stored procedures and functions.
• B.Encrypt the sensitive data at the cell level by using the built-in encryption functions.
• C.Enable Transparent Database Encryption for the CustomerDB database and back up the transaction log.
• D.Enable Transparent Database Encryption for both the CustomerDB database and the master database.