Get a complete hold on MB7-702 exam syllabus through Lead2pass training and boost up your skills. No need to hassle if you are stuck in exam difficulties, Lead2pass will assist you right through exam specific preparation material which are updated regularly.

QUESTION 1
In Microsoft Dynamics NAV, for which two actions can you use a Microsoft SQL Server collation? (Each correct answer presents part of the solution. Choose two.)

A.    to specify the sort order to use for Unicode data types per company
B.    as the code page that is used to store non-Unicode character data per company
C.    as the code page that is used to store non-Unicode character data per database
D.    to specify the sort order to use for Unicode data types per database

Answer: CD

QUESTION 2
You have the following C/AL code segment:
ItemLedgerEntry.SETCURRENTKEY(“Item No.”);
ItemLedgerEntry.FINDSET;
You have the following query, based on the C/AL code segment:
SELECT * FROM “CRONUS International Ltd_$Item Ledger Entry” ORDER BY “Item No_”, “Posting Date”, “Entry No_”
Which two statements are true based on the query? (Each correct answer presents a complete solution. Choose two.)

A.    If the second key in the table is “Item No.”, then it must be disabled. The key “Item No.”, “Posting Date” will be used instead.
B.    The key “Item No.”, “Posting Date” is the first key in the list that starts with the field “Item No.” in the Item Ledger Entry table.
C.    The SQLIndex value of the key “Item No.”, “Posting Date” has been entered with the value “Item No.”.
D.    The SQLIndex value of the key “Item No.” has been entered with the value “Item No.”, “Posting Date”.

Answer: AD
Explanation:
http://msdn.microsoft.com/en-us/library/hh168524(v=nav.70).aspx

QUESTION 3
What does the Vendor.SETAUTOCALCFIELDS function call do?

A.    It removes the automatic calculation of all FlowFields on the vendor record variable when retrieving vendor records from the database.
B.    It sets the automatic calculation of only the first FlowField on the vendor record variable when retrieving vendor records from the database.
C.    It sets the automatic calculation of all FlowFields on the vendor record variable when retrieving vendor records from the database.
D.    It removes the automatic calculation of only the first FlowField on the vendor record variable when retrieving vendor records from the database.

Answer: A

QUESTION 4
You have the following C/AL code:

You must modify code that loops through the purchase lines of a purchase order to sum up the total quantity of items on the order.
You need to select a method to replace the WHAT_FIND_METHOD.
Which method should you use?

A.    FINDLAST
B.    READ
C.    FINDFIRST
D.    FINDSET

Answer: D

QUESTION 5
In SQL Server Profiler you view the following query from Microsoft Dynamics NAV:
SELECT SUM(“Amount”) FROM “CRONUS International Ltd_$Sales Line” WHERE “Document No_” = `ORD-980001′
Which two statements are true? (Each correct answer presents a complete solution. Choose two.)

A.    There is no SumIndexField amount on the Sales Line table for a key that includes the Document No. field.
B.    The MaintainSIFTIndex property is set to FALSE for a key that includes the Document No. field and the Amount field set as SumIndexField.
C.    All keys that include the Document No. field and the Amount field set as SumIndexField are disabled.
D.    There is no SumIndexField Technology (SIFT) bucket enabled in the property SIFTLevelsToMaintain for the Amount field for a key that includes the Document No. field and the Amount field set as SumIndexField.

Answer: AB
Explanation:
http://msdn.microsoft.com/en-gb/library/dd301348.aspx

QUESTION 6
When is the OnAfterGetRecord trigger run in a report object?

A.    After each individual Data Item record is updated.
B.    After each individual DataItem record is retrieved.
C.    Only after the last DataItem record is updated.
D.    Only after the last DataItem record is retrieved.

Answer: B
Explanation:
http://msdn.microsoft.com/en-gb/library/dd301094.aspx

QUESTION 7
You plan to create a Statistics page based on a table with information of training courses sold over time.
You need to create a calculated field with the number of training courses sold and a date filter to make it possible to get figures based on day, week, month, or year.
Which two fields should you create?

A.    Sold Training Courses field with the FieldClass=FlowFilter property and Date field with the FieldClassFlowFilter property
B.    Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClass=FlowFilter property
C.    Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClassFlowField property
D.    Sold Training Courses field with the FieldClass=FlowFilter property and Date field with the FieldClassFlowField property

Answer: B

QUESTION 8
You need to update the Seminar Reg.-Participant List report so that it includes the option field named Status.
Which action should you perform in the Report Designer?

A.    Select the Include Caption check box on the Column row for the Status field.
B.    Add a Column row for the Status field to the Seminar Registration Header data item.
C.    On the DataltemTableView property of the Seminar Registration Header data item, select a key that contains the Status field.
D.    Add a text box for the Status field to the Seminar Registration Header data item.

Answer: B

QUESTION 9
You build a simple sales document list report with the following dataset structure in the Report Dataset Designer:

You design the report layout by using Visual Studio. After saving and compiling the report, you run it to check the result and notice that the Company Name is not shown in the Page Header. When you inspect the text box in the report layout you see that the value equals = Fields’ Name_CompInfo.Value.

A.    Add an appropriate filter to the page header.
B.    Change the value of the text box to Last(Fields!Name_CompInfo.Value, “DataSet_Result”).
C.    Change the value of the text box to = First (Fields!Name_CompInfo.Value, “SataSet_Result”).
D.    Add an appropriate filter to the text box.

Answer: B

QUESTION 10
You need to create a Seminar Statistics page that shows a decimal field by using SumlndexField Technology (SIFT). Which calculation of the CalcFormula method should you use?

A.    LOCKUP
B.    EXIST
C.    SUM
D.    COUNT

Answer: C

If you want to get more MB7-702 exam preparation material,you can download the free demos in PDF files on Lead2pass.It would be great help for you exam.Wish you pass the exam successfully.

www.lead2pass.com/MB7-702.html