Microsoft MB7-702 Online Practice Questions and Exam Preparation

Microsoft MB7-702 Online Questions & Answers

• Question 51:

  When does the OnInsert trigger run on a table?

  A. The trigger code is run before the record is inserted into the database.
  B. The trigger code is run after the record is inserted into the database.
  C. The trigger code is run after the user enters data in every field.
  D. The trigger code is run before the user enters data in every field.
  A. The trigger code is run before the record is inserted into the database.

• Question 52:

  In SQL Server Profiler you view the following query from Microsoft Dynamics NAV:

  SELECT SUM("Amount") FROM "CRONUS International Ltd_$Sales Line" WHERE "Document

  No_" = `ORD-980001'

  Which two statements are true? (Each correct answer presents a complete solution. Choose two.)

  A. There is no SumIndexField amount on the Sales Line table for a key that includes the Document No. field.
  B. The MaintainSIFTIndex property is set to FALSE for a key that includes the Document No. field and the Amount field set as SumIndexField.
  C. All keys that include the Document No. field and the Amount field set as SumIndexField are disabled.
  D. There is no SumIndexField Technology (SIFT) bucket enabled in the property SIFTLevelsToMaintain for the Amount field for a key that includes the Document No. field and the Amount field set as SumIndexField.
  A. There is no SumIndexField amount on the Sales Line table for a key that includes the Document No. field.
  B. The MaintainSIFTIndex property is set to FALSE for a key that includes the Document No. field and the Amount field set as SumIndexField.

• Question 53:

  Which three actions can be found on master pages? (Each correct answer presents a complete solution. Choose three.)

  A. Release open documents
  B. Access navigation
  C. Access statistics
  D. Create new documents
  E. Reverse ledger entries
  F. Access ledger entries
  A. Release open documents
  C. Access statistics
  D. Create new documents

• Question 54:

  You need to develop an enhancement for a regional customer that will be reused for several future enhancements. Which menu ID and level should you use to meet the requirements?

  A. 1020, Dept - Region
  B. 1030, Dept - Country
  C. 1080, Dept - Partner
  D. 1090, Dept - Company
  C. 1080, Dept - Partner

• Question 55:

  When browsing through the tables of a Microsoft Dynamics NAV database, you see a table that is named CRONUS International Ltd_$17 $1. Which two statements about the CRONUS International Ltd_$17$1 table are true? (Each correct answer presents a complete solution. Choose two.)

  A. The table is related to a table with an ID of 17.
  B. It is in a database with a version number older than Microsoft Dynamics NAV Version 5 Service Pack 1.
  C. The table contains total values represented by the first key from the related table with SumIndexFields.
  D. The related table contains one key with SumIndexFields.
  A. The table is related to a table with an ID of 17.
  C. The table contains total values represented by the first key from the related table with SumIndexFields.

• Question 56:

  What are the characteristics of a Cue table?

  A. It contains a single record, with each cue being a field with a FieldClass of FlowField and with a DataType of Integer.
  B. It contains many records, one for each cue. The table is defined with a single field with a FieldClass of FlowField and with a DataType of BigInteger.
  C. It contains a single record, with each cue being a field with a FieldClass of Normal and with a DataType of BigInteger.
  D. It contains many records, one for each cue. The table is defined with a single field with a FieldCIass of Normal and with a DataType of BigInteger.
  A. It contains a single record, with each cue being a field with a FieldClass of FlowField and with a DataType of Integer.

• Question 57:

  You create a set of tables with pages so that it is possible to type Seminar Journal Lines in the Seminar add-on. Which three codeunits make up a posting routine for Journal Lines? (Each correct answer presents part of the solution. Choose three.)

  A. Post Line (Yes/No)
  B. Check Line
  C. Post Batch
  D. Post Batch (Yes/No)
  E. RunCheck Line
  F. Post Line
  B. Check Line
  C. Post Batch
  F. Post Line

• Question 58:

  How many dimension columns must be created on a Seminar Journal Line Page?

  A. Two
  B. Six C. Eight
  D. Ten
  C

• Question 59:

  Which statement is true of a setup table for an application area?

  A. There must only be a single setup record per application area, with the primary key field named Primary Key in the Table Designer.
  B. Setup records may not be modified by users. Setup data is populated by developers to ensure the correct behavior of the application area.
  C. There can be several setup records per application area, with the primary key field named Primary Key in the Table Designer.
  D. There can be several setup records per application area, with the primary key field named Setup in the Table Designer.
  C. There can be several setup records per application area, with the primary key field named Primary Key in the Table Designer.

• Question 60:

  You have the following C/AL code:

  

  You must modify code that loops through the purchase lines of a purchase order to sum up the total quantity of items on the order. You need to select a method to replace the WHAT_FIND_METHOD. Which method should you use?

  A. FINDLAST
  B. READ
  C. FINDFIRST
  D. FINDSET
  D. FINDSET