QUESTION 1
You have created an integration using eConnect. What must be installed to use the integration in a production environment?
A.eConnect full version B.eConnect runtime version C.Integration Manager D.Nothing

Answer: B
Question 2
Where are the business objects that perform data validation and provide the business logic used by eConnect stored?
A.Microsoft Dynamics GP application dictionary B.eConnect application dictionary C.SQL Tables D.SQL Stored Procedures

Answer: D
Question 3
Which of the following statements is true regarding Integration Manager?
A.No knowledge of Microsoft Dynamics GP is required B.No programming knowledge is required C.Does not require licensing D.Does not allow for scripting
Answer: B
Question 4
What are the components of Integration Manager? Choose the 3 that apply.
A.Source Adapters C.Web services D.Integration Manager Engine


Answer: ABD
Question 5
Which of the following statements is false regarding Import Utility?
A.Imports data into any Microsoft Dynamics GP table B.Integrates at the database level C.Performs data validation by applying business logic D.Converts data to valid field types

Answer: C
Question 6
Which of the following database integration tools has built in data validation? Choose the 3 that apply.
A.eConnect B.Web Services for Microsoft Dynamics GP C.Integration Manager D.Dexterity

Answer: ABC
Question 7
Which development tools use eConnect functionality? Choose the 2 that apply.
A.Extender B.Import Utility C.Integration Manager D.Web Services for Microsoft Dynamics GP
Answer: CD
Question 8
What is a non-window field?

A.A field that appears on a window, but cannot be changed
B.A field that is stored in a table, but does not appear on a window
C.A field that is not required
D.A drop-down list field

Answer: B
Question 9
Which of the follow circumstances always causes Import Utility to reject records?
A.Field values exceed the maximum field length B.The source file contains column headings C.Records are duplicates of records already in the table D.Key fields are in lowercase

Answer: C
Question 10
Which of the following is a resource to use when creating an import with Import Utility? Choose the 3 that apply.
A.Microsoft Dynamics GP Database Diagrams B.Microsoft Dynamics GP Resource Descriptions C.Microsoft SQL Server Management Studio D.Microsoft SQL Server Books Online
Answer: ABC
Question 11
What two sets of tables contain the Import Definitions for Import Utility? Choose the 2 that apply.
A.SY50000.idx and SY50000.dat B.SY50100.idx and SY50100.dat C.SY60000.idx and SY60000.dat D.SY50001.idx and SY50001.dat
Answer: AB

What file formats does Import Utility support? Choose the 2 that apply.
A.Tab Delimited file B.SQL database C.Comma Delimited file D.All of the Above

Answer: AC
Question 13
Which of the following actions can be performed by using Import Utility?
A.Insert New Records B.Update Existing Records C.Both Insert and Update D.Delete records

Answer: A
Question 14
When using Import Utility, what happens to invalid data types when they are encountered?
A.Rejected B.Converted C.Ignored D.Translated based on your setup

Answer: B
Question 15
Which of the following types of tables are not recommended as an import destination when using Import Utility? Choose the 2 that apply.
A.Open Tables B.Work Tables C.History Tables D.Master Tables

Question 16
Integration manager can import data in to which of the following?
A.Standard and Modified Microsoft Dynamics GP windows B.Standard Microsoft Dynamics GP windows only C.Standard Microsoft Dynamics GP and third party application windows D.Standard, Modified, and third party application windows

Answer: B
Question 17
To run an integration from within Microsoft Dynamics GP, a user must have access to which of the following security operations?
A.Integration Site Enabler B.Integration Manager C.Integration Tools D.No security is required, security is set at the integration level

Answer: A
Question 18
What is a key reason for selecting an eConnect destination adapter instead of a Microsoft Dynamics GP adapter destination?
A.Ability to integrate based on a schedule B.Potential for better performance with large volumes of data C.Ability to default required fields D.Better data validation
Answer: B
Question 19
Where are Integration Manager registration keys entered?
A.On the server only C.On the first workstation only D.In Microsoft Dynamics GP


Answer: B
Question 20
The IM Registration Utility is found in what location?
A.In the Integration Manager installation directory B.Within the Integration Manager application C.In the Microsoft Dynamics GP installation directory D.Within Microsoft Dynamics GP Utilities

