Note: The answer is for reference only, you need to understand all question.

QUESTION 1
Which of the following is not a recommendation when you install Microsoft Dynamics GP 2010?

A.
Limit network to one protocol

B.
Utilize Shared Memory or VIA

C.
Remove unused network protocols

D.
Ensure that each computer has a unique IP address



Answer: B


QUESTION 2
Which of the following SQL Server installation options are supported by Microsoft Dynamics GP? Mark all that apply.

A.
Mixed Mode Authentication

B.
Named Pipes

C.
Sort Orders other than DOCI or Binary

D.
Install to a default instance of SQL Server 2008



Answer: AD


QUESTION 3
Which of the following is a limitation when using Microsoft Dynamics GP 2010 with SQL Server 2008 Express?

A.
Two company databases

B.
4 GB database size

C.
10 client workstation installations

D.
10 concurrent users



Answer: B


QUESTION 4
Which of the following statements is TRUE regarding ODBC data source setup during the installation of Microsoft Dynamics GP?

A.
The name of the data source is configurable during the installation

B.
By default, the data source is automatically created and named Dynamics GP

C.
It is not possible to opt out of the data source being automatically created

D.
No data source is necessary to use Microsoft Dynamics GP2010



Answer: B


QUESTION 5
When performing a basic installation in Microsoft Dynamics GP Utilities, what are the default settings?

A.
The Account Framework has a maximum number of segments of 5; the length of each segment is 9;

B.
and there are no sorting options. -

C.
The
DYNAMICS database files are created at the default locations defined in the
SQL Server. -

D.
The system password is blank.



Answer: ABCD


QUESTION 6
When you are performing an Advanced installation in Microsoft Dynamics GP Utilities, what is the maximum account framework?

A.
66 characters with 10 segments, no storage size limitation

B.
82 characters with unlimited segments, and a storage size of 82 bytes

C.
Unlimited characters with 10 segments, and no storage size limitation

D.
66 characters with 10 segments, and a storage size of 82 bytes



Answer: D


QUESTION 7
What changes are made to the SQL Server after the DYNAMICS database is initialized?

A.
The DYNAMICS database is created,

B.
tables are added to the database, the DYNGRP, DYNWORKFLOWGRP,

C.
and RAPIDGRP roles are created, and the DYNSA user is created.

D.
None



Answer: ABC


QUESTION 8
Which of the following tasks can you complete using Microsoft Dynamics GP Utilities? Mark all that apply.

A.
Add Sample Company Data

B.
Add a Company

C.
Create a Client Package

D.
Set up Microsoft Dynamics GP Security



Answer: AB


QUESTION 9
Creating the sample company in Microsoft Dynamics GP Utilities will do which of the following? Mark all that apply.

A.
Create the sample company database TWO in SQL Server

B.
Copy all settings from a live company to the sample company

C.
Add data to the tables in the TWO database for testing and troubleshooting purposes

D.
Create the role SAMPLE in the SQL Server



Answer: AC


QUESTION 10
What is the name of the log file that is created during the installation of Microsoft Dynamics GP?

A.
duinstall.log

B.
GPSInstall.txt

C.
GPLoginErrors.log

D.
DynamicsGPInstall.log



Answer: D


QUESTION 11
test your knowledge of this section.

A.
Microsoft Dynamics GP Utilities creates the DYNAMICS system database.

B.
Modify the dexini file to create a DEXSQL.log.

C.
The account framework is set for all companies using Microsoft Dynamics GP Utilities.

D.
TCPIP is the only supported network protocol to use for Microsoft

Dynamics GP.



Answer: ABCD


QUESTION 12
After finishing the installation of Microsoft Dynamics GP on a client workstation, you must complete which of the following tasks?

A.
Launch Microsoft Dynamics GP and log in to synchronize the dictionaries to the account framework

B.
Launch Microsoft Dynamics GP Utilities and log in to synchronize the dictionaries to the account framework

C.
Launch Microsoft Dynamics GP Utilities to initialize the DYNAMICS and company databases

D.
No additional steps are required once the installation is completed



Answer: B


QUESTION 13
Which of the following can you include in the client installation package? Choose two correct answers.

A.
Features to be installed

B.
Service packs to be applied

C.
Reports and forms dictionaries paths

D.
Additional products to be installed



Answer: AC


QUESTION 14
How many types of update files can you use for Automatic Updates?

A.
Three. Update installation packages (.msp files), customizations (.cnk files), and dictionary files (.dic files)

B.
Two. Update installation packages (.msp files) and customizations (.cnk files)

C.
One. Update installation packages (.msp files)

D.
Unlimited



Answer: B


QUESTION 15
If a user does not agree to the automatic update, what happens?

A.
The user is forced to install the update

B.
Microsoft Dynamics GP closes

C.
A user can log in and continue to work without the update

