FM0-305 Online Practice Questions and Answers

Given the following Relationships Graph for a FileMaker 11 database, where Employee, Manager, and Trainer are all table occurrences sharing the same source table:

The database has the following layout, based on the Trainer table occurrence:

If a developer adds the following fields to the portal:

Class::Class Name

Employee::Name

Manager::Name

Which data is shown in the portal?

A. each of the trainer's classes, the first employee enrolled in each class, and the trainer as manager for that employee

B. each of the trainer's classes, the first employee enrolled in each class, and the first related manager for each employee

C. the first class each employee is enrolled in, all employees managed by the trainer, and the trainer as manager for each employee

D. the first class each employee is enrolled in, all employees enrolled in any of the trainer's classes, and the first related manager for each employee

E. the first of the trainer's classes in all rows, all employees enrolled in any of the trainer's classes, and the first related manager for each employee

Which two events can activate an OnObjectEnter script trigger? (Choose two.)

A. clicking a button

B. tabbing to a button

C. navigating from one row in a portal to another

D. switching from one tab to another in a tab control

Given the following formula in a calculation field that returns a Text result: Let( tmp = "2 * 5" Evaluate( Quote ( tmp ) ) ) What will be returned?

A. the value 10

B. the value "10", quotes included

C. the value tmp

D. the value "tmp", quotes included

E. the value 2 * 5

F. the value "2 * 5", quotes included

Given a FileMaker Pro 11 database containing the following two scripts:

Script A:

Set Variable [ $beeps Value:2 ]

Beep

Perform Script [ "Script B" Parameter: $beeps ]

Beep

Script B:

Set Variable [ $counter Value:0 ]

Loop

Beep

Set Variable [ $counter Value:$counter + 1 ]

Exit Loop If [ $counter > Get( ScriptParameter ) ]

End Loop

Exit Script []

Beep

When Script A executes, how many beeps will be heard?

A. 3

B. 4

C. 5

D. 6

A FileMaker Pro 11 file is hosted by FileMaker Server 11. In the course of working with the file, users run scripts that access and update a global variable called $$currentTransactionCount.

Which statement is true about this situation?

A. $$currentTransactionCount does not exist when the file is opened.

B. The value of $$currentTransactionCount will be initialized to a null value each time the user opens the file. C. If the value of $$currentTransactionCount is changed by a serverside script, all loggedin users will see the new value.

C. When a user logs into the file, the value in $$currentTransactionCount will be the value the variable had when the user last logged out.

D. Whenever a user runs a script that updates the value of $$currentTransactionCount, all other loggedin users will see the changed value.

Which two statements are true about the [Full Access] privilege set in a FileMaker Pro 11 database? (Choose two.)

A. It is the only privilege set that can use Custom Functions.

B. It is the only privilege set that can view the Relationships Graph.

C. It is the only privilege set that can modify field options in Table View.

D. It can be deleted only if another full access privilege set has been created.

A FileMaker Pro 11 file named Arctic has Require full access privileges to create references to this file checked. Arctic has also authorized a file named Pacific. After Pacific has been authorized, the owner of Pacific makes a clone of the file and provides it to another developer.

How can the owner of Arctic remove authorization from the clone of Pacific and still allow the original Pacific to reference Arctic?

A. in the clone of Pacific, Deauthorize the Artic file

B. in Arctic, Deauthorize Pacific and then Authorize Pacific again

C. clones of files do not inherit authorizations no additional steps required

D. in Arctic, Deauthorize the new Authorization ID that appears after the first time the clone references Arctic

Which two statements are true about a Daily Backup Schedule that includes the option to keep a maximum of seven backups? (Choose two.)

A. FileMaker Server creates a subfolder each time the schedule is run and places all backups created at that time in the subfolder.

B. FileMaker Server creates a subfolder for the schedule and saves all backups to it, appending a timestamp to the name of each backed up file.

C. On the eighth day of normal functioning, FileMaker Server moves all of the backups created by that schedule to an archive folder and begins creating a new set.

D. On the eighth day of normal functioning, FileMaker Server deletes the oldest backup, which was done on the first day of the previous week, and replaces it with a new backup on the first day of the current week.

Which three are valid methods to export container field contents from FileMaker Pro 11 databases? (Choose three.)

A. use the Export Field Contents script step

B. choose the File > Export Contents As... menu item

C. choose Type: FileMaker Pro from the Export Records to File dialog

D. choose Type: Field Contents from the Export Records to File dialog

E. rightclick (Windows) or Controlclick (Mac OS X) on the field and choose Export Field Contents

Which two statements are true if two windows in a FileMaker Pro 11 database display records based on the same layout? (Choose two.)

A. If a record is being edited in one window, it cannot be edited in the other window.

B. A find performed in one window will be available as a Recent Find in the other window.

C. If a custom menu set is installed in one window, it will become the active menu set in the other window as well.

D. If a new record is created in one window, it will become the active record in both windows after it has been committed in the original window.

E. If a record is being edited in one window, the user will be prompted to save or revert the record when they attempt to switch to the same record in the second window.