Q1: Why do we prefer TempDB over InMemory tables while using them in queries for reports?
Answer: Both are temporary tables but TempDB tables can be used in Joins.
Q2: What are the different container functions?
Answer: condel :- To delete one or more items from a container.
confind :- To locate a sequence of items in a container.
conlen :- To find out length of the container.
connull :- To dispose of a container.
conpeek :- To extract an item from a container.
Q3: How can we restrict a class to be further extended?
Answer: The Final Keyword is used to restrict a class from further being extended. for ex: public final class.
Q4: Which classes are used for data import and export?
Answer: SysDataImport and SysDataExport.
Q5: How to make the last record active when a form is opened in Microsoft Dynamics 365 F&O?
Answer: In the properties of form datasource set the start position property as last.
Q6: What is the differentiate between refresh(),reread(),research(),executequery() in Microsoft Dynamics 365 F&O ?
Answer: refresh() just refreshes the data from form cache.
reread() will read the current record from the DB so you should not use it to refresh the form data if you have added/removed records.
research() will rerun the existing form query form data source. This will maintain any existing filters and sorting on the form.
executeQuery() should be used if you have modified the query in your code and need to refresh the form. It’s like research() only but also takes query changes into account.
Q7: Difference between a temp table and a container?
Answer: In containers, data is retrieved sequentially, but in temporary table enables you to define indexes to speed up data retrieval.
Containers provide slower data access if you are working with high number of records.
While passing a temporary table into a method call, it is passed by reference while Containers are passed by value.
Q8: Is Multiple inheritance possible in Microsoft Dynamics 365 F&O, if not how can we overcome that?
Answer: No. We can use Interfaces to overcome this.
Q9: Is main method necessary to write and why?
Answer: Yes, if we have to open the class from the action menu item we have to create the main method of the class.
Q10: What is the difference between the new & construct method?
Answer: new() method is used to create a memory of the object.
Construct() is a static construct method for each class that we should create. This method should return an instance of the class.
Q11: What is the difference between runBaseBatch and sysOperation framework?
Answer: Both are batch frameworks only. The SysOperation framework is the new replacement of the RunBase framework.
Q12: What are the different properties of a form datasource ?
Answer:
Name of datasource,
Table name,
AllowEdit,
AllowCreate,
AllowDelete,
StartPosition,
JoinSource,
LinkType.
Q13: What is Entire Table Caching?
Answer: The entire table cache is a different from record caching, in this we cache complete local copy of a table. It is ideal for parameter tables where data does not change often.
Q14: What are the link types in form datasource in Microsoft Dynamcis 365 F&O ?
Answer: Passive: In this linked child data sources are not updated automatically. We have to write code on active method of the main data source.
Delayed: There is a pause before linked child data sources are updated.
Active: The child data source is updated instantly when a record in the parent data source is selected.
InnerJoin: Selects records from the main table that have matching records in the joined table and vice versa. Only one record for each match. Records that are without related records in the other data source are eliminated in the ouput.
OuterJoin: Selects records from the main table and check if they have matching records in the joined table.
ExistJoin: It Selects a record from the main table for each matching record in the joined table.
Q15: What can’t we store in containers?
Answer: We can’t store objects in containers.
Q16: On closing of a form what are the methods which are called?
Answer: Close(), closed(), finalise().
Q17: What is the difference between Insert() method and doinsert() method ?
Answer: Insert(): To insert the records into the database and Secure any related transactions with tts.
Doinsert(): These methods should only be used under strict control because they bypass standard validations.
Q18: When a form is opened, what are the sequences of methods that are called?
Answer: Form init(), DataSource init(), Form run(), DataSource executeQuery(), canClose(), close().
Q19: What is find method and its use ?
Answer: Find method selects and returns one record from the table that matches the unique index specified in the input parameters.
Q20: How many types of relations are available in Microsoft Dynamics 365 F&O ?
Answer: Normal, Field fixed, Related field fixed.
Need help? Connect Atul
His proficiency in Azure integration further distinguishes his capability, facilitating seamless connections with Dynamics 365 F&O and enhancing business operations. Committed to project success, he provides ongoing support and shares industry insights through his blog, contributing to the professional community's growth.
- Logic apps VS Power Automate flow - June 28, 2024
- Multithreading batch job in Microsoft Dynamics 365 Finance and Operations - June 21, 2024
- Generate a CAR(Customization Analysis Report) report in Microsoft Dynamics 365 F&O - June 17, 2024
