Free Microsoft 070-432 Exam Dumps Questions & Answers

You administer a SQL Server 2008 instance. The instance contains various SQL Server Agent jobs that use seven shared schedules to run each job on each day of the week. You need to ensure that a job named Job5 no longer runs on Thursdays. What should you do?

• A.Remove the schedule for Thursday from Job5.
• B.Delete the schedule for Thursday.
• C.Disable the schedule for Thursday.
• D.Add a new Job5 schedule for Thursday and disable it.

You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives according to the following table:

You discover that the Windows application log is being filled with entries from a SQL Server Audit process named DatabaseAudit. The volume of these events is causing older events to be removed from the log.
You need to ensure that the following requirements are met:
- SQL Server Audit information is stored in the D:\AuditLogs folder.
- No data is currently lost in the Windows application log.
What should you do?

• A.Open the Windows Server Manager.
  Browse to the Diagnostics\Event Viewer\Windows Logs folder.
  Right-click Application Log, and then click Properties
  Enable the Clear Log option.
• B.Open the Windows Server Manager.
  Browse to the Diagnostics\Event Viewer\Windows Logs folder.
  Right-click Application Log, and then click Properties.
  Enable the Do not overwrite events (Clear logs manually) option,
• C.Create a folder named AuditLogs on drive D.
  Run the following Transact-SQL statement:
  ALTER SERVER AUDIT DatabaseAudit
  TO FILE (FILEPATH = 'D:\AuditLogs')
• D.Create a folder named AuditLogs on drive D.
  Run the following Transact-SQL statement:
  ALTER DATABASE Dat3baseAudit
  ADD LOG FILE (NAME = DatabaseAuditLog, FILENAME =
  'D:\AuditLogs\DatabaseAuditLog.Idf)

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 administer two SQL Server 2008 instances on separate servers named Server1 and Server2.
The AdventureWorks database is set up for synchronous mirroring between the two instances.
You need to configure the database to support automatic failover.
What should you do?

• A.Configure the mirroring session with the SAFETY option set to FULL.
• B.Configure the mirroring session by using the FAILOVER option.
• C.Configure the mirroring session with the SAFETY option set to OFF.
• D.Configure the mirroring session by adding a witness server to it.

You administer a Microsoft SQL Server database.
You plan to deploy a new database application. You want to use SQL Server common language runtime (CLR) integration.
You need to ensure that CLR assemblies can be used.
What should you do?

• A.Open Microsoft SQL Server Management Studio and connect to the server.
  Right-click the server and select Properties.
  Browse to the Advanced tab.
  Configure the CLRIntegration property to True.
• B.open Microsoft SQL Server Management Studio and connect to the server.
  Right-click the server and select Properties.
  Browse to the Advanced tab.
  Configure the Filestream Access Level option to Full access enabled.
• C.Open Microsoft SQL Server Management Studio and connect to the server.
  Right-click the server and select Facets.
  Choose the Server Configuration facet.
  Configure the AweEnabled property to True.
• D.Run the following statement: EXEC sp_configure 'show advanced options', 1 RECONFIGURE GO EXEC sp_configure 'clr enabled', 1 RECONFIGURE GO