Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 61:

  You administer a Microsoft SQL Server 2008 R2 database instance. The service account used by SQL Server services must not have administrative permissions.

  You configure a new SQL Server Agent job to run every night. One of the steps in the job runs a PowerShell step. The job continuously fails on this step and throws the following error message:

  "The process could not be created for step 1 of job (reason: A required privilege is not held by the client). The step failed."

  You need to ensure that the SQL Server Agent Job executes successfully.

  Which four 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 62:

  You administer a SQL Server 2008 instance and a SQL Server 2005 instance. Both instances run on the same computer. The SQL Server 2008 instance contains a database named WebApplicationDB that uses the Fulltext indexes.

  Several records that include the word "root" are added to the WebApplicationDB database. When the Fulltext index is queried for the word "root," an empty resultset is returned.

  You need to ensure that records that contain the word "root" are returned by the query.

  What should you do?

  A. Rebuild the full-text index.
  B. Add the word "root" to the stop list.
  C. Add the word "root" to the thesaurus file.
  D. Stop and restart the MSFTESQL service.
  A. Rebuild the full-text index.

• Question 63:

  You are managing a SQL Server 2008 instance which includes a database called Products for Home.com. On the Products database, logged operations are executed. You should make sure that the database could be recovered to a special point in time. Which is the correct answer?

  A. You should clarify that the database utilizes the full recovery model.
  B. You should clarify that the database utilizes the half recovery model.
  C. You should clarify that the database utilizes the Transactions Log.
  D. You should clarify that the database utilizes the store procedure.
  A. You should clarify that the database utilizes the full recovery model.

• Question 64:

  You administer a SQL Server 2008 instance. The instance contains databases for a finance application and a manufacturing application. You configure the Resource Governor to limit the maximum CPU query time allowed by the applications. The administrator of the manufacturing application reports that certain reports no longer execute successfully. You need to modify the Resource Governor configuration to allow the manufacturing application to consume more CPU time.

  Which Resource Governor component should you configure?

  A. The workload group that is used by default
  B. The workload group that is used by the finance application
  C. The classifier function that identifies the finance application
  D. The workload group that is used by the manufacturing application
  D. The workload group that is used by the manufacturing application

• Question 65:

  You administer a Microsoft SQL Server 2008 R2 database instance that supports a sales management application.

  Occasionally, users of the application report that they receive a deadlock error. You plan to troubleshoot this error.

  You need to ensure that the instance is configured to capture troubleshooting information that will allow you to isolate the cause of the error.

  Which two 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 66:

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

  The InsightDB database is used by an application that is continuously connected.

  The application uses the INSERT command extensively. The application uses triggers to populate multiple tables.

  You need to ensure that the reports generated by the application using the InsightDB database return current information with minimal negative effects on the application inserts.

  What should you do?

  A. Use the database snapshot feature and configure the application to use the snapshot database.
  B. Set the isolation level to Read Uncommitted for the InsightDB database.
  C. Use the database replication feature and configure the application to use the replicated database.
  D. Set the isolation level to Read Committed Snapshot for the InsightDB database.
  D. Set the isolation level to Read Committed Snapshot for the InsightDB database.

• Question 67:

  You design a maintenance plan for a SQL Server 2008 instance that contains a database named SalesDB.

  The SalesDB database includes spatial indexes to support queries on spatial data.

  You need to perform physical consistency checks on SalesDB. You also need to ensure that the performance effect on the SalesDB database is minimized.

  Which Transact-SQL statement should you execute?

  A. DBCC SYS_CHECK (SalesDB);
  B. DBCC SQLPERF (SalesDB);
  C. DBCC RSPAIRDB (SalesDB);
  D. DBCC CHECKDB (SalesDB);
  A. DBCC SYS_CHECK (SalesDB);

• Question 68:

  You administer a SQL Server 2008 instance.

  A SQL Server Agent job executes every 2 minutes. The job logs information to a text file named SQL1.log located on the E: drive.

  Users report that the server is unresponsive. You discover the following problems:

  You need to find out the cause of the SQL Server Agent service failure.

  Which log should you examine?

  A. SQL1.log
  B. log_xx.trc
  C. ERRORLOG
  D. SQLAGENT.OUT
  D. SQLAGENT.OUT

• Question 69:

  You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains the OrderHistory table. The OrderHistory table is partitioned on the OrderId column. The first partition contains integer values between 1 and 100.000. The second partition contains integer values greater than 100.000. You need to add a new partition that contains integer values greater than 200.000. What should you do?

  A. Create a new partition function.
  B. Alter the existing partition scheme.
  C. Alter the existing partition function by using a Split clause.
  D. Alter the existing partition function by using a Merge clause.
  C. Alter the existing partition function by using a Split clause.

• Question 70:

  You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

  

  Currently, the table is not partitioned and contains no indexes.

  You need to partition the table by year.

  What should you do?

  A. Remove the clustered index from the table.
  B. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
  C. Use the ALTER TABLEstatement to remove the COLLATEoption.
  D. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
  E. Create a new filegroup. Create a new database file. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use ALTER INDEX REORGANIZE statement.
  F. Create a new Filegroup. Create a new database File. Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause. Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
  G. Create a new table. Use the ALTER TABLE statement along with the SWITCH PARTITION clause. Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.
  H. Create a new partition function. Create a new partition scheme. Add a clustered index to place the data onto the partition scheme.
  I. Run the following statement: CREATE PARTITION SCHEME SEC_FG AS PARTITION FUNC_FG ALL TO (SECONDARY);
  J. Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= `PartltionByYear'; @OptionValue= 'true';
  H. Create a new partition function. Create a new partition scheme. Add a clustered index to place the data onto the partition scheme.