FileMaker FM1-306 Exam : Developer Essentials for FileMaker 12 Beta Exam

A table in a FileMaker Pro 12 database has a text field CompanyName. The following field validation options are set for this field:
* Validate data in this field only during data entry
* Allow user to override during data entry
* Require not empty
* Display custom message if validation fails
A user imports a set of records into this table. Some records have no value in the CompanyName field. What will occur?

• A. All records with a value for CompanyName will be imported. The user will see an error dialog from the FileMaker Pro application stating that some records could not be imported due to errors, along with a count of those records.
• B. All of the records will be imported. No error message will be displayed.
• C. The user will see the custom error message, but the import will continue if the user overrides the error.
• D. All records with a value for CompanyName will be imported. The user will see the specified custom message.

Given the following return-delimited data in a Team field of a FileMaker Pro 12 database:
Andy Jones
Bernie Lee
Carry Lane
Which formula would result in the string "Bernie Lee" (without quotes or leading/trailing carriage returns) from Team?

• A. Middle (Team ; 12 ; 10)
• B. MiddleValues (Team ; 2 ; 1)
• C. Trim (MiddleWords (Team ; 3 ; 4))
• D. Getltem (Team ; "11" ; 2)
• E. ListValues (Team ; 2)

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 a privilege set that has the Manage External Data Sources option checked in both PROD and DEPT
• B. 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
• C. 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
• D. an active account associated with the [Full Access] privilege set in both PROD and DEPT
• E. 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

Which two are capabilities of the Save Records as PDF script step? (Choose two.)

• A. Create a PDF Form document (.fdf)
• B. Specify email recipients
• C. Create a PDF based on a layout with a blank record
• D. Is server-compatible
• E. Append to existing PDF

Given two tables, Customer and Invoice, related such that customer:: CustomerID = Invoice:: CustomeriD, and a summary field in Invoice, InvoiceCount, defined to count the InvoicelD field.
Which two functions could be used as a field definition in the Customer table to count the number of related invoices? (Choose two.)

• A. ExecuteSQL ("Select Count (Invoice::CustomerID) from Invoice"; " " ; " ")
• B. Count (Invoice::CustomerID)
• C. GetSummary (Invoice::InvoiceCount)
• D. ValueCount (List (CustomerID))
• E. ExecuteSQL ("Select Count (CustomeriD) from Invoice where CustomeriD = ?" ; "" ;
  "" ; Customer::CustomerID)