Answer: A
Question 21
You have been asked to create a new integration database for testing purposes; where can the new database be created?
A.Microsoft Dynamics GP Utilities B.Microsoft Dynamics GP C.Integration Manager D.SQL Management Studio
Answer: C
Question 22
The first time Integration Manager is started, which of the following must be done?
A.Locate the Integration Manager database file B.Register Integration Manager C.Start Microsoft Dynamics GP D.Start Microsoft Dynamics GP Utilities
Answer: B
Question 23

A.The 'sa' user must be used for command line integrations B.The user must be a SQL administrator for command line integrations C.The user name and password displays in the login macro file D.The user name and password displays in the launch .bat file

Answer: C
Question 24
Which of the following Integration Manager techniques can be used to ensure that source data values match Microsoft Dynamics GP values?
A.Update B.Translations C.Restrictions D.Transformations

Answer: B
Question 25
Which of the following are prerequisites to install the Microsoft Dynamics GP destination adapter for Integration Manager? Choose the 2 that apply.
A.Microsoft SQL Server 2005 B.Microsoft Dynamics GP C.User must have full, local administrative rights D.User must be a Microsoft Dynamics GP user

Answer: BC
Question 26
Integration Manager databases can be stored as two different file types. What are they? Choose the 2 that apply.
A. .MDB
B. .XML
C. .IMD
D. .DIC

Question 27
In addition to displaying Integration Manager version information, the About Microsoft Dynamics GP Integration Manager window also displays which of the following?
A.Current users B.Registration keys C.Microsoft Dynamics GP version information D.Source and destination adapter information

Answer: D
Question 28
Keys stored in an integrationmanager.ini file on a specific workstation will do which of the following?
A.Be used if no keys exist in the registry B.Be used if selected as the primary keys C.Override the keys in the registry D.Be overridden by keys in the registry

Answer: D
Question 29
What kind of security privileges are required to run an integration?
A.Administrator privileges on the workstation B.Domain administrator privileges C.SQL administrator privileges D.No special privileges are necessary

Answer: A
Question 30
When planning an integration and identifying the source information, which of the following should be considered? Choose the 2 that apply.

B.Preferred destination type C.Possible formats for the source file D.Number of fields to be integrated

Answer: AC
Question 31
The Integration Manager database conversion process creates which of the following files?
A.A converted database only
B.A log file only
C.A converted database and log file D.No files are created as part of the process

Answer: C
Question 32
The IM Registration Utility creates which of the following files?
A.IMReg.sql B.IMReg.xml C.IM.sql D.IM.xml

Answer: B
Question 33
You recently upgraded Microsoft Dynamics GP and Integration Manager. What happens to integrations during the upgrade process?
A.The integrations are upgraded automatically as part of the Microsoft Dynamics GP upgrade process B.The integration database must be upgraded using the Integration Manager Database Conversion window C.No upgrade is necessary; all integrations can be automatically used in the new version D.No upgrade is possible; all integrations must be recreated
Answer: B Question 34

The Integration Manager installation can be repaired using Add/Remove Programs in Control Panel or by using which of the following methods?
A.Using Microsoft Dynamics GP Utilities B.Using Integration Manager Utilities C.Selecting Integration Manager from Microsoft Dynamics GP CD 2 D.Integration Manager can only be repaired from Add/Remove Programs in Control Panel

Answer: C
Question 35
Integrations created in Integration Manager can be customized by using which of the following?
A.Modifier B.Visual Studio C..Net D.VBScripting

Answer: D
Question 36
Your company has specified a password to exceed credit limits in Receivables Management. When creating a Receivables Transaction integration, which of the following security concerns should you consider?
A.The password is not used, and all transactions integrate B.The password must be entered manually by the user running the integration C.The password is entered in destination mapping D.There are no security considerations in this example

Answer: C
Question 37
When the eConnect destination adapter for Integration Manager is installed, what type of eConnect installation is installed?
A.Runtime B.Full C.Integration


Answer: A
Question 38
Which of the following components make up the Integration Manager workspace? Choose the 2 that apply.
A.Menu B.Toolbar C.Navigation Pane D.Ribbon

