Question 1.
Which of the following should be done when troubleshooting a problematic SQL Server connection when using the SQL Optimized Adapter? Choose the 3 that apply.

A. Verify the SQL Server is running.
B. Be sure that the user specified in the destination settings has correct security to add to the table
C. Confirm the login and password are correct for the SQL Server.
D. Make sure that Microsoft Dynamics GP is running.

Answer: A, B, C

Question 2.
Custom destinations can be created using?

A. Only one table
B. Multiple tables
C. A maximum of two tables
D. Only transaction tables

Answer: B

Question 3.
With the XML Source Adapter, after you select the XML data file you wish to import from, the Source Settings window appears. 

The Source Settings window contains which of the following settings? Choose the 3 that apply.

A. The File path
B. Filter
C. Use Filter
D. Password

Answer: A, B, C

Question 4.
How do you change the company to which records are going to be integrated when using the SQL Optimized Adapter?

A. Change only the Company Database on the Destination Settings of the integration.
B. Change only the Company that you are logged into when the integration is running.
C. Change both the Company Database on the Destination Settings and the Company that you are logged into.
D. It is not possible to change the company for an existing integration. A new integration would  have to be created.

Answer: A

Question 5.
XML is an abbreviation for?

A. Extensible Markup Language
B. External Markup Language
C. External Migration Language
D. Extensible Media Language

Answer: A

Question 6.
Which of the following resources are recommended when creating a Custom Destination? 
Choose the 3 that apply.

A. Database Diagrams
B. Resource Descriptions in Microsoft Dynamics GP
C. Microsoft Dynamics GP Report Writer
D. Microsoft SQL Query Angler

Answer: A, B, D

Question 7.
What can you do using the XML Source Properties window? Choose the 2 that apply.

A. Add child record sets
B. Add text file sources
C. Add new fields
D. Change the XML source file

Answer: A, C

Question 8.
Which of the following destinations are only available using the SQL Optimized Adapter? Choose the 3 that apply.

A. Sales Order
B. Purchase Order
C. Receiving Transaction Entry
D. Shipping Methods

Answer: B, C, D

Question 9.
There are limitations to the Receiving Transaction integration using the SQL Optimized Adapter.

Which of the following is NOT a limitation?

A. Multicurrency transactions are not supported.
B. Vendor Summary information is not updated automatically during an integration.
C. Sales Document Commitments are not supported
D. Shipment/lnvoice document types cannot be entered

Answer: D

Question 10.
Which of the following is NOT true regarding the SQL Optimized Adapter?

A. General Ledger Transactions can be integrated
B. New records can be inserted
C. Existing records can be updated
D. General Ledger Accounts can be integrated

Answer: C

	Web www.certsbraindumps.com