MB7-702 Exam Questions

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

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

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

When is the OnAfterGetRecord trigger run in a report object?

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

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?

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

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?

For each ledger entry table, you have the following table search code segment in the FindRecords function on the Navigate page: You need to replace the IF XXX THEN BEGIN statement...

Which of the following is a use for FlowFields in Microsoft Dynamics NAV?

You have designed a FlowField in a Master table to look at detail information in the Ledger table. You were asked to add a FlowFilter field to the table as well. What is the purpos...

You have created a function in a codeunit. When you set up a parameter you selected VAR. What does that mean?

You have created an XMLPort in C/SIDE. Which of the following is not a trigger in an XMLPort?

You need to create a Role Center page containing a stack of documents. How should you create the activities page?

When does the OnInsert trigger run on a table?

After a new master record is inserted, you notice that many of the fields are populated from other tables. From which tables are the fields populated?

Which three table types belong to the group of configuration tables? (Each correct answer presents a complete solution. (Choose three)

Which two tables are considered master tables? (Each correct answer presents part of the solution. Choose two.)

Which three object types can be created as a Web service? (Each correct answer presents part of solution. Choose three)

When published, which page and table triggers can be run by a user who accesses Microsoft Dynamics NAV from a web service?

You must design an interface that sends email messages automatically during the night. The design needs to minimize future development and maintenance. Which elements should you in...

You need to ensure that code is not run when a process runs from a Web service environment. Which C/AL command should you use?

You need to create an extension codeunit. What does an extension codeunit consist of and how do you use it? (Each correct answer presents a part of the solution. Choose two.)

You need to create a visual interface with Microsoft Dynamics NAV that is embedded on a page. Which interface technology should you use?

Which three object types can be created as web service? (Each correct answer presents part of the solution. Choose two)

What purpose does the code in the OnDelete trigger of a standard master table and a standard supplemental table have in common?

You create a new table with information about DVDs. It is the master table of a Loan add-on. Which name should you give to the table that contains data about the DVDs?

Which statement accurately describes the journal posting routine?

Which three core codeunits does Journal Posting have? (Each correct answer presents part of the solution. Choose three.)

Which Dimension table contains dimension values that are linked to a Seminar Ledger Entry?

How many dimension columns must be created on a Seminar Journal Line Page?

You validate that the Seminar Registration feature follows the standard journal posting process. On which object did you implement the Emptyline function?

You need to ensure that dimension values are updated when you change the global dimensions in the master data table. Which function should you use?

You see the following SQL statements run: Which command(s) have been used to read the data in Microsoft Dynamics NAV?

You add a new key with a number of SumIndexFields to an existing custom table. Users report that creating, modifying, and deleting records in the table takes more time than expecte...

When browsing through the tables of a Microsoft Dynamics NAV database, you see a table that is named CRONUS International Ltd_$17 $1. Which two statements about the CRONUS Internat...

Which group of C/AL functions uses caching on the Microsoft Dynamics NAV Server?

Which two statements about the C/AL LOCKTABLE command are true? (Each correct answer presents a complete solution. Choose two.)

What is the Microsoft Dynamics NAV name for a Microsoft SQL Server index key?

You see the following consecutive SQL statements while profiling: When looking up the C/AL code you see following code: Cust.FINDFIRST; Which C/AL statement on the Cust variable ge...

You write the following C/AL code segment: GLSetup.LOCKTABLE; GLSetup.GET; Which statement is true about the caching of data from the GLSetup table?

You design a new table in Microsoft Dynamics NAV named Circuit. You set the DataPerCompany property to No. You do not change the default keys. What is the name of the clustered ind...

You have developed new functionality and need to show a message by using a dialog box in several languages. How should you create the dialog message?

An application has been multilanguage-enabled. Users report that a number of field names are displayed in English and not in their local language. Which three property misconfigura...

You create a Seminar Charge table with a Type field and a No. field. You need to ensure that lookups always go to the GIL Account table, the Resource table, or the Item table based...

Which statement is true of a setup table for an application area?

You need to create a new transaction document in Microsoft Dynamics NAV. The data structure consists of a header with associated line items. Which pages do you need to create?

You need to add a new field to the Resource table. The field is named LocationType and must have a value of Internal or External. Which data type should you use?