Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 111:

  You are mastering the company database, Users complaints that the SQL Server 2008 application is running slowly. You should check the information of the CPU utilization, disk utilization, and memory utilization. The network should be considered. the detailed information should be checked for the proper example of SQL Server2008.Which is the correct answer?

  A. You should check the proper dynamic management views (DMVs).
  B. In the databases, you should check the distribution of the statistics which are hosted
  C. You should check a statistics update command??s the output.
  D. You should check the recovery model of the master database.
  A. You should check the proper dynamic management views (DMVs).

• Question 112:

  You are managing a SQL Server 2008 computer called SQLTEST1. You should configure the SQL Server service and the SQL Server Agent service to start automatically, and set SQLTEST1 to audit all user names and application names that plan to get information from SQLTEST1. SQLTEST1 must operate auditing always, and you should keep the results for 10 years. Which is the correct answer?

  A. You should disable the C2 Audit Tracing setting on the server properties.
  B. You should create a SQL Server Agent job to run the SQL Trace stored procedure. Configure the job to start when the SQL Server Agent service starts.
  C. You should set the Login auditing setting to both failed and successful logins
  D. You should configure the server authentication mode as SQL Server and Windows Authentication mode.
  B. You should create a SQL Server Agent job to run the SQL Trace stored procedure. Configure the job to start when the SQL Server Agent service starts.

• Question 113:

  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 an Operating System (CmdExec) step. The job continuously fails on this step and throws the following error message:

  "The user does not have sufficient permission to perform the operation."

  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 114:

  You administer a Microsoft SQL Server 2008 R2 database installed along with the default settings.

  You want to migrate a database from a SQL Server 2000 server that is being decommissioned. The application executes a number of Windows command-line calls from stored procedures in the database.

  You need to configure SQL Server 2008 R2 to allow command-line calls from this database.

  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 115:

  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. Run the following statement: EXEC sp_configure 'show advanced options', 1 RECONFIGURE GO EXEC sp_configure 'clr enabled', 1 RECONFIGURE GO
  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 CLRIntegration property to True.
  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. 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.
  D. 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.

• Question 116:

  You administer a SQL Server 2008 instance. The instance contains a database named DB1.

  You plan to allow all the application developers to use SQL Server Profiler to capture traces to troubleshoot the application that uses the database DB1.

  You need to grant the minimum necessary permission to the application developers.

  What should you do?

  A. Grant the appropriate database-level permissions to all database users of the application developers.
  B. Grant the appropriate server-level permissions to all SQL Server logins of the application developers.
  C. Add all the database users of the application developers to a fixed database role.
  D. Add all the SQL Server logins of the application developers to a fixed server role.
  B. Grant the appropriate server-level permissions to all SQL Server logins of the application developers.

• Question 117:

  You are mastering the company database, with SQL Server 2008 computer named SQLDB. The function of the SQLDB is to perform transaction log backups and so on.SQL1 should be reset by another administrator using the tool of SQL Server Surface Area Configuration.

  You should see that SQL1 no longer runs the maintenance tasks automatically. On SQLDB, You should make sure the tasks of the maintenance are finished without menWhich is the correct answer?

  A. You should reset the Web service to log on by using the role of administrator.
  B. You should reset the server so that the SQL Server Agent service starts automatically.
  C. You should reset operate a full backup of the master database by hand.
  D. You should reset SQLDB to use Windows Integrated authentication.
  B. You should reset the server so that the SQL Server Agent service starts automatically.

• Question 118:

  You administer a SQL Server 2008 instance named SQL1. SQL1 contains a database named DB1.

  You create a new user named User1 in the DB1 database. No additional permissions have been assigned to User1 or the public role. User1 will interact with database objects stored in a new schema named Reporting. The other objects in

  the DB1 database are owned by the dbo and are contained in a schema named Operations.

  You need to grant the minimum necessary permission to User1 to create tables and stored procedures in the Reporting schema.

  You also need to ensure that User1 cannot alter any of the objects in the Operations schema.

  Which Transact-SQL statements should you execute?

  A. GRANT CREATE TABLE, CREATE PROCEDURE TO User1; DENY CONTROL ON SCHEMA: Operations TO User1;
  B. ALTER AUTHORIZATION ON SCHEMA::Reporting TO User1;
  C. GRANT CONTROL ON SCHEMA::Reporting TO User1; DENY CONTROL ON SCHEMA::Operations TC User1;
  D. GRANT CREATE TABLE, CREATE PROCEDURE ON SCHEMA: Reporting; TO User1;
  D. GRANT CREATE TABLE, CREATE PROCEDURE ON SCHEMA: Reporting; TO User1;

• Question 119:

  You administer a SQL Server 2008 instance. You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail stored procedure is used to send a large volume of reports

  during business hours. The reports to the manager take a long time to be delivered.

  You need to ensure that the reports to the manager are sent as quickly as possible.

  What should you do?

  A. Add another SMTP account to the existing Database Mail profile.
  B. Configure a new Database Mail profile to be used for the reports to the manager.
  C. Use the (﹊mportance = high parameter when you send the reports to the manager.
  D. Change the Account Retry Attempts option of the Database Mail system properties.
  B. Configure a new Database Mail profile to be used for the reports to the manager.

• Question 120:

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

  You need to configure SQL Server to automatically send an e-mail message when any file in the Finance database increases.

  Which technology should you include in your solution?

  A. SQL Server Profiler
  B. Trace flag
  C. Query notifications
  D. Event notifications
  D. Event notifications