Help me in Questions about Exam NA 40 - 222

Is there someone which can help me for give me the answer to this questions about Exam NA 40 - 222 ? 1) For unlock a table which is the command ? I remember only 2 of the answer: a) UNLOCKTABLE b) COMMIT c) … d) … 2) In which format you can export a Menu Suite: a) in a file with extension .msn or .txt b) you can’t export Menu Suite c) in a file with extension .fob o .txt 3) Form A calls SINGLE instance of a codeunit and assigns ‘RED’ to a global text variable. Form B call an instance of the same codeunit and assigns the same global variable ‘BLUE’. Form A then calls another function in the codeunit and retrives the value of the global variable. What is the value ? a) Red b) Blue c) Null d) you can’t do this 4) When you displaying subordinate records in a subform what control do you use ? a) You must use a Tablebox b) You usually use a Tablebox c) A picture box d) A text box 5) In a Dataport you have to test the data before to import them. Where do you want to place your code ? a) OnBeforeImport b) OnAfterGetRecord c) OnAfterImportRecord d) OnBeforeEvaluate 6) Sec A: Find(’-’); Do Modify(); While next <>0; Sec B: Find(’-’); Do Ok := Modify(); While next <>0; a) Sec A faster b) Sec B faster c) In Sec a there is an error d) Sec A and Sec B are the same 7) What file is not found (has relational with Multilanguage in client folder? a) *.EXT b) *.STX c) *.CHM d) *.FDB 8) You need to open form to get information form input of the user. What code ? a) FORM.RUN(fordID) b) Create variable type form and code: VAR.RUN c) Creta variable type form and code: VAR.RUNMODAL d) FORM.RUNMODAL(formID) 9) What function should you call in a report OnAfterGetRecord trigger that will still print the record you are currently on: a) CurrReport.SKIP b) CurrReport.BREAK c) Exit d) CurrReport.QUIT 10) You are make a data conversion from legacy system to new one using Dataport but something occur thier is description field contain 80 char and the new description field can take 50 char only. You told our customer about this he told you its fine with first 50 char know what is true way to do this data conversion ? a) Change the new description field properties to take 80 char b) Write code in the table trigger to reed the first 50 char c) Dataport will handle this situations you don’t need to do anything d) You need to write code in Dataport to handle these situations e) Put the data in a variable and then write code to read the first 50 char 11) Your Customer COMPLAIN about report you create he said “the report goes write and every thing is correct but the report very slow” What you have to change to fix this problem ? a) Dataitems b) Filters c) Keys d) DataItemTableView 12) In a Report a user wants to set a filter. What dou you do ? a) Populate DataItemTableView b) Delete DataItemTableView c) Populate DataItemLinkReference d) Delete DataItemLinkReference 13) Max number of menu suite in a DB ? a) 10 b) 15 c) 20 d) Unlimeted 14) Look the following code: VarRecord.field1 := ‘xyz’; VarRecord.modify(); When the change is submitted ? a) A submit is implicitly called after the modify b) When leaving the trigger c) Modify submit the transaction 15) What internal document if we add field in table ? a) Documentation trigger b) Project Log c) Field Description d) Code Command 16) What is the main purpose of a subform ? a) Display information below a form b) Filter a subset of information on a form c) Make a form that is reduced in size d) Display information from another table on a form 17) In a subform, what can’t you insert in it ? a) Tab Menu b) Tablebox c) Picturebox d) Subform 18) Under what circumstances is it possible to run a report in a modal fashion while in the middle of a transaction ? a) if the request form is shown modally before the report b) if the report prepopulates all the needed information on the request form before displayed c) if request form is not shown d) if the report is already been run once and the request form was properly filled in 19) Which property of a label control must be set in order to display a value on the control ? a) labelname b) caption c) textbox d) sourceexpr 20) Which property on a subform control would determine the form to be displayed a) form id b) source datalink c) subform id d) subform link 21) When upgrading Menu Suites if a Menu Item has been added to a Menu Group that is no longer a part of the upgraded Menu Suite. What heppens to the Menu Item? a) Menu Item is deleted b) Menu Item is replaced in a lost items group at the bottom of the menu tree c) Menu Item is place in a deleted item group d) the Menu Item is highlighted at the top of Menu Tree 22) Which of the following even triggers would be found in a table object ? a) OnModify b) OnInit c) OnChange d) OnAfterValidate 23) Which ones starts a transaction ? a) Start Trans b) Insert c) Begin Trans d) Commit 24) Which is not a valid reason to using grouping ? a) to cause the report to print a new page for each salesperson when printing a list of customers b) to print a sub total of the balance field for each salesperson when printing a list of customers c) two cause two or more customer reposts to print simultaneously of each salesperson d) to cause the report to print a sub-heading each time the salesperson code changes when printing a list of customers 25) Which statement best describes how Menu Suite object changes are stored ? a) each changes is stored as a complete list of Menu Suite Menus and Items and replaces the privious b) changes are stored as the difference between the privious Menu Suite level and the current one c) only one Menu Suite level is stored which consists of all Menu Items d) Menu Suite changes are not stored 26) Which is the button to compile an object ? a) F5 b) F9 c) F11 d) F4 27) IF ISCLEAR(WordApp) THEN CREATE(WordApp); a) Word App would be cleared b) the Word Application would be created c) if there is no display for wordapp the one will be created d) Word App would be instantiated if it had not been done already 28) Import text object into object designer. Under what circumstances will the import worksheet be display ? a) will be display if both the imported object and the existing object with the same ID have been modify b) never display c) always display d) if an imported object is different from the existing with the same ID 29) When should modification flag (in the object designer) be turned off ? a) after all changes have been made and the version tag has been updated b) after all changes have been made and the documentation trigger has been populated c) after all changes have been made and before updating the document tag d) before importing the same object for an improvment 30) If i don’t know which server option is currently being used (Navision or SQL Server), which is the command that sohw me this thing ? a) serveroption b) recordlevelllocking c) tablelevelllocking d) locktable 31) When you posting a document for example a Document Header Record is write into a Document Header Table Which is the right command to execute this ? a) dochisthead.copyfield((dochead) b) series of assignement dochisthead.‘Customer No’ := dochead.‘Customer No’ c) transferfield(dochead) d) dochisthead.copy(dochead) 32) in the data conversion portion of a project for the closed invoices and payments, you recommend the data be converted using what method (remember that the data for this conversion has not been throughly tested) ? a) write a dataport to import the data into gen journal line record and use it to call gen jnl-post line code unit. b) write dataport to import the data and insert into the general ledger entry c) write dataport to import the data and insert it into yhe gen journal line d) copy and paste the data from excel into general ledger entry 33) responsable for preparing the objects to be taken to the client site for deployment, many developers modify the opbjects. What is the first step in creating the installation object file ? a) select and compile all objects with your version tag b) select and compile all objects that you have created or modified c) select and compile all objects d) select and compile all marked as modified 34) as a programmer for the data conversion part of a project you are recommended that the current customer balances be converted using what method (remember that this area is complete and the data has been tested) a) write a dataport to import the data into a gen journal line record and use it to call gen jnl-post line code unit b) copy and paste the data from excel into gen ledger entry c) write dataport to import the data and insert it into the gen journal line d) write dataport to import the data and insert it into the general ledger entry 35) which of the following describes tab controls ? a) a tab controls can only contain one tab named General b) must contain a tab named general, any addistional names are specified using the new tabname property c) can contain multiple tabs the name of which are specified using multiple tab property d) can contain multiple tabs the name of which are specified using pagenames property 36) to a function is passed a variable of type REC as a VAR variable. Add some code to the function to check the filters. Is it possible ? Why or why not ? a) yes the record available repesent a set of record from the associated table filter and key b) no only access to one rec c) no although 37) Look the following code: 1 Find(‘-‘) Do Delete(); While next <> 0 2 Find(‘-‘) Do Ok:=Delete(); While next <> 0 3 deleteAll(); What’s the difference ? a: 1 is faster b: 2 is faster c: 3 is faster d: all are the same Thanks to all