Answer: AB
Question 39
When installing the eConnect destination adapter for Integration Manager, the specified eConnect user specified must be part of which database role?
A.db_owner B.DYNGRP C.db_datawriter D.DYNWORKFLOWGRP

Answer: B
Question 40
A simple ODBC source allows for which of the following?
A.Connection to a single table or view B.Connection using a SQL statement C.Connection to multiple tables or views D.Connection without a data source defined
Answer: A
Question 41
When creating an integration group, which of the following options are available? Choose the 2 that apply.

A.If document errors, skip document B.If document errors, continue group C.If integration failed, stop group D.If integration failed, skip integration

Answer: BC
Question 42
Which of the following is an available Storage Type for the Integration Log? Choose the 2 that apply.
A.File B.Database C.Spreadsheet D.XML

Answer: AB
Question 43
Data types can be changed within Integration Manager for which source type? Choose the 2 that apply.
A.Simple ODBC source B.Advanced ODBC source C.Text source D.All of the above
Answer: BC
Question 44
What is the best way to limit the data to be integrated to a specific date?
A.Local Translation B.Global Translation C.Filter Restriction D.Order By
Answer: C
Question 45

A.When the integration is saved B.When the destination is mapped C.When a destination is added D.When a source is added

Answer: C
Question 46
As a Technical Support Engineer, you have been asked to create a Sales Order Processing integration. Since there is significant transaction volume each day, you decide to use the eConnect destination adapter in an effort to increase performance. What information do you need to define the destination settings? Choose the 2 that apply.
A.DSN B.Password C.Database ID D.SQL Server Name

Answer: CD
Question 47
Where can you change the maximum number of errors and warnings?
A.In the Relationships window B.In the Source Properties window C.In the Object Browser window D.In the Integration Properties window
Answer: D
Question 48
Which of the following are characteristics of a field marked as a key field in the source properties window?
A.The values in the field must be unique in the source file B.Only fields marked as key fields can be mapped to ID fields C.Must be defined as the relationship between sources D.Must be marked to Show

Question 49
In Integration Manager, what is the definition of a root recordset?
A.The recordset with only one record per parent B.The recordset represented by the cylinder icon C.The recordset with the most key fields D.The recordset at the top level of the destination

Answer: D
Question 50
Which of the following statements is true regarding sources in Integration Manager?
A.A specific source can be used on more than one integration
B.A specific source can only be used on one integration C.Sources are deleted when an integration is deleted D.Sources are user specific

Answer: A
Question 51
If an integration has more than one source query, which of the following statements is true?
A.A relationship between the sources is optional B.There must be more than one source file
C.A relationship must be defined between the sources D.Both source queries must be the same type

Answer: C
Question 52
What is the default value for the maximum number of errors allowed before the integration is stopped by Integration Manager?
A. 1

B. 5
C. 10
D. 25

Answer: C
Question 53
Integration Manager can add a Batch ID for a transaction integration. On the Options tab of the Destination Mapping window, which selection must be made?
A.Set Create New Batch equal to True B.Set Create New Batch equal to Yes C.Set Add New Batch equal to True D.Set Missing Batch equal to Add New Batch

Answer: D
Question 54
Which integration log level is recommended for debugging an integration?
A.Document B.Trace C.Step D.None

Answer: B
Question 55
If you do not select first Row Contains Column Names in the Source properties, what default names are assigned?
A.Column1, Column2, Column3, and so on B.Name1, Name2, Name3, and so on C.F1, F2, F3, and so on D.None of the Above
Answer: C

A.Yes B.No, it integrates into the last company that was logged into C.No, you specify the company in the integration D.No, the integration properties include a company database setting

Answer: A
Question 57
How does Microsoft Dynamics GP define a business object?
A.The window included in a destination
B.A combination of the logic and tables included in a destination C.Any table in Microsoft SQL used by Microsoft Dynamics GP D.Any table group in Microsoft SQL used by Microsoft Dynamics GP

Answer: B
Question 58
How do you change the company to which records integrate when using the eConnect destination adapter?
A.Change only the Company Database in the Destination Settings window of the integration.
B.Change only the company that you are logged into in Microsoft Dynamics GP when the integration is running.
C.Change both the Company Database in the Destination Settings and the company that you are logged into in Microsoft Dynamics GP.
D.It is not possible to change the company for an existing integration. A new integration must be created.
Answer: A
Question 59
How can you preview a Source file?
A.Open the source properties window and go to the Sorting tab B.Open the source properties window and go to the Columns tab C.Right click on the source name


