I hope all of mibuso users will pass the exam soon.
I need answers about my questions (3,4,5,7,9,13)
If somebody have answers or opinions about the questions, please write the forum. I have tried but I can't find the correct answers
I think 7-)a and 9-)a.
Form A calls on 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'. Forma A then calls another function in the same codeunit and and retrieves the value of the globabl variable. What is the value?
a) Red * (chose a)
b) Blue
c) Null
d) you can't do this
hi guys is there anybody to know this question answer ı think it is blue but ı don't know!!
Form A calls on 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'. Forma A then calls another function in the same codeunit and and retrieves the value of the globabl variable. What is the value?
a) Red * (chose a)
b) Blue
c) Null
d) you can't do this
hi guys is there anybody to know this question answer ı think it is blue but ı don't know!!
yesterday was a good day, I've passed the Development Exam!! \:D/
thanks to all you guys, for helping me.
cure
Hi All,
July 27, 2005 was a nice day too, I've passed the Dev. Exam too..... \:D/
thank alot guys.....
Some Qs that I still remember:
1. An a table containt values 1000,2000,3000,4000,5000,6000. Look the following code. (2 Qs).
FIND('+');
NEXT(-3);
FIND('=');
Position of record?
A. 1000.
B. 2000.
C. 3000.
D. 5000.
E. 6000.
2. Report have 2 Items: Customer and Cust. Ledger Entry which is indented. There Code On OnAfterGetRecord of "Cust. Ledger Entry" : CurrReport.Skip. Which one is TRUE:
a. Current Repot -> stop.
b. Customer -> skip.
c. Cust. Ledger Entry -> skip, Customer -> next record.
d. Customer -> skip, Cust. Ledger Entry -> next record.
3. element (xml?), how to implement it to object.
a. instantiate.
b. language structure.
c. dot operator.
d. ???
4. If you want to run a report modally within process of a form, what have you do?
a. variablereport.RUNMODAL.
b. variablereport.RUN.
c. Set ReqFilterFields value.
d. Create Request form.
5. If you want to run a form and the user information will be used to setup more than one table, what will you do:
a. variableform.RUNMODAL.
b. variableform.RUN.
c. FORM.RUN(FORM::Form_Name,rec).
d. FORM.RUNMODAL(FORM::Form_Name,rec).
1. b
2. a
3. c (not sure)
4. a (not sure)
5. don't know
6. d
7. don't know
8. b
9. don't know
10. b
11. b
12. a
13. don't know
14. CurrReport. SHOWOUTPUT(FALSE) or ......PUT(0=1) and so on
15. a
16. c
17. b
I try the development exam this afternoon. I would be very happy, i you can answer the questions too.
cure
My ans are:
5. a
7. b
8. a
9. a
12. b
13 d.
13 don't know
16. a
Aside from this thread, are they any study guides or development books anyone can recommend to help someone pass the cert. exams? I am looking to get mine but having trouble finding developer content.
1) A client make a mailing with microsoft word combinated with MBS, We use for this.
a)ODBC
b)C/ODBC
c)C/Front
d)Automation Microsfot Word
2) 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
3) You need to open form to get information from input of the user.What code?
a)FORM.RUN(formID)
b)Create variable type form and code : VAR.RUN
c)Create variable type form and code : VAR.RUNMODAL
d)FORM.RUNMODAL(formID)
what do you think about this questions?for 2. question ewerybody say different answer,these are my exam questions.I failed at first time if you help me ı'll be happy.Thank You!!!!
As u said, Integer will take only 4 bytes.If TextMode(True), you are getting 5 bytes... I need more information in this regard.
Can you please tell me how to test this?
I really dont know working with File variables.
Can you send me an example ?
[edited]
Now, I have known that if we have a string variable and the textmode = false then system will also consider one byte (always +1). 8)
That's why I got 5 bytes!
If it uses integer variable I'll absolutely get 4 bytes.
Dearly guy, I think your sample questions are C/Side Introduction exam.
You have memorized them well..
I agree with almost all of Xrivo's answers except no:
1) I choose journal table.
5) Shift+F5
20) int
Don't be chicken, type some more sample questions here.. hehe..
1. Which of the following properties u can change during runtime ?
a) Visible <=
b) Vertglue
c) SourceExpr
2. You are make a data conversion from legacy system to new one using Dataport but something occur thier is description filed contain 80 char and the new description filed can take 50 char only. You told our customer about this he told u its fine with first 50 char know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table trigger to reed the first 50 char
c) Dataport will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle these situations
e) Put the data in variable and then write code to read the first 50 char <=
3. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(true) )
a) 2 byte
b) 4 byte
c) 6 byte <=
d) 8 byte
4. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(false) )
a) 2 byte
b) 4 byte <=
c) 6 byte
d) 8 byte
5. Your customer COMPLAIN about report u create he said "the report goes write and every thing is correct but the report very slow" what u have to change to fix this problem??
a) Dataitems
b) Filters
c) Keys <=
d) DataItemTableView
6. One question was about Process and Transaction in Navision
a) One or more transaction in one Process
b) Zero or more transaction in one Process <=
c) One or more Process in one transaction
d) Zero or more Process in one transaction
e) Transaction and Process doesn’t work together...
7. What is the three primary thing mentions in every report (chose three of six)
a) Company Name <=
b) Page number <=
c) Date and time
d) User name <=
e) Time of work
8. Xfile.EoF how can u represent it in another way
a) Xfile.pos
b) Xfile.read
c) Xfile.len
d) File.read(file.pos)= file.len <=
e) File.read= file.len
9. When 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
10. Form A calls on 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'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red <=
b) Blue <=
c) Null
d) You can't do this
11. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
12. User entering a general journal what are the dimension data flows. (2 Questions on this)
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U <=
b) U to V <=
c) T to Z
d) X to Z
13. Report 2 dataitems “Cust. Ledger Entry” and “Customer”. “Cust. Ledger Entry” is linked and indented. What function do you use to break out of the current record?
a) CurrReport.CLOSE
b) CurrReport.QUIT
c) CurrReport.BREAK
d) CurrReport.SKIP <=
14. When 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
15. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
16. Which type of table has most buss rules?
a) Ledger Table
b) Journal Table <=
c)…
17. A KEY can have at most, how many SumIndexFields?
a) 20 <=
b)…
18. What is the fundamental business rule concerning posting for all functional areas?
a) Take Journal recordsand put them into Ledger Table <=
b)…
19. Two options to open a new card from a list form.
a) F11 & Navigate menu
b) Shift F5 & Navigate Menu <=
c) F11 &??
d) Shift F5 &??
20. Which is not valid code?
a) EXIT;
b) EXIT(Amount);
c) EXIT
d)… <=
21. Choose Repeat ... Until loop instance of a While... Do loop when you
a) Want to bypass test given a set of conditional
b) Want to time the loop
c) Want to see how many conditions are mentioned in your test
d) Want to loop to process at least one <=
22. Which of the following commands would be best to use C/AL return the user ID?
a) UID
b) System.UID
c) USERID <=
d)…
23. Which is not considered a document report?
a) Sales invoice
b) Customer Statement
c) Inventory Order details <=
d) Purchase Order
24. Which command would you place on PreSection trigger prevent the section from printing?
a) CurrReport.ShowOutpu(True)
b) CurrReport.ShowOutpu(False) <=
c)…
25. A list report is report that contains a single Dataitem that is the table being listed. which of the following would be a TRUE statement
a) Only PK (field and description and field can be included in ...
b) Each column on the report containing a field from the table on the data is printed from that table, not brought in or calculated other table <=
c) the report limited to only 65500 lines
d) Each Field other then the PK, must be activated using the CALCFIELD equivalent to?
26. Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField <=
27. In the Dataport field designer the list of source expressions should be what order?
a) Same order as the information in the file <=
b) Same order as the fields in the table
c) Alphabetical order
d) Ordered by data type.
28. Which describes Codeunit?
a) container for all c/al code
b) Container for c/al code <=
c) Measurement of C/AL
d) The editor c/al
29. Witch of the followings is not characteristic of a menu suite?
a) It consist of a set of menu
b) A menu item is the highest level in the tree <=
c) A menu node can be either a menugroup or menusuite
d) A menu group contain a collection of menu nodes
30. Which of the following is not true regarding menus or menusuite?
a) A menu contains content for a specific departmental area <=
b) Menus consist of items, groups and objectives <=
c)…
31. Which is the sales & receivables master table?
a) Salesperson
b) Customer <=
c)…
32. If you want a variable that has been passed to be changed while in the function you can ...
a) Pass it by reference <=
b) Pass it by...
c)…
33. What type of data have whole number and max 100000?
a) Int
b) Decimal
c) Option <=
d) Code
34. Which is unary operator?
a) + <= (You can write VAR := +VALUE)
b) /
c)…
35. Which is not converted automatically?
a) Blob to binary <=
b) Int to dec
c)…
36. Form A calls on 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'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red * (chose a) <=
b) Blue (or <=
c) Null
d) You can't do this
37. How many Indents can a report have?
a) 1
b) 10 <=
c) 100
d) Unlimited
38. What is the use of setting permission in the report?
a) Prevent user from using the report
b) Use this property to give a database object extra permission to perform some operations on one or more tables <=
c)...
39. IF Name <> xRec.Name THEN
ERROR('Bat flies');
Substitute the error message:
a) Name is not present in record
b) Don't changed <=
c) Don't delete
d)...
40. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. if in AfterGetRecord of the dataitem2 I call CurrentReport.Skip, what is the next record?
a) Execute next record (dataitem2) <=
b) Execute next record (dataitem1)
c) Nothing, report stop
d)...
41. How many dataitem at the maximum can we indent in a report?
a) 10 <=
b) 20
c) 100
d) Unlimited
42. Something with NODBC and Multilanguage
a) N/ODBC support Multilanguage <=
b)…
43. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. If in AfterGetRecord of the dataitem2 I call CurrentReport.break, what is the next record?
a) Execute next record (dataitem2)
b) Execute next record (dataitem1) <=
c) Nothing, report stop
d)...
44.
Customer.FIND('+');
Customer.NEXT('-3');
Customer.FIND('=');
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
a) 2000
b) 3000
c) 4000
d) 5000
e) 6000 <=
46. What is the property used for Multilanguage support?
a) Caption
b) CaptionML <=
c)...
47. What of the following is it a File function?
a) WRITELINE
b) EXIST <=
c) BINARYMODE
48. What of the following is it a File method?
a) WRITELINE
b) BINARYMODE
c) CREATE <=
d)...
49. In a report what is trigger that fire before?
a) OnInitReport <=
b) OnPreReport
c) OnPreDataItem
d) OnPostDataItem
50. In a report with request form what is trigger that fire before?
a) OnPreReport
b) OnOpenForm <=
c)...
51. Your customer has bought your product, but your salesperson has talked with him and has said that the latest version of navision has the improvements that are present in add-ons that you will install.
What do you do?
a) Install latest version of navision;
b) Install latest version of navision, along with improvements present in your add-on <=
c)...
52. A subform
a) Have always a table box
b) Have usually a table box <=
c)...
53. If I have a code in the OnLookup table trigger that filters in a record set, how can I delete this filter in a form?
a) You can't
b) Write code in OnLookup form trigger <=
c)...
54. For SumIndexFields what do you use?
a) CALCFIELD
b) CALCSUM <=
c)...
55. In legacy system we have a field of 80 characters. You must import from legacy system to Navision but the new field is 50 characters. What do you do, if the customer has said that it is ok if you import from 80 character fields to 50 character fields.
a) Write code in DataPort to convert
b) You must do nothing: Navision do it for you during assignment
c) Put the data in variable and then write code to read the first 50 char <=
d)…
56. There is a report. We want to add to this report the possibility for the user to choose if show a description. To make this we add a check box. What must we do in the report?
a) Write code in OnPreSection report trigger <=
b)…
57. What is the equivalent of CREATETOTALS function in a report (more or less)?
a) TotalFields <=
b)...
58.
Customer.SETCURRENTKEY("No.");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END
Customer.SETCURRENTKEY("Sales");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END
Customer.SETCURRENTKEY("Sales");
Customer.SETFILTER("Sales",'0');
IF Customer.FIND('-') THEN BEGIN
{code}
END
Which is the code faster?
a) The first one
b) The second one <=
c) The third one
d) All three codes go at same way
(Customer.“Sales” is a Calculated Field: you cannot set the key on a calculated field, the instruction Customer.SETCURRENTKEY(“Sales”) is invalid. If SALES is a normal field the second one is the fastest)
59. What it the key to compile an object from object design?
a) F11 (choose) <=
b) There isn't any key
c)...
60. What is the property to select a subform in a form?
61. When you modify a menusuite, what are the changes that remain?
a) It doesn't save them
b) At level of menu level
c) Maintain all changes
d) Only the last
e) Maintain the difference between the level below <=
62. When you create a development database for a customer that has already the db, what do you do?
a) you make a backup and install them with check..
b) create a backup, create a new DB using client, restore from backup <=
c)...
63. Report with modifications. Which do you modify?
a) the new that is a copy of the original <=
b) the original
c)...
64. How do you launch a Codeunit?
a) CODEUNIT.RUNMODAL(..)
b) CODEUNIT.RUN(..) <=
c)...
65. Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord) <=
d)...
66. Import Dataport. From the first record you can extract all data that you need, following data too (for these you don't care about them). What do you do to skip all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord) <=
67. C/AL language programming. What is true?
a) It derives from Microsoft C#
b) All objects have c/al
c) All object except Menusuite <=
d)...
68. I declare a variable with VAR.
a) You pass a variable by reference rather than by value <=
b) You pass a variable by value rather than by reference
c) You declare a variant variable
d)...
69. XMLPort. How do you calculate flowfield in automatic?
a) Calcfields
b) FieldCalc
c) AutoCalcField <=
d)...
70. In a report a user wants to set a filter. What do you do?
a) Populate DataItemTableView
b) Delete DataItemTableView <=
c) Populate dataitemlinkreference
d) Delete dataitemlinkreference
71. You have a report and you print for all users the same value. Why? (it talk about DataItemTableView)
a) You haven't set table filter <=
b)...
72. Import txt file. When does worksheet appear?
a) Never <=
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
73.
IF NextEntryNo = 0 THEN BEGIN
ResLedgEntry.LOCKTABLE;
IF ResLedgEntry.FIND('+') THEN
NextEntryNo := ResLedgEntry."Entry No.";
NextEntryNo := NextEntryNo + 1;
END;
What does this code do (in posting routines)?
a) It is used to have not record with null value
b) To calculate the next entryno <=
c)...
74. What is the following property false?
a) Autoincremental
b) You can modify the table
c)...
75. You must verify the empty row in the journal when you post. What do you do? the code must be reusable
a) You create a CodeUnit and pass it a record <=
b) You can't, because the table don't accept function
c) You put function in the form
d)...
76.
IF ISCLEAR(WORDAPP)
CREATE (WORDAPP)
WordApp is Automation. What does the code do?
a) Sure I instance a variable
b) If the variable doesn't exist I create it <=
c) Clear the variable
d)...
77. Max number of menu suite in a db?
a) 10
b) 15 <=
c) 20
d) Unlimited
78. In a subform, what can you insert in it?
a) Tab menu
b) Tablebox
c) Picturebox
d) Subform <=
79. What is not true for a blob?
a) You can export only as a bitmap <=
b) You can insert "memowrite"
c) It can contain pictures
d) At maximum 2GB
80. You have a label and you want to change its value at runtime. What do you do?
a) SourceExpr
b) SourceExpr only if exist a text box linked with it
c) Is not possible <=
81. You must import sales order data (they are already verified).
a) And b) two option directly into ledger table
c) Copy in journal table, save and post them
d) Copy in journal table and post them <=
82. Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document <=
i) Ledger + document posting
83. You are posting a journal. What are dimensions that are used?
a) Journal <=
b) Ledger
c) Default
84. In a function with a record as parameter, how can you know witch filters have been applied to it ?
a) GetFilters
b) Impossible
c)…
85. Witch kind of files are not present on the client computer
a) stx
b) etx
c) fob
d)…
86. If you set the SourceExpression of a textbox to a BigText variable, what will be the result?
a) Error
b) Text will be truncated
c)…
87. Almost like the #86, If you have varText := varBigText;
a) Error
b) VarText will be truncated
c)…
88. Outstream.Write. What's an invalid target?
a) Blob
b) Ocx
c) Report <=
d) Automation
89. What is the fundamental business rule concerning posting for all functional areas in navision application?
a) All transactions are posted through the Ledger into the journal
b) All transactions are posted by the user directly into Ledger while the journal is used to track user.
c) All transactions are posted through the journal into the ledger <=
d)…
90. Which of the following characteristics not result of the table relationship?
a) Optimize table records <=
b) Validate entry
c) Perform lookup other tables
d) Automatically propagate changes from one table to other table.
91. Which of the following functional area has more than one Master Table?
a) General Ledger <= (G/L Account, Bank Account)
b) Fixed Assets
c) Inventory
d) Sales & receivables
92. Which data type would be used for a field that has a FieldClass property of Flowfield and a Calc Formula method of sum?
a) Date
b) Boolean
c) Decimal <=
d) Integer
93. Which are the valid "parts" of a table in Navision?
a) Data and Ledgers
b) Data and Properties <=
c) Data and described
d) Source and description
94. Which is not a flowfield type?
a) Lookup
b) Sum
c) Validate <=
d) Count
95. Which is Cash Managements master table?
a) Customer
b) G/L Account
c) Cash Account
d) Bank Account <=
96. In customer table comment field and CalcFormula property is following
EXIST('CommentLine') WHERE (Table Name=CONST(Customer),No.=FIELD(No.)))
Select the item that represents the data type of a command field
a) Boolean <=
b) Binary
c) Integer
d) Decimal
97. Which is true?
a) A field in the master table is table related to the ledger table
b) A field in the Ledger table is table related to the master table <=
c) Master and ledger each have a field that is the table related to the other.
98. 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 <=
99. User make journal entries. What type of form used for that in Navision std.
a) List Form
b) Card Form
c) Worksheet form <=
d) Tabular Form
100. What can we do to access list form from a card form?
a) F5, Selecting lookup MenuItem or F11
b) F5, Selecting ListMenu item or selecting the lookup button on toolbar <=
c) F11, Selecting ListMenu item or selecting the lookup button on toolbar
d) F5, Selecting ListMenu item or selecting the find button
101. What is concatenation?
a) Extracting a string from within another string
b) Creating a new string by alternately taking characters from two other string
c) Combining string values by appending the characters of one to end of the other <=
d) Combining string values by adding the numeric value of one to the numeric value of the other
102. Which is not a report type?
a) Transaction
b) Status <=
c) Document
d) Test
103. A list report that contains 1 dataitem is the table being listed. Which is true?
a) Only the PK field and descriptive field can be included in the report
b) Each column on the report contains a field from the table and the data is printed from that table not brought in or calculated <=
104. Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger entry indented under customer. Which of time following would be easiest way to filter both tables to the same date range
a) Use SETRANGE OnPreReport <=
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table using the DataItemLink property
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
105. The Auto save property on a dataitem in a Dataport tells the dataitem to automatically
a) Replace records that exist in the table during on import
b) Save the file periodically
c) Insert records during on import <=
106. Which is True?
a) Xml ports do not handle xml documents that find and delete data in the db <=
b) Xml ports do can be run from object designer
c) Xml ports will produce proper output
107. Which field in the XMLPort description would be used to identify which table a TagName is equivalent to:
a) Table Name
b) TagType
c) TagName
d) Source type <=
108. In a function, when a parameter is specified as Var it means...
a) The parameter is passed as a variant
b) The parameter is passed by value rather than reference
c) The parameter is passed by reference rather than value <=
109. How can an element of object be addressed in Code?
a) Using Instance of class definition
b) Using normal syntax of structure language
c) Using dot operator <=
d) Using pointer reference
110. What file is not found (has relation with Multilanguage) in client folder?
a) *.ETX
b) *.STX
c) *.CHM <= (Help is only Multilanguage)
d) *.FDB
111. What Internal document if we add field in table?
a) Documentation trigger
b) Project Log <= (The question is about a document not a trigger)
c) Field Description
d) Code Command
112. You need to open form to get information from input of the user.What code?
a) FORM.RUN(FormID)
b) Create variable type form and code: VAR.RUN
c) Create variable type form and code: VAR.RUNMODAL
d) FORM.RUNMODAL(FormID) <=
113. What is the not valid target of WRITELINE?
a) BLOB
b) File
c) Report <=
d) Automation
114. Witch posting routine read the journal table?
a) Post Batch
b) Post Line
c) Check Line <=
115. Witch posting routine writes in to ledger table?
a) Post Batch
b) Post Line <=
c) Check Line
116. Look the following code:
Find(‘-‘)
Do
Delete();
While next <> 0
Find(‘-‘)
Do
Ok:=Delete();
While next <> 0
DeleteAll();
What’s the difference?
a) 1 is faster
b) 2 is faster
c) 3 is faster <=
d) All are the same
117. In a report with 1 DataItem. Witch trigger is not executed if the dataset is empty?
a) OnAfterGetRecord <=
b) OnPostDataItem
c)…
118. In a function with a record as parameter. Can we know witch filters have been applies?
a) NO
b) Yes, the records contain all the information about the filter applied <=
c) Yes, the filters applied to a record are stored in a system variable
119. What is a typical instruction in a check line routine?
a) Validate()
b) Modify()
c) TESTFIELD <=
d)…
120. Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
121. 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 <=
122. 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 <=
d)…
123. How to implement optimistic concurrency (I don’t remember the server type) ?
a) Set a maximum of filters. The server will lock the table (implicit) during the update <=
b) Set a maximum of filters and explicitly call the LOCKTABLE
c)…
124. If a customer wants to be able to change the sorting order of a report without the intervention of a Navision developer, what do you do?
a) Fill the ReqFilterHeading
b) Leave the ReqFilterHeading blank
c) Fill the property
d) Leave the property blank?
e) ReqFilterFields
f) Leave DataItemTableView blank <=
125. In a form create with the form wizard. Witch code is automatically generated?
a) Validate(“No.”) in OnAfterGetRecord <=
b) SETRANGE(“No.”) in OnAfterGetRecord
c) FORM.Save() in OnDeleteRecord()
d) In OnNewRecord
126. In a report, witch instruction do the same task as putting a field name in the totalField property ?
a) CreateTotal <=
b) FlowFiels
c) Sum
d)…
127.
Sec A:
Cust.Setcurrentkey('No.');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec B:
Cust.Setcurrentkey('SalesPerson');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec C:
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
a) Sec A is faster
b) Sec B is faster <=
c) Sec C is faster
d) All took same time
128. A client make a mailing with Microsoft word combinated with MBS, We use for this.
a) ODBC
b) C/ODBC
c) C/Front
d) Automation Microsoft Word <=
129. How many Indents can a report have.
a) 1
b) 10 <=
c) 100
d) Unlimited
130. You are making a data conversion from legacy system to new one
Using DataPort but something occur thier is description filed contain 80 char and the new description filed can take 50 char only.
You told our customer about this he told u its fine with first 50 char
Know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table triggers to reed the first 50 char
c) DataPort will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle this situation <=
e) Put the data in variable and then write code to read the first 50 char <=
131. 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
132. How to implement optimistic concurrency (I don’t remember the server type)?
a) Set a maximum of filters. The server will lock the table (implicit) during the update
b) Set a maximum of filters and explicitly call the LOCKTABLE <=
c) Lock table when you read and you are sure that after you will do an update
d)…
133. Which of the following form control would you use to display subsidiary information on the form?
a) Subform <=
b) Textbox
c) Tablebox
d) Matrixbox
134. How menusuite object changes are stored
a) Each change is stored as a complete list of menusuite menus and items and replaces the previous level
b) Changes are stored as the difference between previous menusuite level and the current one <=
c) Menusuite changes are not stored
135. Which of the following is not true regarding the methods and properties of an Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and properties using the C/AL symbol menu <=
b) Certain methods and properties will not be able to utilized in navision if there is no corresponding data type within navision
c) Knowledge of the relationship between COM data typesand navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an outside application.
136. The main limitation of DataPort as a tool to integrate Navision with an outside application is that requires the outside application to:
a) Initiate all data transfers from itself to Navision by running the DataPort
b) Be certified as Navision compliant
c) Place its data into an ASCII file before the navision DataPort can read <=
d) Know internal data structure of the navision tables to be updated by the DataPort
137. Which of the following is Not true regarding XML TagName field
a) Attributes are entered prior to the elements they define <=
b) TagNames must be entered in order
c) Parent elements must precede their child elements
d) Child elements are indented
138. Which of the following XML port TagName properties selects the field to be mapped to Xml data
a) Source field
b) ReqFilterField
c) Xml Field
d) Field name
139. Which field in the Xml port description would be used to identify which table a tagname is equivalent to?
a) Table name
b) Tag Type
c) Tag Name
d) Source Type
140. You are importing data from outside source into Navision using DataPort the data is in variable format and each field is separated by ampersand. Which of the actions should you perform to be able to import data using DataPort?
a) Change field separator to ampersand
b) Change field delimiter to ampersand
c)…
141. Which of the following dataitem properties would be used to specify which field or fields a Navision Report should Group By.
a) GroupTotalFields
b) Total fields <=
c) GroupByFields
d) Req. file
142. You have set the left margin = 1000 , before printing report the user specifies 15mm left margin in the page setup window. When print the report LeftMargin=?
a) 15mm
b) 10mm
c) 25mm
d) 5mm
143. Which of the following is true regarding the Request Options from Designer?
a) Request options form does not exist
b) To design options tab of options
c) To design all of the tabs of the request form design
144. Which of the following is Not a Valid report component?
a) Control
b) Table form <=
c)…
145. You are designing a report that is going to be run while other users are inserting records into the same transaction tables, using version based Navision server what do you need to do t the report to make sure that the data reported will be a consistent snapshot of the data those transactions
a) You don't need to anything <=
b) You will need to set the transaction type property to SnapShot
c) You will need to set the transaction type property to Browse
d) There is nothing you can do. User will just have to tell all the others
146. Which of the following is true regarding to Automation Sever?
a) C/Side can receive events from components with the Automation events=yes
b) C/Side cannot receive events from outside components
c) C/Side can only receive Com+ components
d) C/Side can receive events from components with the WithEvents=yes
147. Cust. Ledger entry indented under Customer, which of the following would be easiest way to filter both tables to the same date.
a) Add DateFilter to the Req. Filter Fields property of the customer dataitem and link the posting date field of the custLedgerEntry data item to the data filter field of the customer table using the DataItemLink property
b) Add DateFilter to ReqFilterField property of the customer dataitem and use the SetFilter command to filter the posting DateField of the Cust. Ledger Entry table.
c) Use SetFilter
d) Use SetRange
148. Which command would you place OnPreSection trigger prevent the section from printing?
a) CurrReport.Showoutput(True)
b) CurrReport.Section(True)
c) OnReportPrint(true)
d) ShowReport
e) CurrReport.Showoutput(False) <=
149. Which is not true?
a) Local CodeUnits can only be run from other CodeUnits <=
b) CodeUnits can be run from other CodeUnits
c) CodeUnits can be run from other objects <=
d) Other object can be run from CodeUnits
150. Local variables are limited in scope to the function which they are defined
a) Local variables can only be defined in CodeUnits
b) Local variables are reinitialized other execution of a Codeunit has completed <=
c) Local variables can only be declared in local functions
151. In order for an outside application to access data within Navision Server using C/ODBC what must it support?
a) Microsoft Query <=
b) ODBC
c) Sql Server
d) Navision Server
152. We have 2 dataitem one is master (I can't remember I think customer and ship ...), and 10 customers have two ShipToAddress. When the report printed how much footer for ship to addresses?
Ans:???
153. When can change the fieldname in the table?
Ans: I think it should be anytime.
154. How many level of menusuite?
Ans: 20
155. How to run a menusuite?
Ans: You can’t
156. What properties need not be defined for menu item?
Ans: Name
157. List the trigger process order of Dataport.
Ans: OnInit, OnPreDataPort, OnPreDataItem, OnBefore/AfterExportRecord, OnPostDataPort
158. How to call a code unit in another object?
Ans: CODEUNIT.RUN
159. Which is NOT a Form Trigger?
Ans: OnDisposeForm
160. If a field in a table’s editable property set to “No”. Which of the following statement is true?
a) User cannot change the value in the form but can change the value by C/AL code <=
b) User cannot change the value in the form or by C/AL code.
c)…
161. How to describe the relationship between Master table and Ledger table?
a) Ledger table is table-related to master table………. <=
b) Master table is table-related to ledger table……….
c)…
162. Complex data type. More functions in it does they slow down?
Ans: ???
163. A question about: KEYGROUPS of report if customer have report only run at end of year
164. How to handle LockTable for small customer who uses Navision Database Server
Ans: ???
I have a few answers or comments on questions posted by b1gb0ss
#26 The automatic calculation of SumIndexFields - acording to the courseware:
CalcFields: Automaticaly calculates the information for flowfields entered here
AutoCalcFields: Used to determine whether or not the value in the flowfield should be recalulated before the field is exported
#30 B)should say OBJECTS not OBJECTIVES - then the correct answer would be A) Departmental areas
#36 I beleive that the correct answer is C) Null as it is not a 'single instance' so the variable is initialized for each instance so it would be 'Null'
#50 I beleive the correct answer is OnInitReport - this is ALWAYS first - doesn't matter if a request form is uesed or not.
#80 Changing a label - this can be done with the 'Caption' property
#83 Posting a Journal - both Journal and Ledger are used
#85 & #110 - The *.FDB (which is the database) are generaly not on the client unless it is a single user installation
#86 & #87 are both A)Error - I tried it and both will not allow it to be done
#91 Fixed Asstes also has 2 Masters Asset and Insurance
#109 - I am not sure of this one but normally ELEMENT is part of an Array or an XML data - both of these would be used with the pointer or index but if they mean property or field of an object then it is the dot
#111 - I could find no information on the Project Log - where do I find this info?
#114 reading Journal records - again acording to the courseware:
CheckLine - Never reads or writes the Journal Table
Post Line - Never reads or writes Journal table - can read other tables for validation - writes Ledger entry
#119 - In my attempt - I had this but TESTFIELD was not an option, however EMPTYLINE() was an option - I thought that was the correct answer but since you didn't ahve it ... Maybe it is the Validate()
#121 You cannot test data before it is imported but it can betested before processed - I think the answer is OnAfterImport because the courseware states that "Most processing and validation is done in the OnAfterImport trigger"
**Optimistic Concurrency - I am not so optismistic!! The references to this in any of the training or reference material - even in the Installation and Configuration manuals is sketchy at best and does not answer these questions ***
#138 & 139 The property that shows the Field or Table is DataSource that is part of SourceType - in SourceType you choose Text,Field or Table
#148 - just remember that another way towrite this is SHOWOUTPUT(0=1)
#151 - I don't think you must have Ms Query as you can use NODBC in C# or VB as the interface without MSQuery - I don't know this one
Hope this helps.
Does anyone know the answer to:
200) Client wants to have a mailmerge with Navision and Word - they want to be able to add or change fields without help of Navision Developer. What is the best way?
a) Navision to word
b) Word to Navision
C) Navision to world
I passed the exam today. This was my 2nd time. Whew! I will be looking closely at that Master Development Certification because we are upgrading and I am taking the upgrade class. I might as well take the exam too! Then only one more elective to Master Developer.
I know that, when i was registered, vue gave me 2NDFREE as a code, and my local test center couldn't apply with that code...
Well, the history is repeating...Today i've encountered the same problem. My code given by VUE was also 2NDFRE and my local test center say that they cannot apply with this code, because they get an error message saying that this code is not good for MBS exams...
For anyone who have encountered the same problem with 2ndshot promotion code, here is the oficial answear from Microsoft (mention: my company is not a microsoft partner yet):
"From: MBS-Certified Professional Program [mbs-cert@microsoft.com]
To: ...
Hello Anca,
The 2nd shot promo is available to you, I have confirmed with the VUE testing center that this promo is still valid. When you are ready to take the free retake, simply call 1-800-837-8734 and an agent there will verify your exam details. "
C:\tmp>dir
Volume in drive C has no label.
Volume Serial Number is 8062-8483
Directory of C:\tmp
08/09/2005 03:22p 4 withTextModeFalse.txt
08/09/2005 03:22p 6 withTextModeTrue.txt
#114 reading Journal records - again acording to the courseware:
CheckLine - Never reads or writes the Journal Table
Post Line - Never reads or writes Journal table - can read other tables for validation - writes Ledger entry
I found the answer on development book pg44
"The Post Batch routine is the only one that actually reads or updates the journal table;the others simply use the Journal record passed into them."
Q1)Which of the following is NOT true of updating data in Navision using NODBC ?
a-)A Microsoft RAISEERROR will be generated
b-)Data Entered through NODBC will not be validated <--choose
c-)Data will be checked for conformance to Navision data types
d-)Additional fields normally populated in the onValidate trigger
Q2) Exit(True)
a-)Return Boolean value
b-)Will not accept a parameter True
c-)Only executes if it returns a vale <--choose
d-)classes down the Navision client
Hello, I cannot find the answer for the following questions. Please help on it. (The question is not exactly the same wording)
1) Which case to run a report in modal fashion, while within a transaction?
a) If request form is show modal before the report
b) If report populate all need information on request form before display
c) If request form is not shown
d) Report already run once and request form was properly fill in
2) NA Server, customer want to sent customer welcome letter, mail merge. What should be used?
a) Mail merge using CODBC
b) Automation from MS word to Navision
c) Automation from Navision to MS word
d) Mail merge ODBC
Note: I choose B, but not sure.
3) Create a card form by form wizard, what code is added automatically?
a) onAfterGetRecord(), setRange("No");
b) onNextRecord()...
c) onDeleteRecord()...
d) onAfterGetRecord(), validate("No");
Note: I try to create a card form, but I don't find any automatically added code
4) Import AR balance, time is limited, so need to do it quick, how to do it
a) Import into Gen. Journal line, save it, open the journal form, post it
b) Import into Gen. Journal line, without saving, call Code Unit to post it
Note: I am not sure for (b). Is this possible for not saving a Gen. Journal line and post it?
5) About the speed of 3 sample code.
a) SetRange
b) SetFilter
Note: Is there any performance difference by SetRange and SetFilter?
Hi All, I have given the development exam my first try, but i failed Anyway, here are some questions i encounter that I am not sure what the answers are. Can someone help me out on the correct or most likely solutions are to these problems?
1)User entering a general journal what are the dimension data flows.
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U
b) U to V
c) T to Z
d) X to Z
2) Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields <=
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField
3) In a report with request form what is trigger that fire before?
is it oninitreport?
4) Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord)
5) Import Dataport. From the first record you can extract all data that you need, following data too (for these you don't care about them). What do you do to skip all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord)
6) have a report and you print for all users the same value. Why?
7) Import txt file. When does worksheet appear?
a) Never
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
8) You must verify the empty row in the journal when you post. What do you do? the code must be reusable
a) You create a CodeUnit and pass it a record
b) You can't, because the table don't accept function
c) You put function in the form
9) You have a label and you want to change its value at runtime. What do you do?
10) Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document
i) Ledger + document posting
11) You are posting a journal. What are dimensions that are used?
a) Journal
b) Ledger
c) Default
12) Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger entry indented under customer. Which of the following would be easiest way to filter both tables to the same date range
a) Use SETRANGE OnPreReport
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table using the DataItemLink property <=
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
13) What is a typical instruction in a check line routine?
14) Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
a) 1
b) 20 <=
c) 40
d) 100
15) 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
16) Which of the following is not true regarding the methods and properties of an Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and properties using the C/AL symbol menu
b) Certain methods and properties will not be able to utilized in navision if there is no corresponding data type within navision
c) Knowledge of the relationship between COM data types and navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an outside application. <=
17) Which of the following XML port TagName properties selects the field to be mapped to Xml data
a) Source field <=
b) ReqFilterField
c) Xml Field
d) Field name
18) what is not true for a blob?
a) you can export only as a bitmap <=
b) you can insert "memowrite"
c) it can contain pictures
d) at maximum 2GB
19) 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
20) How to implement optimistic concurrency
a) Set a maximum of filters. The server will lock the table (implicit) during the update
c) Set a maximum of filters and explicitly call the LOCKTABLE
21) In a function with a record as parameter. Can we know witch filters have been applies?
a) NO
b) Yes, the records contain all the information about the filter applied
c) Yes, the filters applied to a record are stored in a system variable
22) Which is Not true?
a-)Local Codeuınits can only be run from other codeunits <=
b-)codeunits can be run from other codeunits
c-)codeunits can be run from other objects
d-)other object can be run from codeunits
23) local variables are limited in scope to the function which they are defined_
a-)local variable can only be defined in codeunits
b-)lacal variables are reinitialized other execution of a codeunit has completed
c-)lacal variables can only be declared in local functions <=
24) Which of the following is NOT true of updating data in Navision using NODBC ?
a-)A Microsoft RAISEERROR will be generated
b-)Data Entered through NODBC will not be validated
c-)Data will be checked for conformance to Navision data types
d-)Additional fields normally populated in the onValidate trigger
25) you have set the left margin = 1000 , before printing report the user specifies 15mm left margin in the page setup window. when print the report leftmargin=?
a-)15mm
b-)10mm
c-)25mm
d-)5mm
I am a Technical consultant & thinking to sit for certification by end of this month.Please tell me...
1.What are the documents i should read??
2.Which chapters are very important??
3.What is the code of the exams?
4.what is the system of the exam & how the intreface looks like??
5.Total Marks & Pass Marks??
6.Can i give a demo test in some website?? (as it is available 4 other certification courses like MCSD,MCSE,OCP,..)
May be this questions are already been asked somewhere in this forum...i have searched, could not find ...:(....
Comments
1. Propreties AutoCalcField (TRUE)
4. Use Automation from Navision to World (not sure)
thanks to all you guys, for helping me.
cure
=D>
I hope all of mibuso users will pass the exam soon.
I need answers about my questions (3,4,5,7,9,13)
If somebody have answers or opinions about the questions, please write the forum. I have tried but I can't find the correct answers
I think 7-)a and 9-)a.
thanks all
a) Red * (chose a)
b) Blue
c) Null
d) you can't do this
hi guys is there anybody to know this question answer ı think it is blue but ı don't know!!
answer is A, because of the Single instance
Hi All,
July 27, 2005 was a nice day too, I've passed the Dev. Exam too..... \:D/
thank alot guys.....
Some Qs that I still remember:
1. An a table containt values 1000,2000,3000,4000,5000,6000. Look the following code. (2 Qs).
FIND('+');
NEXT(-3);
FIND('=');
Position of record?
A. 1000.
B. 2000.
C. 3000.
D. 5000.
E. 6000.
2. Report have 2 Items: Customer and Cust. Ledger Entry which is indented. There Code On OnAfterGetRecord of "Cust. Ledger Entry" : CurrReport.Skip. Which one is TRUE:
a. Current Repot -> stop.
b. Customer -> skip.
c. Cust. Ledger Entry -> skip, Customer -> next record.
d. Customer -> skip, Cust. Ledger Entry -> next record.
3. element (xml?), how to implement it to object.
a. instantiate.
b. language structure.
c. dot operator.
d. ???
4. If you want to run a report modally within process of a form, what have you do?
a. variablereport.RUNMODAL.
b. variablereport.RUN.
c. Set ReqFilterFields value.
d. Create Request form.
5. If you want to run a form and the user information will be used to setup more than one table, what will you do:
a. variableform.RUNMODAL.
b. variableform.RUN.
c. FORM.RUN(FORM::Form_Name,rec).
d. FORM.RUNMODAL(FORM::Form_Name,rec).
regards,
manto.
My ans are:
5. a
7. b
8. a
9. a
12. b
13 d.
13 don't know
16. a
Congret all passed. I passed the exam on last Monday 25.
I find the almost answer from the solution development courseware.
a)ODBC
b)C/ODBC
c)C/Front
d)Automation Microsfot Word
2) 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
3) You need to open form to get information from input of the user.What code?
a)FORM.RUN(formID)
b)Create variable type form and code : VAR.RUN
c)Create variable type form and code : VAR.RUNMODAL
d)FORM.RUNMODAL(formID)
what do you think about this questions?for 2. question ewerybody say different answer,these are my exam questions.I failed at first time if you help me ı'll be happy.Thank You!!!!
As u said, Integer will take only 4 bytes.If TextMode(True), you are getting 5 bytes... I need more information in this regard.
Can you please tell me how to test this?
I really dont know working with File variables.
Can you send me an example ?
With Regards,
Shilpa Reddy
a) Visible <=
b) Vertglue
c) SourceExpr
2. You are make a data conversion from legacy system to new one using Dataport but something occur thier is description filed contain 80 char and the new description filed can take 50 char only. You told our customer about this he told u its fine with first 50 char know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table trigger to reed the first 50 char
c) Dataport will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle these situations
e) Put the data in variable and then write code to read the first 50 char <=
3. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(true) )
a) 2 byte
b) 4 byte
c) 6 byte <=
d) 8 byte
4. If you create file and write to it the number '1000' what is the size if u know that the textmode method is (textmode(false) )
a) 2 byte
b) 4 byte <=
c) 6 byte
d) 8 byte
5. Your customer COMPLAIN about report u create he said "the report goes write and every thing is correct but the report very slow" what u have to change to fix this problem??
a) Dataitems
b) Filters
c) Keys <=
d) DataItemTableView
6. One question was about Process and Transaction in Navision
a) One or more transaction in one Process
b) Zero or more transaction in one Process <=
c) One or more Process in one transaction
d) Zero or more Process in one transaction
e) Transaction and Process doesn’t work together...
7. What is the three primary thing mentions in every report (chose three of six)
a) Company Name <=
b) Page number <=
c) Date and time
d) User name <=
e) Time of work
8. Xfile.EoF how can u represent it in another way
a) Xfile.pos
b) Xfile.read
c) Xfile.len
d) File.read(file.pos)= file.len <=
e) File.read= file.len
9. When 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
10. Form A calls on 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'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red <=
b) Blue <=
c) Null
d) You can't do this
11. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
12. User entering a general journal what are the dimension data flows. (2 Questions on this)
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U <=
b) U to V <=
c) T to Z
d) X to Z
13. Report 2 dataitems “Cust. Ledger Entry” and “Customer”. “Cust. Ledger Entry” is linked and indented. What function do you use to break out of the current record?
a) CurrReport.CLOSE
b) CurrReport.QUIT
c) CurrReport.BREAK
d) CurrReport.SKIP <=
14. When 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
15. What function should you call in a report onaftergetRecord trigger that will still print the record your currently on.
a) CurrReport.SKIP
b) CurrReport.BREAK
c) Exit <=
d) CurrReport.QUIT
16. Which type of table has most buss rules?
a) Ledger Table
b) Journal Table <=
c)…
17. A KEY can have at most, how many SumIndexFields?
a) 20 <=
b)…
18. What is the fundamental business rule concerning posting for all functional areas?
a) Take Journal recordsand put them into Ledger Table <=
b)…
19. Two options to open a new card from a list form.
a) F11 & Navigate menu
b) Shift F5 & Navigate Menu <=
c) F11 &??
d) Shift F5 &??
20. Which is not valid code?
a) EXIT;
b) EXIT(Amount);
c) EXIT
d)… <=
21. Choose Repeat ... Until loop instance of a While... Do loop when you
a) Want to bypass test given a set of conditional
b) Want to time the loop
c) Want to see how many conditions are mentioned in your test
d) Want to loop to process at least one <=
22. Which of the following commands would be best to use C/AL return the user ID?
a) UID
b) System.UID
c) USERID <=
d)…
23. Which is not considered a document report?
a) Sales invoice
b) Customer Statement
c) Inventory Order details <=
d) Purchase Order
24. Which command would you place on PreSection trigger prevent the section from printing?
a) CurrReport.ShowOutpu(True)
b) CurrReport.ShowOutpu(False) <=
c)…
25. A list report is report that contains a single Dataitem that is the table being listed. which of the following would be a TRUE statement
a) Only PK (field and description and field can be included in ...
b) Each column on the report containing a field from the table on the data is printed from that table, not brought in or calculated other table <=
c) the report limited to only 65500 lines
d) Each Field other then the PK, must be activated using the CALCFIELD equivalent to?
26. Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField <=
27. In the Dataport field designer the list of source expressions should be what order?
a) Same order as the information in the file <=
b) Same order as the fields in the table
c) Alphabetical order
d) Ordered by data type.
28. Which describes Codeunit?
a) container for all c/al code
b) Container for c/al code <=
c) Measurement of C/AL
d) The editor c/al
29. Witch of the followings is not characteristic of a menu suite?
a) It consist of a set of menu
b) A menu item is the highest level in the tree <=
c) A menu node can be either a menugroup or menusuite
d) A menu group contain a collection of menu nodes
30. Which of the following is not true regarding menus or menusuite?
a) A menu contains content for a specific departmental area <=
b) Menus consist of items, groups and objectives <=
c)…
31. Which is the sales & receivables master table?
a) Salesperson
b) Customer <=
c)…
32. If you want a variable that has been passed to be changed while in the function you can ...
a) Pass it by reference <=
b) Pass it by...
c)…
33. What type of data have whole number and max 100000?
a) Int
b) Decimal
c) Option <=
d) Code
34. Which is unary operator?
a) + <= (You can write VAR := +VALUE)
b) /
c)…
35. Which is not converted automatically?
a) Blob to binary <=
b) Int to dec
c)…
36. Form A calls on 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'. Forma A then calls another function in the same Codeunit and retrieves the value of the global variable. What is the value?
a) Red * (chose a) <=
b) Blue (or <=
c) Null
d) You can't do this
37. How many Indents can a report have?
a) 1
b) 10 <=
c) 100
d) Unlimited
38. What is the use of setting permission in the report?
a) Prevent user from using the report
b) Use this property to give a database object extra permission to perform some operations on one or more tables <=
c)...
39. IF Name <> xRec.Name THEN
ERROR('Bat flies');
Substitute the error message:
a) Name is not present in record
b) Don't changed <=
c) Don't delete
d)...
40. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. if in AfterGetRecord of the dataitem2 I call CurrentReport.Skip, what is the next record?
a) Execute next record (dataitem2) <=
b) Execute next record (dataitem1)
c) Nothing, report stop
d)...
41. How many dataitem at the maximum can we indent in a report?
a) 10 <=
b) 20
c) 100
d) Unlimited
42. Something with NODBC and Multilanguage
a) N/ODBC support Multilanguage <=
b)…
43. 2 dataitem: one (dataitem2) is below of the other (dataitem1) and indented. If in AfterGetRecord of the dataitem2 I call CurrentReport.break, what is the next record?
a) Execute next record (dataitem2)
b) Execute next record (dataitem1) <=
c) Nothing, report stop
d)...
44.
Customer.FIND('+');
Customer.NEXT('-3');
Customer.FIND('=');
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
a) 2000
b) 3000 <=
c) 4000
d) 5000
e) 6000
45.
Customer.FIND('+');
Customer.NEXT('3');
Customer.FIND('=');
In table the following records are present: 1000, 2000, 3000, 4000, 5000, 6000.The result of previous instructions is:
a) 2000
b) 3000
c) 4000
d) 5000
e) 6000 <=
46. What is the property used for Multilanguage support?
a) Caption
b) CaptionML <=
c)...
47. What of the following is it a File function?
a) WRITELINE
b) EXIST <=
c) BINARYMODE
48. What of the following is it a File method?
a) WRITELINE
b) BINARYMODE
c) CREATE <=
d)...
49. In a report what is trigger that fire before?
a) OnInitReport <=
b) OnPreReport
c) OnPreDataItem
d) OnPostDataItem
50. In a report with request form what is trigger that fire before?
a) OnPreReport
b) OnOpenForm <=
c)...
51. Your customer has bought your product, but your salesperson has talked with him and has said that the latest version of navision has the improvements that are present in add-ons that you will install.
What do you do?
a) Install latest version of navision;
b) Install latest version of navision, along with improvements present in your add-on <=
c)...
52. A subform
a) Have always a table box
b) Have usually a table box <=
c)...
53. If I have a code in the OnLookup table trigger that filters in a record set, how can I delete this filter in a form?
a) You can't
b) Write code in OnLookup form trigger <=
c)...
54. For SumIndexFields what do you use?
a) CALCFIELD
b) CALCSUM <=
c)...
55. In legacy system we have a field of 80 characters. You must import from legacy system to Navision but the new field is 50 characters. What do you do, if the customer has said that it is ok if you import from 80 character fields to 50 character fields.
a) Write code in DataPort to convert
b) You must do nothing: Navision do it for you during assignment
c) Put the data in variable and then write code to read the first 50 char <=
d)…
56. There is a report. We want to add to this report the possibility for the user to choose if show a description. To make this we add a check box. What must we do in the report?
a) Write code in OnPreSection report trigger <=
b)…
57. What is the equivalent of CREATETOTALS function in a report (more or less)?
a) TotalFields <=
b)...
58.
Customer.SETCURRENTKEY("No.");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END
Customer.SETCURRENTKEY("Sales");
Customer.SETRANGE("Sales",0);
IF Customer.FIND('-') THEN BEGIN
{code}
END
Customer.SETCURRENTKEY("Sales");
Customer.SETFILTER("Sales",'0');
IF Customer.FIND('-') THEN BEGIN
{code}
END
Which is the code faster?
a) The first one
b) The second one <=
c) The third one
d) All three codes go at same way
(Customer.“Sales” is a Calculated Field: you cannot set the key on a calculated field, the instruction Customer.SETCURRENTKEY(“Sales”) is invalid. If SALES is a normal field the second one is the fastest)
59. What it the key to compile an object from object design?
a) F11 (choose) <=
b) There isn't any key
c)...
60. What is the property to select a subform in a form?
a) SubFormID <=
b) SubForm
c)...
61. When you modify a menusuite, what are the changes that remain?
a) It doesn't save them
b) At level of menu level
c) Maintain all changes
d) Only the last
e) Maintain the difference between the level below <=
62. When you create a development database for a customer that has already the db, what do you do?
a) you make a backup and install them with check..
b) create a backup, create a new DB using client, restore from backup <=
c)...
63. Report with modifications. Which do you modify?
a) the new that is a copy of the original <=
b) the original
c)...
64. How do you launch a Codeunit?
a) CODEUNIT.RUNMODAL(..)
b) CODEUNIT.RUN(..) <=
c)...
65. Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord) <=
d)...
66. Import Dataport. From the first record you can extract all data that you need, following data too (for these you don't care about them). What do you do to skip all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord) <=
67. C/AL language programming. What is true?
a) It derives from Microsoft C#
b) All objects have c/al
c) All object except Menusuite <=
d)...
68. I declare a variable with VAR.
a) You pass a variable by reference rather than by value <=
b) You pass a variable by value rather than by reference
c) You declare a variant variable
d)...
69. XMLPort. How do you calculate flowfield in automatic?
a) Calcfields
b) FieldCalc
c) AutoCalcField <=
d)...
70. In a report a user wants to set a filter. What do you do?
a) Populate DataItemTableView
b) Delete DataItemTableView <=
c) Populate dataitemlinkreference
d) Delete dataitemlinkreference
71. You have a report and you print for all users the same value. Why? (it talk about DataItemTableView)
a) You haven't set table filter <=
b)...
72. Import txt file. When does worksheet appear?
a) Never <=
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
73.
IF NextEntryNo = 0 THEN BEGIN
ResLedgEntry.LOCKTABLE;
IF ResLedgEntry.FIND('+') THEN
NextEntryNo := ResLedgEntry."Entry No.";
NextEntryNo := NextEntryNo + 1;
END;
What does this code do (in posting routines)?
a) It is used to have not record with null value
b) To calculate the next entryno <=
c)...
74. What is the following property false?
a) Autoincremental
b) You can modify the table
c)...
75. You must verify the empty row in the journal when you post. What do you do? the code must be reusable
a) You create a CodeUnit and pass it a record <=
b) You can't, because the table don't accept function
c) You put function in the form
d)...
76.
IF ISCLEAR(WORDAPP)
CREATE (WORDAPP)
WordApp is Automation. What does the code do?
a) Sure I instance a variable
b) If the variable doesn't exist I create it <=
c) Clear the variable
d)...
77. Max number of menu suite in a db?
a) 10
b) 15 <=
c) 20
d) Unlimited
78. In a subform, what can you insert in it?
a) Tab menu
b) Tablebox
c) Picturebox
d) Subform <=
79. What is not true for a blob?
a) You can export only as a bitmap <=
b) You can insert "memowrite"
c) It can contain pictures
d) At maximum 2GB
80. You have a label and you want to change its value at runtime. What do you do?
a) SourceExpr
b) SourceExpr only if exist a text box linked with it
c) Is not possible <=
81. You must import sales order data (they are already verified).
a) And b) two option directly into ledger table
c) Copy in journal table, save and post them
d) Copy in journal table and post them <=
82. Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document <=
i) Ledger + document posting
83. You are posting a journal. What are dimensions that are used?
a) Journal <=
b) Ledger
c) Default
84. In a function with a record as parameter, how can you know witch filters have been applied to it ?
a) GetFilters
b) Impossible
c)…
85. Witch kind of files are not present on the client computer
a) stx
b) etx
c) fob
d)…
86. If you set the SourceExpression of a textbox to a BigText variable, what will be the result?
a) Error
b) Text will be truncated
c)…
87. Almost like the #86, If you have varText := varBigText;
a) Error
b) VarText will be truncated
c)…
88. Outstream.Write. What's an invalid target?
a) Blob
b) Ocx
c) Report <=
d) Automation
89. What is the fundamental business rule concerning posting for all functional areas in navision application?
a) All transactions are posted through the Ledger into the journal
b) All transactions are posted by the user directly into Ledger while the journal is used to track user.
c) All transactions are posted through the journal into the ledger <=
d)…
90. Which of the following characteristics not result of the table relationship?
a) Optimize table records <=
b) Validate entry
c) Perform lookup other tables
d) Automatically propagate changes from one table to other table.
91. Which of the following functional area has more than one Master Table?
a) General Ledger <= (G/L Account, Bank Account)
b) Fixed Assets
c) Inventory
d) Sales & receivables
92. Which data type would be used for a field that has a FieldClass property of Flowfield and a Calc Formula method of sum?
a) Date
b) Boolean
c) Decimal <=
d) Integer
93. Which are the valid "parts" of a table in Navision?
a) Data and Ledgers
b) Data and Properties <=
c) Data and described
d) Source and description
94. Which is not a flowfield type?
a) Lookup
b) Sum
c) Validate <=
d) Count
95. Which is Cash Managements master table?
a) Customer
b) G/L Account
c) Cash Account
d) Bank Account <=
96. In customer table comment field and CalcFormula property is following
EXIST('CommentLine') WHERE (Table Name=CONST(Customer),No.=FIELD(No.)))
Select the item that represents the data type of a command field
a) Boolean <=
b) Binary
c) Integer
d) Decimal
97. Which is true?
a) A field in the master table is table related to the ledger table
b) A field in the Ledger table is table related to the master table <=
c) Master and ledger each have a field that is the table related to the other.
98. 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 <=
99. User make journal entries. What type of form used for that in Navision std.
a) List Form
b) Card Form
c) Worksheet form <=
d) Tabular Form
100. What can we do to access list form from a card form?
a) F5, Selecting lookup MenuItem or F11
b) F5, Selecting ListMenu item or selecting the lookup button on toolbar <=
c) F11, Selecting ListMenu item or selecting the lookup button on toolbar
d) F5, Selecting ListMenu item or selecting the find button
101. What is concatenation?
a) Extracting a string from within another string
b) Creating a new string by alternately taking characters from two other string
c) Combining string values by appending the characters of one to end of the other <=
d) Combining string values by adding the numeric value of one to the numeric value of the other
102. Which is not a report type?
a) Transaction
b) Status <=
c) Document
d) Test
103. A list report that contains 1 dataitem is the table being listed. Which is true?
a) Only the PK field and descriptive field can be included in the report
b) Each column on the report contains a field from the table and the data is printed from that table not brought in or calculated <=
104. Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger entry indented under customer. Which of time following would be easiest way to filter both tables to the same date range
a) Use SETRANGE OnPreReport <=
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table using the DataItemLink property
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
105. The Auto save property on a dataitem in a Dataport tells the dataitem to automatically
a) Replace records that exist in the table during on import
b) Save the file periodically
c) Insert records during on import <=
106. Which is True?
a) Xml ports do not handle xml documents that find and delete data in the db <=
b) Xml ports do can be run from object designer
c) Xml ports will produce proper output
107. Which field in the XMLPort description would be used to identify which table a TagName is equivalent to:
a) Table Name
b) TagType
c) TagName
d) Source type <=
108. In a function, when a parameter is specified as Var it means...
a) The parameter is passed as a variant
b) The parameter is passed by value rather than reference
c) The parameter is passed by reference rather than value <=
109. How can an element of object be addressed in Code?
a) Using Instance of class definition
b) Using normal syntax of structure language
c) Using dot operator <=
d) Using pointer reference
110. What file is not found (has relation with Multilanguage) in client folder?
a) *.ETX
b) *.STX
c) *.CHM <= (Help is only Multilanguage)
d) *.FDB
111. What Internal document if we add field in table?
a) Documentation trigger
b) Project Log <= (The question is about a document not a trigger)
c) Field Description
d) Code Command
112. You need to open form to get information from input of the user.What code?
a) FORM.RUN(FormID)
b) Create variable type form and code: VAR.RUN
c) Create variable type form and code: VAR.RUNMODAL
d) FORM.RUNMODAL(FormID) <=
113. What is the not valid target of WRITELINE?
a) BLOB
b) File
c) Report <=
d) Automation
114. Witch posting routine read the journal table?
a) Post Batch
b) Post Line
c) Check Line <=
115. Witch posting routine writes in to ledger table?
a) Post Batch
b) Post Line <=
c) Check Line
116. Look the following code:
Find(‘-‘)
Do
Delete();
While next <> 0
Find(‘-‘)
Do
Ok:=Delete();
While next <> 0
DeleteAll();
What’s the difference?
a) 1 is faster
b) 2 is faster
c) 3 is faster <=
d) All are the same
117. In a report with 1 DataItem. Witch trigger is not executed if the dataset is empty?
a) OnAfterGetRecord <=
b) OnPostDataItem
c)…
118. In a function with a record as parameter. Can we know witch filters have been applies?
a) NO
b) Yes, the records contain all the information about the filter applied <=
c) Yes, the filters applied to a record are stored in a system variable
119. What is a typical instruction in a check line routine?
a) Validate()
b) Modify()
c) TESTFIELD <=
d)…
120. Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
a) 1 <=
b) 20
c) 40
d) 100
121. 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 <=
122. 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 <=
d)…
123. How to implement optimistic concurrency (I don’t remember the server type) ?
a) Set a maximum of filters. The server will lock the table (implicit) during the update <=
b) Set a maximum of filters and explicitly call the LOCKTABLE
c)…
124. If a customer wants to be able to change the sorting order of a report without the intervention of a Navision developer, what do you do?
a) Fill the ReqFilterHeading
b) Leave the ReqFilterHeading blank
c) Fill the property
d) Leave the property blank?
e) ReqFilterFields
f) Leave DataItemTableView blank <=
125. In a form create with the form wizard. Witch code is automatically generated?
a) Validate(“No.”) in OnAfterGetRecord <=
b) SETRANGE(“No.”) in OnAfterGetRecord
c) FORM.Save() in OnDeleteRecord()
d) In OnNewRecord
126. In a report, witch instruction do the same task as putting a field name in the totalField property ?
a) CreateTotal <=
b) FlowFiels
c) Sum
d)…
127.
Sec A:
Cust.Setcurrentkey('No.');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec B:
Cust.Setcurrentkey('SalesPerson');
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
Sec C:
Cust.Setrange(Cust.Salesperson,'PS');
If Cust.Find('-') then
Repeat
Cust.CreditLimit(LCY) := 10000;
Until Cust.Next = 0;
a) Sec A is faster
b) Sec B is faster <=
c) Sec C is faster
d) All took same time
128. A client make a mailing with Microsoft word combinated with MBS, We use for this.
a) ODBC
b) C/ODBC
c) C/Front
d) Automation Microsoft Word <=
129. How many Indents can a report have.
a) 1
b) 10 <=
c) 100
d) Unlimited
130. You are making a data conversion from legacy system to new one
Using DataPort but something occur thier is description filed contain 80 char and the new description filed can take 50 char only.
You told our customer about this he told u its fine with first 50 char
Know what is true way to do this data conversion?
a) Change the new description filed properties to take 80 char
b) Write code in the table triggers to reed the first 50 char
c) DataPort will handle this situations u don’t need to do any thing
d) You need to write code in data port to handle this situation <=
e) Put the data in variable and then write code to read the first 50 char <=
131. 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
132. How to implement optimistic concurrency (I don’t remember the server type)?
a) Set a maximum of filters. The server will lock the table (implicit) during the update
b) Set a maximum of filters and explicitly call the LOCKTABLE <=
c) Lock table when you read and you are sure that after you will do an update
d)…
133. Which of the following form control would you use to display subsidiary information on the form?
a) Subform <=
b) Textbox
c) Tablebox
d) Matrixbox
134. How menusuite object changes are stored
a) Each change is stored as a complete list of menusuite menus and items and replaces the previous level
b) Changes are stored as the difference between previous menusuite level and the current one <=
c) Menusuite changes are not stored
135. Which of the following is not true regarding the methods and properties of an Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and properties using the C/AL symbol menu <=
b) Certain methods and properties will not be able to utilized in navision if there is no corresponding data type within navision
c) Knowledge of the relationship between COM data typesand navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an outside application.
136. The main limitation of DataPort as a tool to integrate Navision with an outside application is that requires the outside application to:
a) Initiate all data transfers from itself to Navision by running the DataPort
b) Be certified as Navision compliant
c) Place its data into an ASCII file before the navision DataPort can read <=
d) Know internal data structure of the navision tables to be updated by the DataPort
137. Which of the following is Not true regarding XML TagName field
a) Attributes are entered prior to the elements they define <=
b) TagNames must be entered in order
c) Parent elements must precede their child elements
d) Child elements are indented
138. Which of the following XML port TagName properties selects the field to be mapped to Xml data
a) Source field
b) ReqFilterField
c) Xml Field
d) Field name
139. Which field in the Xml port description would be used to identify which table a tagname is equivalent to?
a) Table name
b) Tag Type
c) Tag Name
d) Source Type
140. You are importing data from outside source into Navision using DataPort the data is in variable format and each field is separated by ampersand. Which of the actions should you perform to be able to import data using DataPort?
a) Change field separator to ampersand
b) Change field delimiter to ampersand
c)…
141. Which of the following dataitem properties would be used to specify which field or fields a Navision Report should Group By.
a) GroupTotalFields
b) Total fields <=
c) GroupByFields
d) Req. file
142. You have set the left margin = 1000 , before printing report the user specifies 15mm left margin in the page setup window. When print the report LeftMargin=?
a) 15mm
b) 10mm
c) 25mm
d) 5mm
143. Which of the following is true regarding the Request Options from Designer?
a) Request options form does not exist
b) To design options tab of options
c) To design all of the tabs of the request form design
144. Which of the following is Not a Valid report component?
a) Control
b) Table form <=
c)…
145. You are designing a report that is going to be run while other users are inserting records into the same transaction tables, using version based Navision server what do you need to do t the report to make sure that the data reported will be a consistent snapshot of the data those transactions
a) You don't need to anything <=
b) You will need to set the transaction type property to SnapShot
c) You will need to set the transaction type property to Browse
d) There is nothing you can do. User will just have to tell all the others
146. Which of the following is true regarding to Automation Sever?
a) C/Side can receive events from components with the Automation events=yes
b) C/Side cannot receive events from outside components
c) C/Side can only receive Com+ components
d) C/Side can receive events from components with the WithEvents=yes
147. Cust. Ledger entry indented under Customer, which of the following would be easiest way to filter both tables to the same date.
a) Add DateFilter to the Req. Filter Fields property of the customer dataitem and link the posting date field of the custLedgerEntry data item to the data filter field of the customer table using the DataItemLink property
b) Add DateFilter to ReqFilterField property of the customer dataitem and use the SetFilter command to filter the posting DateField of the Cust. Ledger Entry table.
c) Use SetFilter
d) Use SetRange
148. Which command would you place OnPreSection trigger prevent the section from printing?
a) CurrReport.Showoutput(True)
b) CurrReport.Section(True)
c) OnReportPrint(true)
d) ShowReport
e) CurrReport.Showoutput(False) <=
149. Which is not true?
a) Local CodeUnits can only be run from other CodeUnits <=
b) CodeUnits can be run from other CodeUnits
c) CodeUnits can be run from other objects <=
d) Other object can be run from CodeUnits
150. Local variables are limited in scope to the function which they are defined
a) Local variables can only be defined in CodeUnits
b) Local variables are reinitialized other execution of a Codeunit has completed <=
c) Local variables can only be declared in local functions
151. In order for an outside application to access data within Navision Server using C/ODBC what must it support?
a) Microsoft Query <=
b) ODBC
c) Sql Server
d) Navision Server
152. We have 2 dataitem one is master (I can't remember I think customer and ship ...), and 10 customers have two ShipToAddress. When the report printed how much footer for ship to addresses?
Ans:???
153. When can change the fieldname in the table?
Ans: I think it should be anytime.
154. How many level of menusuite?
Ans: 20
155. How to run a menusuite?
Ans: You can’t
156. What properties need not be defined for menu item?
Ans: Name
157. List the trigger process order of Dataport.
Ans: OnInit, OnPreDataPort, OnPreDataItem, OnBefore/AfterExportRecord, OnPostDataPort
158. How to call a code unit in another object?
Ans: CODEUNIT.RUN
159. Which is NOT a Form Trigger?
Ans: OnDisposeForm
160. If a field in a table’s editable property set to “No”. Which of the following statement is true?
a) User cannot change the value in the form but can change the value by C/AL code <=
b) User cannot change the value in the form or by C/AL code.
c)…
161. How to describe the relationship between Master table and Ledger table?
a) Ledger table is table-related to master table………. <=
b) Master table is table-related to ledger table……….
c)…
162. Complex data type. More functions in it does they slow down?
Ans: ???
163. A question about: KEYGROUPS of report if customer have report only run at end of year
164. How to handle LockTable for small customer who uses Navision Database Server
Ans: ???
#26 The automatic calculation of SumIndexFields - acording to the courseware:
CalcFields: Automaticaly calculates the information for flowfields entered here
AutoCalcFields: Used to determine whether or not the value in the flowfield should be recalulated before the field is exported
#30 B)should say OBJECTS not OBJECTIVES - then the correct answer would be A) Departmental areas
#36 I beleive that the correct answer is C) Null as it is not a 'single instance' so the variable is initialized for each instance so it would be 'Null'
#50 I beleive the correct answer is OnInitReport - this is ALWAYS first - doesn't matter if a request form is uesed or not.
#80 Changing a label - this can be done with the 'Caption' property
#83 Posting a Journal - both Journal and Ledger are used
#85 & #110 - The *.FDB (which is the database) are generaly not on the client unless it is a single user installation
#86 & #87 are both A)Error - I tried it and both will not allow it to be done
#91 Fixed Asstes also has 2 Masters Asset and Insurance
#109 - I am not sure of this one but normally ELEMENT is part of an Array or an XML data - both of these would be used with the pointer or index but if they mean property or field of an object then it is the dot
#111 - I could find no information on the Project Log - where do I find this info?
#114 reading Journal records - again acording to the courseware:
CheckLine - Never reads or writes the Journal Table
Post Line - Never reads or writes Journal table - can read other tables for validation - writes Ledger entry
#119 - In my attempt - I had this but TESTFIELD was not an option, however EMPTYLINE() was an option - I thought that was the correct answer but since you didn't ahve it ... Maybe it is the Validate()
#121 You cannot test data before it is imported but it can betested before processed - I think the answer is OnAfterImport because the courseware states that "Most processing and validation is done in the OnAfterImport trigger"
**Optimistic Concurrency - I am not so optismistic!! The references to this in any of the training or reference material - even in the Installation and Configuration manuals is sketchy at best and does not answer these questions ***
#138 & 139 The property that shows the Field or Table is DataSource that is part of SourceType - in SourceType you choose Text,Field or Table
#148 - just remember that another way towrite this is SHOWOUTPUT(0=1)
#151 - I don't think you must have Ms Query as you can use NODBC in C# or VB as the interface without MSQuery - I don't know this one
Hope this helps.
Does anyone know the answer to:
200) Client wants to have a mailmerge with Navision and Word - they want to be able to add or change fields without help of Navision Developer. What is the best way?
a) Navision to word
b) Word to Navision
C) Navision to world
Thanks
Is anyone going for the Master? Has anyone questions from the Installation & Configuration or from the Financials tests? [-o<
Thanks for all the help and support everyone!
I passed the exam today. This was my 2nd time. Whew! I will be looking closely at that Master Development Certification because we are upgrading and I am taking the upgrade class. I might as well take the exam too! Then only one more elective to Master Developer.
Yea! 8)
For all who need to schedule the second shot, please contact vue customer service directly.
FYI. http://www.vue.com/contact/ms/
"From: MBS-Certified Professional Program [mbs-cert@microsoft.com]
To: ...
Hello Anca,
The 2nd shot promo is available to you, I have confirmed with the VUE testing center that this promo is still valid. When you are ready to take the free retake, simply call 1-800-837-8734 and an agent there will verify your exam details. "
regarding the question above....
this is what i done.
DOS Prompt result
Find(‘-‘)
Do
Modify();
While next <> 0
2
Find(‘-‘)
Do
Ok:=Modify();
While next <> 0
the question is which one is the fast??
are there any difference between them I choose first one is fast but I'm not sure :?
I found the answer on development book pg44
"The Post Batch routine is the only one that actually reads or updates the journal table;the others simply use the Journal record passed into them."
Answer is a) Post Batch
a-)A Microsoft RAISEERROR will be generated
b-)Data Entered through NODBC will not be validated <--choose
c-)Data will be checked for conformance to Navision data types
d-)Additional fields normally populated in the onValidate trigger
Q2) Exit(True)
a-)Return Boolean value
b-)Will not accept a parameter True
c-)Only executes if it returns a vale <--choose
d-)classes down the Navision client
1) Which case to run a report in modal fashion, while within a transaction?
a) If request form is show modal before the report
b) If report populate all need information on request form before display
c) If request form is not shown
d) Report already run once and request form was properly fill in
2) NA Server, customer want to sent customer welcome letter, mail merge. What should be used?
a) Mail merge using CODBC
b) Automation from MS word to Navision
c) Automation from Navision to MS word
d) Mail merge ODBC
Note: I choose B, but not sure.
3) Create a card form by form wizard, what code is added automatically?
a) onAfterGetRecord(), setRange("No");
b) onNextRecord()...
c) onDeleteRecord()...
d) onAfterGetRecord(), validate("No");
Note: I try to create a card form, but I don't find any automatically added code
4) Import AR balance, time is limited, so need to do it quick, how to do it
a) Import into Gen. Journal line, save it, open the journal form, post it
b) Import into Gen. Journal line, without saving, call Code Unit to post it
Note: I am not sure for (b). Is this possible for not saving a Gen. Journal line and post it?
5) About the speed of 3 sample code.
a) SetRange
b) SetFilter
Note: Is there any performance difference by SetRange and SetFilter?
1-c
2-this is my exam question I choose c
3-d
4-b
5-setrange is faster than setfilter so answer is a
1)User entering a general journal what are the dimension data flows.
T Default Dimension
U Journal Dimension
V Dimension Ledger
X Production Order Dimension
Y Document Dimension
Z Posted Document Dimension
a) T to U
b) U to V
c) T to Z
d) X to Z
2) Which Xml properties will cause flowfields to be calc automatically?
a) Calcfields <=
b) Flowcalc
c) CalcFlow
d) DoCalc
e) AutoCalcField
3) In a report with request form what is trigger that fire before?
is it oninitreport?
4) Report only batch. How do you launch it?
a) Report.run
b) Report.run (record)
c) Report.run (tmpRecord)
5) Import Dataport. From the first record you can extract all data that you need, following data too (for these you don't care about them). What do you do to skip all records except the first one?
a) CurrentReport.skip (in onbeforeimportrecord)
b) CurrentReport.skip (in onafterimportrecord)
c) Init (in onbeforeimportrecord)
d) Init (in onafterimportrecord)
6) have a report and you print for all users the same value. Why?
7) Import txt file. When does worksheet appear?
a) Never
b) Always
c) If two objects (that present and that you imported) are modified
d) If the object has different modifications
8) You must verify the empty row in the journal when you post. What do you do? the code must be reusable
a) You create a CodeUnit and pass it a record
b) You can't, because the table don't accept function
c) You put function in the form
9) You have a label and you want to change its value at runtime. What do you do?
10) Insert a record in sales order. What dimensions are used?
a) Default dimension
b) Journal dimension
c) Ledger
d) Document
e) Document posting
g) Default + journal
h) Journal+ document
i) Ledger + document posting
11) You are posting a journal. What are dimensions that are used?
a) Journal
b) Ledger
c) Default
12) Report with Customer and Cust.Ledger entry as dataitems and Cust.Ledger entry indented under customer. Which of the following would be easiest way to filter both tables to the same date range
a) Use SETRANGE OnPreReport
b) Add DateFilter to the ReqFilterFields property of the customer dataitem and link the posting date field of the Cust.Ledger entry dataitem to the Date filter field of the customer table using the DataItemLink property <=
c) Add DateFilter to the ReqFilterFields property of the customer dataitem and, use the set SETFILTER cmd to Filter the posting date field Cust.Led.Entry
d) Use SETFILTER OnPreDataItem
13) What is a typical instruction in a check line routine?
14) Look the following code in a post batch routine:
LOCKTABLE;
SETRANGE("Journal Template Name",'GENERAL');
SETRANGE("Journal Batch Name",'IMPORT');
IF FIND('+') THEN
NextLineNo := "Line No." + 10000
ELSE
NextLineNo := 10000;
If we post a journal of 20 lines. How many times the line “NextLineNo := "Line No." + 10000” will be executed ?
a) 1
b) 20 <=
c) 40
d) 100
15) 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
16) Which of the following is not true regarding the methods and properties of an Automation server controlled from C/SIDE?
a) When the Automation variable is properly declared, you can view the methods and properties using the C/AL symbol menu
b) Certain methods and properties will not be able to utilized in navision if there is no corresponding data type within navision
c) Knowledge of the relationship between COM data types and navision data types is required
d) Com data type can be converted to Navision data types using alterdatatype in order for an outside application. <=
17) Which of the following XML port TagName properties selects the field to be mapped to Xml data
a) Source field <=
b) ReqFilterField
c) Xml Field
d) Field name
18) what is not true for a blob?
a) you can export only as a bitmap <=
b) you can insert "memowrite"
c) it can contain pictures
d) at maximum 2GB
19) 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
20) How to implement optimistic concurrency
a) Set a maximum of filters. The server will lock the table (implicit) during the update
c) Set a maximum of filters and explicitly call the LOCKTABLE
21) In a function with a record as parameter. Can we know witch filters have been applies?
a) NO
b) Yes, the records contain all the information about the filter applied
c) Yes, the filters applied to a record are stored in a system variable
22) Which is Not true?
a-)Local Codeuınits can only be run from other codeunits <=
b-)codeunits can be run from other codeunits
c-)codeunits can be run from other objects
d-)other object can be run from codeunits
23) local variables are limited in scope to the function which they are defined_
a-)local variable can only be defined in codeunits
b-)lacal variables are reinitialized other execution of a codeunit has completed
c-)lacal variables can only be declared in local functions <=
24) Which of the following is NOT true of updating data in Navision using NODBC ?
a-)A Microsoft RAISEERROR will be generated
b-)Data Entered through NODBC will not be validated
c-)Data will be checked for conformance to Navision data types
d-)Additional fields normally populated in the onValidate trigger
25) you have set the left margin = 1000 , before printing report the user specifies 15mm left margin in the page setup window. when print the report leftmargin=?
a-)15mm
b-)10mm
c-)25mm
d-)5mm
I need help from u all ....
I am a Technical consultant & thinking to sit for certification by end of this month.Please tell me...
1.What are the documents i should read??
2.Which chapters are very important??
3.What is the code of the exams?
4.what is the system of the exam & how the intreface looks like??
5.Total Marks & Pass Marks??
6.Can i give a demo test in some website?? (as it is available 4 other certification courses like MCSD,MCSE,OCP,..)
May be this questions are already been asked somewhere in this forum...i have searched, could not find ...:(....
Thnx
Soumya