quote:

1) For unlock a table which is the command ? I remember only 2 of the answer: a) UNLOCKTABLE b) COMMIT c) … d) …

a table get’s unlocked when a write transaction is finished or interrupted. COMMIT and ERROR will both UNLOCK a table. There are also indirect COMMIT’s (i.e. running a CU without using the return value will unlock the tables modified inside that CU)

quote:

2) In which format you can export a Menu Suite: a) in a file with extension .msn or .txt b) you can’t export Menu Suite c) in a file with extension .fob o .txt

c)

quote:

3) Form A calls SINGLE instance of a codeunit and assigns ‘RED’ to a global text variable. Form B call an instance of the same codeunit and assigns the same global variable ‘BLUE’. Form A then calls another function in the codeunit and retrives the value of the global variable. What is the value ? a) Red b) Blue c) Null d) you can’t do this

BLUE

quote:

4) When you displaying subordinate records in a subform what control do you use ? a) You must use a Tablebox b) You usually use a Tablebox c) A picture box d) A text box

good one, I would say b) but Navision Styleguide might say a)

quote:

5) In a Dataport you have to test the data before to import them. Where do you want to place your code ? a) OnBeforeImport b) OnAfterGetRecord c) OnAfterImportRecord d) OnBeforeEvaluate

a)

