Question 1.
Which of the following is a resource that may be useful in setting up an import?

A. Software Development Kit
B. Resource Descriptions
C. Microsoft SQL Query Analyzer
D. SQL Books Online

Answer: A, B, C

Question 2.
What tables contain the Import Definitions?

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: A, B

Question 3.
What file format does Import Utility support?

A. Tab Delimited file
B. SQL database
C. Comma Delimited file
D. All of the Above

Answer: A, C

Question 4.
Which of the following capabilities does Import Utility possess?

A. Insert New Records
B. Update Existing Records
C. Both Insert and Update
D. Neither, it is a read-only tool

Answer: A

Question 5.
When importing General Journal Transactions with Import Utility, which tables would be required?

A. GL00100
B. GL10000
C. GL10001
D. GL00105

Answer: B, C

Question 6.
When using the Import Utility, what will happen to invalid data types?

A. Rejected
B. Converted and truncated
C. Ignored
D. Translated based on your setup

Answer: B

Question 7.
VB scripts can be attached at which of the following levels?

A. Integration Level
B. Field Level
C. Translation Level
D. Source Level

Answer: A, B, D

Question 8.
Which of the following operating systems are not compatible with Integration Manager Version 8.0?

A. Windows 98/98 SE
B. Windows 95
C. Windows 2000
D. Windows XP

Answer: A, B

Question 9.
When creating a Simple ODBC query to access an Excel spreadsheet, what step must be done in Excel in order to see 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 general format
D. The first Excel row must have column names

Answer: B

Question 10.
It integration is run and a user does not have rights to the window, will the integration fail?

A. No, the Great Plains 8.0 adapter integrates at the table level
B. Yes, the Great Plains 8.0 adapter is a macro interlace integration, thus a user needs  
    permission at the window level
C. No, it depends on the database version you are using
D. No, any user with rights to Integration Manager has rights to the windows

Answer: B

	Web www.certsbraindumps.com