FileMaker FileMaker Certification FM0-305 Questions & Answers

• Question 1:

  Which two types of fields will always be excluded from the search when a user performs a Quick Find? (Select two.)

  A. merge fields

  B. summary fields

  C. unindexed fields

  D. related fields in a portal

  E. fields with global storage

  Correct Answer: BE

• Question 2:

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

  Correct Answer: C

• Question 3:

  Which formula returns "052010" given a date field myDate that contains the date May 20, 2010?

  A. Month (myDate) and "" and Year (myDate)

  B. Date ( Month (myDate) "" Year (myDate))

  C. Right ("0" and Month (myDate) 2) and "" and Year (myDate)

  D. Let ( [ d = GetAsText (myDate) m = Month (d) y = Year (d) ] m and "" and y )

  Correct Answer: C

• Question 4:

  A user finds a set of records and saves the find criteria using the Saved Finds command. The user then switches to a layout based on a different, unrelated table occurrence and attempts to perform the saved find. What will happen next?

  A. The saved find does not appear in the list of Saved Finds.

  B. The user receives the alert No records match this set of find requests.

  C. The saved find is available, but selecting it does not change the record set.

  D. The user receives the alert This set of find requests cannot be processed on this layout.

  E. The find is executed on the layout on which they saved the find, and the proper found set is displayed.

  Correct Answer: A

• Question 5:

  Which two statements are true about the Status Toolbar? (Choose two.)

  A. Record navigation via the Status Toolbar can be prevented by installing a Custom Menu.

  B. The name and/or function of a status toolbar button can be changed by installing a Custom Menu.

  C. The ability to add or remove buttons on the Status Toolbar can be prevented by installing a Custom Menu.

  D. Users whose privilege set has Available menu commands set to Minimum cannot customize the Status Toolbar.

  E. The initial settings of the Status Toolbar are stored with the database file and shared with all users of the hosted file.

  F. Customization of the Status Toolbar can be prevented by running a script which contains the Show/ Hide Status Area [Lock Show] script step.

  Correct Answer: AB

• Question 6:

  Which two statements are true about overriding the default behavior of the Quick Find box available in the Status Toolbar? (Choose two.)

  A. The Perform Quick Find custom menu item must be installed.

  B. The Show/Hide Quick Find script step will allow the user to hide the Quick Find box.

  C. The Get( QuickFindText ) function will return the text entered into the Quick Find box.

  D. A Layout based script trigger can be used to override a find request issued from the Quick Find box.

  Correct Answer: AC

• Question 7:

  Which two statements are true about windows in a FileMaker database? (Choose two.)

  A. A given user may have a maximum of 100 windows open concurrently.

  B. Creation of a new window will activate an OnLayoutEnter script trigger.

  C. On the Windows platform, only the currently active window can be maximized.

  D. The Adjust Window script step can be used to move a window to a location specified by a calculation formula.

  Correct Answer: BC

• Question 8:

  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.

  Correct Answer: AB

• Question 9:

  Which operation requires a database file to be open in FileMaker Pro 11?

  A. performing a File Maintenance option

  B. creating a copy of a file in which the OnFirstWindowOpen script is disabled

  C. performing the Export Records command from a menu, script or script trigger

  D. creating a copy of a file based on its logical structure (same as Compacted Copy)

  Correct Answer: C

• Question 10:

  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.

  Correct Answer: AC