quote:

6) Sec A: Find(’-’); Do Modify(); While next <>0; Sec B: Find(’-’); Do Ok := Modify(); While next <>0; a) Sec A faster b) Sec B faster c) In Sec a there is an error d) Sec A and Sec B are the same

d) I would say that Sec A might be slightly faster (not really noticable)

quote:

7) What file is not found (has relational with Multilanguage in client folder? a) *.EXT b) *.STX c) *.CHM d) *.FDB

c)

quote:

8) You need to open form to get information form input of the user. What code ? a) FORM.RUN(fordID) b) Create variable type form and code: VAR.RUN c) Creta variable type form and code: VAR.RUNMODAL d) FORM.RUNMODAL(formID)

This question is not complete. (I guess this is an original MS question). This depends if the form is table related or not: If it is table related, c) and d) are valid answers if the record is retrieved. If it is not table related, only valid answer is c) [code] 9) What function should you call in a report OnAfterGetRecord trigger that will still print the record you are currently on: a) CurrReport.SKIP b) CurrReport.BREAK c) Exit d) CurrReport.QUIT c)

quote:

10) You are make a data conversion from legacy system to new one using Dataport but something occur thier is description field contain 80 char and the new description field can take 50 char only. You told our customer about this he told you its fine with first 50 char know what is true way to do this data conversion ? a) Change the new description field properties to take 80 char b) Write code in the table trigger to reed the first 50 char c) Dataport will handle this situations you don’t need to do anything d) You need to write code in Dataport to handle these situations e) Put the data in a variable and then write code to read the first 50 char

e)

quote:

11) Your Customer COMPLAIN about report you create he said “the report goes write and every thing is correct but the report very slow” What you have to change to fix this problem ? a) Dataitems b) Filters c) Keys d) DataItemTableView

very funny: might be any combination of b), c) and d)

quote:

12) In a Report a user wants to set a filter. What dou you do ? a) Populate DataItemTableView b) Delete DataItemTableView c) Populate DataItemLinkReference d) Delete DataItemLinkReference

c)

quote:

13) Max number of menu suite in a DB ? a) 10 b) 15 c) 20 d) Unlimeted

How many does one need ? [:D] As there is a limitation to 10 MenuSuites for AddOn, I would say 15

quote:

14) Look the following code: VarRecord.field1 := ‘xyz’; VarRecord.modify(); When the change is submitted ? a) A submit is implicitly called after the modify b) When leaving the trigger c) Modify submit the transaction

