Microsoft 70-432 Online Practice Questions and Exam Preparation

Microsoft 70-432 Online Questions & Answers

• Question 1:

  You administer a remote 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 and triggers the population of multiple tables.

  Users of the application report that the application performance is poor. You suspect that the performance issues are related to blocking.

  You need to monitor the state of the instance at regular intervals without affecting the application performance further.

  Which tool should you use?

  A. SQL Server Profiler
  B. Windows System Monitor
  C. Dynamic Management Views
  D. SQL Server Resource Governor
  C. Dynamic Management Views

• Question 2:

  You administer a SQL Server 2008 instance.

  You use the SQL Server Import and Export Wizard to export data from SQL Server to a Microsoft Excel file.

  You save the package definition to a file.

  You need to reexecute the package from the command line.

  Which utility should you use?

  A. bcp.exe
  B. dta.exe
  C. dtexec.exe
  D. sqlmaint.exe
  C. dtexec.exe

• Question 3:

  You administer a SQL Server 200S instance. A user named Mary reports that she is waiting for a query to complete. You need to ascertain whether the query is blocked. Which tool should you use?

  A. The Windows System Monitor tool
  B. The Database Engine Tuning Advisor tool
  C. The Activity Monitor tool in Microsoft SQL Server Management Studio
  D. The Job Activity Monitor tool in Microsoft SQL Server Management Studio
  C. The Activity Monitor tool in Microsoft SQL Server Management Studio

• Question 4:

  You administer a SQL Server 2008 cluster. You plan to test the failover response of the cluster. You need to implement a manual failover on the cluster.

  Which two actions should you perform? (Each correct answer presents a complete solution. Choose two.)

  A. Restore a backup to the active node.
  B. Remove the shared array from the active node.
  C. Unplug the network cable(s) from the active node.
  D. Use Encrypting File System (EFS) to encrypt the contents of a shared folder on the active node.
  B. Remove the shared array from the active node.
  C. Unplug the network cable(s) from the active node.

• Question 5:

  You administer a Microsoft SQL Server 2008 database for an order-processing application. The following Transact-SQL statements have been run against the database:

  

  You need to ensure that members of the reporting group can use only up to 35 percent of the CPU and up to 45 percent of the available RAM.

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

  You administer a SQL Server 2008 instance that contains a database named SpatialDB. The SpatialDB database includes spatial data types.

  You need to perform a database consistency check on SpatialDB to include the spatial indexes. You also need to ensure that the effect on the database concurrency is minimized.

  Which Transact-SQL statement should you execute?

  A. DBCC CHECKCATALOG (SpatialDB);
  B. DBCC CHECKALLOC (SpatialDB) WITH TABLOCK;
  C. DBCC CHECKDB (SpatialDB) WITH TABLOCK. PHYSICAL_ONLY:
  D. DBCC CHECKDB (SpatialDB) WITH EXTENDED_LOGICAL_CHECKS:
  D. DBCC CHECKDB (SpatialDB) WITH EXTENDED_LOGICAL_CHECKS:

• Question 7:

  You are mastering the company database called TesterDB; the database includes a database that uses SQL Server log shipping. Log shipping will happen half a hour. You should make the full backup.

  In order to cut the net bandwidth utilization when maintenance every night.

  Which is the correct answer?

  A. You should set the database to utilize the bulk-logged recovery model.
  B. You should reproduce only those indexes that ask it every night.
  C. You should add the time during transaction log backups.
  D. You should disable log shipping after the nightly maintenance.
  B. You should reproduce only those indexes that ask it every night.

• Question 8:

  You administer a SQL Server 2008 instance for a company named Contoso Ltd. The instance contains a database named DB1.

  A Windows group named CONTOSO\Managers can access the DB1 database. CONTOSO\Managers is a member of the db_owner role in the DB1 database.

  A Windows user named User1 is a member of the CONTOSO\Managers group.

  You need to ensure that User1 is unable to access the SQL Server instance.

  Which Transact-SQL statement(s) should you execute in the DB1 database?

  A. DROP LOGIN "CONTOSO\User1";
  B. EXEC dbo.sp_droprolemember ' db_owner ', 'CONTOSO\User1';
  C. EXEC dbo.sp_revokedbaccess 'CONTOSO\User1'; EXEC dbo.sp_revokelogin 'CONTOSO\User1';
  D. CREATE LOGIN "CONTOSO\User1" FROM Windows; DENY CONNECT SQL TO "CONTOSO\User1";
  D. CREATE LOGIN "CONTOSO\User1" FROM Windows; DENY CONNECT SQL TO "CONTOSO\User1";

• Question 9:

  You troubleshoot a SQL Server 2008 instance.

  You suspect that an application uses an inefficient locking strategy and causes concurrency problems.

  You need to identify the following:

  Which dynamic management view should you use?

  A. sys.dm_os_waiting_tasks
  B. sys.dm_os_wait_stats
  C. sys.dm_tran_active_transactions
  D. sys.dm_exec_requests
  A. sys.dm_os_waiting_tasks

• Question 10:

  You administer a SQL Server 2008 instance.

  You need to configure the instance to use a single thread for queries that have an estimated execution cost less than 3. Which sp_configure configuration option should you set?

  A. priority boost
  B. precompute rank
  C. max worker threads
  D. query governor cost limit
  E. cost threshold for parallelism
  E. cost threshold for parallelism