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.)

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.)

What does the Vendor.SETAUTOCALCFIELDS function call do?

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?

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.)

Which FlowField methods are SIFT Indexes used for?

In which two locations can you start the debugger? (Each correct answer presents a
complete solution. Choose two.)

You need to debug codeunit 80 – Sales Post on a sales order to validate whether the Invoice
variable changes status during the execution of the codeunit. How should you add the
Invoice field to the Watches list in the debugger?

You enhance the standard Fixed Asset table so that a fixed asset record cannot be deleted
when the Blocked field is set to TRUE by adding the following code to the On Delete trigger:
IF Blocked THEN
ERROR(CANNOT_DELETE)
CANNOT_DELETE is a text constant containing the ENU caption “You cannot delete this
record because it is blocked.”.
Against the code, a different developer writes a test function named TestBlockedFixedAsset.
The function must pass successfully when the Blocked field is set to TRUE and the record is
being deleted. The test function contains the following code:
FA.INIT;
FA.”No.” := ‘TEST’;
FA.Blocked:= TRUE;
FA.INSERT;
FA.DELETE (TRUE);
You run the test function but it does not pass successfully. How should you update the test
function code so that it passes successfully?

Which three function types are valid for handler functions? (Each correct answer presents
part of the solution. Choose three.)