Microsoft MB6-704 Online Practice Questions and Exam Preparation

Microsoft MB6-704 Online Questions & Answers

• Question 11:

  You need to identify which elements the Reverse engineer tool will provide for a data model. Which three elements should you identify? Each correct answer presents part of the solution.

  A. Table methods
  B. Classes
  C. Table fields
  D. Base enumerations
  E. Extended data types (EDTs)
  C. Table fields
  D. Base enumerations

  ---

  The following table lists the elements that are included in the diagram for the UML data model:

  *

  (C) Table fields

  *

  (D) All base enums

  *

  (F) All extended data types Etc.

  Note: The Reverse Engineering tool can create the following types of UML models:

  *

  UML data model

  *

  UML object model

  Reference: Reverse Engineering Tool Overview [AX 2012]

• Question 12:

  You need to add a conditional statement into a query object. Which class should you use?

  A. Query Item
  B. Query Build Data Source
  C. Query
  D. Query Range
  C. Query

  ---

  In Microsoft Dynamics AX, you can create a query to retrieve data by using the query classes.

  Note: The Query class enables you to create, read, update, and delete X++ code and metadata.

  The Query class embodies the structure of a query. Objects of this type are not used for fetching records from the database. Instead, use a QueryRun object that may be assigned a query object. The dynamic behavior of a query is defined by the . The static behavior is defined by the Query class. Queries contain one or more data sources that correspond to tables in the database. The data sources are specified by using QueryBuildDataSource objects.

  Incorrect Not B: The QueryBuildDataSource class provides the building blocks that queries are made of. Data sources are arranged in hierarchies that define the sequence in which records are fetched from the tables that are assigned to the data sources. Each data source defines the order in which the records are fetched, and also the criteria that must be met by the selected records. This class lets you create, read, update, and delete X++ code and metadata. Not D: Query range value expressions can be used in any query where you need to express a range that is more complex than is possible with the usual dot-dot notation (such as 5012..5500).

  Reference: How to: Create Queries by Using X++ [AX 2012]

• Question 13:

  You have a table named Vend Table that contains a field named Main Contact Worker. Main Contact Worker is the reference Recid. Many records in the Vend Table table have the same value for Main Contact Worker.

  Users frequently search for data in the Vend Table table based on the Main Contact Worker field.

  You need to ensure that when the users create queries that include the Main Contact Worker field in the where clause, the query results are returned in the least amount of time possible.

  What should you create in Vend Table?

  A. A unique index in Main Contact Worker
  B. A surrogate key that is used as the primary index
  C. A primary index for Main Contact Worker
  D. A non-unique index in Main Contact Worker
  B. A surrogate key that is used as the primary index

  ---

  For new tables the default is a primary key based on the RecId field. This is represented as the surrogate key in the user interface.

  PrimaryIndex: contains the surrogate key plus every index on the table that has its AlternateKey property set to Yes.

  Note: If you store surrogate foreign key values in your tables, you will have to correctly work with these values in your Enterprise Portal integration. This involves creating a reference data source to link to the data that is accessed by the

  surrogate foreign key. It can also include using the AxReferenceField to access the surrogate foreign key value.

  Reference: Table Keys: Surrogate, Alternate, Replacement, Primary, and Foreign [AX 2012]

• Question 14:

  You are creating an extensible data security (XDS) policy.

  You need to return the data from the primary table that will be used to filter the data in a con- strained table.

  What should you use?

  A. The Code profiler
  B. Code permissions
  C. Secured APIs
  D. A policy query
  D. A policy query

  ---

  You can define a policy query by specifying a value for the Query property in the AOT at Secu- rity > Policies > YourPolicy. You can use a policy query to secure the constrained tables speci- fied in a given security policy. The query selects data from a primary table. The values in that data are then used to restrict the data returned from the constrained table.

  Reference: Overview of Security Policies for Table Records [AX 2012]

