FileMaker FileMaker Certifications FM0-305 Questions & Answers

• Question 81:

  What is a reason to use the Let() function in a formula for a FileMaker Pro 11 calculation field?

  A. to set a variable $$status that can be displayed on a layout

  B. to limit the iterations of a Loop() function used in the formula

  C. to modify data in a text field referenced elsewhere in the formula

  D. to define a custom function that can be used in other calculation formulas

  Correct Answer: A

• Question 82:

  What can be retrieved using one of the Get functions?

  A. the list of users logged into a file

  B. the list of plugins installed for a user

  C. the list of script triggers defined for a named object on a layout

  D. the list of unique IDs for the current window's found set of records

  E. the list of NIC addresses for network cards connected to the user's computer

  Correct Answer: E

• Question 83:

  For which two actions will FileMaker Pro 11 NOT preserve Sort Order for records being browsed, by reordering or resorting the found set following the action? (Choose two.)

  A. selecting the Records > Show Omitted Only menu item

  B. adding records to the table using File > Import Records > File...

  C. modifications to a field's data caused by choosing Relookup Field Contents for a field used to specify the current sort order

  D. modifications to schema for instance redefining a field type from Number to Text when that field is used to specify the current sort order

  E. in Browse mode, rightclick a field that is used as a a field used to specify the current sort order and choose the Extend Found Set popup menu item to add some matching records to the found set

  Correct Answer: AB

• Question 84:

  A database has an Order table and a Customer table. There is a relationship between Customer and Order. On a layout based on the Customer table there is a portal showing all of that customer's orders for the current calendar year. The portal has no filter criteria applied. There is a calculation field in the Customer table, zSumOrders, that adds up the total amount of all the customer's orders for the year. This field is displayed below the portal. Which one may cause the displayed value of zSumOrders on a customer record to change?

  A. adding one or more sort criteria to the Orders portal

  B. adding one or more sort criteria to the relationship on which the Orders portal is based

  C. using Filter Portal Records to further limit the set of records displayed in the Orders portal

  D. changing the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal

  E. selecting the Save record changes automatically setting in the Layout Setup dialog for the layout in question

  Correct Answer: D

• Question 85:

  For which two actions will FileMaker Pro 11 automatically preserve sort order for a found set of records by reordering or resorting the found set following the action? (Choose two.)

  A. Import records using Update matching records in found set to modify some values in a field used as a sort key.

  B. Use Replace Field Contents... on a field used as a sort key to change its values for all the records in the found set.

  C. Edit a value list, when that value list is currently defining a field's sort order (i.e. Sort Records using Custom order based on value list).

  D. A script run in another user session includes the Set Field By Name script step and modifies the value of a sort key field in one of the records of the current user's found set.

  Correct Answer: BD

• Question 86:

  For which two is it possible to specify conditional formatting? (Choose two.)

  A. a Web Viewer

  B. a merge variable

  C. a layout's body part

  D. the title of a chart object.

  E. an inserted graphic formatted as a button

  F. a rectangle object being used as a graphical background

  Correct Answer: AB

• Question 87:

  Which two events can activate an OnObjectEnter script trigger? (Choose two.)

  A. clicking a button

  B. tabbing to a button

  C. navigating from one row in a portal to another

  D. switching from one tab to another in a tab control

  Correct Answer: BC

• Question 88:

  Which two statements are true about OnTimer triggers? (Choose two.)

  A. They only run when the application is idle.

  B. OnTimer triggers are configured in the File Options dialog.

  C. Different OnTimer scripts can be installed in different windows.

  D. Days and times can be specified when the OnTimer script activates.

  Correct Answer: AC

• Question 89:

  For which two script triggers can the processing of the triggering event be canceled using Exit Script [False]? (Choose two.)

  A. OnLayoutExit

  B. OnViewChange

  C. OnObjectEnter

  D. OnObjectModify

  E. OnObjectValidate

  Correct Answer: AE

• Question 90:

  The field exampleField has a script trigger set to activate OnObjectKeystroke and run the following script:

  Allow User Abort [Off]

  Set Error Capture [On]

  If [Length (File::exampleField)= 7]

  Exit Script [Result: 0]

  Else

  Set Field [File::exampleField File::Field and ""]

  Exit Script []

  End If

  The field exampleField has the value of 111111.

  At the end of the string a 9 is entered.

  What is the resulting value in the field after the script trigger has processed?

  A. 0

  B. 111111

  C. 111111

  D. 1111110

  E. 1111119

  Correct Answer: B