Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 121:

  You are mastering the company database, with a SQL Server 2008 computer called SQLTEST1.There are three examples of SQL Server in the SQLTEST1.The ability to connect to the dedicated administrative connection on every example of SQL Server should be included in the disaster recovery plan of the company. You find that you could connect to the connection on SQLTEST1 default example while testing this ability; you could not connect to the dedicated connection on the two other examples on SQLTEST1. You should clarify that the examples are implementing and that client applications should be able to approach them. You should make sure that no other administrators are attempting to connect to any dedicated connections on SQLTEST1. You should also make sure that you could connect to the dedicated connection on all three examples. Which is the correct answer?

  A. You should begin the SQL Server Browser service. Set the service to run automatically.
  B. You should utilize the IIS tool to make the dedicated administrative connection.
  C. You should stop and restart the default examples of SQL Server.
  D. You should reset the default example to utilize a default port amount other than 1434.
  A. You should begin the SQL Server Browser service. Set the service to run automatically.

• Question 122:

  You are a database administrator for your company. The company uses a SQL Server 2008 database that includes a table named Inventory.

  The table contains a column named Price. A company policy states that the value in the Price column cannot be decreased by more than 10 percent in any single database operation.

  Updates to the Price column are made by various means, including by using ad hoc queries. You need to ensure that this company policy is enforced. What should you do?

  A. You should develop a trigger which rolls back changes to the Price column which breaks company policy.
  B. On the Price column, you should develop a primary key constraint to a table which includes valid prices.
  C. You should develop a view which rolls back changes to the Price column which breaks company policy.
  D. You should develop a stored procedure which allows changes to the Price column which breaks company policy.
  A. You should develop a trigger which rolls back changes to the Price column which breaks company policy.

• Question 123:

  You administer three SQL Server 2008 instances named Instance1, Instance2, and Instance3. Each of the three instances runs on a separate server. A mission-critical database is mirrored between Instance1 and Instance2. Instance3 is

  configured as the witness. Instance1 is configured as the Principal. You plan to apply an update to the servers that run Instance1 and Instance2. The update requires a restart.

  You need to ensure that the servers meet the following requirements during the update process:

  What should you do?

  A. Install the update on the server that runs Instance2. Perform a manual failover of the mirroring session. Install the update on the server that runs Instance1.
  B. Remove the mirroring session. Install the update on both servers. Re-establish the mirroring session.
  C. Remove the mirroring session. Run the SQL Server 2008 Upgrade Advisor Install the update on both servers. Re-establish the mirroring session.
  D. Suspend the mirroring session Install the update on both servers.
  E. Suspend the mirroring session. Install the update on the server that runs Instance2. Resume the mirroring session. Perform a manual failover of the mirroring session. Install the update on the server that runs Instance1.
  E. Suspend the mirroring session. Install the update on the server that runs Instance2. Resume the mirroring session. Perform a manual failover of the mirroring session. Install the update on the server that runs Instance1.

• Question 124:

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

• Question 125:

  You administer a SQL Server 2008 instance that contains a database named AdventureWorks.

  The AdventureWorks database contains a table named OrderDetail. You plan to export all data from this table to a file.

  You need to ensure that the following data export requirements are met:

  A Microsoft Office Open XML document format is used The data export process is saved for reuse.

  What should you do?

  A. Run the SQLCmd utility and save the output to a file.
  B. Run the SQL Import and Export Data Wizard and save the output to a file.
  C. Run the bulk copy program utility along with a format file and an output file.
  D. Run the bulk copy program utility along with an output file and no format file.
  B. Run the SQL Import and Export Data Wizard and save the output to a file.

• Question 126:

  You administer a Microsoft SQL Server 2008 R2 database instance.

  You plan to automate maintenance tasks.

  What task types are included in a SQL Maintenance Plan? (To answer, drag the component to the correct task or tasks in the answer area. The component may be used once or more than once. Each task may be used once or not at all.

  Additionally, you may need to drag the split bar between panes or scroll to view content.)

  Select and Place:

  

  