• Question 15:

  You have a form that displays a list of items from a table named Table l.

  You need to prevent all users from updating the records by using the form. What should you modify?

  A. The table field groups
  B. The menu items
  C. The form template
  D. The data source
  B. The menu items

  ---

  Role-based security in Microsoft Dynamics AX

  The security model is hierarchical, and each element in the hierarchy represents a different level of detail. Permissions represent access to individual securable objects, such as menu items and tables.

  Incorrect:

  Not A:

  Field groups make it easier to create a logical layout in a form or report in a number of ways:

  A whole group of fields can be added to a form or report in one step instead of moving them in- dividually. The field group can be given a label that is displayed on the form. It's easier to update forms and reports using field groups because a

  change to a field group is re- flected in all the forms and reports that use it.

• Question 16:

  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?

  A. Inner
  B. Exists
  C. Outer
  D. Not exists
  A. Inner

  ---

  InnerJoin: - Combined data source select the record from the main table that matches records in the joined table and vice versa. There is one record for each match. Records without related records in the other data source are eliminated from the result.

  Reference: Link Type and Join Types in ax 2012

• Question 17:

  You have a table that contains invoices.

  You need to create a Fact Box that displays the number of invoices in the table.

  Which type of Fact Box should you use?

  A. form part
  B. cue group
  C. cue
  D. info part
  D. info part

  ---

  *

  Info part:

  part that shows a collection of data fields from a specified query. An info part uses metadata to describe how the data appears. As a result, you can use an info part in both the client and EP.

  *

  FactBox type: Fields and values

  Info part or form part

  A FactBox that shows a list of field names and values. The value can include a link that opens the record in a form.

  Incorrect:

  Not A: Form Part

  A part that represents a pointer to a form. You use a form part when you want a form to appear in the FactBox pane, enhanced preview, or preview pane.

  Not B: cue group

  A part that includes reference to one or more cues. You use a cue group to list a collection of query results. Typically, the list shows summary data that is related to a record or a task.

  Reference: Parts [AX 2012]

• Question 18:

  You have a process that throws an Update Conflict exception.

  You need to identify a possible cause of the exception.

  What should you identify?

  A. The security for the table in which the record resides was changed between the time you se- lected the record for update and the time you attempted to change the record.
  B. a new record was inserted in the table between the time you selected the record for update and the time you attempted to change the record.
  C. The table in which the record resides was renamed between the time you selected the record for update and the time you attempted to change the record.
  D. The record changed between the time you selected the record for update and the time you at- tempted to change the record.
  D. The record changed between the time you selected the record for update and the time you at- tempted to change the record.

  ---

  Optimistic Concurrency Control (OCC) helps increase database performance. Pessimistic Con- currency Control locks records as soon as they are fetched from the database for an update. How- ever, Optimistic Concurrency only locks records from the time when the actual update is per- formed. OCC makes it possible for other processes to update a record even after it has been fetched. You can catch update conflicts by catching the UpdateConflict and UpdateConflictNotRecovered ex- ceptions.

  Reference: Optimistic Concurrency Control [AX 2012]

• Question 19:

  You make changes to the security configuration of a role.

  You need to ensure that the changes appear in the Application Object Tree (AOT) immediately.

  What should you select from the Caches menu?

  A. Refresh data
  B. Refresh dictionary
  C. Refresh report server
  D. Refresh elements
  B. Refresh dictionary

  ---

  Refresh dictionary

  Flushes cached application object information for items in the Data Dictionary node of the AOT. Use this when you have made changes to resources in the Data Dictionary node, such as tables or extended data types, but the changes are not

  immediately reflected in Enterprise Portal.

  Incorrect:

  Not A: Refresh data

  Flushes cached database records. Use this when changes in the database are not immediately re- flected in Enterprise Portal.

  Not C, not D: No such refresh commands.

  Reference: Troubleshooting: Enterprise Portal Development [AX 2012]

• Question 20:

  You have a class named Classl.

  You need to identify all of the classes that extend Classl.

  Which tool should you use?

  A. The Type hierarchy browser
  B. The Tracing cockpit
  C. The Code profiler
  D. The Compare tool
  A. The Type hierarchy browser

  ---

  You can view information about the parents and children of application objects by using the Type Hierarchy Browser. For example, you can see all the classes that extend a particular class, or see which data types a particular extended data type inherits from. You can also see which types implement fields, methods, and properties.

  Reference: Type Hierarchy Browser and Type Hierarchy Context [AX 2012]