Microsoft 070-432 Exam Syllabus Topics:

Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:

1. You maintain a SQL Server 2008 instance. You create a new SQL Agent job that includes a Windows PowerShell job step.
The PowerShell job step uses the SQLCmd utility to transfer data between servers.
You need to ensue that an operator named ResponseTeam is notified by an e-mail message if the job fails.
What should you do?

A) Enable Notifications.
Create the ResponseTeam operator.
Direct the Notification to the ResponseTeam operator on failure of the Powershell job step.
B) Create the ResponseTeam operator.
Configure the job step proxy account to use the ResponseTeam operator account.
Select the proxy account for the e-mail profile.
C) Enable Notifications.
Create the ResponseTeam operator.
Direct the Notification to the ResponseTeam operator on job failure.
D) Create the ResponseTeam operator.
Assign the ResponseTeam operator as the failCsafe operator.
Enable the job.

2. ---
You administer a SQL Server 2008 instance that contains a very large database named FinanceDB.
You plan to create a maintenance plan that meets the following objectives for the FinanceDB database:
It executes the DBCC CHECKDB statement.
It rebuilds all the indexes.
It updates all index statistics.
You need to ensure that the maintenance plan is executed in the minimum amount of time.
Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)

A) Use the Shrink Database task.
B) Use the Check Database Integrity task.
C) Use the Rebuild index task.
D) Use the Reorganize Index task.
E) Use the Update Statistics task.

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

4. You migrate an application from Microsoft SQL Server 2000 to Microsoft SQL Server 2008.
You need to monitor the SQL Server instance to record the use of features that will be discontinued.
What should you do?

A) Use a SQL server-side trace that captures the SQL:BatchCompleted and Exception event classes.
B) Use the SQL Server Profiler that captures the SQL:BatchCompleted and Exception event classes.
C) Use a SQL server-side trace that captures the Deprecation Announcement and Deprecation Final Support event classes.
D) Use the SQL Server 2008 Upgrade Advisor.

5. You administer a SQL Server 2008 instance that contains a database named DB1. DB1 contains a table named Table1.
The DB1 database includes a stored procedure named Procedure1. Procedure 1 uses a sp_executesql Transact-SQL statement to select data from Table1.
According to business requirements, users are not allowed to access tables directly in any database.
When a user executes Procedure1, the following exception is raised:
"Msg 229, Level 14, State 5, Line 1
The SELECT permission was denied on the object Table1', database 'DB1', schema 'dbo'."
You need to ensure that the user can successfully execute Procedure1 without violating the business requirements.
What should you do?

A) Execute the GRANT EXECUTE ON dbo.Procedure1 TO User1 Transact-SQL statement.
B) Alter Procedure1 and add the EXECUTE AS USER = 'dbo' option immediately before the call to the sp_executesql stored procedure.
C) Execute the GRANT SELECT ON dbo.Table1 TO User1 Transact-SQL statement.
D) Alter Procedure1 and add the WITH EXECUTE AS OWNER option to its header.

Solutions: