FileMaker Developer Essentials for FileMaker 12 Sample Questions:

1. Which two statements are true about a Daily Backup Schedule that includes the option to keep a maximum of seven backups? (Choose two.)

A) On the eighth day of normal functioning. FileMaker Server deletes the oldest backup, which was done on the first day of the previous week, and replaces it with a new backup on the first day of the current week.
B) On the eighth day of normal functioning, FileMaker Server moves the oldest backup created by that schedule to an archive folder.
C) FileMaker Server creates a subfolder each time the schedule is run and places all backups created at that time in the subfolder.
D) FileMaker Server creates a subfolder for the schedule and saves all backups to it, appending a timestamp to the name of each backed up file.

2. Which statement is true regarding layout themes in FileMaker Pro 12?

A) The style attributes for a new object (e.g. field or text box) added to a layout will be determined by the layout part in which it is created
B) Changing a layout's theme will optionally update all layouts sharing the same original theme by choosing Update matching layouts in the Change Theme dialog.
C) Changing a layout to the Classic theme of the Basic theme group will leave all objects and their styles unaffected.
D) A Touch theme (e.g. River Touch) must be used for a layout to be compatible with iOS devices.
E) Holding down the Control (Windows) or Command (Mac OS X) keys while clicking the Apply theme styles button of the Inspector, the object styles of the currently selected object will be applied to all objects of the same type on the layout.

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

4. According to the FileMaker Server Configuration Guide, which two are considered best practices for backing up databases hosted by FileMaker Server 12? (Choose two.)

A) Configure backup schedules to direct the backup of hosted databases directly to another computer or storage device
B) Use the Server Admin Console Schedule Assistant or fmsadmin tool to perform backups
C) Include the option to Verify backup integrity in backups performed during off-peak hours
D) Use enterprise-class backup software to do a full system backup of the FileMaker Server 12 at least once a week
E) Use enterprise-class backup software to do an incremental system backup of the FileMaker Server 12 at least once a day

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

Solutions: