FileMaker Developer Essentials for FileMaker 12 Sample Questions:

1. Which statement is true given two FileMaker Pro 12 files, Vendors and Products, if a table from Products appears on the Vendors Relationships Graph?

A) Layouts from Products can be displayed in the same window as layouts from Vendors.
B) A table occurrence from Products is required on the Vendors Relationships Graph in order to call a script in Products from Vendors
C) Vendors can contain multiple valid external FileMaker Data Sources referencing Products.
D) Scripts in Vendors can reference data from global variables defined in Products.

2. A database has a Customer table and an Order table. On a layout based on the Customer table there is a portal showing related orders for the current calendar year. The portal does not include a filter formula. 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. zSumOrders is included on the layout.
Assuming no changes to the data, what may cause the displayed value of zSumOrders on a customer record to change?

A) In Layout Mode, move the zSumOrders field into the Orders portal row
B) Change the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal
C) Add one or more sort criteria to the relationship on which the Orders portal is based
D) Add a portal filter using Filter Portal Records so only unpaid orders will be displayed

3. A FileMaker Pro 12 file contains the following script:

If this script is executed in a context where there is found a set of six records, which value will be returned from the script?

A) No value will be returned.
B) 1
C) 6
D) 7

4. Which two statements are true about fields using global storage in FileMaker Pro 12? (Choose two.)

A) Changes to data in globally stored fields in a shared file are stored when the server cache is flushed.
B) Fields using global storage can be used as match fields in a relationship.
C) Globally stored fields are always empty at the start of a user's session.
D) Globally stored fields can only be accessed from within the file in which they are defined.
E) A container field using global storage may not be configured to store its data externally.

5. Which two statements are true about container fields that are configured to Store container data externally in FileMaker Pro 12? (Choose two)

A) It is possible to customize the directory location where FileMaker Pro 12 will store external container data.
B) Container data stored externally using Secure storage is encrypted.
C) FileMaker Pro 12 can store a maximum of 64 million external files per database file.
D) Once a container field has been configured to store data internally, the data must be re-imported if the field is changed to store data externally.

Solutions: