FM0-307 Exam Questions

A FileMaker Pro 12 file has a Customer table and a related Contact table. The relationship from Customer to Contact is configured to create related records in the Contact table. On...

A FileMaker Pro 12 database is hosted by FileMaker Server 12. 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 a...

Which two are required for FileMaker Go 12 to have access to Externally Stored SQL (ESS) data in a database that is hosted from FileMaker Server 12? (Choose two.)

Which three methods can be used to access an ODBC data source from within FileMaker Pro 12? (Choose three.)

Given the following formula: Case (Children > 1 and Bedrooms = Children; "Overcrowded" ; Children > 2 and Bedrooms = Children; "Crowded" ; Children < 4 or Bedrooms > 1; "Comfortabl...

Which two statements are true about scripts in a hosted FileMaker Pro 12 file? (Choose two.)

Which two statements are true about setting up a System-level script to run as a scheduled script in FileMaker Server 12? (Choose two.)

A FileMaker Pro 12 file contains the following script: If this script is executed in a context where there is found a set of six records, which value will be returned from the scri...

In which two cases will the object name of a button be available to a script that is performed by the button? (Choose two.)

Which statement is true regarding resizing layout parts and objects in FileMaker Pro 12?

FileMaker FM0-307 : Practice Test Which two techniques could be used to generate the data points for a pie chart? (Choose two.)

A user logs in to a database hosted on FileMaker Server 12. It is set up to allow authentication via FileMaker and External Server accounts. The user is a member of two external gr...

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

Given a FileMaker Pro 12 database containing the following two scripts: When Script A executes, how many beeps will be heard?

Consider a FileMaker Pro 12 database with the following tables and fields: FileMaker FM0-307 : Practice Test Assuming only the above relationships between table occurrences, using...

Which two statements are true about script triggers? (Choose two.)

Which three options will allow a FileMaker Pro 12 database to be run using FileMaker Go 12. (Choose three)

Which two are valid types listed in the FileMaker Pro 12 Export Records to File dialog? (Choose two.)

Which two FileMaker Pro 12 objects will display data contents even when unrelated to the current layout's table occurrence? (Choose two.)

Which two statements are true if a layout is configured with an OnRecordLoad script trigger enabled in both Browse and Find modes? (Choose two.) FileMaker FM0-307 : Practice Test

The following script will set a value into a field after the script is called by that field's OnObjectExit script trigger: Set Field By Name [Get (ScriptParameter); "foo" ] Which t...

Which two privileges are needed for a non [Full Access] privilege set to allow the creation and modification of new layouts in a FileMaker Pro 12 database? (Choose two.)

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

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

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

Given the following formula: If the field Name contains "John Q. Adams, Jr.", what will the formula return?

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

What is the theoretical maximum record count in a FileMaker Pro 12 file?

Which two statements are true regarding object styles in FileMaker 12? (Choose two.)

Which two features of FileMaker Pro 12 require indexing in order to work? (Choose two.)

Which two statements are true about using external authentication in a FileMaker Pro 12 database? (Choose two.)

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

Which statement is true about container fields in FileMaker Pro 12?

For which two is it possible to specify conditional formatting? (Choose two.)

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

Which three Web publishing options are available in the FileMaker 12 product line? FileMaker FM0-307 : Practice Test (Choose three.)

Which function returns a unique, unchanging identifier of a computer or device accessing a FileMaker database?

According to the FileMaker Server Configuration Guide, it is considered a best practice to use which two system settings on a FileMaker Server 12? (Choose two.)

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

A database hosted on FileMaker Server 12 has the [Guest] account active and associated with a custom privilege set called Remote. The Remote privilege set has only the fmiwp extend...

The FileMaker database, Customers, is hosted from the FileMaker Server 12 default Data\Databases directory. Customers includes the table, Rewards, containing the managed container...

Which statement are true about importing tables using FileMaker Pro 12 Advanced?

Which three are valid XML grammars for use with Custom Web Publishing (CWP)? (Choose three.)

Which two statements are true when a script is installed on a window using the Install OnTimer Script step? (Choose two.)

Considering the following scenario: Three files - A.fmp12, B.fmp12, C.fmp12 File B has an external reference to file A There are no other external references between the files All...

Given the following script: Which conclusion can be made?

Which two are required for a FileMaker Pro 12 user to access a supported external SQL FileMaker FM0-307 : Practice Test Source (ESS) from a file being hosted by FileMaker Server 12...

Which two are required for a user to successfully run a script that uses the Execute SOL script step? (Choose two.)

What is the maximum number of files that can be hosted on FileMaker Server 12 Advanced?

Which statement is true of container fields in FileMaker Pro 12?