• Question 127:

  You maintain a SQL Server 2008 instance.

  You have an existing database maintenance plan that performs the following tasks:

  You need to modify the SQL Server instance such that an e-mail message is sent to the operators when the maintenance plan fails to execute successfully.

  What should you do?

  A. Enable a fail-safe operator for the SQL Server Agent.
  B. Modify the database maintenance plan to e-mail a report to the appropriate operators.
  C. Modify the database maintenance plan to include a Notify Operator task that e-mails the appropriate operators.
  D. Modify the SQL Server Agent job that executes the database maintenance plan to notify the appropriate operators.
  D. Modify the SQL Server Agent job that executes the database maintenance plan to notify the appropriate operators.

• Question 128:

  You administer a SQL Server 2008 instance that has TCP/IP enabled. You need to verify the port that the SQL Server instance listens on. What should you do?

  A. Open SQL Server Configuration Manager Expand the SQL Server Network Configuration service. Select the Protocols for (InstanceName) service. In the right panel, right-click TCP/IP, select the Properties option, and then select the IP Addresses tab.
  B. Open SQL Server Configuration Manager Select the SQL Server Services service. In the right panel, right-click SQL Server Browser, right-click Properties, and then select the Advanced tab.
  C. Open SQL Server Configuration Manager Select the SQL Server Services service. In the right panel, right-click SQL Server (InstanceName), right-click Properties, and then select the Advanced tab.
  D. Open SQL Server Configuration Manager Expand the SQL Native Client 10.0 Configuration service. Select the Client Protocols service. Select the Properties option.
  A. Open SQL Server Configuration Manager Expand the SQL Server Network Configuration service. Select the Protocols for (InstanceName) service. In the right panel, right-click TCP/IP, select the Properties option, and then select the IP Addresses tab.

• Question 129:

  You administer two SQL Server 2008 instances named Instance1 and Instance2.

  A database named Customers resides on Instance1. You move the Customers database from Instance1 to Instance2.

  A SQL Server login named User1 that has the password "111999" is used by a user to access the database on Instance1. You create the same SQL Server login on Instance2.

  The user attempts to access the Customers database on Instance2 by using the SQL Server login User1. However, the user receives an error message which indicates that the access to the Customers database is denied.

  You need to ensure that User1 can access the Customers database.

  Which Transact-SQL statements should you execute on Instance2?

  A. USE Customers; ALTER USER User1 WITH LOGIN = User1;
  B. USE Customers; ALTER USER User1 ENABLE;
  C. USE Customers; ALTER LOGIN User1 WITH PASSWORD = '111999' UNLOCK;
  D. USE Customers; ALTER LOGIN User1 WITH DEFAULT_DATABASE = Customers;
  A. USE Customers; ALTER USER User1 WITH LOGIN = User1;

• Question 130:

  You maintain a SQL Server 2008 instance that contains a database named Finance.

  The Finance database contains the following filegroups:

  The PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume.

  A filegroup named Histoiy that contains historical data stored in the G: volume.

  The transaction log of the database is stored in the H: volume.

  As part of the archiving strategy for the Finance database, data is frequently moved from the PRIMARY filegroup to the History filegroup.

  The backup strategy for the Finance database consists of the following requirements:

  Backing up the PRIMARY filegroup five times a day

  Backing up the History filegroup at the end of each working day

  Backing up the transaction log every 15 minutes

  At 13:00 hours, the volume that contains the History filegroup fails. You need to restore the database by ensuring minimal data loss in minimum possible time.

  What should you do?

  A. Restore the most recent backup of the History filegroup.
  B. Restore the most recent backup of the History filegroup. Restore all the transaction log backups after the most recent backup of the History filegroup.
  C. Backup the transaction log. Restore the most recent backup of the History filegroup. Restore all the transaction log backups after the most recent backup of the History filegroup.
  D. Backup the transaction log. Restore the most recent backup of the PRIMARY filegroup. Restore the most recent backup of the History filegroup. Restore all the transaction log backups after the most recent backup of the History filegroup.
  C. Backup the transaction log. Restore the most recent backup of the History filegroup. Restore all the transaction log backups after the most recent backup of the History filegroup.