FM0-305 Online Practice Questions and Answers

Given a text field Full Name, AutoEnter by Calculated value has been selected in field options, using the following formula: name First and " " and 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. when the record is first created

B. when the field Full Name itself is modified

C. only when the field Full Name was previously empty

D. when either of the fields Name First or Name Last are modified

E. when the field Full Name itself is modified and the record is committed

A table in a FileMaker Pro 11 database has a field CompanyName of type Text. 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 of the records will be imported. No error message will be displayed.

B. The user will see the custom error message, but the import will continue if the user overrides the error.

C. All records with a value for CompanyName will be imported. The user will also see the specified custom error message.

D. The user will see the custom error message, but in the case of an import, overriding the error is not allowed and no records are imported.

E. 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.

Which two features require indexing in order to work? (Choose two.)

A. List function

B. Dynamic subsummary reports

C. Autocomplete using existing values

D. Dynamic value lists based on FileMaker tables

E. Add Leading Group by in Table View

The field exampleField has a script trigger set to activate OnObjectKeystroke and run the following script:

Allow User Abort [Off]

Set Error Capture [On]

If [Length (File::exampleField)= 7]

Exit Script [Result: 0]

Else

Set Field [File::exampleField File::Field and ""]

Exit Script []

End If

The field exampleField has the value of 111111.

At the end of the string a 9 is entered.

What is the resulting value in the field after the script trigger has processed?

A. 0

B. 111111

C. 111111

D. 1111110

E. 1111119

A database has an Order table and a Customer table. There is a relationship between Customer and Order. On a layout based on the Customer table there is a portal showing all of that customer's orders for the current calendar year. The portal has no filter criteria applied. There is a calculation field in the Customer table, zSumOrders, that adds up the total amount of all the customer's orders for the year. This field is displayed below the portal. Which one may cause the displayed value of zSumOrders on a customer record to change?

A. adding one or more sort criteria to the Orders portal

B. adding one or more sort criteria to the relationship on which the Orders portal is based

C. using Filter Portal Records to further limit the set of records displayed in the Orders portal

D. changing the criteria of the portal's relationship to further limit the set of records displayed in the Orders portal

E. selecting the Save record changes automatically setting in the Layout Setup dialog for the layout in question

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

A. set the chart to Use Data From: Related Records and specify multiple data series, each based on a related number field

B. set the chart to Use Data From: Current Record (delimited data) and specify multiple data series, each of which references a summary 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

A FileMaker Pro 11 database is hosted by FileMaker Server 11. User A and User B are accessing the database at the same time. User A runs a script that loops over a set of records and makes changes to those records. During the time that the script runs, User B is editing one of the records that is also in User A's found set and is being acted on by User A's script.

Which statement is true about this situation?

A. User A's script will stop looping when it reaches the record User B is editing.

B. User A's script will make changes to all records in its found set except the record being edited by User

B.

C. User A's script will stop looping when it reaches the record User B is editing, and will wait to continue until User B releases the record.

D. When it reaches the record User B is editing, User A's script will stop if User A's script is running with Set Error Capture[On]. Otherwise User A will be prompted to either continue or cancel the running script.

Which three are required to use all of the features of FileMaker Server 11 Advanced for Macintosh? (Choose three.)

A. SSH

B. PHP Engine

C. Apache web server

D. the Console application

E. QuickTime Plugin for Macintosh

F. Java Runtime Environment (JRE)

LAN users of a hosted database are reporting slow performance. A Performance Monitor log file from the FileMaker Server machine reports a consistently high value on the Network Interface/Output Queue Length Performance Object Counter.

The server has dual processors, 2Gb of RAM and three 7200 RPM hard drives configured using RAID 5. Which two steps would most likely improve performance? (Choose two.)

A. install 2Gb of additional RAM

B. replace the machine with one which has four processors

C. install an additional network card and team it with the existing card

D. replace the network card with a model which has an onboard processor

E. install an additional hard drive and configure the drive subsystem using RAID 1+0

In FileMaker Pro 11 Advanced, which two statements are true about the Data Viewer and Script Debugger? (Choose two.)

A. The Current tab of the Data Viewer can be used to modify the value of a variable.

B. The Script Debugger will be invoked when a script is run from a button, but not from a Custom Menu.

C. The Watch tab of the Data Viewer can be used to create global variables when the user has [Full Access] privileges in a file.

D. The Current tab of the Data Viewer can be used to modify the value of a field with global storage while a script is paused in the Script Debugger.