FileMaker Developer Essentials for FileMaker 12 Sample Questions:

1. Which statement is true about the Filter Portal Records feature in FileMaker Pro 12?

A) The portal filter formula may not refer to any globally stored fields, summary fields, or unstored calculation fields.
B) The feature requires one or more additional relationships to be added to the Relationships Graph.
C) Aggregate functions (e.g., Sum, Count) based on the portal's relationship will not be affected by the portal's filter formula.
D) There can be one unique filter formula applied for each portal state (Normal State, In Focus, Hover, or Pressed)
E) The portal filter formula must refer to at least one field in the immediately related table.

2. Given the following Relationships Graph for a FileMaker Pro 12 database, where Employee, Manager, and Trainer are all table occurrences sharing the same source table:

The database has the following layout, based on the Trainer table occurrence:

If a developer adds the following fields to the portal:
Class:: Class Name Employee:: Name Manager:: Name
Which data is shown in the portal?

A) The first class each employee is enrolled in, all employees managed by the trainer, and the trainer as manager for each employee
B) Each of the trainer's classes, the first employee enrolled in each class, and the trainer as manager for that employee
C) The first of the trainer's classes in all rows, all employees enrolled in any of the trainer's classes, and the first related manager for each employee
D) The first class each employee is enrolled in, all employees enrolled in any of the trainer's classes, and the first related manager for each employee
E) Each of the trainer's classes, the first employee enrolled in each class, and the first related manager for each employee

3. Which statement is true regarding applying object styles in FileMaker Pro 12?

A) Holding down the Alt (Windows) or Option (Mac OS X) key while clicking the Copy Object Style button in Inspector will only copy the styles for the currently selected object state.
B) The Format Painter tool can only apply styles associated with the Normal State of an object.
C) The Copy Object Style and Paste Object Style buttons of the Inspector will only work among layouts of the same file.
D) The Format Painter will only apply styles to objects on the same layout.
E) The Format Painter cannot be used to apply the style of one layout part to another.

4. Consider two FileMaker files, Collection and Item, where tables from Item are included in the Relationships Graph of Collection.
Which method will preserve all functionality in the Relationships Graph of Collection after renaming the Item file to Artifact?

A) Delete referenced Item table occurrences in the Relationships Graph for Collection andrecreate them for Artifact
B) Choose File > Manage > External Data Sources... for Collection and reset the file path
C) Select referenced Item table occurrences in the Relationships Graph for Collection and right-click to choose Rename File Source...
D) Click the Repair Reference button in the Relationships Graph for Collection and reset the file path

5.
Assume the user has full privileges to view and modify all data in the file. Which two statements are true in this situation? (Choose two.)

A) The Name Last field is in the Header part.
B) If viewed as a form in Browse mode, Quick Find will ignore the data in the Name Last field.
C) The Name Last field will be excluded from the list of available fields in the Sort Records... dialog for the Current Layout
D) The user will be able to edit the contents of z_TempText in Table view.
E) The script step insert Text [Select; Customer:: z_TempText; "Complete"] will result in Error 102 ("Field is missing") and z_TempText will be empty.
F) The Activities portal, Name Last field, and z_TempText field are within the page boundary and thus will be included when printed in Form view.

Solutions: