Microsoft MB7-702 Online Practice Questions and Exam Preparation

Microsoft MB7-702 Online Questions & Answers

• Question 71:

  You plan to create a Statistics page based on a table with information of training courses sold over time. You need to create a calculated field with the number of training courses sold and a date filter to make it possible to get figures based on day, week, month, or year.

  Which two fields should you create?

  A. Sold Training Courses field with the FieldClass=FlowFilter property and Date field with the FieldClassFlowFilter property
  B. Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClass=FlowFilter property
  C. Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClassFlowField property
  D. Sold Training Courses field with the FieldClass=FlowFilter property and Date field with the FieldClassFlowField property
  B. Sold Training Courses field with the FieldClassFlowField property and Date field with the FieldClass=FlowFilter property

• Question 72:

  What is the Microsoft Dynamics NAV name for a Microsoft SQL Server index key?

  A. Secondary key
  B. Primary key
  C. Field in a key definition
  D. Heap
  B. Primary key

• Question 73:

  In Microsoft Dynamics NAV, for which two actions can you use a Microsoft SQL Server collation? (Each correct answer presents part of the solution. Choose two.)

  A. to specify the sort order to use for Unicode data types per company
  B. as the code page that is used to store non-Unicode character data per company
  C. as the code page that is used to store non-Unicode character data per database
  D. to specify the sort order to use for Unicode data types per database
  B. as the code page that is used to store non-Unicode character data per company
  D. to specify the sort order to use for Unicode data types per database

• Question 74:

  You need to debug codeunit 80 - Sales Post on a sales order to validate whether the Invoice variable changes status during the execution of the codeunit. How should you add the Invoice field to the Watches list in the debugger?

  A. In the Watches section, click the Action menu item, and then click the Customize button.
  B. Click the Variable button on the ribbon menu. Then find the variable and click the Add Watch button.
  C. Find the Invoice variable in the code section, right-click it, and then click the Add Watch button.
  D. Click the Set/Clear Condition button on the ribbon menu. Then find the variable and click the Add Watch button.
  B. Click the Variable button on the ribbon menu. Then find the variable and click the Add Watch button.

• Question 75:

  Which three function types are valid for handler functions? (Each correct answer presents part of the solution. Choose three.)

  A. ReportHandler
  B. RoleCenterHandler
  C. MessageHandler
  D. TestHandler
  E. Normal
  F. ConfirmHandler
  A. ReportHandler
  C. MessageHandler
  F. ConfirmHandler

• Question 76:

  You need to create a report object that processes data in batches and updates data tables, but does not generate any printed output. What should you do?

  A. Name the object. Append the word "Batch" at the end of the object name.
  B. Ensure the TransactionType property is set to either Update or UpdateNoLocks.
  C. Set the ProcessingOnly property to Yes.
  D. Create the report object without defining any DataItems.
  C. Set the ProcessingOnly property to Yes.

• Question 77:

  You need to debug codeunit 80 - Sales Post on a sales order to ensure that a certain set of lines are performed. How should you debug it?

  A. Start the debugger and select a session that is ready to post a sales order. The debugger starts when you choose Post (F9) on the ribbon menu.
  B. Only start the debugger and select a session that is ready to post a sales order.
  C. Set a breakpoint trigger in codeunit 80, and then select a session that is ready to post a sales order. The debugger starts when you press Post (F9) on the ribbon menu.
  D. Start the debugger and select a session that is ready to post a sales order. Then click the Set/Clear Condition button on the ribbon menu to mark codeunit 80 to be debugged.
  C. Set a breakpoint trigger in codeunit 80, and then select a session that is ready to post a sales order. The debugger starts when you press Post (F9) on the ribbon menu.

• Question 78:

  You need to create a Seminar Statistics page that shows a decimal field by using SumlndexField Technology (SIFT). Which calculation of the CalcFormula method should you use?

  A. LOCKUP
  B. EXIST
  C. SUM
  D. COUNT
  C. SUM

• Question 79:

  Which two statements about the C/AL LOCKTABLE command are true? (Each correct answer presents a complete solution. Choose two.)

  A. All records in the table read by SQL Server are locked to ensure database integrity.
  B. The command is valid for all subsequent instances of record variables based on the table within the transaction.
  C. Only records in the table within the filter are locked by SQL Server to ensure database integrity.
  D. The command locks the table in SQL Server to ensure database integrity.
  B. The command is valid for all subsequent instances of record variables based on the table within the transaction.
  D. The command locks the table in SQL Server to ensure database integrity.

• Question 80:

  You have a setup table and page.

  You must insert the following code segment into a page trigger:

  RESET;

  IF NOT GET THEN BEGIN

  INIT; INSERT; END;

  Which trigger should you select?

  A. OnInit
  B. OnOpenPage
  C. OnClosePage
  D. OnQueryClosePage
  E. OnFindRecord
  B. OnOpenPage