c)

quote:

15) What internal document if we add field in table ? a) Documentation trigger b) Project Log c) Field Description d) Code Command

That is definitely company policy. I would say a) b) and c)

quote:

16) What is the main purpose of a subform ? a) Display information below a form b) Filter a subset of information on a form c) Make a form that is reduced in size d) Display information from another table on a form

d)

quote:

17) In a subform, what can’t you insert in it ? a) Tab Menu b) Tablebox c) Picturebox d) Subform

d)

quote:

18) Under what circumstances is it possible to run a report in a modal fashion while in the middle of a transaction ? a) if the request form is shown modally before the report b) if the report prepopulates all the needed information on the request form before displayed c) if request form is not shown d) if the report is already been run once and the request form was properly filled in

c)

quote:

19) Which property of a label control must be set in order to display a value on the control ? a) labelname b) caption c) textbox d) sourceexpr

b)

quote:

20) Which property on a subform control would determine the form to be displayed a) form id b) source datalink c) subform id d) subform link

c)

quote:

21) When upgrading Menu Suites if a Menu Item has been added to a Menu Group that is no longer a part of the upgraded Menu Suite. What heppens to the Menu Item? a) Menu Item is deleted b) Menu Item is replaced in a lost items group at the bottom of the menu tree c) Menu Item is place in a deleted item group d) the Menu Item is highlighted at the top of Menu Tree

I have no clue, but I would guess it will be deleted as well.

quote:

22) Which of the following even triggers would be found in a table object ? a) OnModify b) OnInit c) OnChange d) OnAfterValidate

a)

quote:

23) Which ones starts a transaction ? a) Start Trans b) Insert c) Begin Trans d) Commit

b)

quote:

24) Which is not a valid reason to using grouping ? a) to cause the report to print a new page for each salesperson when printing a list of customers b) to print a sub total of the balance field for each salesperson when printing a list of customers c) two cause two or more customer reposts to print simultaneously of each salesperson d) to cause the report to print a sub-heading each time the salesperson code changes when printing a list of customers

c)

quote:

25) Which statement best describes how Menu Suite object changes are stored ? a) each changes is stored as a complete list of Menu Suite Menus and Items and replaces the privious b) changes are stored as the difference between the privious Menu Suite level and the current one c) only one Menu Suite level is stored which consists of all Menu Items d) Menu Suite changes are not stored

b)

quote:

26) Which is the button to compile an object ? a) F5 b) F9 c) F11 d) F4

c)

quote:

27) IF ISCLEAR(WordApp) THEN CREATE(WordApp); a) Word App would be cleared b) the Word Application would be created c) if there is no display for wordapp the one will be created d) Word App would be instantiated if it had not been done already

d)

quote:

28) Import text object into object designer. Under what circumstances will the import worksheet be display ? a) will be display if both the imported object and the existing object with the same ID have been modify b) never display c) always display d) if an imported object is different from the existing with the same ID

b)

quote:

29) When should modification flag (in the object designer) be turned off ? a) after all changes have been made and the version tag has been updated b) after all changes have been made and the documentation trigger has been populated c) after all changes have been made and before updating the document tag d) before importing the same object for an improvment

a)

quote:

30) If i don’t know which server option is currently being used (Navision or SQL Server), which is the command that sohw me this thing ? a) serveroption b) recordlevelllocking c) tablelevelllocking d) locktable

b) I mean I would just check in File,Database, Information [:D]

quote:

31) When you posting a document for example a Document Header Record is write into a Document Header Table Which is the right command to execute this ? a) dochisthead.copyfield((dochead) b) series of assignement dochisthead.‘Customer No’ := dochead.‘Customer No’ c) transferfield(dochead) d) dochisthead.copy(dochead)

c)

quote:

