Microsoft MB6-704 Actual Free Exam Questions & Community Discussion

You need to develop X++ code to fetch data from a database by using a query object.
Which class should you use to perform the fetch operation?

You have a Dynamics AX deployment that contains three legal entities.
You need to search for records across all three legal entities.
What should you create?

You are writing logic to fetch data from a database. The logic will use a select statement. You need to identify which keyword to use to fetch a single record from the database. Which keyword should you use?

----
Last Name is a field in a table. The length of the field is modified at different layers as follows:
At the SYS layer, the field is set to 20 characters.
At the USR layer, the field is set to 60 characters.
At the CUS layer, the field is set to 40 characters.
At the VAR layer the field it is set to 10 characters.
At runtime, what will be the length of the Last Name field?

You are developing queries to fetch data from the CustTable table. CustTable contains a
field named City. There is a non-unique cluster index named city Idx in the City field.
You need to fetch data from CustTable in ascending order based on City.
What are three possible SQL statements that achieve this goal? Each correct answer presents a complete solution.

You are developing a solution to store sales orders in Dynamics AX. Each sales order can contain multiple sales order lines. A sales order line can be part of only one sales order.
You create two tables named Sales Table and Sales Line. The tables will model the sales order and the sales order line entities. Sales Table will store sales orders and Sales Line will store sales order lines.
You need to specify the relationship between the tables.
Which relationship should you specify?

You have the following X++ statement:

You need to identity the output of the statement.
What should you identify?

You are developing X++ code to retrieve data from a table named Table l.
You need to use a select statement to retrieve only records from Table l that have related records in a table named Table2.
Which type of join should you use?

You have the following X++ code: (Line numbers are included for reference only.)


Method l and method2 are in Class l. Method3 is in Class2. You need to set variablel for class l Obj to a value of 5. Which code segment should you insert at line 21?