FileMaker FM0-305 Online Practice Questions and Exam Preparation

FileMaker FM0-305 Online Questions & Answers

• Question 1:

  Which two script steps, if executed by a user in a hosted file with multiple loggedin users, can affect the active sessions of other users? (Choose two.)

  A. Insert From Index
  B. Set Field By Name
  C. Enable Account [Deactivate]
  D. Refresh Window [Flush cached join results]
  E. Install Menu Set ["My Menu Set" Use as file default]
  F. Set Variable [$$globalUserCount Value: $$globalUserCount + 1]
  A. Insert From Index
  B. Set Field By Name

• Question 2:

  Which two statements are true about field indexing in FileMaker Pro 11? (Choose two.)

  A. Calculation fields cannot be indexed.
  B. Indexing improves the speed at which sorts are performed.
  C. To establish a relationship between two fields, both fields are required to be indexed.
  D. A field must be indexed in order for Autocomplete using previously entered values to function.
  E. Minimal indexing indicates that either the value index or the word index has been created, but not both.
  D. A field must be indexed in order for Autocomplete using previously entered values to function.
  E. Minimal indexing indicates that either the value index or the word index has been created, but not both.

• Question 3:

  Which three statements are true about a Web Viewer object placed on a layout in a FileMaker Pro 11 file? (Choose three.)

  A. It can be defined as a button.
  B. It can support ActiveX controls (on Windows).
  C. It can render valid HTML (including CSS styles) stored in a global variable.
  D. It can be configured to show a Back button in the Web Viewer Setup dialog.
  E. It can be configured to log into a secured web sites by sending the current user's FileMaker Pro account name and password.
  A. It can be defined as a button.
  B. It can support ActiveX controls (on Windows).
  C. It can render valid HTML (including CSS styles) stored in a global variable.

• Question 4:

  Which three are necessary to create and publish a PHPbased Web site using the PHP Site Assistant? (Choose three.)

  A. a copy of FileMaker Pro 11 Advanced
  B. a working installation of FileMaker Server
  C. a development computer with Java installed
  D. a development computer with the PHP runtime engine installed
  E. one or more hosted database files with the [fmphp] extended privilege enabled for at least one active user account
  B. a working installation of FileMaker Server
  C. a development computer with Java installed
  E. one or more hosted database files with the [fmphp] extended privilege enabled for at least one active user account

• Question 5:

  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.
  A. The Current tab of the Data Viewer can be used to modify the value of a variable.
  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.

• Question 6:

  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.
  A. FileMaker Server creates a subfolder each time the schedule is run and places all backups created at that time in the subfolder.
  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.

• Question 7:

  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.
  B. User A's script will make changes to all records in its found set except the record being edited by User B.

• Question 8:

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

• Question 9:

  Which statement is true about the sort order of data in portals in FileMaker Pro 11?

  A. If the relationship that defines the portal's record set includes a Sort records setting, unindexed fields in the sort setting will be ignored.
  B. If the relationship that defines the portal's record set includes a Sort records setting, any sort setting applied to the portal in Layout mode will be ignored.
  C. If the relationship that defines the portal's record set includes a Sort records setting, the sort setting will be restricted to field data from the portal's table.
  D. If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will be sorted based upon the relationship closest to the portal's table occurrence.
  E. If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will combine the Sort records settings of all of those relationships, subsorting by the relationships closest to the portal's table occurrence.
  D. If there are multiple sorted relationships defined between the layout's table occurrence and the portal's table occurrence, the portal records will be sorted based upon the relationship closest to the portal's table occurrence.

• Question 10:

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