A new database is created with two tables, Client and Contracts. The only modification made on the Relationships Graph is to establish a relationship between them which is set to delete related records in Contracts when a record in Client is deleted.

What happens when the Client table occurrence is deleted from the Relationships Graph?

A. Since it is the only occurrence of the Client table on the graph, it can not be deleted.

B. Any records in the Contracts table that were related to matching Client records are deleted.

C. The formula in the calculation field Name Full (defined as Name First and " " and Name Last) will be broken.

D. Any records in the Contracts table that were related to matching Client records will have values in the Client ID field deleted.

Given the following relationship graph: Without inspecting the data, what is known about this database?

A. There are no records in the Event table at this time.

B. The Event table occurrence references a table from an external ODBC data source.

C. There can be zero or one, but no more than one, Event record related to any Task record.

D. The corner arrows indicate all three table occurrences reference tables from external data sources.

E. From a layout based on the Event table occurrence, a portal could be drawn showing both related Task and Volunteer data.

A FileMaker Pro 11 file contains the following script: Show All Records Unsort Records Set Variable [$counter Get(FoundCount)] Go To Record/Request/Page [First] Loop Duplicate Record/Request Go To Record/Request/Page [First] Omit Record Set Variable [$counter Value: $counter 1] Exit Loop If [$counter=0] End Loop How many records will the table contain after this script is done executing, if the script begins execution in

a database table containing six records total?

A. 6

B. 12

C. 13

D. 24

E. The script will not finish executing but will loop until forcibly terminated.

Which three conditions must be met to allow user access via accounts that are externally authenticated? (Choose three.)

A. The file must be hosted from FileMaker Server.

B. Account Group Name must match a Group Name specified in the external authentication directory service.

C. The associated privilege set must have the Extended Privilege Access via FileMaker Network (fmapp).

D. The associated privilege set must have the Extended Privilege Access via External Server Authentication (fmesa).

E. The Specify Directory Service Settings in the FileMaker Server Admin Console must be configured to include the LDAP Server Address, Port, and Search Base.

Which formula returns the calendar quarter (1, 2, 3, 4) of a date contained in a field called myDate?

A. Int ( Month ( myDate ) / 3 )

B. Mod ( Month ( myDate ) 3 ) + 1

C. Ceiling ( Month ( myDate ) / 3 )

D. Let ( m = Month ( myDate ) Case ( m > 0 1 m > 3 2 m > 6 3 4) )

E. Let ( m = Month ( myDate ) Choose ( m 1 1 1 2 2 2 3 3 3 4 4 4 ) )