FileMaker Developer Essentials for FileMaker 12 Beta Sample Questions:

1. Which two actions could generate a line chart that contains multiple lines? (Choose two.)

A) display a found set of data in Table View, sort by two fields, then click on the header of one of the sort fields and create a Quick Chart using both sorted fields
B) set the chart to use data from Related Records and specify multiple data series, each based on a related number field
C) set the chart to use data from Current Found Set and specify multiple data series, each referencing a single number field
D) set the chart to use data from Current Found Set and specify a single data series that contains a return delimited list of values

2. Which three field options may be set for a shadow field from an External ODBC Data Source? (Choose three.)

A) Auto-enter: serial number, on commit
B) Storage: Minimal Indexing
C) Validation: existing value
D) Validation: unique value
E) Auto-enter: creation date
F) Validation: validated by calculation

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

4. 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 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.
B) These fields may be indexed unless they are of type Summary.
C) These fields may only be of type Summary or Calculation
D) 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.

5. Which two will allow an account to perform a server-side script in FileMaker Server 12?
(Choose two.)

A) The Extended Privilege Access via Server Scripts [fmsscript] is checked.
B) The Extended Privilege Access via FileMaker Network [fmapp] is checked.
C) The account under which the script is run must have privileges to execute the specified script.
D) The specified script is set to Run script with full access privileges
E) The Allow Enabled Schedules to Run is checked in the FileMaker Server Admin Console.

Solutions: