Online Access Free 070-432 Exam Questions

You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database contains a table named Customers that has a column named CompanyName.
The current database collation is SQL_Latin1_General_Cp1_CI_AS.
You need to ensure that the indexes which include the CompanyName column are case-sensitive.
You also need to ensure that other case-insensitive queries are unaffected.
What should you do?

• A.Drop all indexes on the Sales database.
  Modify the database to specify SQL_Latin1_General_Cp1_CS_AS as the default collation.
  Rebuild all the indexes.
• B.Drop all indexes on the Customer table that include the CompanyName column in the index key.
  Modify the column to specify the SQL_Latin1_General_Cp1_CS_AS collation.
  Recreate the CompanyName indexes on the Customer table.
• C.Use the UPPER function in the filter criteria on all queries that filter on the CompanyName column.
• D.Use the CAST function in the filter criteria on all queries that filter on the CompanyName column.

You administer a SQL Server 2008 instance that contains the AdventureWorks database.
The Adventure Works database uses the bulk-logged recovery mode.
You log ship the AdventureWorks database across a WAN link.
There is a scheduled job that rebuilds the indexes of the AdventureWorks database.
You discover that the job increases the size of the log backups for log shipping.
You need to minimize the size of the log backups used by log shipping.
What should you do?

• A.Compress the log file backups.
• B.Change the job to drop the indexes, and then recreate the indexes.
• C.Alter the AdventureWorks database to use the Full recovery mode.
• D.Alter the AdventureWorks database to use the Simple recovery mode.

You maintain a SQL Server 2008 instance.
The SQL Server instance is configured to use the -T1222 and -T1204 trace flags during
startup.
You need to ensure that your failure recovery plan backs up the use of the trace flags.
What should you do?

• A.Backup the SQL Server registry hive.
• B.Backup the master database.
• C.Backup the resource database.
• D.Backup the default.trc file.

You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses stored procedures that include the EXECUTE AS clause and that use Microsoft Windows accounts. The company's written security policy states that all enterprise applications must run under the context of a service account that requires the minimum amount of privileges.
You need to configure the SQL Server service torun under the appropriate context for the installation of the new enterprise sales application. Under which context should the SQL Server service run?

• A.Under the context of the local Administrator account
• B.Under the context of the local service account
• C.Under the context of the local system account
• D.Under the context of the domain user account

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