Answer: C
Question 60
Which of the following destination adapters apply business logic when integrating data?
A.Import Utility B.Microsoft Dynamics GP Destination Adapters Only C.eConnect Destination Adapters Only D.Both Microsoft Dynamics GP and eConnect Destination Adapters

Answer: D
Question 61
How does Integration Manager determine the data type for source fields?
A.Prompts user to define B.Reads metadata of source to determine data type C.Guesses based on field content D.It does not make a determination, data types must be manually entered for all fields

Answer: C
Question 62
Which of the following sources allow Integration Manager to create a rejection file?
A.Simple ODBC Source B.SQL Source C.Text Source D.Advanced ODBC Source
Answer: C
Question 63
Where are Pathname translations stored?
A.In the IM.IMD

C.In the IM.dic on each workstation D.In the Dynamics.dic on each workstation

Answer: B
Question 64
What is a key difference between the Simple ODBC and Advanced ODBC sources?
A.Simple ODBC can only pull data from Excel spreadsheets B.Advanced ODBC can only be used by the 'sa' user C.Simple ODBC must be the only source on an integration D.Advanced ODBC requires a SQL statement to be written

Answer: D
Question 65
When an integration is deleted, which of the following items are not deleted at the same time? Choose the 2 that apply.
A.Sources Queries B.Data Sources C.Query Relationships D.Destination Mappings
Answer: AB
Question 66
What is the default Relationship Type?
A.There can be 0 or 1 record in the child for each record in the master B.There must be exactly 1 record in the child for each record in the master C.There can be 0 or more records in the child for each record in the master D.There must be at least 1 record in the child for each record in the master
Answer: C
Question 67

A.Local translations cannot be changed B.Local translations can only be used on the field and integration where they are created C.Global translations can be used on multiple integrations D.Global translations can only be used on integrations with the same destination

Answer: BC
Question 68
When creating a Simple ODBC query to access an Excel spreadsheet, what step must be done in Excel to integrate the data?
A.Give the spreadsheet a name that matches the query name B.Define a named range within the spreadsheet C.Format the spreadsheet as a eneral format D.The first Excel row must have column names

Answer: B
Question 69
Which of the following types of translations can be created? Choose the 2 that apply.
A.Universal Translation B.Global Translation C.Local Translation D.Fixed Translation
Answer: BC
Question 70
What happens when an integration that contains older destination or source adapters is opened?
A.It automatically upgrades, regardless of Integration Manager settings. B.It automatically upgrades, unless "Do Not Automatically Upgrade Sources and Destinations" is selected. C.It never automatically upgrades; the Database Conversion must be run. D.It never automatically upgrades; the adapters must be manually upgraded in Microsoft Access.
Answer: C Question 71

Which of the following actions are required steps to schedule an integration? Choose the 3 that apply.
A.Create a Microsoft Dynamics GP Login Macro B.Create a .BAT file to run an integration C.Create a macro to log out of Microsoft Dynamics GP D.Create a .BAT file to start Microsoft Dynamics GP

Answer: ABD
Question 72
Where are data sources created in Integration Manager stored?
A.On the workstation where they were created B.On the SQL Server C.In the Integration Database D.In the location specified when they are created

Answer: C
Question 73
Where can data sources for Integration Manager be created?
A.In Integration Manager only B.In Control Panel only C.In either Integration Manager or Control Panel D.Only the data source created when Microsoft Dynamics GP is installed can be used in Integration Manager
Answer: C
Question 74
The following are a list of several VBScripting events. Which selection lists the events in the correct order?
A.Before Integration, Before Source, After Source, After Integration B.Before Source, Before Integration, After Source, After Integration C.Before Source, Before Integration, After Integration, After Source D.Before Integration, Before Source, After Integration, After Source

Question 75
VB scripts can be attached at which of the following levels? Choose the 3 that apply.
A.Integration Level B.Field Level C.Translation Level D.Query/Source Level
Answer: ABD