32) in the data conversion portion of a project for the closed invoices and payments, you recommend the data be converted using what method (remember that the data for this conversion has not been throughly tested) ? a) write a dataport to import the data into gen journal line record and use it to call gen jnl-post line code unit. b) write dataport to import the data and insert into the general ledger entry c) write dataport to import the data and insert it into yhe gen journal line d) copy and paste the data from excel into general ledger entry

a)

quote:

33) responsable for preparing the objects to be taken to the client site for deployment, many developers modify the opbjects. What is the first step in creating the installation object file ? a) select and compile all objects with your version tag b) select and compile all objects that you have created or modified c) select and compile all objects d) select and compile all marked as modified

c)

quote:

34) as a programmer for the data conversion part of a project you are recommended that the current customer balances be converted using what method (remember that this area is complete and the data has been tested) a) write a dataport to import the data into a gen journal line record and use it to call gen jnl-post line code unit b) copy and paste the data from excel into gen ledger entry c) write dataport to import the data and insert it into the gen journal line d) write dataport to import the data and insert it into the general ledger entry

can anyone explain what the difference between a and c is ? I would say a)

quote:

35) which of the following describes tab controls ? a) a tab controls can only contain one tab named General b) must contain a tab named general, any addistional names are specified using the new tabname property c) can contain multiple tabs the name of which are specified using multiple tab property d) can contain multiple tabs the name of which are specified using pagenames property

d)

quote:

36) to a function is passed a variable of type REC as a VAR variable. Add some code to the function to check the filters. Is it possible ? Why or why not ? a) yes the record available repesent a set of record from the associated table filter and key b) no only access to one rec c) no although

a)

quote:

| 37) Look the following code: 1 Find(‘-‘) Do Delete(); While next <> 0 2 Find(‘-‘) Do Ok:=Delete(); While next <> 0 3 deleteAll(); What’s the difference ? a: 1 is faster b: 2 is faster c: 3 is faster d: all are the same
[/quote]
3 is fastest, a and b actually do not even work [:D] If you are deleting records in a loop, you must use WHILE FIND(’-’) DO Otherwise the NEXT command skips records. Yes, and please tell me if I would have passed. My last Navision exam is years ago. |
| - |

quote:
quote:

quote:
34) as a programmer for the data conversion part of a project you are recommended that the current customer balances be converted using what method (remember that this area is complete and the data has been tested) a) write a dataport to import the data into a gen journal line record and use it to call gen jnl-post line code unit b) copy and paste the data from excel into gen ledger entry c) write dataport to import the data and insert it into the gen journal line d) write dataport to import the data and insert it into the general ledger entry

can anyone explain what the difference between a and c is ? I would say a)

I think the difference is that in a) you fill a record variable with gen journal line as subtype and then call the codeunit from inside the dataport; in c) you fill the gen journal line table, assigning a journal template name, batch name and line no. to each line, and then use the post function on the general journals form to post all the lines. I would usually choose c), but what would I be recommended as programmer I don’t know! [:D] Anna

Well I hate people studying exams instead of studying Navision… but The key is the line : “(remember that this area is complete and the data has been tested)” Navision recommend that you post each line one at a time (a), the main reason for using a journal (c) is so that you can check the data for errors, and review it prior to posting. (a) is faster than (c) by a lot, especially if you have dimensions. PS anyone ever heard of a client that provides them with fully tested and checked data for a dataconversion.

quote:

PS anyone ever heard of a client that provides them with fully tested and checked data for a dataconversion.
Originally posted by David Singleton - 2005 Oct 20 : 16:25:01

No! That’s why, after having studied Navision, studying exams might also prove useful! [:P] Anna

  1. When upgrading Menu Suites if a Menu Item has been added to a Menu Group that is no longer a part of the upgraded Menu Suite. What heppens to the Menu Item? a) Menu Item is deleted b) Menu Item is replaced in a lost items group at the bottom of the menu tree c) Menu Item is place in a deleted item group d) the Menu Item is highlighted at the top of Menu Tree Ans: b) [OK]

Yes Anna, sad but true.