FileMaker Developer Essentials for FileMaker 12 Sample Questions:

1. Considering the following scenario:
File Access protection is now turned ON in file A.
Which two statements are true about this situation? (Choose two)

A) File A will now require authorization to access file
B) To authorize file C to access file A, a user will require a minimum of write access for both files.
C) File B will be automatically authorized in file
D) To create a new script in file C that uses the Open File script step to open file A will require authorization
E) The user is prompted to authorize file B when file B is open.

2. Given two tables in FileMaker Pro 12 with the following fields and table occurrences:

What two methods can be used to add a portal to a layout based on the Players table, which shows only the names of the current player's teammates, but not the current player's name? (Choose two.)

A) base the portal on the relationship Players:: TeamID = Teammates:: TeamID Anduse a portal filter based on the calculation Players:: PlayerIDTeammates:: PlayerID
B) basesthe portal on the multi-predicate relationship: Players::TeamID = Teammates::TeamID AND Players: PlayerIDTeammates:: PlayerID
C) base the portal on the relationship Players::TeamID = Teammates::TeamID Seta sort order of PlayerID. Ascending on the relationship, and Configurethe portal to have an Initial row value of 2.
D) base the portal on the relationship Players:: Team ID = Teammates:: Team ID Anduse a portal filter based on the calculation Players:: PlayerIDSelf

3. A FileMaker Pro 12 database has a script called MyScript that contains only the following script step:
Install OnTimer Script [Hello World; Interval:60]
From Window_01 the user runs MyScript and then creates a new window (Window_02). From Window_02 the user creates a new window (Window_03).
What is the status of the script Hello World?

A) The Hello World script runs immediately when each new window opens.
B) The Hello World script will continue to run on Window_01 and Window_02 and Window_03.
C) The Hello World script will continue to run on Window_01 until it triggers for the first time in one of the new windows.
D) The Hello World script will continue to run on Window_01 but will not run on Window_02 or Window_03.

4. Given a text field Full Name, Auto-Enter by Calculated value has been selected in the field options, using the following formula:
Name First &." "& Name Last
The developer then disables (unchecks) the option Do not replace existing value of field (if any).
For which two cases will the results of the specified formula be inserted into the field Full Name? (Choose two.)

A) Only when the field Full Name was previously empty
B) When the field Full Name itself is modified
C) When either of the fields Name First or Name Last is modified
D) When the field Full Name itself is modified and the record is committed
E) When the record is first created

5. Which two features of FileMaker Pro 12 require indexing in order to work? (Choose two.)

A) The ExecuteSQL calculation function with a JOIN in the query
B) The List function
C) Dynamic subsummary reports in Browse mode
D) Auto-complete using existing values
E) Dynamic value lists based on FileMaker tables

Solutions: