Microsoft MB3-861 Online Practice Questions and Exam Preparation

Microsoft MB3-861 Online Questions & Answers

• Question 41:

  You are using the Automatic Updates feature to publish a service pack update. What table does the client workstation check when connecting to the database for updates?

  A. ACTIVITY
  B. DB_Upgrade
  C. Dex_session
  D. SYUPDATE
  D. SYUPDATE

• Question 42:

  What tools are recommended when troubleshooting performance issues with Microsoft Dynamics GP? Choose the 2 that apply.

  A. Dexsql.log
  B. Check Links
  C. SQL Profiler
  D. Windows Advanced System Properties
  A. Dexsql.log
  C. SQL Profiler

• Question 43:

  Which of the following factors determine the frequency and type of backup to use when designing a backup plan for your Microsoft Dynamics GP SQL databases? Choose the 2 that apply.

  A. The acceptable amount of work that can be lost due to failure.
  B. The volume of transactions on the SQL server.
  C. The version of Microsoft SQL server you are running.
  D. The version of your Microsoft Windows operating system.
  A. The acceptable amount of work that can be lost due to failure.
  B. The volume of transactions on the SQL server.

• Question 44:

  Which of the following statements best describe the POWERUSER role? Choose the 2 that apply.

  A. Tasks cannot be assigned to the POWERUSER role.
  B. The sa and DYNSA users are automatically assigned to the POWERUSER role.
  C. Users assigned to the POWERUSER role automatically have access to all modified and custom windows and reports.
  D. When a user is assigned to the POWERUSER role,they cannot be assigned to any other roles.
  A. Tasks cannot be assigned to the POWERUSER role.
  B. The sa and DYNSA users are automatically assigned to the POWERUSER role.

• Question 45:

  When using the Microsoft SQL Server Maintenance Plan Wizard, there are several recommended tasks you can select in the Select Maintenance Tasks window. These include: Choose the 2 that apply.

  A. Clean Up History.
  B. Reorganize Index.
  C. Shrink Database.
  D. Update Statistics.
  B. Reorganize Index.
  D. Update Statistics.

• Question 46:

  When installing Microsoft SQL 2008 for use with Microsoft Dynamics GP, you should select:

  A. Business Intelligence Development Studio.
  B. Client Tools Connectivity.
  C. Integration Services.
  D. SQL Server Books Online.
  B. Client Tools Connectivity.

• Question 47:

  Which command should you use to view the SQL service pack installed on a particular instance of SQL?

  A. Select @@servername
  B. Select @@version
  C. Sp_helpdb
  D. Sp_helpsort
  B. Select @@version

• Question 48:

  What does the DPM consider when you are deciding which Process Server ina Service is assigned an offloaded task? Mark all that apply.

  A. The speed of the DPS's processor
  B. The number of DPSs in the Service
  C. The number of Services defined
  D. The number and length of jobs in the DPS queue
  A. The speed of the DPS's processor
  D. The number and length of jobs in the DPS queue

• Question 49:

  What window is used to view the Process Server Log?

  A. DPS Server Setup
  B. DPS Setup
  C. User Preferences
  D. Process Server Inquiry
  D. Process Server Inquiry

• Question 50:

  You receive an error message that states "DBMS: 0, GP: 20486." What is the best resource to get more information on the error?

  A. SQL Server Books Online
  B. GPS_SQL_Error_Codes table
  C. Microsoft Dynamics GP Online Documentation
  D. Event Logs
  B. GPS_SQL_Error_Codes table