Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 31:

  You administer a Microsoft SQL Server 2008 R2 database named AdventureWorks2008R2 that hosts a credit card-processing application. You need to implement transparent data encryption.

  Which four Transact-SQL statements should you use? (To answer, move the appropriate SQL statements from the list of statements to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

• Question 32:

  You install a Microsoft SQL Server 2008 R2 instance that uses default settings.

  You want to add a storage area network (SAN) array. The SAN has two mapped drives: D and L.

  You need to ensure that all new databases meet the following requirements:

  Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

  Select and Place:

  

  

• Question 33:

  You are managing a SQL Server 2008 instance which includes a database called Products for Home.com. You should not modify the database frequently everyday. You should make sure that you develop a read-only copy of the database for reporting purposes at the beginning of every day .Which is the correct answer?

  A. You should utilize database snapshots.
  B. You should utilize Transactions Log.
  C. You should utilize store procedure
  D. You should utilize schema-bound views and XML schema
  A. You should utilize database snapshots.

• Question 34:

  You administer a SQL Server 2008 instance. A payroll application is used to store sensitive data in a database named PayrollDB.

  You plan to implement the following security measure:

  You need to devise a method to encrypt data. What should you include in your solution?

  A. Use a certificate to protect the data encryption key. Export the certificate to a file.
  B. Use cell-level encryption to protect sensitive data.
  C. Use a symmetric key provisioned through Extensible Key Management (EKM).
  D. Use Transparent Data Encryption (TDE) for the PayrollDB database.
  B. Use cell-level encryption to protect sensitive data.

• Question 35:

  You are managing a SQL Server 2000 instance which includes a database called Products for Home.com. You decide to install a SQL Server 2008 instance for business. You should make sure that third-party applications could run normally on both database instances, you could get the results by conforming to the listed conditions:1. The existed application environments keep common. 2. Minimal database administrative effort.Which is the correct answer?

  A. You should update the SQL Server 2000 application to utilize SQL Server 2008.
  B. You should update the SQL Server 2000 instance application to utilize SQL Server 2008 instance.
  C. Before setting the new application to utilize the new instance. You could install SQL Server 2008 as a named instance
  D. Before setting the new application to utilize the default instance. You could install SQL Server 2008 as a named instance
  C. Before setting the new application to utilize the new instance. You could install SQL Server 2008 as a named instance

• Question 36:

  You administer a SQL Server 2008 instance that runs on a Windows Server 2003 computer. The instance uses mixed authentication mode.

  You need to ensure that the SQL Server 2008 authenticated logins follow the same password complexity rules that are enforced by Windows Server 2003. You also need to ensure that the password complexity rules continue to be enforced.

  Which two actions should you perform? (Each correct answer presents part of the solution.

  Choose two.)

  A. Use the ALTER LOGIN ... HASHED statement to modify all logins.
  B. Use the ALTER LOGIN ... CHECK_POLICY = ON statement to modify all logins.
  C. Use the ALTER LOGIN ... CHECK_EXPIRATION = ON statement to modify all logins.
  D. Use Policy-Based Management to create a policy that prevents any violation of these rules.
  E. Create an SQL Server Agent job that runs periodically to raise an alert if a rule violation is detected.
  B. Use the ALTER LOGIN ... CHECK_POLICY = ON statement to modify all logins.
  D. Use Policy-Based Management to create a policy that prevents any violation of these rules.

• Question 37:

  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. Immediately allow failback
  C. Allow failback only during business horns
  D. Allow failback only during non-business hours
  A. Prevent automatic failback

• Question 38:

  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:

  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. 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)
  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. 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.
  D. 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.

• Question 39:

  You are managing a SQL Server 2008 instance which includes some applications for Home.com.

  You set the SQL Server Agent service to implement through utilizing the SerTest\Test account.

  You create a job named MailingTester that allows a file to be stored to a log server. The job could not run normally because it could not own proper access to the log server.

  You decide to set the service of SQL Server Agent.

  You should make sure that you could run the settings such that the SQL Server Agent service owns all access to the log server. Which is the correct answer?

  A. You should utilize the type of Domain account
  B. You should utilize the type of remote System account
  C. You should utilize the type of remote Service account
  D. You should utilize the type of Local Service account
  A. You should utilize the type of Domain account

• Question 40:

  You maintain a SQL Server 2008 instance.

  You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night.

  You need to enforce a mail retention policy to delete copies of automatically generated mails after 60 days.

  Which process should you use?

  A. Set the Subscription retention interval to delete mails after 60 days.
  B. Set the MailProfile property of a Management Policy on the Server facet to delete mails after 60 days.
  C. Create a SQL Agent job to use the sysmail_delete_log_sp stored procedure to delete mails older than 60 days.
  D. Create a SQL Agent job to use the sysmail_delete_mailitems_sp stored procedure to delete mails older than 60 days.
  D. Create a SQL Agent job to use the sysmail_delete_mailitems_sp stored procedure to delete mails older than 60 days.