I just had taken my Navision Dev II exam. Below are some questions and answer which is including some explanation from me. I hope that it will help someone who going to take the Dev II exam.
Note: I advised someone who going to take the Navision Dev II exam, please go through Navision Dev I and II training material first especially Dev 1(Chapter 27) and Dev II (Chapter 10). Even got the questions please double check and find out the correct answer.
Good luck!!!
1). How do a call a report to run batch
A. Report.RUN
B. Report.RUN(Record)
C. Report.RUNMODAL(Record)
D. Report.RUN(tmpRecord)
Ans:C
Explanation:
Batch only is meaning that processing only report. base on Navision 4.0 standard, it usually using "Report.RunModal" to call and proccessing data
Example:
"REPORT.RUNMODAL(SemReportSelection."Report ID",TRUE,FALSE,SemRegHeader);"
2)
If there is a variable called “RepProc” with subtype report, what is the correct code to run this batch?
A. RepProc.RUN
B. RepProc.RUN(Record)
C. RepProc.RUNMODAL(Record)
D. RepProc.RUNMODAL
Ans:D
Explanation:
If user created a variable of report which is "RepProc". Then using "RepProc" to call a form. In Navision standard, using variable report is cannot pass in any parameter to run a report.
Warehouse -> Item Reclass. Journal -> Menu Item(Function)-> Get Bin Code:
BinContent.SETRANGE("Location Code","Location Code");
GetBinContent.SETTABLEVIEW(BinContent);
GetBinContent.InitializeItemJournalLine(Rec);
GetBinContent.RUNMODAL;
CurrForm.UPDATE(FALSE);
3.
What Internal document if we add field in table?
a) Documentation trigger
b) Project Log
c) Field Description
d) Code Command
Ans:C
Explanation:
Page: 548(Dev 1 Chapter 27)
Internal Documentation
1. Code Comments
2. Documentation Trigger of each object
3. Description fields in the fields definitions
Field Description:
- Whenever you add a new field to an existing Table Object, or modify an exiting field in a table object, you should mark that field with the same Reference Number that was recorded in the Documentation Trigger of that same object.
Simply entering the Reference Number into the Description property of the field should do this marking.
4)
In the data conversion portion of a project for the closed invoices and payments, you recommend the data be converted using what method (remember that the data for this conversion has not been thoroughly tested)?
a) Write a Dataport to import the data into gen. journal line record and use it to call gen. jnl-post line code unit.
b) Write Dataport to import the data and insert into the general ledger entry
c) Write Dataport to import the data and insert it into the gen. journal line
d) Copy and paste the data from excel into general ledger entry
Ans:C
Explanation:
Page 259 (Dev 2 Chapter 10)
Note: When importing ledger or balance data, the most important thing to remember is to never import directly into a Ledger table!
Instead, import the data into an appropriate journal table, You can either leave the entries in the Journal table to be reviewed and posted later or, if you perform more testing up front to ensure that the data is correct, post the Journal entries as you import them.
5. When must the “SourceExpr” property be populated for a label control?
A. when the label control is bound to a textbox control
B. never, there is not such property for label controls.
C. only when the control is placed on an unbound form
D. when then ParentControl property of the label control is set to the source table.
Ans:B
Explanation:
Label not like Text box. Label no any property of “SourceExpr”
************************************************************************
6.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 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
Ans: B
Explanation:
Go to Object Design -> Create a new “Report” -> Click on “Property” (Shift+F4)
Transaction Type -> Press (F1)
There are four basic transaction type options: Browse, Snapshot, UpdateNoLocks and Update. Additionally, there is a Report option that maps to one of the basic options. This enables a report to use the most concurrent read-only form of data access for the connected server. When you use Navision Database Server, it maps to Snapshot and when you use SQL Server, it maps to Browse.
The transaction behavior when using SQL Server is as follows:
Browse
This is a read-only transaction. Modifications cannot occur within the transaction. All read operations are performed with READ UNCOMMITTED locking. Therefore, no locks are placed and locks placed by other sessions are not honored. This means that it is possible to read uncommitted data.
Snapshot
This is a read-only transaction. Modifications cannot occur within the transaction. All read operations are performed with SERIALIZABLE locking. Therefore, share-locks are placed and are maintained until the end of the transaction. This guarantees a consistent snapshot of the data read within the transaction.
Microsoft's definition of "SERIALIZABLE" is as follows:
"A transaction isolation level that ensures that a database changes from one predictable state to another. If multiple concurrent transactions can be executed serially, and the results are the same, the transactions are considered serializable."
Dear All,
I think this forum must not discuss the exam questions so detail and make the exam as if it's necessary very much. although you didn't pass the exam it doesn't mean you fail to be a developer or technical, try another time. Here I specify the persons that I think stress and not well prepared before exam are:
1. kwchau
2. codasyl
3. Another that I can't write but also his also writing the exam questions and asking here.
[-X [-X
1.- Wich of the following would not be a valid target for the WRITELINE method of an OutStream type variable?
A - BLOB
B - File
C - Report
D - Automation
2.- In regard to the following block of code, wich statement is true about performance when code is executed?
WITH Customer DO BEGIN
//Section A
SETCURRENTKEY("No.");
SETRANGE("Salesperson Code",'PS');
IF FIND('-') THEN
REPEAT
"Credit Limit (LCY)" = 1000;
MODIFY;
UNTIL NEXT=0;
//Section B
SETCURRENTKEY("Salesperson Code");
SETRANGE("Salesperson Code",'PS');
IF FIND('-') THEN
REPEAT
"Credit Limit (LCY)" = 1000;
MODIFY;
UNTIL NEXT=0;
//Section C
SETCURRENTKEY("Salesperson Code");
SETRANGE("Salesperson Code",'=%1','PS');
IF FIND('-') THEN
REPEAT
"Credit Limit (LCY)" = 1000;
MODIFY;
UNTIL NEXT=0;
END;
A - Section A will execute fastest
B - Section B will execute fastest
C - Section C will execute fastest
D - All of the sections will execute at the same speed
The Navision Developer's Exam is a joke. A lot like a typical University exam, it tests a person's knowledge of book theory, that really is of very little value compared to actual experience. The NAV Dev exam doesn't particularly test a person's Navision development ability. It reflects more how well a person can memorize keywords and methodologies, many of which on the test rarely (if ever) come up in day-to-day Navision development. To top this off, some of the exam questions are so poorly worded, they are very tricky as a result. It's not kidding when it instructs to, "Please select the best answer", because often there is more than one correct answer; and it's a matter of selecting the BEST one. Very brutal for an exam where over 80% is a passing score.
I took the exam 5 years ago, and failed it the first time only getting 70-something percent. I passed the second time I took it (don't recall my score). This seems typical for most individuals. After 5 years of development experience in Navision, I recently took the updated exam version, and failed again! (only 68% this time! ). Was fed up from this, so I purchased the exam answers from www.examkiller.net to study, re-took the test for free through the second-shot program, and scored 97%. What a joke... :roll:
The Navision Developer's Exam is a joke. A lot like a typical University exam, it tests a person's knowledge of book theory, that really is of very little value compared to actual experience. The NAV Dev exam doesn't particularly test a person's Navision development ability. It reflects more how well a person can memorize keywords and methodologies, many of which on the test rarely (if ever) come up in day-to-day Navision development. To top this off, some of the exam questions are so poorly worded, they are very tricky as a result. It's not kidding when it instructs to, "Please select the best answer", because often there is more than one correct answer; and it's a matter of selecting the BEST one. Very brutal for an exam where over 80% is a passing score.
I took the exam 5 years ago, and failed it the first time only getting 70-something percent. I passed the second time I took it (don't recall my score). This seems typical for most individuals. After 5 years of development experience in Navision, I recently took the updated exam version, and failed again! (only 68% this time! ). Was fed up from this, so I purchased the exam answers from www.examkiller.net to study, re-took the test for free through the second-shot program, and scored 97%. What a joke... :roll:
The best trick (and perfectly legal!) to pass the test is to read the notes in the manuals. These notes, most of the time, are the answers to the questions.
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
6.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 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
Ans: B
In my opinion, the right answer is A), because Navision uses SnapShot transaction type by default. You don't need to change anything.[/quote]
8. 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)
I tried on my system and I found that both c and d answers run good in Navision.
You answered c but also d is correct.
Are you sure of your choice?
Which is the difference?
8. 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)
I tried on my system and I found that both c and d answers run good in Navision.
You answered c but also d is correct.
Are you sure of your choice?
Which is the difference?
Thank you
With FORM.RUN, you can continue working on the original form WITHOUT waiting for the called form to close (and returning a value).
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
For 13) if no code is generated which is the right answer for the exam certification?
A very good question indeed.
The problem with the exam is that they don't expect the correct answer but the answer that you find in the manuals, even if it is wrong.
So best way to succeed in an honest way : read the manuals, especially the notes.
Regards,Alain Krikilion No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
10-)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
The right answer is not d? I saw someone answered a.
10-)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
The right answer is not d? I saw someone answered a.
I've seen some questions about this but I still don't know the right answers.
You have opened a File variable and are using it to export data from Microsoft Navision. Suppose you execute the following line of C/AL code:
XFile.WRITE('Line No.);
where 'Line No.' is a field of type integer. What is the total number of bytes that will be added to the file due to the above line of code, if 'Line No.' had a value of 1000, and if the TEXTMODE for xFile was set to FALSE
A) 4 bytes 6 Bytes
C) 8 bytes
D) 2 bytes
Somewhere I heard that the correct answer must be C)
If the TEXTMODE was set on TRUE the correct answer must be
- if the value of B is too large to put it in A (false because then you get an error at runtime)
- if the value of B can't be evaluated to the datatype of A (I chose this)
- if A is different from B
- another option...
What can't you do during a transaction:
- do a COMMIT to end the transaction
- show a MESSAGE (I chose this)
- modally run a codeunit (or something like that)
- another option...
What property can not be set for a menuitem:
- object type
- object ID
- caption (after selecting name first, which is the correct answer, I chose this :oops: )
- name
Which form-type can not be created using the form wizard:
- if the value of B is too large to put it in A (false because then you get an error at runtime)
- if the value of B can't be evaluated to the datatype of A (I chose this)
- if A is different from B
- another option...
What can't you do during a transaction:
- do a COMMIT to end the transaction
- show a MESSAGE (I chose this)
- modally run a codeunit (or something like that)
- another option...
What property can not be set for a menuitem:
- object type
- object ID
- caption (after selecting name first, which is the correct answer, I chose this :oops: )
- name<=
Which form-type can not be created using the form wizard:
1. How menusuite changes are stored?
A. Each change is stored as a complete list of menu and items and replaces the previous level
B. Changes are stored as the difference between the previous menusuite level and the current one
C. Only one menusuite level is stored which consists of all menu items
D. Menusuite changes are not stored
2. Wich 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
3. which of the following is Not true regarding menus or .menusuites?
a-)A menu contains content for a spesific deparmental area
b-)menus consisst of items, groups and objectives
4. When you modify a menusuite, what are the changes that remains?
a) it doesn't save them
b) at level of menu level
c) maintain all changes
d) only the last
5. 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
6. 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)…
7. 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
8)How meny menusuits can we creaed?
1.10
2.15
3.150
4.unlimited
Integration with Outside Applications
TEXT=Which of the following facilities provided by Navision will allow an outside application to access data stored within the Navision Server?
A#C/ODBC***
B#C/COAST
C#OLE Automation
D#C/FRONT
E#C/OCX
F#Impuls Workbench
TEXT=Which of the following facilities provided by Navision will allow a Navision (C/SIDE) application to access data or functions in outside applications?
A#Impuls Workbench
B#OLE Automation
C#C/COAST
D#C/ODBC
E#C/OCX
F#C/FRONT***
TEXT=In order for an outside application to access data within Navision Server using C/ODBC, what must it must support?
A#Microsoft Query //
B#Microsoft's SQL Server
C#Microsoft's ODBC***
D#Navision Server
TEXT=The main limitation of dataports as a tool to integrate Navision with an outside application, is that it 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 it.
D#Know the internal data structure of the Navision tables to be updated by the dataport.***
TEXT=If you want to set up your system so that an outside application, for example MS Excel, can read Navision data, your first step is to install the C/ODBC driver on your system.
Your next step is to:
A#Run Navision Financials, click Tools, Options, and set the Quick Find option to Yes.
B#Run the Control Panel, select Administrative Tools, and select Data Sources (ODBC).****
C#Run MS Excel and click Data, Get External Data, New Database Query.
D#Re-start your system.
TEXT=For many outside applications, it is necessary to set up the C/ODBC Options so that the Identifiers field is set to "All Except Dot".
Once this option has been set, then the field
Customer No.
will appear in the outside application as
A#Customer No.
B#Customer No_
C#Customer_No_***
D#Customer No
TEXT=Before you decide to write to Navision from an outside application using C/ODBC, you must consider which one of the following limitations of this integration tool?
A#You cannot set any FlowField values using C/ODBC.*****
B#You cannot execute any C/AL code in any object using C/ODBC.
C#Transaction processing and table locking do not work using C/ODBC.
D#You cannot read and write during the same transaction using C/ODBC.
TEXT=You have an option field in a table which could contain one of these options: Slow,Medium,Fast,Hyper.
You set the C/ODBC option field called "Option Field Type" to Integer.
If a particular record has this field set to "Fast", what will the outside application using C/ODBC see as the value of this field?
A#1
B#2***
C#Fast
D#3
TEXT=Knowledge of the syntax of what language is an advantage when creating advanced ODBC queries to access Navision data?
A#SQL***
B#C++
C#C/AL
D#Visual Basic
TEXT=Select the Navision platform option that allows users to access Navision data through ODBC.
A#SQL Server Option for Navision
B#Both the Navision Server and the SQL Server Option for Navision***
C#Navision Server
CORRECTOPTION=2:1
TEXT=Select the item that represents an advantage of C/FRONT over C/ODBC for integrating with Navision data stored on the Navision Server.
A#C/ODBC uses a client session. C/FRONT does not.
B#C/FRONT can calculate FlowField values. C/ODBC cannot.**
C#C/FRONT instructions are easier to write than C/ODBC instructions.
D#C/FRONT is faster than C/ODBC.***
TEXT=Select an item that respresents an advantage of C/ODBC over C/FRONT for integrating with Navision data stored on the Navision Server.
A#C/FRONT uses a client session. C/ODBC does not.***
B#C/ODBC is faster than C/FRONT.
C#C/ODBC instructions are easier to write than C/FRONT instructions.
D#C/ODBC can calculate FlowField values. C/FRONT cannot.
TEXT=Select the item that represents characteristics of an OCX control when used with Navision.
A#A small, outside application that can read data from Navision.
B#Allows Navision to use C/ODBC to read MS Access data files.
C#Can be placed on a form, like a TextBox control.
D#A small, outside application that you can call from within Navision.***
TEXT=You are required to have the C/OCX granule on your license in order to
A#Modify any C/SIDE object when one or more other objects include an OCX control.
B#Run any C/SIDE object which includes an OCX control.
C#Create a variable of type OCX within any C/SIDE object.
D#Develop in C/SIDE.
E#Modify any object which contains a variable of type OCX.
F#Run any OCX control from within Navision.****
TEXT=Once you have created a global variable of type OCX in an object, how do you view its properties and methods?
A#Press F5 and select the variable in the Symbol menu.//
B#Click View, Globals and select the variable in the list.
C#Press F1 and search for it in the on-line help.
D#Press F9 and view the new triggers that were created.
TEXT=If you want to use a method in an OCX control, and find that it requires a parameter of type "long", what C/SIDE data type should you use for that parameter?
A#Text with length greater than 50
B#Integer
C#Decimal***
D#Long
10-)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
The right answer is not d? I saw someone answered a.
Thank oyu.
I got this question on my exam. I selected "d" only
I've failed the Development 2 exam this morning and was very suprised at how many scenario questions were used and how open ended them questions are. I tried sticking to the Microsoft material and not just looking at the questions on here but to my suprise i think this was the wrong thing to do.
Most of the questions could have had at least 2 answers based on how you read the question.
I did all of the test questions in the material and found them to be ok, i took the exam and I feel like i have been robbed.
You have added a command button to a form that calls a codeunit when it is pressed
(using RunObject). The OnRun trigger of the codeunit modifies the customer
record as follows:
IF Customer. GET(CustNo) THEN BEGIN
Customer. 'Chain Name':=New Chain Name;
Customer. MODIFY;
END;//Other code here
When does the customer change get committed to the database?
A. The change gets committed automatically at the end of the execution of the codeunit.
B. The change gets committed automatically when the user leaves the record or the form.
C. The change will not get committed since you did not use the commit statement.
D. The change gets committed automatically with an implicit commit immediately
following the modify
statement.
Answer: A
A is correct? Where can I find information about this thing? ]
:-k
The design specifications written by your senior Microsoft Navision Consultant in
Development call for you to integrate Microsoft Word with Microsoft Navision
(running on a Microsoft?Navision?Server). You see that your customer wants to
create a mail merge once a week to send out a welcome letter to new customers.
Your customer wants a solution in which they can easily add additional fields to the
letter without having to require additional customizations by a Microsoft Navision
consultant. What option would you choose to fit your customer's need?
MB7-222
A. Automation from Microsoft Navision to Microsoft Word
B. Mail Merge using C/ODBC
C. Automation from Microsoft Word to Microsoft Navision
D. Mail Merge using ODBC
Answer: B
I find everywhere in the manual examples about Word mail merging with Automation (A)
Comments
I just had taken my Navision Dev II exam. Below are some questions and answer which is including some explanation from me. I hope that it will help someone who going to take the Dev II exam.
Note: I advised someone who going to take the Navision Dev II exam, please go through Navision Dev I and II training material first especially Dev 1(Chapter 27) and Dev II (Chapter 10). Even got the questions please double check and find out the correct answer.
Good luck!!!
1). How do a call a report to run batch
A. Report.RUN
B. Report.RUN(Record)
C. Report.RUNMODAL(Record)
D. Report.RUN(tmpRecord)
Ans:C
Explanation:
Batch only is meaning that processing only report. base on Navision 4.0 standard, it usually using "Report.RunModal" to call and proccessing data
Example:
"REPORT.RUNMODAL(SemReportSelection."Report ID",TRUE,FALSE,SemRegHeader);"
************************************************************************
2)
If there is a variable called “RepProc” with subtype report, what is the correct code to run this batch?
A. RepProc.RUN
B. RepProc.RUN(Record)
C. RepProc.RUNMODAL(Record)
D. RepProc.RUNMODAL
Ans:D
Explanation:
If user created a variable of report which is "RepProc". Then using "RepProc" to call a form. In Navision standard, using variable report is cannot pass in any parameter to run a report.
Warehouse -> Item Reclass. Journal -> Menu Item(Function)-> Get Bin Code:
BinContent.SETRANGE("Location Code","Location Code");
GetBinContent.SETTABLEVIEW(BinContent);
GetBinContent.InitializeItemJournalLine(Rec);
GetBinContent.RUNMODAL;
CurrForm.UPDATE(FALSE);
************************************************************************
3.
What Internal document if we add field in table?
a) Documentation trigger
b) Project Log
c) Field Description
d) Code Command
Ans:C
Explanation:
Page: 548(Dev 1 Chapter 27)
Internal Documentation
1. Code Comments
2. Documentation Trigger of each object
3. Description fields in the fields definitions
Field Description:
- Whenever you add a new field to an existing Table Object, or modify an exiting field in a table object, you should mark that field with the same Reference Number that was recorded in the Documentation Trigger of that same object.
Simply entering the Reference Number into the Description property of the field should do this marking.
************************************************************************
4)
In the data conversion portion of a project for the closed invoices and payments, you recommend the data be converted using what method (remember that the data for this conversion has not been thoroughly tested)?
a) Write a Dataport to import the data into gen. journal line record and use it to call gen. jnl-post line code unit.
b) Write Dataport to import the data and insert into the general ledger entry
c) Write Dataport to import the data and insert it into the gen. journal line
d) Copy and paste the data from excel into general ledger entry
Ans:C
Explanation:
Page 259 (Dev 2 Chapter 10)
Note: When importing ledger or balance data, the most important thing to remember is to never import directly into a Ledger table!
Instead, import the data into an appropriate journal table, You can either leave the entries in the Journal table to be reviewed and posted later or, if you perform more testing up front to ensure that the data is correct, post the Journal entries as you import them.
************************************************************************
5. When must the “SourceExpr” property be populated for a label control?
A. when the label control is bound to a textbox control
B. never, there is not such property for label controls.
C. only when the control is placed on an unbound form
D. when then ParentControl property of the label control is set to the source table.
Ans:B
Explanation:
Label not like Text box. Label no any property of “SourceExpr”
************************************************************************
6.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 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
Ans: B
Explanation:
Go to Object Design -> Create a new “Report” -> Click on “Property” (Shift+F4)
Transaction Type -> Press (F1)
There are four basic transaction type options: Browse, Snapshot, UpdateNoLocks and Update. Additionally, there is a Report option that maps to one of the basic options. This enables a report to use the most concurrent read-only form of data access for the connected server. When you use Navision Database Server, it maps to Snapshot and when you use SQL Server, it maps to Browse.
The transaction behavior when using SQL Server is as follows:
Browse
This is a read-only transaction. Modifications cannot occur within the transaction. All read operations are performed with READ UNCOMMITTED locking. Therefore, no locks are placed and locks placed by other sessions are not honored. This means that it is possible to read uncommitted data.
Snapshot
This is a read-only transaction. Modifications cannot occur within the transaction. All read operations are performed with SERIALIZABLE locking. Therefore, share-locks are placed and are maintained until the end of the transaction. This guarantees a consistent snapshot of the data read within the transaction.
Microsoft's definition of "SERIALIZABLE" is as follows:
"A transaction isolation level that ensures that a database changes from one predictable state to another. If multiple concurrent transactions can be executed serially, and the results are the same, the transactions are considered serializable."
I think this forum must not discuss the exam questions so detail and make the exam as if it's necessary very much. although you didn't pass the exam it doesn't mean you fail to be a developer or technical, try another time. Here I specify the persons that I think stress and not well prepared before exam are:
1. kwchau
2. codasyl
3. Another that I can't write but also his also writing the exam questions and asking here.
[-X [-X
Rgds,
sea-navision-community-subscribe@yahoogroups.com
detail in:
http://sea-navision-community.blogspot.com
A - BLOB
B - File
C - Report
D - Automation
2.- In regard to the following block of code, wich statement is true about performance when code is executed?
WITH Customer DO BEGIN
//Section A
SETCURRENTKEY("No.");
SETRANGE("Salesperson Code",'PS');
IF FIND('-') THEN
REPEAT
"Credit Limit (LCY)" = 1000;
MODIFY;
UNTIL NEXT=0;
//Section B
SETCURRENTKEY("Salesperson Code");
SETRANGE("Salesperson Code",'PS');
IF FIND('-') THEN
REPEAT
"Credit Limit (LCY)" = 1000;
MODIFY;
UNTIL NEXT=0;
//Section C
SETCURRENTKEY("Salesperson Code");
SETRANGE("Salesperson Code",'=%1','PS');
IF FIND('-') THEN
REPEAT
"Credit Limit (LCY)" = 1000;
MODIFY;
UNTIL NEXT=0;
END;
A - Section A will execute fastest
B - Section B will execute fastest
C - Section C will execute fastest
D - All of the sections will execute at the same speed
I took the exam 5 years ago, and failed it the first time only getting 70-something percent. I passed the second time I took it (don't recall my score). This seems typical for most individuals. After 5 years of development experience in Navision, I recently took the updated exam version, and failed again! (only 68% this time! ). Was fed up from this, so I purchased the exam answers from www.examkiller.net to study, re-took the test for free through the second-shot program, and scored 97%. What a joke... :roll:
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
jus wanted to thank you all for the precious help.
i passed my exams Dev I & II.
this forum has helped me cleared many doubts.
thnkx guys
\:D/ \:D/ \:D/
8. 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)
I tried on my system and I found that both c and d answers run good in Navision.
You answered c but also d is correct.
Are you sure of your choice?
Which is the difference?
Thank you
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
c) Create variable type form and code: VAR.RUNMODAL
d) FORM.RUNMODAL(FormID)
Thank you
but if you use d) how do you get back the selected value? You should also give a record to put the selected value in.
So C).
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
13. 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
I tried more time but I had no automatic code in Navision.
Does it depend from version?
Are you sure that a is correct?
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
In C/SIDE reference guide I only find
[Action] := Form.RUNMODAL(Number [, Record] [, Field])
RUNMODAL with a variable form where is explaind
For 13) if no code is generated which is the right answer for the exam certification?
A very good question indeed.
The problem with the exam is that they don't expect the correct answer but the answer that you find in the manuals, even if it is wrong.
So best way to succeed in an honest way : read the manuals, especially the notes.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
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
The right answer is not d? I saw someone answered a.
Thank oyu.
The right answer should be d).
You have opened a File variable and are using it to export data from Microsoft Navision. Suppose you execute the following line of C/AL code:
XFile.WRITE('Line No.);
where 'Line No.' is a field of type integer. What is the total number of bytes that will be added to the file due to the above line of code, if 'Line No.' had a value of 1000, and if the TEXTMODE for xFile was set to FALSE
A) 4 bytes
6 Bytes
C) 8 bytes
D) 2 bytes
Somewhere I heard that the correct answer must be C)
If the TEXTMODE was set on TRUE the correct answer must be
I tested this via this code
xfile.WRITEMODE(TRUE);
xfile.TEXTMODE(FALSE);
xfile.QUERYREPLACE(TRUE);
xfile.CREATE('c:\false.txt');
xfile.WRITE('1000');
The size of the dokument was 5 bytes
With this code
xfile.WRITEMODE(TRUE);
xfile.TEXTMODE(TRUE);
xfile.QUERYREPLACE(TRUE);
xfile.CREATE('c:\true.txt');
xfile.WRITE('1000')
The size of the dokument was 6 bytes
Who can Help me with the correct answer to the case (TEXTMODE = FALSE) ??
- ocx & automation
- c/Front & odbc (I chose this)
- ocx & C/Front
- odbc & automation
Question about possibility to export a menusuite object:
- you can not export
- you can export only as TXT
- you can export as TXT or as FOB (I chose this)
- another option...
Master table for the Cash Management functional department:
- Customer
- G/L Account
- Bank Account (correct answer)
- Cash Account
Functional department with more than one master table:
- Sales & Receivables
- Inventory
- Fixed Assets (correct answer)
- ...
XMLPorts: which is not a valid component:
- trigger
- properties
- label (correct answer)
- tagnames
A := B ==> What generates a compiler error:
- if the value of B is too large to put it in A (false because then you get an error at runtime)
- if the value of B can't be evaluated to the datatype of A (I chose this)
- if A is different from B
- another option...
What can't you do during a transaction:
- do a COMMIT to end the transaction
- show a MESSAGE (I chose this)
- modally run a codeunit (or something like that)
- another option...
What property can not be set for a menuitem:
- object type
- object ID
- caption (after selecting name first, which is the correct answer, I chose this :oops: )
- name
Which form-type can not be created using the form wizard:
- card-type
- tabular-type
- worksheet-type (I chose this)
- blank
For which form-type, created using the form wizard, do you have "column break"? (question wasn't like this but it had "Column break" in it :-))
- card-type
- tabular-type (I chose this)
- worksheet-type
- blank
Which is not a valid reason for using grouping in a report?
- ocx & automation <=
- c/Front & odbc (I chose this)
- ocx & C/Front
- odbc & automation
Question about possibility to export a menusuite object:
- you can not export
- you can export only as TXT
- you can export as TXT or as FOB (I chose this)
- another option...
Master table for the Cash Management functional department:
- Customer
- G/L Account
- Bank Account (correct answer)
- Cash Account
Functional department with more than one master table:
- Sales & Receivables
- Inventory
- Fixed Assets (correct answer)
- ...
XMLPorts: which is not a valid component:
- trigger
- properties
- label (correct answer)
- tagnames
A := B ==> What generates a compiler error:
- if the value of B is too large to put it in A (false because then you get an error at runtime)
- if the value of B can't be evaluated to the datatype of A (I chose this)
- if A is different from B
- another option...
What can't you do during a transaction:
- do a COMMIT to end the transaction
- show a MESSAGE (I chose this)
- modally run a codeunit (or something like that)
- another option...
What property can not be set for a menuitem:
- object type
- object ID
- caption (after selecting name first, which is the correct answer, I chose this :oops: )
- name<=
Which form-type can not be created using the form wizard:
- card-type
- tabular-type
- worksheet-type (I chose this)
- blank
For which form-type, created using the form wizard, do you have "column break"? (question wasn't like this but it had "Column break" in it :-))
- card-type =>this is correct
- tabular-type (I chose this)
- worksheet-type
- blank
Which is not a valid reason for using grouping in a report?[/quote]
Regards
Paul
Dynamics Nav Functional Consultant
A. Each change is stored as a complete list of menu and items and replaces the previous level
B. Changes are stored as the difference between the previous menusuite level and the current one
C. Only one menusuite level is stored which consists of all menu items
D. Menusuite changes are not stored
2. Wich 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
3. which of the following is Not true regarding menus or .menusuites?
a-)A menu contains content for a spesific deparmental area
b-)menus consisst of items, groups and objectives
4. When you modify a menusuite, what are the changes that remains?
a) it doesn't save them
b) at level of menu level
c) maintain all changes
d) only the last
5. 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
6. 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)…
7. 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
8)How meny menusuits can we creaed?
1.10
2.15
3.150
4.unlimited
TEXT=Which of the following facilities provided by Navision will allow an outside application to access data stored within the Navision Server?
A#C/ODBC***
B#C/COAST
C#OLE Automation
D#C/FRONT
E#C/OCX
F#Impuls Workbench
TEXT=Which of the following facilities provided by Navision will allow a Navision (C/SIDE) application to access data or functions in outside applications?
A#Impuls Workbench
B#OLE Automation
C#C/COAST
D#C/ODBC
E#C/OCX
F#C/FRONT***
TEXT=In order for an outside application to access data within Navision Server using C/ODBC, what must it must support?
A#Microsoft Query //
B#Microsoft's SQL Server
C#Microsoft's ODBC***
D#Navision Server
TEXT=The main limitation of dataports as a tool to integrate Navision with an outside application, is that it 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 it.
D#Know the internal data structure of the Navision tables to be updated by the dataport.***
TEXT=If you want to set up your system so that an outside application, for example MS Excel, can read Navision data, your first step is to install the C/ODBC driver on your system.
Your next step is to:
A#Run Navision Financials, click Tools, Options, and set the Quick Find option to Yes.
B#Run the Control Panel, select Administrative Tools, and select Data Sources (ODBC).****
C#Run MS Excel and click Data, Get External Data, New Database Query.
D#Re-start your system.
TEXT=For many outside applications, it is necessary to set up the C/ODBC Options so that the Identifiers field is set to "All Except Dot".
Once this option has been set, then the field
Customer No.
will appear in the outside application as
A#Customer No.
B#Customer No_
C#Customer_No_***
D#Customer No
TEXT=Before you decide to write to Navision from an outside application using C/ODBC, you must consider which one of the following limitations of this integration tool?
A#You cannot set any FlowField values using C/ODBC.*****
B#You cannot execute any C/AL code in any object using C/ODBC.
C#Transaction processing and table locking do not work using C/ODBC.
D#You cannot read and write during the same transaction using C/ODBC.
TEXT=You have an option field in a table which could contain one of these options: Slow,Medium,Fast,Hyper.
You set the C/ODBC option field called "Option Field Type" to Integer.
If a particular record has this field set to "Fast", what will the outside application using C/ODBC see as the value of this field?
A#1
B#2***
C#Fast
D#3
TEXT=Knowledge of the syntax of what language is an advantage when creating advanced ODBC queries to access Navision data?
A#SQL***
B#C++
C#C/AL
D#Visual Basic
TEXT=Select the Navision platform option that allows users to access Navision data through ODBC.
A#SQL Server Option for Navision
B#Both the Navision Server and the SQL Server Option for Navision***
C#Navision Server
CORRECTOPTION=2:1
TEXT=Select the item that represents an advantage of C/FRONT over C/ODBC for integrating with Navision data stored on the Navision Server.
A#C/ODBC uses a client session. C/FRONT does not.
B#C/FRONT can calculate FlowField values. C/ODBC cannot.**
C#C/FRONT instructions are easier to write than C/ODBC instructions.
D#C/FRONT is faster than C/ODBC.***
TEXT=Select an item that respresents an advantage of C/ODBC over C/FRONT for integrating with Navision data stored on the Navision Server.
A#C/FRONT uses a client session. C/ODBC does not.***
B#C/ODBC is faster than C/FRONT.
C#C/ODBC instructions are easier to write than C/FRONT instructions.
D#C/ODBC can calculate FlowField values. C/FRONT cannot.
TEXT=Select the item that represents characteristics of an OCX control when used with Navision.
A#A small, outside application that can read data from Navision.
B#Allows Navision to use C/ODBC to read MS Access data files.
C#Can be placed on a form, like a TextBox control.
D#A small, outside application that you can call from within Navision.***
TEXT=You are required to have the C/OCX granule on your license in order to
A#Modify any C/SIDE object when one or more other objects include an OCX control.
B#Run any C/SIDE object which includes an OCX control.
C#Create a variable of type OCX within any C/SIDE object.
D#Develop in C/SIDE.
E#Modify any object which contains a variable of type OCX.
F#Run any OCX control from within Navision.****
TEXT=Once you have created a global variable of type OCX in an object, how do you view its properties and methods?
A#Press F5 and select the variable in the Symbol menu.//
B#Click View, Globals and select the variable in the list.
C#Press F1 and search for it in the on-line help.
D#Press F9 and view the new triggers that were created.
TEXT=If you want to use a method in an OCX control, and find that it requires a parameter of type "long", what C/SIDE data type should you use for that parameter?
A#Text with length greater than 50
B#Integer
C#Decimal***
D#Long
My feeling is it a mixture of knowledge + common sense + typical questions...
Easy to pass if you know technical stuff logically and conceptually.
I got this question on my exam. I selected "d" only
Cleared by 99%
gr8 help frm anil kumar
I've failed the Development 2 exam this morning and was very suprised at how many scenario questions were used and how open ended them questions are. I tried sticking to the Microsoft material and not just looking at the questions on here but to my suprise i think this was the wrong thing to do.
Most of the questions could have had at least 2 answers based on how you read the question.
I did all of the test questions in the material and found them to be ok, i took the exam and I feel like i have been robbed.
But do you have the pdf exam examples from examkiller.net.
How do they come delivered?
Can you please share them as example?
Are they updated?
Andrea
You have added a command button to a form that calls a codeunit when it is pressed
(using RunObject). The OnRun trigger of the codeunit modifies the customer
record as follows:
IF Customer. GET(CustNo) THEN BEGIN
Customer. 'Chain Name':=New Chain Name;
Customer. MODIFY;
END;//Other code here
When does the customer change get committed to the database?
A. The change gets committed automatically at the end of the execution of the codeunit.
B. The change gets committed automatically when the user leaves the record or the form.
C. The change will not get committed since you did not use the commit statement.
D. The change gets committed automatically with an implicit commit immediately
following the modify
statement.
Answer: A
A is correct? Where can I find information about this thing? ]
:-k
The design specifications written by your senior Microsoft Navision Consultant in
Development call for you to integrate Microsoft Word with Microsoft Navision
(running on a Microsoft?Navision?Server). You see that your customer wants to
create a mail merge once a week to send out a welcome letter to new customers.
Your customer wants a solution in which they can easily add additional fields to the
letter without having to require additional customizations by a Microsoft Navision
consultant. What option would you choose to fit your customer's need?
MB7-222
A. Automation from Microsoft Navision to Microsoft Word
B. Mail Merge using C/ODBC
C. Automation from Microsoft Word to Microsoft Navision
D. Mail Merge using ODBC
Answer: B
I find everywhere in the manual examples about Word mail merging with Automation (A)