Dynamics AX technical consultant interview questions

1.      How can we create primary key for a table?

Post by Amer atiya, explaining the process of Primary key creation

2.      what precautions you need for overriding fetch() method for a report?

msn link of how to Override the fetch Method to Filter Data for Reports.

3.      Difference between OCC (Optimistic concurrency control) and PCC (Pessimistic concurrency control)?

MSN Link explaining OCC and PCC

4.      How many types of MAP there in Dynamics AX?

I have written a post explaining the difference

5.      What is cache lookup what is it used for?

Dynamics AX Caching

6.      Difference between table and views?

Table vs views

7.      why we use dialog? and how to accomplished it?

MSDN Link explaining dialog

8.      what are the different type of index?

Index Overview

9.      Difference b/w cascade + restricted and restricted delete actions?

Delete actions in AX

10.  In which case delete_from and delete() have same result?

Delete() will delete one record at a time.

Delete_from can delete multiple records at a time.

11.  Explain sales/purchase order processes in AX.

Purchase Order

Sales Order

12.  Can you just tell the table properties that you can remember

Tables Overview

13.  Different types of relation? Explain it detail?

Relations in Tables

14.  Explain Queries? What’s it used for?

AOT Query

X++ Query

15.  Explain different types of reports?

There are two types of reports in AX

SSRS Reports

X++ Reports

16.  Differentiate auto design spec & Generated design? Which one is a preferable choice and why ? 

Report Design for X++ Reports

17.  What are all the add- on tools you used in Dynamics AX (It’s an indirect question for AIF)

18.  Explain primary index and Cluster index? Explain in detail?

19.  What is the default index for a table?

       Default Index in Table

20.  Did you work with EP (Enterprise Portal & Workflow) how you can implement this features into your projects ?

       EP in AX 2012

21.  Can you just point out some best practice you used when u develop a project? 

22.  Did you worked with base modules? 

Question: What is the default index for a table ?

Microsoft Dynamics AX requires a unique index on each table. If there are no indexes on a table or all the indexes are disabled, a system index is automatically created. The system index is created on the RecId and DataAreaId fields if the DataAreaId field exists. Otherwise, the system index is created on the RecId field. You can see system indexes in the database, but they aren't visible in the AOT.