D.
A user can log in and continue to work without the update, although the user is not able to enter and post transactions



Answer: B


QUESTION 16
Which file is considered the main business logic or code file for Microsoft Dynamics GP and where is it located?

A.
Dynamics.exe. Stored on the server

B.
Dynamics.exe. Stored on each client computer

C.
Dynamics.dic. Stored on the server

D.
Dynamics.dic. Stored on each client computer



Answer: D


QUESTION 17
Which lines, when set to TRUE in the Dex.ini file, create a dexsql.log file? Mark all that apply.

A.
SQLLogAllODBCMessages

B.
SQLLogSQLStmt

C.
Synchronize

D.
SQLLogODBCMessages



Answer: ABD


QUESTION 18
Can you create a stored procedure from within Microsoft Dynamics GP?

A.
Yes, by using the SQL Maintenance window

B.
Yes, by using Microsoft Dynamics GP Utilities

C.
Yes, but only from the Microsoft Dynamics GP application installed on the SQL server

D.
No, only from within SQL Server Management Studio



Answer: A


QUESTION 19
A new user is created. The user can log in to Microsoft Dynamics GP, but he or she does not have a company to choose. What is the problem?

A.
The user already exists in SQL Server

B.
The user is not logging in to the correct server

C.
The user is supplying the wrong password

D.
The user is not granted access to the company in the User Access Setup window



Answer: D


QUESTION 20
What is the purpose of the System Password?

A.
To grant user access to the system database

B.
To grant the administrator access to Microsoft Dynamics GP

C.
To grant access to the System menus

D.
To grant access to the SQL Server data tables



Answer: C


QUESTION 21
When you attempt to add a new user, the Save button is not available in the User Setup window. What causes this?

A.
User licensing is exceeded

B.
Not being logged in as sa or DYNSA

C.
The User ID already exists

D.
No password is specified for the user



Answer: B


QUESTION 22
Which of the following are elements of security in Microsoft Dynamics GP? Select the three that apply.

A.
Roles

B.
User Classes

C.
Operations

D.
Tasks



Answer: ACD


QUESTION 23
Which of the following describes the default Microsoft Dynamics GP security model?

A.
All users initially have access to only the items required to login plus SmartList

B.
All users initially have access to all items

C.
All users initially have access to only the items required to login plus all inquiry windows and reports

D.
All users initially have access to only the items required to log in to the application



Answer: D


QUESTION 24
Which of the following statements is FALSE regarding the POWERUSER role in Microsoft Dynamics GP?

A.
Grants access to all operations

B.
Overrides other role assignments for a user

C.
Can be modified

D.
Automatically created by the system



Answer: C


QUESTION 25
What window do you use to delete a stranded user from Microsoft Dynamics GP?

A.
The User Activity window in Microsoft Dynamics GP

B.
The User window in Microsoft Dynamics GP

C.
The User Preferences window

D.
Delete the user at the SQL database level in the SQL Server Management Studio



Answer: A


QUESTION 26
What two database options do you need to check to ensure optimal performance? Select the two that apply.

A.
Auto Close

B.
Auto Create Statistics

C.
Auto Shrink

D.
Auto Update Statistics



Answer: BD


QUESTION 27
Which recovery model allows for recovery to a point in time?

A.
Bulk-Logged

B.
Simple

C.
Full

D.
Complete



Answer: C


QUESTION 28
When you are modifying forms and reports, which files must be included in the backup plan? Select the two that apply.

A.
Dynamics.dic

B.
Dyn.dic

C.
Forms.dic

D.
Reports.dic



Answer: CD


QUESTION 29
Which user must be logged in to use the Backup and Restore commands in Microsoft Dynamics GP?

A.
Only sa

B.
Lessonuser1

C.
Any valid user in Microsoft Dynamics GP.

D.
DYNSA or sa



Answer: D


QUESTION 30
Which of the following tasks can you complete using the SQL Maintenance window in Microsoft Dynamics GP? Select the three that apply.

A.
Recompile Stored Procedures

B.
Update Statistics

C.
Check Links for Logical Table Groups

D.
Drop Auto Procedure



Answer: ABD


QUESTION 31
Which of the following database objects cannot be recreated using the Microsoft Dynamics GP Database Maintenance Utility?

A.
Functions and Stored Procedures

B.
Tables

C.
Views

D.
Triggers



Answer: B


QUESTION 32
Which of the following maintenance tasks in the Maintenance Plan Wizard are recommended for Microsoft Dynamics GP? Select the two that apply. (Select all that apply)

A.
Check database integrity

B.
Shrink database

C.
Clean up history

D.
Reorganize Index



Answer: AD


QUESTION 33
What radio button must you select in the File and Printer Sharing window?

A.
Maximize throughput for file sharing

B.
Maximize throughput for local applications

C.
Maximize throughput for printer sharing

D.
Maximize throughput for network applications



Answer: D


QUESTION 34
Put the following items in the recommended order to check for bottlenecks on the server.

A.
MEMORY 1

B.
DISK 2

C.
NETWORK 3

D.
CPU 4



Answer: ABCD


QUESTION 35
What services must be turned off on the Microsoft Dynamics GP data server?

A.
All unused services

B.
All services not necessary for the Microsoft Dynamics GP system

C.
All remote access services

D.
All services except SQL Server service



Answer: A


QUESTION 36
What is the minimum SQL Server memory setting for Microsoft Dynamics GP?

A.
5 MB

B.
5 percent of RAM

C.
25 MB

D.
25-30 percent of RAM



Answer: B


QUESTION 37
Which of the following is a recommendation for RAID with Microsoft Dynamics GP?

A.
Both Software and Hardware level RAID are supported

B.
Always use RAID 1 for log files and RAID 5 for data files

C.
RAID recommendations are based on transaction volume and module use

D.
No RAID recommendations are made for Microsoft Dynamics GP



Answer: C


QUESTION 38
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



Answer: B


QUESTION 39
What information source tracks ODBC messages?

A.
Profiler

B.
DEXSQL.LOG

C.
Event Viewer

D.
SQL Error Logs



Answer: B


QUESTION 40
What lines in the dex.ini file must be set to TRUE to create a dexsql.log file? Mark all that apply.

A.
SQLStmt = TRUE

B.
SQLLogSQLStmt = TRUE

C.
SQLLogODBCMessages = TRUE

D.
SQLLogAllODBCMessages = TRUE



Answer: BCD


QUESTION 41
Where are the SQL Server Error Logs located? Mark all that apply.

A.
SQL Server Management Studio

B.
In the Data folder inside the MSSQL folder in Windows Explorer

C.
In the Log folder inside the MSSQL folder in Windows Explorer

D.
Profiler



Answer: AC


QUESTION 42
Fill in the blanks to test your knowledge.

A.
The Process Server component that manages load balancing is DPM

B.
DPS is the Process Server component that performs selected processes. Load balancing is only available for Services

C.
The number of servers added to each service needs to be Equal

D.
To use the process server, set the Distributed Processes option in the User Preferences window to remote



Answer: ABCD


QUESTION 43
What is a grouping of process servers called?

A.
Load Balancing

B.
Processing

C.
Sending data updates to the server

D.
Managing communication between process servers



Answer: A


QUESTION 44
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



Answer: AD


QUESTION 45
When load balancing is active but the DPM is offline, which Process Server in the Service is assigned all off-loaded tasks?

A.
The fastest Process Server

B.
The Process Server with the least jobs in its queue

C.
The tasks are rotated among the Process Servers in the Service list

D.
The first Process Server in the Service list



Answer: D


QUESTION 46
Put the following steps in order to correctly start the DPM and DPS.

A.
1 : Turn off all computers that are or will be using DPM, DPS orMicrosoft Dynamics GP.
2 : Start the DPM computer.

B.
3 : Launch DPM by dragging the dynamics.set file on top of the dpm.exe file.
4 : Start the DPS computer(s).

C.
5 : Launch DPS by double-clicking dps.exe.

D.
6 : Start all other computers that use Microsoft Dynamics GP.



Answer: ABCD


QUESTION 47
What actions are available for interacting with the processes that are listed in the Process Monitor window? Mark all that apply.

A.
Suspend

B.
Detail

C.
Move

D.
Redisplay



Answer: ABD


QUESTION 48
What window is used to view the Process Server Log?

A.
DPS Server Setup

B.
DPS Setup

C.
User Preferences

D.
Process Server Inquiry



Answer: D


QUESTION 49
Which report type can be printed in place of an existing Microsoft Dynamics GP report?

A.
Custom

B.
Modified

C.
Modified Custom

D.
Single Table



Answer: B


QUESTION 50
Which of the following statements is true concerning Report Writer and Security?

A.
Security is automatically granted to custom and modified reports for all users

B.
Security is not automatically granted to custom and modified reports

C.
Only administrative users can be granted security for custom reports

D.
Security can only be defined by class for custom reports



Answer: B


QUESTION 51
Where in Microsoft Dynamics GP can SQL Server Reporting Service reports be accessed?

A.
Report Lists

B.
Report Writer

C.
Report Catalog

D.
Report Panes



Answer: A


QUESTION 52
Which of the following statements is FALSE regarding the SQL Server Report Wizard?

A.
Users can create either Tabular or Matrix style reports

B.
Report layouts cannot be edited after you use the wizard

C.
The wizard is started from the Business Intelligence Development Studio

D.
Windows or SQL Server authentication can be used



Answer: B


QUESTION 53
Which of the following statements is true regarding the deployment of the Microsoft Office Excel Reports?

A.
They must be deployed after the data connections

B.
Security is defined in Microsoft Dynamics GP

C.
They can be printed in place of standard Microsoft Dynamics GP reports

D.
Only Microsoft Dynamics GP users can access them



Answer: A


QUESTION 54
Which of the following must be completed for you to use a template in place of a standard Microsoft Dynamics GP report? Mark all that apply.

A.
A template is assigned to the company

B.
The report is enabled for templates

C.
A template is assigned to the customer or vendor

D.
The report allows the use of the standard report



Answer: AB


QUESTION 55
If you want to send a standard Microsoft Dynamics GP report by e-mail , you must use which of the following file formats?

A.
HTML

B.
XPS

C.
DOCX

D.
PDF



Answer: A


QUESTION 56
Reports must be published by using which of the following:

A.
Mapped drive

B.
Web site

C.
UNC path

D.
PDF file



Answer: C


QUESTION 57
What lines in the dex.ini file must be set to TRUE to create a dexsql.log file? Mark all that apply.

A.
SQLStmt = TRUE

B.
SQLLogSQLStmt = TRUE

C.
SQLLogODBCMessages = TRUE

D.
SQLLogAllODBCMessages = TRUE



Answer: BCD


QUESTION 58
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



Answer: AD


QUESTION 59
Which report type can be printed in place of an existing Microsoft Dynamics GP report?

A.
Custom

B.
Modified

C.
Modified Custom

D.
Single Table



Answer: B


QUESTION 60
Which of the following statements is FALSE regarding the SQL Server Report Wizard?

A.
Users can create either Tabular or Matrix style reports

B.
Report layouts cannot be edited after you use the wizard

C.
The wizard is started from the Business Intelligence Development Studio

D.
Windows or SQL Server authentication can be used



Answer: B


QUESTION 61
When performing a basic installation in Microsoft Dynamics GP Utilities, what are the default settings?

A.
The Account Framework has a maximum number of segments of 5; the length of each segment is 9;

B.
and there are no sorting options. -

C.
The
DYNAMICS database files are created at the default locations defined in the
SQL Server. -

D.
The system password is blank.



Answer: ABCD


QUESTION 62
After finishing the installation of Microsoft Dynamics GP on a client workstation, you must complete which of the following tasks?

A.
Launch Microsoft Dynamics GP and log in to synchronize the dictionaries to the account framework

B.
Launch Microsoft Dynamics GP Utilities and log in to synchronize the dictionaries to the account framework

C.
Launch Microsoft Dynamics GP Utilities to initialize the DYNAMICS and company databases

D.
No additional steps are required once the installation is completed



Answer: B


QUESTION 63
When you attempt to add a new user, the Save button is not available in the User Setup window. What causes this?

A.
User licensing is exceeded

B.
Not being logged in as sa or DYNSA

C.
The User ID already exists

D.
No password is specified for the user



Answer: B


QUESTION 64
What window do you use to delete a stranded user from Microsoft Dynamics GP?

A.
The User Activity window in Microsoft Dynamics GP

B.
The User window in Microsoft Dynamics GP

C.
The User Preferences window

D.
Delete the user at the SQL database level in the SQL Server Management Studio



Answer: A


QUESTION 65
Which recovery model allows for recovery to a point in time?

A.
Bulk-Logged

B.
Simple

C.
Full

D.
Complete



Answer: C


QUESTION 66
Which of the following database objects cannot be recreated using the Microsoft Dynamics GP Database Maintenance Utility?

A.
Functions and Stored Procedures

B.
Tables

C.
Views

D.
Triggers



Answer: B


QUESTION 67
What lines in the dex.ini file must be set to TRUE to create a dexsql.log file? Mark all that apply.

A.
SQLStmt = TRUE

B.
SQLLogSQLStmt = TRUE

C.
SQLLogODBCMessages = TRUE

D.
SQLLogAllODBCMessages = TRUE



Answer: BCD


QUESTION 68
What is a grouping of process servers called?

A.
Load Balancing

B.
Processing

C.
Sending data updates to the server

D.
Managing communication between process servers



Answer: A


QUESTION 69
What actions are available for interacting with the processes that are listed in the Process Monitor window? Mark all that apply.

A.
Suspend

B.
Detail

C.
Move

D.
Redisplay



Answer: ABD


QUESTION 70
Which of the following statements is true concerning Report Writer and Security?

A.
Security is automatically granted to custom and modified reports for all users

B.
Security is not automatically granted to custom and modified reports

C.
Only administrative users can be granted security for custom reports

D.
Security can only be defined by class for custom reports



Answer: B


QUESTION 71
Reports must be published by using which of the following:

A.
Mapped drive

B.
Web site

C.
UNC path

D.
PDF file



Answer: C