MB3-859 - Microsoft Dynamics GP 2010 Financials
Go back to
Microsoft
Example Questions
Which report type can be printed in place of an existing Microsoft Dynamics GP report?
Modified
Which file is considered the main business logic or code file for Microsoft Dynamics GP and where is it located?
Dynamics.dic. Stored on each client computer
Which of the following database objects cannot be recreated using the Microsoft Dynamics GP Database Maintenance Utility?
Tables
When you are performing an Advanced installation in Microsoft Dynamics GP Utilities, what is the maximum account framework?
66 characters with 10 segments, and a storage size of 82 bytes
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?
The user is not granted access to the company in the User Access Setup window
How many types of update files can you use for Automatic Updates?
Two. Update installation packages (.msp files) and customizations (.cnk files)
Where in Microsoft Dynamics GP can SQL Server Reporting Service reports be accessed?
Report Lists
You receive an error message that states "DBMS: 0, GP: 20486." What is the best resource to get more information on the error?
GPS_SQL_Error_Codes table
After finishing the installation of Microsoft Dynamics GP on a client workstation, you must complete which of the following tasks?
Launch Microsoft Dynamics GP Utilities and log in to synchronize the dictionaries to the account framework
Which of the following SQL Server installation options are supported by Microsoft Dynamics GP? Mark all that apply.
Mixed Mode Authentication
Install to a default instance of SQL Server 2008
Which recovery model allows for recovery to a point in time?
Full
Creating the sample company in Microsoft Dynamics GP Utilities will do which of the following? Mark all that apply.
Create the sample company database TWO in SQL Server
Add data to the tables in the TWO database for testing and troubleshooting purposes
Which of the following describes the default Microsoft Dynamics GP security model?
All users initially have access to only the items required to log in to the application
Where are the SQL Server Error Logs located? Mark all that apply.
SQL Server Management Studio
In the Log folder inside the MSSQL folder in Windows Explorer
Fill in the blanks to test your knowledge.
The Process Server component that manages load balancing is DPM
DPS is the Process Server component that performs selected processes. Load balancing is only available for Services
The number of servers added to each service needs to be Equal
To use the process server, set the Distributed Processes option in the User Preferences window to remote
When performing a basic installation in Microsoft Dynamics GP Utilities, what are the default settings?
The Account Framework has a maximum number of segments of 5; the length of each segment is 9;
and there are no sorting options. -
The DYNAMICS database files are created at the default locations defined in the SQL Server. -
The system password is blank.
When you are modifying forms and reports, which files must be included in the backup plan? Select the two that apply.
Forms.dic
Reports.dic
What does the DPM consider when you are deciding which Process Server ina Service is assigned an offloaded task? Mark all that apply.
The speed of the DPS's processor
The number and length of jobs in the DPS queue
Which of the following is a limitation when using Microsoft Dynamics GP 2010 with SQL Server 2008 Express?
4 GB database size
Put the following items in the recommended order to check for bottlenecks on the server.
MEMORY 1
DISK 2
NETWORK 3
CPU 4
What changes are made to the SQL Server after the DYNAMICS database is initialized?
The DYNAMICS database is created,
tables are added to the database, the DYNGRP, DYNWORKFLOWGRP,
and RAPIDGRP roles are created, and the DYNSA user is created.
Which user must be logged in to use the Backup and Restore commands in Microsoft Dynamics GP?
DYNSA or sa
What lines in the dex.ini file must be set to TRUE to create a dexsql.log file? Mark all that apply.
SQLLogSQLStmt = TRUE
SQLLogODBCMessages = TRUE
SQLLogAllODBCMessages = TRUE
Which of the following is a recommendation for RAID with Microsoft Dynamics GP?
RAID recommendations are based on transaction volume and module use
What two database options do you need to check to ensure optimal performance? Select the two that apply.
Auto Create Statistics
Auto Update Statistics
Which of the following is not a recommendation when you install Microsoft Dynamics GP 2010?
Utilize Shared Memory or VIA
Which of the following statements is true concerning Report Writer and Security?
Security is not automatically granted to custom and modified reports
Which of the following can you include in the client installation package? Choose two correct answers.
Features to be installed
Reports and forms dictionaries paths
Which of the following tasks can you complete using Microsoft Dynamics GP Utilities? Mark all that apply.
Add Sample Company Data
Add a Company
Which of the following are elements of security in Microsoft Dynamics GP? Select the three that apply.
Roles
Operations
Tasks
What information source tracks ODBC messages?
DEXSQL.LOG
Put the following steps in order to correctly start the DPM and DPS.
1 : Turn off all computers that are or will be using DPM, DPS orMicrosoft Dynamics GP. 2 : Start the DPM computer.
3 : Launch DPM by dragging the dynamics.set file on top of the dpm.exe file. 4 : Start the DPS computer(s).
5 : Launch DPS by double-clicking dps.exe.
6 : Start all other computers that use Microsoft Dynamics GP.
Which lines, when set to TRUE in the Dex.ini file, create a dexsql.log file? Mark all that apply.
SQLLogAllODBCMessages
SQLLogSQLStmt
SQLLogODBCMessages
Can you create a stored procedure from within Microsoft Dynamics GP?
Yes, by using the SQL Maintenance window
Which of the following statements is FALSE regarding the POWERUSER role in Microsoft Dynamics GP?
Can be modified
test your knowledge of this section.
Microsoft Dynamics GP Utilities creates the DYNAMICS system database.
Modify the dexini file to create a DEXSQL.log.
The account framework is set for all companies using Microsoft Dynamics GP Utilities.
TCPIP is the only supported network protocol to use for Microsoft Dynamics GP.
When load balancing is active but the DPM is offline, which Process Server in the Service is assigned all off-loaded tasks?
The first Process Server in the Service list
What window do you use to delete a stranded user from Microsoft Dynamics GP?
The User Activity window in Microsoft Dynamics GP
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 template is assigned to the company
The report is enabled for templates
Which of the following statements is FALSE regarding the SQL Server Report Wizard?
Report layouts cannot be edited after you use the wizard
What is the minimum SQL Server memory setting for Microsoft Dynamics GP?
5 percent of RAM
What is the purpose of the System Password?
To grant access to the System menus
What is the name of the log file that is created during the installation of Microsoft Dynamics GP?
DynamicsGPInstall.log
What is a grouping of process servers called?
Load Balancing
Reports must be published by using which of the following:
UNC path
If you want to send a standard Microsoft Dynamics GP report by e-mail , you must use which of the following file formats?
HTML
What radio button must you select in the File and Printer Sharing window?
Maximize throughput for network applications
Which of the following tasks can you complete using the SQL Maintenance window in Microsoft Dynamics GP? Select the three that apply.
Recompile Stored Procedures
Update Statistics
Drop Auto Procedure
What actions are available for interacting with the processes that are listed in the Process Monitor window? Mark all that apply.
Suspend
Detail
Redisplay
When you attempt to add a new user, the Save button is not available in the User Setup window. What causes this?
Not being logged in as sa or DYNSA