Online Access Free MB6-890 Practice Test

You are developing a solution that stores purchase orders in Microsoft Dynamics AX. Each purchase order can contain multiple purchase order lines. A purchase order line can onry be part of one purchase order.
You create two tables, named PurchTable and PurchLine. to model the entities.
PurchTable will store purchase orders, and PurchLine will store information about the purchase order lines.
Which relation should you specify between the tables?

• A.a field fixed relation
• B.a foreign key relation on PurchTable to PurchLine
• C.a related field fixed relation
• D.a foreign key relation on PurchLine to PurchTable

You need to determine the output of the following code:

What is the output in the Infolog after running the code?

• A.12 9
• B.20 16
• C.6 4
• D.2 1

Your solution stores customers in a table named Gust Table. CustTable contains a field named AccountNum, which is used to store the unique account number for a customer.
Data in the AccountNum field is 4 characters in length.
You need to retrieve only the records in CustTable where the second character of the
Account Number is the letter "H".
How should you write the select statement?

• A.select * from CustTable where CustTable.AccountNum like "*H"
• B.select * from CustTable where CustTable.AccountNum like "H*"
• C.select * from CustTable where CustTable.AccountNum like "?H*"
• D.select * from CustTable where CustTable.AccountNum like "*H?"

You need to create several reports that use the same combination of tables as data sources. You know that you will need a relation between these tables so that the report outputs as desired. You also want the ability to change details, such as report parameters or sorting options, at run time.
Which element should you create to store these tables and the relations so that you can reuse the element as the data source on future reports?

• A.a table map
• B.a new table
• C.a query
• D.a view

You create a privilege to maintain vendor information.
To which two elements can you add the privilege? Each correct answer presents part of the solution.

• A.permissions
• B.duties
• C.roles
• D.policies