FileMaker Developer Essentials for FileMaker 12 Beta Sample Questions:

1. Which statement is true about supplemental fields added to a table occurrence based on an External ODBC Data Source that uses MySQL?

A) These fields will be added to the table definitions within MySQL when the Sync button in the FileMaker Pro 12 Manage Database dialog is used.
B) These fields may only be of type Summary or Calculation
C) These fields will be lost if the schema of the MySQL table is changed and then the Sync button in the FileMaker Pro 12 Manage Database dialog is used.
D) These fields may be indexed unless they are of type Summary.

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

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

3. What is the minimal requirement to add an external FileMaker Data Source table occurrence of Inventory from a file called DEPT to the Relationships Graph of a file called PROD?

A) an active account associated with any privilege set in PROD, and an active account associated with a privilege set that has view record access for the Inventory table
B) an active account associated with the [Full Access] privilege set in PROD and an active account in DEPT associated with a privilege set that has view record access for the Inventory table
C) an active account in DEPT associated with a privilege set that has the Manage External Data Sources option checked, and an active account with the [Full Access] privilege set in PROD
D) an active account associated with the [Full Access] privilege set in both PROD and DEPT
E) an active account associated with a privilege set that has the Manage External Data Sources option checked in both PROD and DEPT

4. A text field called FirstLast in FileMaker Pro 12 is set to auto-enter the following formula:
FirstName & " " & LastNarne
FirstName and LastNarne are text fields in the same table. The option Do not evaluate if all referenced fields are empty is unchecked. The option Do not replace existing value of field (if any) is checked.
Under which two circumstances will the value of the calculation be inserted into the FirstLast field? (Choose two.)

A) the FirstName or LastNarne field is modified and the FirstLast field is empty
B) a user selects the menu item Records > Relookup Field Contents
C) a record is first created
D) each time the value of the FirstName or LastNarne field is modified
E) any field value on the record is modified and the FirstLast field is empty

5. 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 enterprise-class backup software to do an incremental system backup of the FileMaker Server 12 at least once a day
C) Use the Server Admin Console Schedule Assistant or fmsadmin tool to perform backups
D) Include the option to Verify backup integrity in backups performed during off-peak hours
E) Use enterprise-class backup software to do a full system backup of the FileMaker Server 12 at least once a week

Solutions: