Q1. 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*"

View Answer

Q2. A relationship is defined between two tables named CustTable and CustGroup. Each record in CustTable references a record in CustGroup.

You need to set up delete actions to ensure that records in CustGroup can only be deleted if there are no CustTable records that reference or relate to the record.

Which values for the On Delete property for the relation should you specify?

A. None

B. Cascade + Restricted

C. Restricted

D. Cascade

View Answer

Q3. You are required to configure a Microsoft Dynamics AX production environment for your customer.

You need to configure the Dynamics AX server as part of the overall installation and configuration.

Which two components can be used to deploy the server? Each correct answer presents a complete solution.

A. Database

B. Azure Infrastructure as a Service (IaaS) Virtual Machines

C. Windows PowerShell Commands

D. Internet Information Services (DA) web application

View Answer

Q4.  You need to write an expression to calculate the compound interest that a bank needs The formula for compound interest after one period is as follows:

I = (P * (1 + R)) - P

Where

I = Compound interest

P = Principal that was invested R = Rate of interest

after one period.

Which X++ expression is equivalent to the formula above using operator precedence in X+-

+-?

A. I = P* 1 + R- P

B. I = P*(1 + R-P)

C. I = P*(1 + R)-P

D. I = (P* 1) + (R-P)

View Answer

Q5. You have an X++ class, which has the following code:

You need to call checkBOM() method of the BomHierarchyCheck class from a static method class. Which code should you write within the static method to achieve this goal?

A)

B)

C)

D)

A. Option A

B. Option B

C. Option C

D. Option D

View Answer

Q6. You are working in the Visual Studio development environment

You need to develop a simple list form. This form should let users add new records but should not let users edit existing records.

Which properties should you set to achieve this goal?

A. Set Form > Data Source > Property > AllowEdit to Yes & Set Form > Data Source > Property > AHowEditOnCreate to Yes

B. Set Form > Data Source > Property > AllowEdit to No & Set Form > Data Source > Property > AHowEditOnCreate to Yes

C. Set Form > Data Source > Property > AllowEdit to No & Set Form > Data Source > Property > AHowEditOnCreate to No

D. Set Form > Data Source > Property > AllowEdit to Yes & Set Form > Data Source > Property > AHowEditOnCreate to No

View Answer

Q7. You are developing a form that allows users to update an order status. You create a table named Tablel that you will use as a data source for this form.

You want to include a radio-button style selection so that the end user can choose between three different order statuses: "Canceled", "Delivered", "Processing".

What should you add to Table1 so that you can add the radio button selection to the form?

A. three different string fields that represent each order status

B. three different Extended Data Types (EDTs) of type string with each order status

C. a Boolean data type with values that represent each choice

D. a base enumeration with three elements that represent each order status

View Answer

Q8. You need to present the advantages of label files to your project team.

Which three attributes of label files should you mention? Each correct answer presents part of the solution.

A. supports multiple language formats

B. creates reusable content that can be updated centrally

C. serves as a centralized database of all labels

D. restricts labels to a finite list of those available

E. hard codes the string answers within code, without reference

View Answer

Q9. You need to create a base enumeration to store the different values for types of services your company offers. You add several different service types to the enumeration. The first service type you create for the enumeration is "Cleaning".

When you look in the database, what do you see in the ServiceType column that represents the Cleaning service type?

A. 0

B. -1

C. A

D. Cleaning

View Answer

Q10. You plan to create two tables Table1 and Table2. Both tables will have a field of type string that has a length of 15 and is named Customer Number. The tables will have a relation on the Customer Number field.

You need to ensure that the string length of Customer Number is identical in both tables. The solution must ensure that if any relations on the Customer Number field are added to other tables, the additional tables will have the same string length for Customer Number.

What should you use?

A. an index

B. a class

C. an extended data type

D. a base enumeration

View Answer